Posts by Brent Ozar

Eyes up here, kid

Free Webcast: Help! My SQL Server Maintenance is Taking Too Long!

“Time for a smoke break.” You manage growing SQL Server databases with shrinking nightly maintenance windows. You just don’t have enough time left each night to do the necessary backups, corruption checking, index maintenance, and data jobs that your users and apps want to run. Cloud storage isn’t helping the problem, either. Stop playing Tetris…
Read More

We Lost Gareth Swanepoel.

Thirteen years ago, I met Gareth Swanepoel (@GarethSwan) for the first time, interviewed him for his first real sysadmin job, and … turned him down. Gareth Swanepoel circa 2007 Thankfully, my manager overruled me and hired him anyway. Thank goodness – and thank goodness Gareth forgave me for my incredibly bad judgment, hahaha. Gareth proved…
Read More

Your Ten Favorite Blog Posts from 2020

The most popular posts this year were when I ran my Fundamentals classes for free throughout the year. I ran a different class per month, and posted signups and videos here on the blog. I’m setting those aside, though, because they’re not evergreen: they’ve since disappeared since I only ran ’em free for a limited…
Read More
How I Use the First Responder Kit

Updated First Responder Kit and Consultant Toolkit for December 2020

sp_BlitzLock gets better identification of parallel deadlocks, sp_DatabaseRestore uses Ola’s scripts for logging, and lots of bug fixes this month. Watch and learn To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First Responder Kit extension: ctrl/command+shift+p, First Responder Kit: Import. PowerShell users: run Install-DbaFirstResponderKit from dbatools Download the…
Read More
Menu
{"cart_token":"","hash":"","cart_data":""}