Skip to content
Write a review
UdemySQLPaid courseIntermediate levelCertificate

Building an Automated SQL Server Performance Tuning Engine (Udemy.com)

Real World Automated SQL Server Performance Tuning

4.5
137 reviews

Created by: Mike West

Last updated February 2017

icon
What you will learn

  • At the end of the course you'll be able to take what you've learned and the code I've provided to completely automate tuning a production SQL Server instance.
  • The students will have a solid understanding of how the process of performance tuning at the instance level works.

How it compares

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

  • Rating4.5 out of 5higher than 48% of them
  • Reviews137#324 of 389 by number of reviews
  • Length1.2 hoursshorter than 95% of them
  • Last updatedFebruary 2017earlier than 87% of them

icon
Course Description

Recent Reviews: 

"Mike has given a great template that will allow DBAs to ease their admin tasks. Really well done." -- Doug Alderson

"This is a great tool to help DBAs and non- database system administrator for performance fine tuning" -- Bernard Bernard

Welcome to Building an Automated SQL Server Performance Tuning Engine.

In this course, we are going to build a completely automated application for tuning a SQL Server instance.

The application has been running on live production instances for several years. These SQL Servers have needed no performance tuning attention since the tool was installed.

I’ve created the software and named it SQL Black Box. I choose the name because for most in the organization the inner workings of the tool will be a black box.

The software in the course will be written in C# and the SQL Server code will obviously be transact-sql.  

This is not a step by step on how I authored the code. This course assembles the sundry components that make up the application. 

You’ll be able to take the application and install it on any SQL Server you want.  You won’t be able to resale any portion of the code but that’s the only restriction.

Regardless of your skill level this application will ease your administrative burden.

Advanced students will be able to choose what modules they want to implement. I use the term module within the software to denote individual unit of work.

For example, there will be a module that removes exact duplicates and there will be a module that adds high impact indexes to the instance.

Please note I used the word instance and not databases. We don’t tune databases; we tune the instance they are on because all the critical resources are shared at that level.

Those students newer to SQL Server will be able to change a couple of lines of code, build the modules and then use task scheduler to automated their schedules.

Thank you for your interest in Building an Automated SQL Server Performance Tuning Engine and we will see you in the course.

Read More Intermediate Intermediate Level product length iconTime: 1.2h

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

Mike West

I'm the founder of LogikBot. I've worked at Microsoft and Uber. I helped design courses for Microsoft's Data Science Certifications. If you're interested in machine learning, I can help.

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  

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
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

All SQL courses

icon
Reviews

4.5

137 ratings on Udemy

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

Write a review

By Bill Kelly on 6/26/2020

Great tangible scripts to help setup and automate performance tuning. Mike also delivers in a succinct, get-right-to-the-point format.

By Thato Mekwa on 9/5/2019

I couldn't get the vs solution working on my machine, but its a reference problem. I will have to look at this in the future. Really an awesome skill.

By Curtis Bragdon on 4/15/2019

Excellent course on modulizing maintenance task without using SQL Server Agent. Great for small shops with no DBA or a Jr DBA

By Joseph Bartholomew on 3/6/2019

was searching for this code online cuz i knew its possible database maintenance, should be automatic. i really like the automatic index management cuz right now microsoft only dose this on azure which is limiting for me.

By Greg Regan on 12/21/2018

Very patiently explained to those of us who are not as technically experienced. I'm actually implementing this on a production SQL Server instance and it's working great. One bonus is that as well as addressing automated tuning, it gives you a template to implement timed execution of your own stored procedures. For example, I was triggering a backup script using the windows timer API in an Access front end VBA but these can be problematic. Now I use the solution provided in this course to run a backup stored procedure hourly on the server using Windows Task Scheduler.

By Leroy Gonzalez on 4/29/2018

So far a very well-taught course with good presentation quality. I know it's focused on the SQL Black Box tool only but still might be good to have a little more detail on SQL performance in the early segments.

By Robert Ryks on 3/19/2017

Very useful. The course is worth the cost if you are looking to automate a few of the troublesome tasks you have to do as an SQL server DBA. I had hopped for some magic but most of what I saw was variations of existing ideas and scripts that are readily available. It is helpful though to have them all in one comprehensive tutorial.

By Marcos Vinicio de Oliveira on 2/15/2017

This course got me, very quickly, to the point I was hoping for. There are very good explanations about the topics and very good exemples.

By Doug Alderson on 2/12/2017

Mike has given a great template that will allow DBAs to ease their admin tasks. Really well done.

By Bernard Garcia on 2/9/2017

This is a great tool to help DBAs and non- database system administrator for performance fine tuning

Showing all 10 reviews on CourseDuck

Read all 137 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

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

Overall Score : 90 / 100

Building an Automated SQL Server Performance Tuning Engine
Visit course on Udemy Write a review
  • Video Duration: icon 1.2h
  • Price: $59.99
  • Provider: icon Udemy
  • Updated: icon February 2017
  • 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