Posts by Brent Ozar

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. Office Hours: Speed Round in Camden HarborWatch this video on YouTube 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?…

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. Office Hours: Ask Me Anything About SQL Server and AzureWatch this video on YouTube Here’s what we covered: 00:00 Start 01:05 Mike: Hi Brent. You’ve mentioned there are two types of DBAs:…

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. Office Hours: SQL Server and Azure SQL DB QuestionsWatch this video on YouTube <sigh>…

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: Office Hours: Having a Bad DayWatch this video on YouTube   Here’s what we covered: 00:00 Start 01:12 NotCloseEnoughToRetirementToStopLearning: If you…

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. Office Hours: You Didn't Miss Anything, I SwearWatch this video on YouTube Here’s what we covered: 00:00 Start 00:12 DBABA (database administrator by accident): I have…

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…

After a long trip through Scandinavia, I’m back in the desert. You posted questions at https://pollgab.com/room/brento and I took the hot seat: Office Hours: Back in the Vegas Home OfficeWatch this video on YouTube   Here’s what we covered today: 00:00 Start 03:15 Marek: Hi Brent, what is the best solution to continuously synchronize Logins…

I have a special guest star on today’s episode: Pinal Dave dropped by the house! We went through a few of the top-voted questions from https://pollgab.com/room/brento. Office Hours with Surprise Special GuestWatch this video on YouTube 00:00 Start 00:15 What happened to you? Did you spend too much time in the sun? 00:48 AccidentalDBA: How…

Despite its location, Hammerfest, Norway attracts countless tourists eager to see the festival celebrating one of the world’s favorite rappers. Did I get that right? I’m not sure I got that right. There’s also fierce competition for the title of northernmost town: nearby Honningsvåg Norway also wants that claim, but with a population of only…

Just after passing the Arctic Circle marker and celebrating with a glass of champagne, I took your top-voted questions from https://pollgab.com/room/brento. Office Hours at the Arctic Circle, NorwayWatch this video on YouTube Here’s what we covered: 00:00 Start 01:13 TheEveryDayDBA: Does it matter on what column you implement a table partition for a very large…