SQL in Stockholm
SQL Server thoughts from the support team in Stockholm
The end of the line
Today is my last day at Microsoft. I’m off to do something completely different, joining a small...
Date: 02/04/2011
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...
Date: 01/10/2011
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...
Date: 01/05/2011
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...
Date: 12/10/2010
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...
Date: 11/01/2010
The Forefront TMG/UAG team in Stockholm is hiring
Following the success of my previous post about recruitment, we're advertising another position from...
Date: 09/27/2010
The SQL Server Support Team in Stockholm is hiring
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
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...
Date: 03/12/2010
Troubleshooting SQL Server Management Studio with SQL Profiler and Debugging Tools – Part 3
(An alternate title for this post could be “How to debug SSMS managed code”) In the first 2 posts of...
Date: 02/03/2010
Changed behaviour of OPTION RECOMPILE syntax in SQL Server 2008 SP1 cumulative update #5
On Monday we released Cumulative update package 5 for SQL Server 2008 Service Pack 1, under...
Date: 11/18/2009
Troubleshooting SQL Server Management Studio with SQL Profiler and Debugging Tools – Part 1
This is the first in a series of 3 posts which discuss troubleshooting SQL Server Management Studio...
Date: 10/20/2009
SQL Server Database Mirroring Pre-requisites and guidelines
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
SQL Server DMV script for monitoring USERSTORE_TOKENPERM size by token type and number
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
SQL Server DMV script for searching the plan cache by query text, plan handle or execution time
I guess everyone has their own set of DMV scripts to hand when working with SQL Server nowadays. I...
Date: 09/24/2009
Realistic troubleshooting example of extended events (XEvent) usage in SQL Server 2008 – Part 1
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
Fixed - incorrect CPU time reported by sys.dm_exec_query_stats for parallel plans
I was discussing with Elisabeth back in this blog post about the above problem, and made comments...
Date: 09/03/2009
Troubleshooting SQL Server deadlocks and performance when running SharePoint
I’ve worked on a lot of cases this year involving SharePoint. Here are some example problems I...
Date: 06/15/2009
Download location for SQLDIAG Perfstats DMV scripts
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
SQL Server 2005 Error: 701, Severity: 17, State: 193
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
New SQL Server 2008 DMV which I noticed this week - sys.dm_os_sys_memory
In the continuing series of "things I notice in SQL Server which I didn't know were there", I...
Date: 04/24/2009
Unable to use forced parameterization when deploying plan guides in SQL Server 2005
I was working a case last week where I wanted to instate some fairly simple plan guides for a query...
Date: 03/30/2009
How to Customise SQLDIAG in SQL Server 2008 to collect DBCC MEMORYSTATUS
Although Books Online makes some mention of SQLDIAG customizations, it doesn’t any explicit...
Date: 03/27/2009
TechDays Sweden: post presentation questions and follow ups
Following my presentation here in Västerås yesterday there were a few people waiting to speak to me...
Date: 03/18/2009
Come and say Hi at TechDays Sweden tomorrow....
I'll be presenting (my usual mantra on using SQLDIAG to troubleshoot your own problems) at 16:15...
Date: 03/16/2009
sys.dm_exec_query_stats DMV can report invalid information for parallel plans
Elisabeth Redei asked me to respond to a question earlier today following a comment on her blog post...
Date: 03/10/2009
No SQL posts this week - skiing again!
I am fortunate enough to be contining the testing of my hypothesis that skiing in Sweden is better...
Date: 02/18/2009
Kill with rollback estimation
It's always amazing when you find something new in something so common that you thought you knew so...
Date: 02/13/2009
SQL Server Compilation Bottlenecks – Error: 8628, Severity: 17, State: 0. – Part 1
[alternative title: Memory Troubleshooting using DBCC MEMORYSTATUS] The following samples are taken...
Date: 02/03/2009
Which sessionid has the most locks in a SQL Server instance
Quick post today. Was playing around with something on Friday night, thinking how to answer this...
Date: 02/02/2009
Thoughts about building a SQL Server 2008 cluster in Hyper-V
Having built a SQL Server 2005 cluster on virtualized hardware, using Virtual Server, i thought it...
Date: 01/22/2009
Problems executing maintenance plans in SQL Server 2008 - Resolved by SQL 2008 CU#3
In November I wrote here about problems executing maintenance plans due to Integration Services...
Date: 01/20/2009
Error 29528. The setup has encountered an unexpected error while Setting Internal Properties
We've just published a change to KB925976 on how to work around the following setup error: Error...
Date: 01/19/2009
Sample Application to test database mirroring failover
Here's the source for a tiny C# app I wrote to test database mirroring failover at the application...
Date: 01/16/2009
Starting SQLDIAG or PSSDIAG automatically using SQL Alerts
This is something I was thinking about this week whilst chatting with a customer. I've done it...
Date: 01/15/2009
Changes to management of 'TokenAndPermUserStore' in SQL 2005 SP3
SQL Server 2005 service pack 3 released today and you can download it from here:...
Date: 12/16/2008
SQL Server Database Mirroring error 1443 - Connection Handshake Failed
Here's another error that I picked from the forums today, which I see a fair number of occurrences...
Date: 12/11/2008
Database Mirroring Error 1418 Troubleshooter
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
More blogs from the SQL Server Support team in Europe
I just noticed that my colleague João blogs as well. You can find his blog here:...
Date: 12/02/2008
Problems executing maintenance plans in SQL Server 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