Cumulative Update #7 for SQL Server 2008 RTM

  Keep your system up to date with the most recent cumulative update package for SQL Server 2008 RTM. This package contains all of the SQL Server 2008 hotfixes that have been released since the initial release of SQL Server 2008 RTM. o    Understanding Incremental Servicing Model for SQL Server   o    CU#7 KB Article:…


Guest Failover Clustering now supported for virtualised SQL Server

Just in case you missed it!!! Microsoft Support announced an update to the SQL Server virtualisation support policy.   Guest Failover Clustering is supported for SQL Server 2005 and SQL Server 2008 in a virtual machine for Windows Server 2008 with Hyper-V, Microsoft Hyper-V Server 2008, and SVVP certified configurations provided both of the following…

2

Little Off Topic – Augmented Reality & SQL Server

Finally I found a cool demo of Augmented Reality that is near and dear to me – as it promotes Microsoft SQL Server 2008. I found out about it while searching for Augmented reality demos on Windows Live. The following blog entry – http://blog.mccann.be/2009/04/06/augmented-reality-campaign-for-microsoft-belgium/ pointed me to this demo. So here it is – for…

2

SQL Server I/O for Thought

Following are the links specifically relating to best practices for setting up disk I/O for SQL Server workloads. Predeployment I/O Best Practices – http://sqlcat.com/whitepapers/archive/2007/11/21/predeployment-i-o-best-practices.aspx Complete I/O Best practices whitepaper – http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx Storage Top 10 Best Practices – http://sqlcat.com/top10lists/archive/2007/11/21/storage-top-10-best-practices.aspx Tools – below are links to tools that can aid you in the testing of I/O for…


Verifying if a connection to SQL Server is Encrypted

If you do not have a network parser such as netmon and want to verify if the connection from the client to the SQL server is encrypted, the following query can be utilised: SELECT encrypt_option FROM sys.dm_exec_connections WHERE session_id = @@SPID — Note: remove the WHERE clause to see all connections.

3

SQL Server CACHING & Performance Testing

As you know SQL Server uses caches to speed up access to data and also query plans.   There are two caches one for Data and the other of Query Plans. When you are doing performance testing, with static data and you want to get accurate results of your test, it is recommended that you…