Scottish SQL Server User Group Meeting – Oct 8th

I have the great pleasure of speaking at the next Scottish SQL Server User Group meeting being held in Mocrosoft’s Edinburgh ofice on Thursday the 8th of October. Full details can be found on the UK User Group site. My talk will focus on some of the great tools we have for collecting and analysing…


Troubleshooting SQL Server 2008 Performance Problems

A new whitepaper covering the topic of performance troubleshooting in SQL Server 2008 has now been released. You can download the paper from the following link:


SQL Server 2005 Multi-Site Clustering with Windows Server 2008

I was working recently with a customer who was looking to deploy a SQL Server 2005 cluster across 2 geographically dispersed sites using Windows Server 2008. They were looking to utilise the new clustering improvements in Windows Server 2008 to build a highly available SQL Server solution. The customer required automatic failover between the sites…


Performance Dashboard Reports for SQL Server 2008

During a recent visit to Seattle for a Microsoft conference, I learned from my colleague Michael Thomassy that it’s possible to run the SQL Server 2005 Performance Dashboard reports on SQL Server 2008, with a slight modification. There is a great new feature in SQL Server 2008 called Performance Data Collection, which I have blogged about in the past,…


Scottish SQL Server User Group Meeting – 29th January

I have uploaded my slides from my Upgrading to SQL Server 2008 session at the recent Scottish SQL Server User Group meeting held in Edinburgh on the 29th January. It was good to see a number of new faces at the meeting, and if you fancy coming along in the future, register for updates at the…


CU #3 for SQL Server 2008 Released

On January 19, 2009 Microsoft shipped the Third Cumulative Update for SQL Server 2008 RTM.                                                                                                                        This CU represents 36 Resolved Issues and 30 Unique Customer Requests. More details and download details can be found here: