Blogs

August 2006 - Posts

• August PASSMN Meeting

  Upcoming PASSMN meeting information below. My esteemed colleague Stan Sajous will be co-presenting with me on Encryption in SQL Server 2005. The topic focuses specifically on resolving performance issues in a scalable encryption scenario. Hope to see Read More... Posted Monday, August 21, 2006 8:34 PM by Lara Rubbelke | 2 Comments Filed under: PASSMN

• Great Post on SSIS Destinations + More Information

  One of my favorite blogs on SQL Server Integration Services (SSIS) is by Jamie Thompson. He does a tremendous job sharing tips, tricks, and lessons learned from working with SSIS. Recently he posted a blog on three of the destination adapters and the Read More... Posted Sunday, August 20, 2006 10:15 PM by Lara Rubbelke | 4 Comments Filed under: SQL Server Integration Services

• Smart Index Defrag/Reindex for a Consolidated SQL Server 2005 Environment

  (Update: An ONLINE version of this procedure is now available) I am sure we all have our own version of a "smart" reindex script for SQL Server 2000. This is a script that assesses the current level of fragmentation, and only executes a reindex or indexdefrag Read More... Posted Wednesday, August 16, 2006 10:15 PM by Lara Rubbelke | 32 Comments Filed under: Programming, Maintenance Attachment(s): RebuildIndex_Smart_Update.zip