Tip Tips for Effective Database Maintenance
Category: Interesting Reads
Important Links for SQL Server 2008
Features Supported by the Editions of SQL Server 2008 http://msdn.microsoft.com/en-us/library/cc645993.aspx SQL Server 2008 Encryption Hierarchy http://msdn.microsoft.com/en-us/library/ms189586.aspx SQL Injection http://msdn.microsoft.com/en-us/library/ms161953.aspx Understanding and Manging the suspect_pages Table
Imporant Links for SQL Server 2005
Features Supported by the Editions of SQL Server 2005 http://msdn.microsoft.com/en-us/library/ms143761(SQL.90).aspx SQL Server 2005 Encryption Hierarchy http://msdn.microsoft.com/en-us/library/ms189586(SQL.90).aspx SQL Injection http://msdn.microsoft.com/en-us/library/ms161953(SQL.90).aspx Understanding and Manging the supsect_pages Table
Execution Plan Basics
Just read article explaining SQL Query plans and how to understand them. I find many people don’t know what these plans mean or if they
To SP or not to SP in SQL Server
Just read this article, I am stronge following to SPs. Of of the points highlighted in this were a bit of suprise to me. Using