All things SQL Server Related....

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 Read More...

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 Read More...

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/ Read More...

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 Read More...

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 -- Read More...

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 Read More...