Blog

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

    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.

    aws
    amazon-vpc
    cloud-networking
    nat-gateway
    network-security

    Running AWS VPCs Efficiently

    DCDustin CollettNovember 10, 2005

    Design AWS VPCs for simpler routing, controlled egress costs, least-privilege access, useful observability, and routine cleanup.

    sql-server-2005
    dynamic-management-views
    missing-indexes
    database-administration
    historical

    DMV of the Day - sys.dm_db_missing_index_details

    BKBrian KnightOctober 23, 2005

    A preserved SQL Server 2005 introduction to sys.dm_db_missing_index_details as a first-pass source of missing-index hints.