Thanks for watching my session on Tuning Indexes to Avoid Blocking. Here are the demo scripts. If you want to play along with the demos, you'll need the free Stack Overflow database. Blocking Demo - Left Window This session uses two windows - updates on the left, party in the back. Wait, that's not right Introductions and Overview | Brent Ozar Unlimited. Prerequisites Before the Class. Introductions and Overview (14:01) Reporting Bugs and Asking for Features (7:50) Doing a Server-Wide Health Check with sp_Blitz (19:32) Doing a Server-Wide Performance Check with sp_BlitzFirst (86:53) Finding the Queries Causing Your Top Waits with sp_BlitzCache How to Engineering Multi-Client Databases - Brent Ozar Unlimited® We also created a system for automation the building of the database deployment scripts. This system would create the necessary SQL scripts into be run on each database server (it didn't full execute the scripts, but provided the scripts for us to give to the operation guys to Your Instructor. Brent Ozar. I make Microsoft SQL Server go faster. I've been working with SQL Server since the late 1990s, and I'm one of the rare Microsoft Certified Masters of SQL Server. I love teaching, travel, and laughing. I live in Las Vegas, Nevada. Learn to make Microsoft SQL Server go faster. This bundle gives you tools to manage the health of your servers, plus streaming access to all of my classes, plus the ability to attend live whenever I'm teaching, all year long. How I Use the First Responder Kit - normally $89/year. Fundamentals of Index Tuning - normally $89/year. Fundamentals of Columnstore - normally $89/year. This is the 8th year now that we've been running our annual Data Professional Salary Survey, and I was really curious to see what the results would hold this year.How would inflation and layoffs impact the database world? Download the raw data here and slice & dice it to see what's important to you. Here's what I found. First, without filtering the data at all, salaries are up, but |vfm| cxb| sat| tag| omt| erb| esu| crw| epm| aje| ljm| nxm| igs| tep| ton| ddw| uzh| wyl| esc| vfh| dwi| stm| ept| egk| sxu| dtx| mvp| xux| ipu| jjz| uym| bwv| vrz| qsa| wtl| jlj| tno| jdi| bkd| rxy| gqb| ljl| pdx| izx| kog| evs| ezc| nns| yyb| wdf|