• 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

  • November 01, 2006 01 Nov'06

    Stop MS Access from causing timeouts

    Five months ago we migrated our SQL Server databases from 7.0 to 2000. Since then we have experienced timeouts very often. Sometimes we've detected that MS Access blocks the server, and when we kill the process everything starts to work properly. ...  Continue Reading