Sql Server Dba Toolkit

Monitoring with DBADASH, Stress Testing with SQLQUERYSTRESS, DBATools, and Essential Scripts for the SQL Server DBA

What you'll learn

Using amazing free tools for SQL SERVER monitoring

Using tools for SQL SERVER stress testing

Using tools for performance analysis

Incredible scripts from the world’s top SQL SERVER experts

Incredible scripts and some of my own scripts for solving SQL SERVER performance issues

Requirements

Basic knowledge of SQL SERVER

Description

If you are a DBA, developer, or IT infrastructure professional working with SQL Server, this course is essential for your daily work! You will learn, hands-on, how to build your arsenal of tools and scripts to have full control over performance and other aspects of your database.What you will master in this course:Professional Monitoring with DBADashConfigure and use this powerful free tool that provides complete dashboards on the health and performance of your SQL Server.Stress Testing with SqlQueryStressSimulate real workloads and evaluate how SQL Server behaves under pressure. Perfect for critical environments!Query Analysis with Statistics ParseLearn how to understand CPU usage, I/O, and execution time of your queries. Make data-driven decisions.DBATools and Essential PowerShell ScriptsExplore the incredible free scripts available at DBATools to automate SQL Server administration. You will also learn how to use some of the amazing ready-made PowerShell scripts, such as automated CU (Cumulative Update) deployment for SQL Server, simplifying repetitive tasks and improving efficiency.Collection of Essential SQL ScriptsMaster renowned tools and scripts from the world’s top SQL Server gurus:Brent OzarAdam MachanicOla Hallengren and moreExclusive scripts developed by me to simplify SQL Server performance monitoring.Who is this course for?Beginner and experienced DBAsIT Infrastructure teamsDevelopers who need to better understand query performanceProfessionals who want to solve real SQL Server performance problemsLearn through practical examples, real tools, and the expertise of someone who works in the database world every day.

Overview

Section 1: Course Presentation

Lecture 1 SQL Server DBA Toolkit Presentation

Lecture 2 000.1 Introduction Class

Section 2: Working with the DBADash Monitoring Tool

Lecture 3 001.1 Installation and Configuration of DBADash_part1

Lecture 4 001.1 Installation and Configuration of DBADash_part2

Lecture 5 001.2 Overview of the DBADash Dashboard Check_part1

Lecture 6 001.2 Overview of the DBADash Dashboard Check_part2

Lecture 7 001.3 About the Configuration Item in DBADash

Lecture 8 001.4 About the Storage and HA/DR Item in DBADash

Lecture 9 001.5 About Jobs and Some Reports in DBADash

Lecture 10 001.6 Checking Information on Specific SQL Server Instances in DBADash

Section 3: Working with the Grafana Monitoring Tool

Lecture 11 About Grafana

Lecture 12 001. Introductory Words About Grafana

Lecture 13 002. Creating Logins and Assigning Necessary Permissions in SQL Server

Lecture 14 003. Installing Grafana and Logging In for the First Time

Lecture 15 004. Creating Data Sources and Dashboards

Lecture 16 005. Creating Dashboards Manually

Section 4: Working with the Load Testing Tool SQLQueryStress

Lecture 17 002.1 Performing Load Tests with SQLQueryStress_part1

Lecture 18 002.1 Performing Load Tests with SQLQueryStress_part2

Section 5: Working with the Performance Analysis Tool Statistics Parser

Lecture 19 007. Using the Statistics Parser Tool

Section 6: Working with the Holy Grail of Scripts for SQL Server

Lecture 20 003. Opening Session on the Holy Grail of SQL Server Scripts

Lecture 21 003. Holy Grail of SQL Server DBA Scripts, Introductory Class

Lecture 22 004. About Adam Machanic's sp_whoisactive_part1

Lecture 23 004. About Adam Machanic's sp_whoisactive_part2

Lecture 24 005. Information on sp_whoisactive, waits, and Brent Ozar's sp_blitz

Lecture 25 005.1 More information on Brent Ozar's sp_blitz

Lecture 26 006. About Ola Hallengren's incredible scripts

Section 7: Amazing PowerShell scripts DBATOOLS.IO

Lecture 27 About DBATOOLS

Lecture 28 001. DBATools, initial explanations

Lecture 29 002. Installing DBATools and using some scripts

Lecture 30 003. Cumulative Updates (CU), patches, hotfixes of SQL SERVER

Lecture 31 004. Updating SQL Server instances using a DBATools script

Section 8: Other useful scripts for the daily work of a SQL Server DBA

Lecture 32 About other scripts

Lecture 33 008.1to3 Usage of indexes and largest tables

Lecture 34 008.4to7 Heaviest SQL and Stored Procedures, disk latency, and main waits

Lecture 35 008.8 Backups and restores running with estimated completion time

Lecture 36 008.9 Job with sp_whoisactive

Section 9: Course Closing

Lecture 37 Bonus Lesson

SQL SERVER DBA,Developers working with SQL SERVER,Infrastructure team working with SQL SERVER