• November 30, 2006 30 Nov'06

    Active/Active clusters in SQL Server

    Multi-instance, or Active/Active SQL Server cluster design is an involved process. To optimize high availability and performance, you must consider a number of components in ensuring both instances can run on a single node. Hilary Cotter walks you ...  Continue Reading

  • November 28, 2006 28 Nov'06

    Upgrade to SQL Server 2005 and maintain older database

    Upgrading to SQL Server 2005 may cause you some initial trepidation. You'll want to maintain your databases in old faithful (SQL Server 2000) while your new system proves reliable. Contributor Michelle Gutzait outlines methods including replication ...  Continue Reading

  • November 21, 2006 21 Nov'06

    Top 10 SQL Server backup and recovery tips

    We've tallied a Top 10 collection of backup and recovery tips for 2006. View the complete list where database restores of different shapes and sizes took the majority of slots.  Continue Reading

  • November 12, 2006 12 Nov'06

    SQL Server change management tools

    Database change management can be an agonizing task for SQL Server developers. Eric Brown, a SQL Server developer and expert, walks you through three useful tools. Learn why using database backup, Database Snapshot and Database Import and Export ...  Continue Reading

  • November 08, 2006 08 Nov'06

    SQL Server backup encryption for improved security

    SQL Server offers many approaches to securing your database backup files, and the contents of those files. You can create backup passwords and/or encrypt stored procedures. Edgewood Solutions' Greg Robidoux details these options, as well as options ...  Continue Reading

  • November 06, 2006 06 Nov'06

    Logging for security compliance in SQL Server

    Logging for security compliance in SQL Server can be tricky. Recommendations come from all directions: vendors, auditors and lawyers. As a SQL Server administrator, it's your job to determine what's reasonable based on risk. Contributor Kevin Beaver...  Continue Reading

  • November 01, 2006 01 Nov'06

    Transfer encrypted stored procedures in a database

    How do I transfer encrypted stored procedures in a DB? I am using the DTS wizard method with SQL Server 2000 on two servers. I copied all objects of the DB to the new destination second server but the database will not run on the new server because...  Continue Reading

  • November 01, 2006 01 Nov'06

    SQL Server Integration Services programming basics

    SSIS is more than a tool to move data around in SQL Server 2005. It creates a system where the data sets that you import and the packages you create are programmatic objects that can talk to one another, rather than existing as static data.  Continue Reading