Posts by Brent Ozar

[Video] Office Hours in Camden Harbor

Videos
1 Comment
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?…
Read More
And it looks bad even in shades.

Why Haven’t You Disabled SA? Wrong Answers Only.

Humor
31 Comments
On social media, I asked folks, “Why haven’t you disabled the SA account in your SQL Servers? Wrong answers only.” The results were pretty funny: “I went a step further and also created an account called ‘as’. Now my boss keeps bragging to his golf buddies that we run our database fully SaaS.” – Hugo…
Read More

[Video] Office Hours at Megunticook Falls in Camden, Maine

Videos
0
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:…
Read More

Office Hours, Silent Film Edition

Videos
6 Comments
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>…
Read More
Brent Reading Book

Office Hours: “Read This” Edition

SQL Server
1 Comment
Sometimes when people post questions at https://pollgab.com/room/brento, the answer is just a link, nothing more, nothing less. It doesn’t make sense for me to rehash something that’s been covered really well online, and I want to link ’em to the best resource possible. Petr: Huge slowdown of basic queries when using a partitioned table (Partition_Key…
Read More

[Video] Office Hours: Having a Bad Day Edition

Videos
2 Comments
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…
Read More

[Video] Office Hours: Yes, I’m In the Same Shirt

Videos
7 Comments
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…
Read More

[Video] Halloween Office Hours in Salem, MA

Videos
2 Comments
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…
Read More

Announcing Buy-Now-Pay-Later

Company News
9 Comments
Some of you are staring longingly at my training classes. You don’t get a training budget at work, so anything you invest in your own career has to come out of your own pocket. Good news: we now offer buy-now-pay-later! It’s perfect for one-time purchases like the Lifetime Fundamentals & Mastering Bundle. (We only offer…
Read More

[Video] Office Hours: Back in the Vegas Home Studio

Videos
5 Comments
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…
Read More

[Video] Office Hours with a Surprise Special Guest

Videos
1 Comment
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…
Read More

[Video] Office Hours at the Northernmost Town in the World

Videos
0
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…
Read More

Well, I’m Not Doing SQLBits After All.

SQLBits
66 Comments
I was so excited when SQLBits announced their 2024 dates & location, and I told y’all that I was blocking out my calendar and I’d be there. Unfortunately, not gonna happen. This year, SQLBits dramatically cut payments for speakers. We used to get paid per attendee at our workshops, but that’s done. Now you get…
Read More

[Video] Office Hours at the Arctic Circle

Videos
0
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…
Read More