The end of the line

Today is my last day at Microsoft. I’m off to do something completely different, joining a small Scandinavian tech company called Basefarm. You can continue to find me online here: Enjoy your SQL Servers ! It’s been a pleasure. Graham


SQL Server blocking caused by database mirroring wait type DBMIRROR_DBM_EVENT

I was looking at a problem this morning about long blocking chains caused by the wait type DBMIRROR_DBM_EVENT, and it makes an interesting case study about database mirroring, blocking, undocumented wait types and general troubleshooting techniques for database mirroring. The information following relates ONLY to SQL 2005, SQL 2008 and SQL 2008 R2. However since…


Compatibility problems between DMO and SMO connectivity on newer versions of SQL Server

We’ve recently been looking at a problem which triggered this error: [Microsoft][ODBC SQL Server Driver][SQL Server]To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO) In our case it was actually being thrown by the SQL Server Web Data Administrator which is available on codeplex, but it…