Posts by Brent Ozar

[Video] Office Hours: Live on Black Friday Edition

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

[Video] Office Hours: Black Friday Promo Edition

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

BrentOzar.com Cyber Monday Week Sale

Company News
0
Every November, we run a huge sale here on my training courses, apps, and online services. Now’s your chance to talk to the boss and get the SQL Server and Azure SQL DB training that will help your company solve real problems in the year 2024 and beyond. The Fundamentals package is best if you’ve…
Read More

[Video] Office Hours: Brent’s Cursed Technology Edition

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

[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. 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…
Read More
And it looks bad even in shades.

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

Humor
24 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. 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…
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. <sigh> So here are the questions & answers: 00:25 Calvin H: Any tips or…
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:   Here’s what we covered: 00:00 Start 01:12 NotCloseEnoughToRetirementToStopLearning: If you got a new job production DBA where you had to…
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. 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…
Read More

The Black Friday Sale is Live!

Company News
4 Comments
You’ve used sp_Blitz and the First Responder Kit to learn a lot about your databases. You read the blog regularly, subscribed to the free newsletter, watched some of my YouTube videos, maybe even watched me on Twitch or followed me on Instagram. You wanna take my training classes, but… they’re expensive. I feel you, and…
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 My 2023 Black Friday Sale!

Company News
7 Comments
You’ve used sp_Blitz and the First Responder Kit to learn a lot about your databases. You read the blog regularly, subscribed to the free newsletter, watched some of my YouTube videos, maybe even watched me on Twitch or followed me on Instagram. You wanna take my training classes, but… they’re expensive. I feel you, and…
Read More