SQL in Stockholm
SQL Server thoughts from the support team in Stockholm
How to configure SQL Server database mirroring between 2 instances on a standalone server
There are lots of troubleshooting articles about how to diagnose connectivity problems when setting...
Author: Graham Kent [MSFT] Date: 11/21/2008
Interesting things to watch out for when using the autoclose database option
Here's something which I've been looking at this week, surrounding the autoclose database option....
Author: Graham Kent [MSFT] Date: 11/13/2008
Want to read some tips and tricks from the SQL Developer support team?
Well if you do you should check out the blog of my colleague and Microsoft pool team partner Spike,...
Author: Graham Kent [MSFT] Date: 11/13/2008
Database Mirroring Monitor can cause large tempdb growth in SQL Server 2005 - changed behavior in SQL Server 2008
On extremely rare occasions in SQL Server 2005, when the following conditions are true: 1. You have...
Author: Graham Kent [MSFT] Date: 11/12/2008
New SQL Blogger from my team
My hugely experienced colleague Clive, from the SQL Escalation team in the UK, has just started a...
Author: Graham Kent [MSFT] Date: 10/24/2008
Non-yielding IOCP Listener - Stack Dump analysis
Here's something I was looking at yesterday which is worth a quick look. It's quite a common...
Author: Graham Kent [MSFT] Date: 09/11/2008
Kayaking and tempdb file placement
So, no posts for 10 weeks, but that's because sometimes there are other things going on in Stockholm...
Author: Graham Kent [MSFT] Date: 09/09/2008
SQL Server Assertions and Dumps – a typical example and some proactive help
I recently worked with a customer who was seeing the following error in their error log: SQL Server...
Author: Graham Kent [MSFT] Date: 06/25/2008
Slow recovery times and slow performance due to large numbers of Virtual Log Files
In my previous post about database mirroring configuration problems caused by large numbers of...
Author: Graham Kent [MSFT] Date: 05/16/2008
1413 error when starting Database Mirroring – How many virtual log files is too many?
Recently in Cumulative update package 6 for SQL Server 2005 Service Pack 2 we released a fix for a...
Author: Graham Kent [MSFT] Date: 05/09/2008
Performance Problems in SQL Server - What data should I collect?
If you ever talk to me or any of my colleagues in the SQL Server PSS support team, and you have a...
Author: Graham Kent [MSFT] Date: 04/14/2008
Somewhere to start
Following my guest posts with Tess, here and here, I thought it would be interesting to expand some...
Author: Graham Kent [MSFT] Date: 04/14/2008