Posts by Brent Ozar

On Black Friday, I took a break from answering support emails to hit your top-voted questions from https://pollgab.com/room/brento.   Here’s what we covered: 00:00 Start 00:41 MatthewsSQLServer: How AlwaysON AG failovers cause can be analyzed, is it DB/Cluster/Infrastructure/AD issue. Can you please suggest any videos or blogs that can help? 02:19 NotADeveloper: We have a…

In this episode, a lot of the questions triggered mentions of our Black Friday Sale, on now! Here’s what we covered: 00:00 Start 01:41 Pete: 1 NUMA, 2 NUMA, 3 NUMA, 4 NUMA, or More? 176 cores, 1.5 TB RAM, currently all in a single NUMA configuration. I’m just a jr DBA so researching if…

I first answered these while standing at a harbor in Maine, but upon arriving home, I realized my camera had failed to record any audio. Doh! So I took the list of questions from https://pollgab.com/room/brento and streamed ’em from my home office in Vegas instead. Here’s what we covered: 00:00 Start 02:51 Furkan: Hello Brent,while…

On an overcast morning in scenic Camden, Maine, I stood on the docks and took your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:54 Alma Fahlstrøm: Does index fragmentation matter with column store indexes on SQL 2019 / NVME San storage? 01:22 Miss Minutes: What is your recommended way to find the…

While in historic and beautiful Camden to hang out with friends, I went to Megunticook Falls and answered your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:05 Mike: Hi Brent. You’ve mentioned there are two types of DBAs: Production DBAs and Development DBAs. Are recruiters and hiring managers familiar with the term…

Hey, remember in yesterday’s video how I said I was having a really bad day? Well, here’s how bad it was – I recorded two videos in a row, and I forgot to turn my microphone on for the second video. <sigh> So here are the questions & answers: 00:25 Calvin H: Any tips or…

The first day back after a long vacation is always rough, and today’s no exception. I took your questions from https://pollgab.com/room/brento in an effort to turn things around and get back in the groove:   Here’s what we covered: 00:00 Start 01:12 NotCloseEnoughToRetirementToStopLearning: If you got a new job production DBA where you had to…

Why yes, I’m wearing the same shirt as the video from “yesterday”. Why do you ask? Stop paying attention to that, and check out the top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:12 DBABA (database administrator by accident): I have a complex, nested view. everytime after a dacpac deployment this view runs…

I visited friends in Salem, Massachusetts, home of the 1692 witch trials, and it turns out Salem is a great place to visit around Halloween! There were tours, characters in costume, witch gear shops, and all kinds of spooky-themed happenings. I sat down outside of the Charter Street Cemetery to take your top-voted questions from…