Mathom Solutions Blog-IT

As part of Bob Ward's (twitter) talk at the 2009 US PASS Summit in Seattle called Inside SQL Server Wait Types, he has created this blog post as a reference point to find out information about wait types in SQL Server 2005 and 2008.  

Kalen (site) uses a table that can be created in the master database, and then populates it with the output of DBCC LOGINFO. Once you have captured all the rows from DBCC LOGINFO, you can query them using any TSQL queries.

Lukasz (site) says that failover clustering with SSRS is possible, however there are a number of considerations and manual steps involved on your part. The documentation and links he provides proof that scaling out SSRS is your best option for achieving High Availability.

SQL Azure Database is a cloud database service from Microsoft. It provides web-facing database functionality as a utility service. SQL Azure can provide many benefits, including rapid provisioning, cost-effective scalability, high availability, and reduced management overhead. This Microsoft white paper provides an architectural overview of SQL Azure Database, and talks about how you can use augment your existing managed infrastructure.

Good step by step to getting started by Microsoft's SQL Azure platform.