|
Description
This course is about learning a very specific skill that’s one of the most important ones to becoming a senior level SQL Server DBA and that is – Where do you begin troubleshooting production issues?I’m going to give you the starting point and we are going to work through several examples of real world scenarios where a SQL Server was down and how I brought back online.All industries have their own vernacular and the SQL world is no exception.I’ll be introducing some new terms and scripts that are very specific to performance tuning and optimization.These scripts and how I apply them are worth the cost of the course.Performance tuners are like mechanics. Our goal is to keep the SQL engine as tuned as it possibly can be.In the real world, the elite SQL Server DBAs don’t use canned tools. Many of the greats have a library of scripts and they use ONE of these every single day.If you don’t have a script library started then I’ll show you how to set one up and GIVE you your first few scripts.When I’m called into troubleshoot a struggling SQL Server I always use ONE script first.
Who is the 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.
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.
|
