• November 12, 2006 12 Nov'06

    Extend SSIS packages with scripting and programming

    SQL Server Integration Services brings new meaning to importing data, compared to DTS. Microsoft also offers two methods of extending SSIS functionality. Contributor Serdar Yegulalp shares how to extend Control Flow and Data Flow with scripting, and...  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

    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

    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

    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