Blog

    IT insights, cybersecurity tips, and technology best practices from our team.

    managed-services
    business
    guide

    How to Choose the Right Managed Service Provider

    DCDustin CollettFebruary 10, 2026

    Not all MSPs are created equal. Learn the key factors to consider when selecting a managed service provider for your business.

    sql-express
    msde
    sql-server-backups
    task-scheduler
    historical

    Automating SQL Express Backups

    BKBrian KnightAugust 13, 2006

    A preserved SQL Express and MSDE backup-scheduling article describing Brian Knight's historical three-file script package.

    sql-server-2005
    service-pack
    ssis
    database-mirroring
    historical

    Service Pack 1 Released!

    BKBrian KnightApril 20, 2006

    A preserved announcement of SQL Server 2005 Service Pack 1 and its database mirroring and SSIS enhancements.

    ssis
    sql-server-integration-services
    execute-sql-task
    connection-managers
    ssis-variables

    SSIS: Using Variables in Connection Managers

    BKBrian KnightMarch 3, 2006

    Load connection values with an Execute SQL Task, map each row to SSIS variables, and use those variables in connection-manager expressions.

    sql-server-2005
    northwind
    pubs
    sample-databases
    historical

    Pubs and Northwind databases not installed in SQL Server 2005

    BKBrian KnightJanuary 6, 2006

    A preserved SQL Server 2005-era guide to installing the older Pubs and Northwind sample databases for legacy examples.

    ssis
    sql-server-2005
    integration-services
    books
    historical

    Professional SQL Server 2005 Integration Services Sample Chapter

    BKBrian KnightDecember 30, 2005

    A preserved announcement for Professional SQL Server 2005 Integration Services and its end-to-end package sample chapter.

    ssis
    sql-server-integration-services
    script-task
    dts-variables
    ssis-debugging

    SSIS/DTS RuntimeException: The Element Cannot Be Found in a Collection

    BKBrian KnightDecember 30, 2005

    Diagnose SSIS Script Task variable-access errors by checking variable names, scope, and the ReadOnlyVariables and ReadWriteVariables lists.

    sql-server
    sysindexes
    row-counts
    database-administration
    historical

    Quickly Retrieving the Row Count for All Tables

    BKBrian KnightDecember 21, 2005

    A partial recovery of a SQL Server article comparing sp_msforeachtable with estimated row counts stored in sysindexes.

    ssis
    sql-server-2005
    protectionlevel
    dtutil
    historical

    SSIS Packages are Encrypted by Default

    BKBrian KnightDecember 19, 2005

    A preserved SQL Server 2005-era explanation of SSIS package ProtectionLevel behavior and a historical Dtutil batch example.

    sql-server-2005
    visual-studio-2005
    sql-server-management-studio
    ssis
    historical

    Speeding up the VS/SQL User Interface Load Time

    BKBrian KnightDecember 16, 2005

    A preserved SQL Server 2005-era tip for bypassing the Visual Studio and SQL Management Studio splash screens with the historical -nosplash switch.