Blogs

November 2006 - Posts

• PASS Summit 2006 Session: Securing Your Data with SQL Server 2005 Encryption

  Thank to all who attended our session on securing data using SQL Server 2005. As promised, attached are the demo scripts and the presentation. I included the script used to represent the EncryptByPassPhrase function where the text is exposed in Profiler Read More... Posted Wednesday, November 15, 2006 6:16 PM by Lara Rubbelke | 3 Comments Filed under: Presentation Materials Attachment(s): 301PASSEncryption.zip

• Maximum Degree of Parallelism and Hyperthreading

  For those who are challenged with deciphering how to configure the max degree of parallelism on a server where hyperthreading is enabled, the max degree of parallelism configuration is based on physical processors and not logical processors. I recently Read More... Posted Monday, November 13, 2006 10:13 AM by Lara Rubbelke | 1 Comments Filed under: SQL Server 2005 Optimizer Enhancements