How I Solve 95% of All SQL Server Outages

Learn How To Troubleshot Any Down SQL Server With One Free Script

Created by: Mike West
Creator of LogikBot

What Will I Learn?

• Be able to troubleshoot the vast majority of produciton down situations.
• Understand how organic transactions flow through a well tuned SQL Server.
• You'll have a well defined, simplistic process approach on how to approach any outage.
• Answer any interview question on the topic of production outages with conviction.
• Speak the proper vernacular when discussing performance tuning, wait statistics and SQL Server incidents.
• Accurately analyze performance related outages.

Requirements

• Before you begin you will need to a strong fundamental grasp for SQL Server
• Using the industry vernacular on SQL Server DBA levels, the course is intended for junior level SQL Server DBAs and above.
• You’ll need to have SQL Server installed on a laptop or environment where you can run the demos.
• All of the demos are written in transact. All versions from 2005 forward will work however, ideally you’ll be using 2012 or 2014.
• You’ll need to have local administrative permission on this environment to install one small application.
• All the tools, scripts and code needed for this course are included in the cost of the course. There are no additional fees.

Target audience

• Those with a fundamental understanding of SQL Server.
• If we use the collegiate scale this course would be a 300 level course.
• While I appreciate your enthusiasm beginners should wait until they’ve had a couple of years of experience under their belt before working through this course. It will be here when you’re ready.
• The ideal student would be a mid to senior level SQL Server DBA with three or more years’ experience as an operational DBA.