Advanced SQL Server Performance Tuning
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
A Pragmatic Real World Approach To Tuning SQL Server.Description
COURSE REVIEWS:
"It's not what I thought it would be. It covers limited topics and does not present a solid step by step approach to approaching a SQL server you've never had a dealing with and finding the performance issues and fixing them." -- Albert
"This is the 9th Mike West course I have taken. The dude really know his stuff and is able to relay to the listener in a very approachable way. Quick note if you do the exercises yourself - you want to give SQL Server time to "catch up" -- Apkambledev
"Good & very well explain especially the Live Demo step by step. The way explanation capture the attention to listen & very interesting." --Micheale.See
"Great ,Learning many things. thanks !!"-- Mittal
"Awesome tutorial." -- Sivram
"This is a great quick course with many take aways! It's short and to-the-point, which's great for people with familiarity with the subject." - Said
"Excellent course, very good examples" -- Cesar
"The course is pretty clear so far albeit, slightly brief." -- Ken
"Its excellent very much informative." -- Afroz
"A good course with information and tips that apply to the real world." --Ian B
"In depth." -- Sherrie
"Thanks for the great course!" -- Andrey
"Nice course. Simple and crisp." -- M1981
"Great course! The things that Mike taught are practical and can be applied in the real world immediately." -- Ricky V.
"This gives a deep diving scenario." -- Anish
COURSE INTRODUCTION
This course focuses on making SQL Server perform more optimally.
In my first course we laid the groundwork by tuning OUR instances with a top down approach.
WE will continue on that path with this course.
Even though the course has the word “Advanced" in it, there's NOTHING COMPLICATED about taking what's in the course and applying it in the real word.
It's “advanced" in that I'll take more time explaining how to implement these recommendations.
The course is still very much a "buttons and Knobs" course. This simply means WE won't dive too deeply into the minutia. We are still going to focus on items that are easily implemented. Some features will have a level of contention associated with them in the SQL Server community. It will be up to you decide to implement or not.
Additionally, some of the concepts may be new to even more senior level resources so I want to make sure I'll cover the why of the topic as well as the how.
This course will give YOU deeper insight into what it takes to become a skilled PERFORMANCE TUNER. Once thought of as an art, performance tuning is nothing more than a series of processes that seek to accomplish TWO basic goals.
The FIRST one is to increase the response time for a given transaction or set of transactions.
The SECOND one is reduce resource consumption. On the surface this sounds simple but nothing could be further from the truth.
Take the next step on YOUR performance tuning journey and SIGN UP now.
Requirements
- Requirements
- You will need to have SQL Server 2012 or 2014 installed. It can be an express version.
- I'll be providing all the scripts and schema for the course. There is no other cost other than the price of the course. Everything else is included or free.
- If you're not familiar with SQL Server fundamentals then this course may not be for you. I do appreciate and understand your enthusiasm and promise this course will be here when you're ready.
Advanced SQL: MySQL Data Analysis & Business Intelligence
- 4.7
-
![]()
![]()
![]()
![]()
![]()
Master advanced SQL database coding w/ MySQL Workbench. My SQL course takes your SQL analysis skills to new heights! ______________________________ See why John is one of the TOP-RATED SQL/MySQL Instructors on Udemy:...
Oracle PL/SQL Database Administration: 11g/12c DBA Developer
- 2.7
-
![]()
![]()
![]()
![]()
![]()
Oracle PLSQL Database Administration: Become A Oracle DBA 11g, Goldengate 12c Developer, Advanced SQL Java Certification PL/SQL is a procedural language designed specifically to embrace SQL statements within its syntax....
Data Visualization with Tableau - Novice to Pro!: 5-in-1
- 4.3
-
![]()
![]()
![]()
![]()
![]()
Master the art of creating insightful visualizations from complex data with this visually appealing tutorial! Tableau is one of the fastest evolving Business Intelligence (BI) and data visualization tools....
Learn How To Become an Azure SQL Database Architect
- 0.0
-
![]()
![]()
![]()
![]()
![]()
A Pragmatic Introduction To Azure SQL Database Some Course Reviews from Similar Courses: "I've also looked at the database with multiple system monitoring products....
