Autoplay
Autocomplete
Previous Lecture
Complete and continue
How I Use the First Responder Kit
Before the Class
Prerequisites Before the Class
Introductions and Overview (13:02)
Reporting Bugs and Asking for Features (7:50)
Download the Slides
The Core Scripts: The Most Important Stuff to Learn
Doing a Server-Wide Health Check with sp_Blitz (26:20)
Doing a Server-Wide Performance Check with sp_BlitzFirst (89:27)
Finding the Queries Causing Your Top Waits with sp_BlitzCache (38:39)
Analyzing Index Design Problems with sp_BlitzIndex (42:01)
Getting AI Advice
Getting Started with the Easy Way: Generating Prompts with @AI = 2 (8:27)
Harder Setup but Easier Execution: Calling ChatGPT & LLMs with @AI = 1 (25:30)
The Specialist Scripts
Analyzing Deadlocks with sp_BlitzLock (19:14)
Check Which Queries Are Running with sp_BlitzWho and sp_WhoIsActive (14:00)
Check Your Data Risks with sp_BlitzBackup (9:14)
Restore & Test Databases with sp_DatabaseRestore (14:13)
Like a Consultant: Writing Up Your Findings
Automate the Data-Gathering Process with the Consultant Toolkit (9:21)
Recap and Writing Up Your Findings (5:08)
Harder Setup but Easier Execution: Calling ChatGPT & LLMs with @AI = 1
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock