SQL in Stockholm
SQL Server thoughts from the support team in Stockholm
Today is my last day at Microsoft. I’m off to do something completely different, joining a small...
Date: 02/04/2011
I was looking at a problem this morning about long blocking chains caused by the wait type...
Date: 01/10/2011
We've recently been looking at a problem which triggered this error: [Microsoft][ODBC SQL Server...
Date: 01/05/2011
This might sounds like a strange requirement, but it can be converted to do a number of different...
Date: 12/10/2010
It's very rare that I tell people to blindy apply service packs or hotfixes (especially windows...
Date: 11/01/2010
Following the success of my previous post about recruitment, we're advertising another position from...
Date: 09/27/2010
Update 23th August This position has now been filled - thanks for everything who submitted their...
Date: 06/22/2010
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...
Date: 06/11/2010
Should you try to configure an SSIS package which uses the Transfer Objects Task, and then execute...
Date: 03/12/2010
(An alternate title for this post could be “How to debug SSMS managed code”) In the first 2 posts of...
Date: 02/03/2010
On Monday we released Cumulative update package 5 for SQL Server 2008 Service Pack 1, under...
Date: 11/18/2009
This is the first in a series of 3 posts which discuss troubleshooting SQL Server Management Studio...
Date: 10/20/2009
I noticed that we have posted a really good summary of the above points through the new fast publish...
Date: 10/19/2009
SQL Server 2008 SDK directory does not contain the opends60.lib file required for the creation of extended stored procedures
If you are trying to create extended stored procedures in SQL Server 2008, you will probably have...
Date: 09/29/2009
Here’s a script I was using last week. I wrote this so that it could be used in a custom PSSDIAG /...
Date: 09/28/2009
I guess everyone has their own set of DMV scripts to hand when working with SQL Server nowadays. I...
Date: 09/24/2009
Here’s an example of how to collect and consume extended events in SQL Server 2008. It’s something...
Date: 09/23/2009
Troubleshooting SQL Server performance problems associated with low memory conditions – should I use sys.dm_os_ring_buffers
I recently received a question through this blog about the use of the sys.dm_os_ring_buffers DMV...
Date: 09/10/2009
I was discussing with Elisabeth back in this blog post about the above problem, and made comments...
Date: 09/03/2009
I’ve worked on a lot of cases this year involving SharePoint. Here are some example problems I...
Date: 06/15/2009
I refer to this many times in my other posts, so here’s a direct link to the download location of...
Date: 06/11/2009
Here’s another interesting example which we worked recently in the Stockholm office, which relates...
Date: 06/02/2009
SQL Server Error: 7320 Cannot execute the query "xxx" against OLE DB provider "DB2OLEDB" for linked server "xxx"
Here's a little something that me and my colleagues were looking at this week. Our customer was...
Date: 05/15/2009
In the continuing series of "things I notice in SQL Server which I didn't know were there", I...
Date: 04/24/2009
I was working a case last week where I wanted to instate some fairly simple plan guides for a query...
Date: 03/30/2009
Although Books Online makes some mention of SQLDIAG customizations, it doesn’t any explicit...
Date: 03/27/2009
Following my presentation here in Västerås yesterday there were a few people waiting to speak to me...
Date: 03/18/2009
I'll be presenting (my usual mantra on using SQLDIAG to troubleshoot your own problems) at 16:15...
Date: 03/16/2009
Elisabeth Redei asked me to respond to a question earlier today following a comment on her blog post...
Date: 03/10/2009
I am fortunate enough to be contining the testing of my hypothesis that skiing in Sweden is better...
Date: 02/18/2009
It's always amazing when you find something new in something so common that you thought you knew so...
Date: 02/13/2009
[alternative title: Memory Troubleshooting using DBCC MEMORYSTATUS] The following samples are taken...
Date: 02/03/2009
Quick post today. Was playing around with something on Friday night, thinking how to answer this...
Date: 02/02/2009
Having built a SQL Server 2005 cluster on virtualized hardware, using Virtual Server, i thought it...
Date: 01/22/2009
In November I wrote here about problems executing maintenance plans due to Integration Services...
Date: 01/20/2009
We've just published a change to KB925976 on how to work around the following setup error: Error...
Date: 01/19/2009
Here's the source for a tiny C# app I wrote to test database mirroring failover at the application...
Date: 01/16/2009
This is something I was thinking about this week whilst chatting with a customer. I've done it...
Date: 01/15/2009
SQL Server 2005 service pack 3 released today and you can download it from here:...
Date: 12/16/2008
Here's another error that I picked from the forums today, which I see a fair number of occurrences...
Date: 12/11/2008
I've been posting in the MSDN and TECHNET mirroring forums in the last few days and I've noticed a...
Date: 12/08/2008
I just noticed that my colleague João blogs as well. You can find his blog here:...
Date: 12/02/2008
In the RTM build of SQL Server 2008 , if you install the tools in any edition, you are able to...
Date: 11/27/2008