Skip to content
Write a review
UdemySQLPaid courseIntermediate levelCertificate

How I Solve 95% of All SQL Server Outages (Udemy.com)

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

4.4
344 reviews

Created by: Mike West

Last updated September 2015

icon
What you will 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.

How it compares

Against the other 388 rated Udemy courses in SQL on CourseDuck:

  • Rating4.4 out of 5higher than 34% of them
  • Reviews344#244 of 389 by number of reviews
  • Length1.3 hoursshorter than 94% of them
  • Last updatedSeptember 2015earlier than 97% of them

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 88 / 100

icon
Course Description

Recent Review:
"This was one of the most useful classes I have taken in a long time. Very specific, real-world examples. It covered several instances of 'what is happening', 'what it means' and 'how you fix it'. I was impressed." Steve
What do I mean when I use the words "real world?"

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.
You'll learn the language of performance tuning.
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.
One stored procedure to rule them all!
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.
This script was developed by one of the world's leading experts on SQL Server and used by many of the world's leading experts on SQL Server.
This is a hands on course.
You will simulate a OLTP application and learn what to look for when issues arise. All of the demos are written in transact. Everything is included in the price of the course. Set up for the course is easy. Installing the tools will take several minutes.
The most important part of our course will be working through the real world examples. All my lessons will have very specific instructions. The set up for all of the lessons is simply to cut and paste the transact code into SQL Server Management Studio.
The vast majority of the course will be working through the demos and analyzing how to troubleshot production down issues and what steps can be taken to bring the server back online.
The course will also include lectures but the lectures will be short and pragmatic. SQL Server is one of the most complicated pieces of software in Microsoft's suite. This course will provide you with the single most important facet to analyzing real world outages. Where do you start?
If you want to be one of the most skilled SQL Server DBAs then you MUST learn how to use this script effectively!
Start now! Enroll today. Who this course is for:
  • 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.
Read More Intermediate Intermediate Level product length iconTime: 1.3h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

placeholder

Machine Learning Enthusiast
I've worked with databases for over two decades. I've worked for or consulted with over 50 different companies as a full time employee or consultant. Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman.
Over the last five years I've transitioned to the exciting world of applied machine learning. I'm excited to show you what I've learned and help you move into one of the single most important fields in this space.
Experience, education and passion
I learn something almost every day. I work with insanely smart people. I'm a voracious learner of all things SQL Server and I'm passionate about sharing what I've learned. My area of concentration is performance tuning. SQL Server is like an exotic sports car, it will run just fine in anyone's hands but put it in the hands of skilled tuner and it will perform like a race car.
Certifications
Certifications are like college degrees, they are a great starting points to begin learning. I'm a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) and Microsoft Certified Trainer (MCT).
Personal
Born in Ohio, raised and educated in Pennsylvania, I currently reside in Atlanta with my w

Read More

icon
More courses by Mike West

$14.99

Free

$13.99

$69.99

$54.99

$54.99

All courses by Mike West

icon
Reviews

4.4

344 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Framir Rivas

Fantastic !!!

By Larry Eisenstein

What else can you say about a free course.... except Thank you!

By Abiy Shekur

Well-Done!

By Laurence Proctor

This is a fantastically structured course, and the material alone is worth more than the course itself. Excellent material, well structured approach. Fantastic Course!! A+++

By Anonymized User

More excercises and examples will help us to understand better.

By John Campbell

Excellent content presented both clearly and efficiently.

By Dave Greening

I little monotonous - perhaps a bit more excitement from the author?

By Anonymized User

Great course! Thanks for the specific examples of these common issues.

By Ahmad

may I expect more information about that subject

By Rukai Lou

The Load Generator is the best part of this course.

By Kucheruk Serhii

Examples are not very clear. Lecturer speaks to fast and it is hard to understand

By David Slaughter

This was a great course where the instruction was understandable and fun to follow.

I would highly recommend everyone to take this course.

Showing 12 of 49 reviews

How I Solve 95% of All SQL Server Outages
Visit course on Udemy Write a review
  • Video Duration: icon 1.3h
  • Price: $49.99
  • Provider: icon Udemy
  • Updated: icon September 2015
  • Level: Intermediate Intermediate
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com