Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
9 Hour(s) 11 Minute(s)
Language
English
Taught by
Sandro Servino
Rating
Course Overview
Monitoring with DBADASH, Stress Testing with SQLQUERYSTRESS, DBATools, and Essential Scripts for the SQL Server DBA
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 DBADash
Configure and use this powerful free tool that provides complete dashboards on the health and performance of your SQL Server.
Stress Testing with SqlQueryStress
Simulate real workloads and evaluate how SQL Server behaves under pressure. Perfect for critical environments!
Query Analysis with Statistics Parse
Learn how to understand CPU usage, I/O, and execution time of your queries. Make data-driven decisions.
DBATools and Essential PowerShell Scripts
Explore 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 Scripts
Master renowned tools and scripts from the world’s top SQL Server gurus:
Brent Ozar
Adam Machanic
Ola Hallengren and more
Exclusive scripts developed by me to simplify SQL Server performance monitoring.
Who is this course for?
Beginner and experienced DBAs
IT Infrastructure teams
Developers who need to better understand query performance
Professionals who want to solve real SQL Server performance problems
Learn through practical examples, real tools, and the expertise of someone who works in the database world every day.
Course Content
- 9 section(s)
- 37 lecture(s)
- Section 1 Course Presentation
- Section 2 Working with the DBADash Monitoring Tool
- Section 3 Working with the Grafana Monitoring Tool
- Section 4 Working with the Load Testing Tool SQLQueryStress
- Section 5 Working with the Performance Analysis Tool Statistics Parser
- Section 6 Working with the Holy Grail of Scripts for SQL Server
- Section 7 Amazing PowerShell scripts DBATOOLS.IO
- Section 8 Other useful scripts for the daily work of a SQL Server DBA
- Section 9 Course Closing
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
