Product has been added to your cart.

Posts by Brent Ozar

Brent Ozar
2446 posts
https://www.brentozar.com
I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. I'm based out of Las Vegas. He/him.

Updated First Responder Kit and Consultant Toolkit for December 2023

Brent Ozar
First Responder Kit Updates
1 Comment
New this month: more work on letting sp_Blitz run with limited permissions, nicer Markdown output, sp_BlitzLock compatibility with Managed Instances, and more. Wanna watch me use it? Take the class. 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…
Read More

[Video] Office Hours: 21 Good Questions

Brent Ozar
Videos
2 Comments
This one is a 3-part episode: I take 21 questions from https://pollgab.com/room/brento and then later, work on First Responder Kit pull requests. Here’s what we covered: 00:00 Start 01:08 MooneyFlyer: Hey Brent, apart from installing and playing around with it, what is the best way to get started with Postgres for someone familiar with SQL…
Read More

[Video] Office Hours: Wrong Side of the Bed Edition

Brent Ozar
Videos
1 Comment
I woke up on the wrong side of the bed after a nap. How does that even happen?!? To take the edge off, I poured myself a gin & tonic and went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 05:41 LongRunningBackups: You say to use SAN snapshot backups on larger…
Read More
Brent Reading Book

Interesting Aurora MySQL Feature: The Buffer Pool Survives Restarts

Brent Ozar
Amazon Web Services (AWS)
11 Comments
“Documentation! Hey, look at that.” Lemme start this off by saying this is probably irrelevant to you. (It’s irrelevant to me, too.) If you’re strapped for time, just skip past this blog post. This one’s for the curious folks. AWS Aurora MySQL is Amazon’s flavor of MySQL with their own unique performance and reliability improvements.…
Read More

[Video] Office Hours: Sunshine Edition

Brent Ozar
Videos
1 Comment
You know how this works: you posta the questions at https://pollgab.com/room/brento, and I giva the answers: Here’s what you asked in this episode: 00:00 Start 03:18 DBA in VA: I recently discovered the “force order” query hint. I’m usually inclined to let the optimizer do its thing, but I have seen some of our code…
Read More

[Video] Office Hours: Really Good Questions Edition

Brent Ozar
Videos
0
Y’all were on fire in this one! You posted great questions at https://pollgab.com/room/brento and I worked through ’em: Here’s what we covered: 00:00 Start 04:06 DislikeEntityFramework: In AWS RDS, we inherited a 9TB table with uniqueidentifier as clustered PK, another column is an identity int but not needed. How can we quickly fix this? Drop…
Read More

[Video] Office Hours: Ask Me Anything About SQL Server and Azure

Brent Ozar
Videos
2 Comments
In between client calls, I stop to review y’all’s top-voted questions from https://pollgab.com/room/brento. Here’s what we covered today: 00:00 Start 02:44 mailbox: Do DBA’s still need to be the only ones with permission and responsibility to roll-out code changes in production? Are there are shops in which this is a developer task that doesn’t involve…
Read More

[Video] Office Hours: Live on Black Friday Edition

Brent Ozar
Videos
3 Comments
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

Brent Ozar
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

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

Brent Ozar
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

Brent Ozar
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.

Brent Ozar
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

Brent Ozar
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

Brent Ozar
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