I thought the PASS Summit was a great success this year. I always enjoy speaking at the PASS Summit (this year I spoke on Wait Types. I’m working now on starting to populate the Wait Type Repository ) but I also really enjoy working at the SQL Server...

Recently, we have troubleshoot a customer issue related to SQL CLR. The problem is that the assembly is configured to use external_access but he kept getting an exception similar to this (this is a sample call stack): Msg 6522, Level 16, State 1, Procedure...

I’ve seen a few customers run in to this recently when the resource database is in a different location than the master database.  A cumulate update or GDR for SQL Server 2005 may fail with the following for the SQL Server Database Services 2005...

I just completed a lengthy bit of research and thought I would share it with everyone.   There are several trace flags and registry keys outlined in this post.    !!! As always USE WITH APPROPRIATE CAUTION !!!   From: Robert...

Previously I have posted details on backup/restore designs and how to tell what backup/restore is doing. http://blogs.msdn.com/psssql/archive/2009/03/03/how-it-works-sql-server-vdi-vss-backup-resources.aspx http://blogs.msdn.com/psssql/archive/2008/01...

12/10/2009: Significant updates to the blog. Check back in 2010 for more updates to the wait type table As part of my talk at the 2009 US PASS Summit here in Seattle called Inside SQL Server Wait Types , I’m creating this blog post as a reference...