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: http://se.linkedin.com/in/globalgoat www.globalgoat.com Enjoy your SQL Servers ! It’s been a pleasure. Graham

0

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…

0

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…

1

Extended Event to track and trace syntax errors

This might sounds like a strange requirement, but it can be converted to do a number of different things. The scenario is that for reason I won’t discuss here, I want to track any user / application which issues an SQL batch which contains invalid syntax. The value here is that this would be extremely…

0

SQL Server performance problems due to high privileged CPU time when running Windows Server 2008 R2

It’s very rare that I tell people to blindy apply service packs or hotfixes (especially windows ones) without first analyzing where their performance problem lies, but if you are running SQL Server 2008 on Windows Server 2008 R2 (specifically this OS only) then you should absolutely ensure that you’ve installed the following fix: 976700  An…

1

The Forefront TMG/UAG team in Stockholm is hiring

Following the success of my previous post about recruitment, we’re advertising another position from a different support group also located here in Stockholm. You can read the details here http://blogs.technet.com/b/isablog/archive/2010/09/15/forefront-tmg-uag-help-wanted-at-microsoft-in-stockholm.aspx ….and you might notice the common language to my previous post 🙂 Please don’t contact me about this one though, ensure you email the contact…

0

The SQL Server Support Team in Stockholm is hiring

Update 23th August This position has now been filled – thanks for everything who submitted their CVs. The Microsoft SQL Server support team in Stockholm is looking to hire a contractor to help out over the next year or so, to cover some staff absences. If you’d be interested to come and work with us…

0

Script to run in SQL Server Agent to monitor DMVs, log results and take action depending upon results

Here’s a script to play with which is useful for simple management tasks. I wrote it to help someone with a TokenAndPermUserStore cache issue (http://support.microsoft.com/kb/927396/) which are relatively uncommon nowadays. I actually sent it to someone today which is why it came to mind, but it occurred to me that the template of the script…

0

Access Denied error when running SQL Server Transfer Objects Task with a Proxy Account

Should you try to configure an SSIS package which uses the Transfer Objects Task, and then execute this package through SQL Agent, when you choose to run the task as a proxy credential, as opposed to the normal SQL Agent user, you may encounter a failure. The typical full text of the error message from…

0