Enabling Kerberos Authentication for Reporting Services

Recently, I’ve helped several customers with Kerberos authentication problems with Reporting Services and Analysis Services, so I’ve decided to write this blog post and pull together some useful resources in one place (there are 2 whitepapers in particular that I found invaluable configuring Kerberos authentication, and these can be found in the references section at…


Hosting the Performance Dashboard Reports in SSRS

I blogged a while back about modifying the SQL Server 2005 Performance Dashboard reports to run on SQL Server 2008. I’ve since been working with several customers who use these reports for performance troubleshooting, but who would like to host them on their Reporting Services platform so they can be viewed online instead of within…


Mirroring Multiple SQL Server Databases on a Single Instance

This is a question I get asked a lot by customers (last week being the latest) and the answer really depends on which platform you are running on. There is a support policy in Books Online that states that we only support a maximum of 10 mirrored databases per instance on 32-bit systems, however in…

Caching SSRS Reports for Performance

I’ve been fairly quiet on the blogging-front recently, but I have been busy working with SQL Server Reporting Services (SSRS) ! I’ve also been fortunate enough to present a session to customers on SSRS scalability at a recent Business Intelligence Operations Day in Reading, UK. One thing that struck me from that day was that…


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: http://msdn.microsoft.com/en-us/library/dd672789.aspx


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,…


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:   http://support.microsoft.com/kb/960484/en-us  


SQL Server 2008 Upgrade Technical Reference Guide Released

The SQL Server 2008 Technical Reference Guide has just been released, covering the essential steps and best practices to upgrade existing 2000 and 2005 instances to 2008. There is also a list of other upgrade resources available at http://msdn.microsoft.com/en-us/library/cc936623.aspx These guides are intended to suppliment the information already available in SQL Server 2008 Books Online.


SQL Server 2008 Cumulative Update #2 Released

Cumulative Update package 2 has now been released for SQL Server 2008. See the following KB article for full details: http://support.microsoft.com/kb/958186/en-us