Office Hours: One-Word Answers Edition
Some of the questions y’all post at https://pollgab.com/room/brento are pretty straightforward. Let’s get ‘er done. LetTheDbaHandleIt: My friend needs […]
Production Database Administration
Erik Darling’s Month of Free Tools Training
Over the past month (plus or minus a couple days), Erik Darling churned out dozens of posts to […]
Most DBAs Say They’re Encrypting Personally Identifiable Data. Most.
Despite the continuous stream of data breaches, ransomware, and GDPR violations, some companies still aren’t encrypting personally identifiable […]
Office Hours, Short Text Answers Edition
Not all of the questions y’all post at https://pollgab.com/room/brento require long, thought-out answers. Some are just one-line specials, […]
Your Turn: I’m Not Answering These 13 Office Hours Questions
Normally, after I do a round of Office Hours of going through the questions that got posted at […]
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 […]
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 […]