Let’s Make September Our Free Community Tools Awareness Month.
Last week, I was reading a brand new article from a Microsoft employee about how you should directly […]
Production Database Administration
Office Hours Speed Round, Text Edition
Not all of the questions y’all post at https://pollgab.com/room/brento are hard – some of ’em can be answered […]
Office Hours Speed Round: Text Edition
I recorded an Office Hours stream answering a bunch of your questions quickly, but…I forgot to turn on […]
Office Hours, Text Edition: No-Brainer Questions
Not all questions require a video answer. Here are some simple no-brainer ones: Q: BehindTheScenesDBA: With all its limitations, […]
Meme Week: SQL Server 2012 as of 2022
This week, I’m writing blog posts that can be summed up in one image. Here’s the first one: […]
What Trace Flags Are You Using, and Why?
Most of the time, when you need to change SQL Server’s behavior – like how it handles memory […]
Don’t Use SQL Server to Send Emails.
I would like to unsubscribe from this idea. I’m not talking about Agent alerts when jobs fail. That’s […]
How to Patch SQL Server
Microsoft releases SQL Server Cumulative Updates about every 60 days. This is a part of your job that […]
What Does a Database Administrator Actually Do?
BrentOzar.com is 20 years old, and I’m celebrating by being a little retrospective and future-looking this month. Today, […]
What’s a Size-of-Data Operation?
Database professionals say, “That’s slow because it’s a size-of-data operation.” A size-of-data operation is when the database has […]
Free Webcast: Help! My SQL Server Maintenance is Taking Too ...
“Time for a smoke break.” You manage growing SQL Server databases with shrinking nightly maintenance windows. You just […]
Frequently Asked Questions from Office Hours
In my Twitch & YouTube live streams, some questions seem to come up every week. I’m not expecting […]
Databases Are Like Walk-In Coolers. #tsql2sday
In the back of a restaurant, there’s a walk-in cooler (or a few of ’em.) When a chef […]
Updated Fundamentals of Database Administration Class: Just $39
You’re a systems administrator or developer who’s been stuck in charge of the SQL Server. You have a […]
SQL Server Problems We Don’t Have Anymore
We have completely new problems today. I was cleaning out a folder of presentations and I realized there […]
How to Install Azure Data Studio to Work with SQL ...
(intro will go here) Download Azure Data Studio on your desktop. Do this on your desktop, not the […]
How to Get Started with SQL Server Management Studio
In the big picture, you need to: Download the free Microsoft SQL Server Management Studio and install it, […]
What If You Really DO Need to Shrink a Database?
You’ve heard that shrinking a database is bad because it introduces both external and internal fragmentation, it causes […]
[Video] Free DBA Training Month: Patching SQL Server
While you’re stuck inside wondering if you’ll ever be able to attend a user group meeting again, I’m […]
[Video] Free DBA Training Month: Configuring TempDB, Lock Pages in ...
While you’re stuck inside wondering if you’ll ever be able to attend a user group meeting again, I’m […]
[Video] Free DBA Training Month: Setting Up Alerts and Ola’s ...
While you’re stuck inside wondering if you’ll ever be able to attend a user group meeting again, I’m […]
[Video] Can You Tell When a Rollback Will Finish?
I happened to see this DBA.StackExchange.com question about killing a big delete, and I really felt for the […]
[Video] How Can I Measure If My Database Does More ...
When someone asks you, “Is this database read-intensive or write-intensive?” you probably look at sys.dm_io_virtual_file_stats to measure the file […]