Home Sitemap Feedback About... Print
Custom Search

SQL Server Troubleshooting


I have been working in the IT industry as system / network manager for over 15 years and like most of my colleagues, I have a large collection of troubleshooting links and favorites. I decided to put them on a website for easy access, wherever I am.

The information on this site is about Microsoft's SQL Server. And since I am a general system manager and not an application developer, this site is focused on information to help you install, maintain and troubleshoot your SQL Server.

SQL events, blogs and webcasts Latest SQL related KB articles
Inside SQL Server Integration Services with Andy Leonard (Level 200)

In this geekSpeak, Microsoft Most Valuable Professional (MVP) Andy Leonard discusses best practices for using Microsoft SQL Server Integration Services (SSIS) in the enterprise. Andy explains what SSIS does well and doesn't do well and describes common struggles when learning SSIS ...... (more)
2028436 - Certain database operations take a very long duration to complete or encounter errors when the transaction log has numerous virtual log files

2646329 - How to troubleshoot "Msg 3041" in SQL Server

955763 - The SQL Server Agent service does not start after you upgrade from SQL Server 2008 Express or from SQL Server 2008 Express with Advanced Services to SQL Server 2008 Developer, to SQL Server 2008 Enterprise, or to SQL Server 2008 Standard

2629969 - SQL Server 2008 builds that were released after SQL Server 2008 SP3 was released

Cumulative Updates Included in SQL Server 2008 R2 SP1

982870 - Diagnosing and Troubleshooting SQL Server Performance Problems
Recommended downloads
SQL Server 2012 Release Candidate 0 (RC0)
SQL Server 2012 Express LocalDB RC0
2591748 - Cumulative update package 3 for SQL Server 2008 R2 SP 1
2591746 - Cumulative update package 10 for SQL Server 2008 R2
2648098 - Cumulative update package 3 for SQL Server 2008 SP3