Microsoft is pleased to announce the availability of SQL Server 2008 Service Pack 2. Both the Service Pack and Feature Pack updates are now ready for download on the Microsoft Download Center.  Service Pack 2 for SQL Server 2008 includes new compatibility...

The SQL CAT Team have just released another SQL Server High Availability case study. This time it is based on a Australian customer – Queensland Rail’s implementation of a geo-clustered SQL Server using Hitachi SANs with Truecopy. This infrastructure...

I have recently been doing a lot of work with PowerPivot, and installing it at customers site. I have on two occasions now come across the below error message:     Error: Your SQL Server 2008 R2 installation completed with failures.            ...

Let me say that again just in case you missed it, SQL Server is the most secure RDBMS. This is just not me saying, it is based on figures tracked by NIST, and the full details have been written up by a independent analyst. The full report can be accessed...

Time to time I get questions asked about training and learning more about SQL Server management, maintenance, best practices. As with every Microsoft product I say they are best learnt with hands on technique, that is to say get yourself a copy of the...