October, 2010

We at SQL Server support team, continue to invest our time in writing tools and utilities which can aid you in troubleshooting SQL Server issues. SQL Server Backup Simulator is one such tool which will help you while troubleshooting issues in taking backup...

A recent discussion on the #sqlhelp hashtag on Twitter got me researching into this issue. The error message was: 2010-10-19 02:56:59.380 Logon Error: 18456, Severity: 14, State: 11 . 2010-10-19 02:56:59.380 Logon Login failed for user <Server name>...

Recently, I worked on an interesting case where customer after upgrading an instance of SQL Server 2008 with SP1, the SQL server 2008 services and resources went into a stopped and failed state respectively. The services might appear to come online briefly...

Troubleshooting tempdb growth due to Version Store usage Recently I worked on an issue where the tempdb database version store cleanup was not occurring. I created a small repro to demonstrate the behavior. My tempdb has been showing the version...