Finding the Best Time for Maintenance: Answers & Discussion
Your Query Exercise was to find the best time to do database maintenance by querying the Users table, […]
brentozar.com
Save 5% on SQLBits Registration with BRENT5.
Going to the SQLBits conference in March? Whether you’re registering in-person or attending virtually, save 5% on your […]
[Video] Office Hours: The Question is Not the Problem Edition
I answer your top-voted Azure SQL DB and SQL Server questions from https://pollgab.com/room/brento and lose my temper about […]
Query Exercise: Find the Best Time for Maintenance
If we’ve gotta take the database down for maintenance – perhaps a version upgrade, perhaps upgrading our own […]
Find Posts with the Wrong CommentCount: Answers & Discussion
Your Query Exercise was to find denormalization accuracy problems: checking the accuracy of a reporting column, Posts.CommentCount. There […]
We’re Starting to Automate Testing for the First Responder Kit.
Brent says: It’s really funny how the world works. I wrote what you see below in December 2023 […]
[Video] Office Hours: Ask Me Anything About the Microsoft Data ...
Forgive the hoarse voice – I’m recovering from something COVID-ish. I went through your top-voted questions from https://pollgab.com/room/brento […]
Query Exercise: Find Posts with the Wrong CommentCount
For 2024, I’m trying something new: weekly homework challenges! For this week’s query challenge, we’re going to do […]
Find Foreign Key Problems: Answers & Discussion
Your Query Exercise was to find foreign key problems: data that might stop us from successfully implementing foreign […]
Announcing the 2024 Data Professional Salary Survey Results.
This is the 8th year now that we’ve been running our annual Data Professional Salary Survey, and I […]
Query Exercise: Find Foreign Key Problems
For 2024, I’m trying something new: weekly homework challenges! For this week, let’s say we’ve decided to implement […]
[Video] Office Hours: Oddball Questions Edition
The last Office Hours of 2023 featured some oddball questions from https://pollgab.com/room/brento. Not bad, just … odd. Here’s […]
Who’s Hiring in the Microsoft Data Platform Community? January 2024 ...
Is your company hiring for a database position as of January 2024? Do you wanna work with the […]
[Video] Office Hours: Holiday Speed Round Edition
Most of the https://pollgab.com/room/brento questions from this episode had really short and sweet answers. Let’s take a break […]
Updated First Responder Kit and Consultant Toolkit for December 2023
New this month: more work on letting sp_Blitz run with limited permissions, nicer Markdown output, sp_BlitzLock compatibility with […]
[Video] Working on First Responder Kit Pull Requests
For this month’s First Responder Kit releases, I worked through most of the pull requests live on my […]
The Annual Data Professional Salary Survey Closes This Week!
Take the Data Professional Salary Survey now. The 2020s have been tough: a pandemic, a recession, layoffs, and […]
[Video] Office Hours: 21 Good Questions
This one is a 3-part episode: I take 21 questions from https://pollgab.com/room/brento and then later, work on First […]
[Video] Office Hours: Wrong Side of the Bed Edition
I woke up on the wrong side of the bed after a nap. How does that even happen?!? […]
Interesting Aurora MySQL Feature: The Buffer Pool Survives Restarts
“Documentation! Hey, look at that.” Lemme start this off by saying this is probably irrelevant to you. (It’s […]
[Video] Office Hours: Sunshine Edition
You know how this works: you posta the questions at https://pollgab.com/room/brento, and I giva the answers: Here’s what […]
[Video] Office Hours: Really Good Questions Edition
Y’all were on fire in this one! You posted great questions at https://pollgab.com/room/brento and I worked through ’em: […]
What Would You Ask Your Predecessor? Get Answers with ChatGPT.
So many times in my career, I’ve come across a questionable query, table design, or server configuration decision, […]
How Has Inflation Affected Your Salary? Let’s Find Out Together.
The 2020s have been tough: a pandemic, a recession, layoffs, and inflation. Inflation makes things particularly tricky because […]
Who’s Hiring in the Microsoft Data Platform Community? December 2023 ...
Is your company hiring for a database position as of December 2023? Do you wanna work with the […]
ChatDBA: ChatGPT 4 Answers 5 Office Hours Questions
Every now and then, someone asks a question on PollGab about why I don’t use ChatGPT to answer […]
[Video] Office Hours: Live on Black Friday Edition
On Black Friday, I took a break from answering support emails to hit your top-voted questions from https://pollgab.com/room/brento. […]
[Video] Office Hours: Black Friday Promo Edition
In this episode, a lot of the questions triggered mentions of our Black Friday Sale, on now! Here’s […]
BrentOzar.com Cyber Monday Week Sale
Every November, we run a huge sale here on my training courses, apps, and online services. Now’s your […]
It’s Black Friday! Time to save big on SQL Server ...
My Annual Black Friday Sale is On! I’m running a giant Black Friday sale on my training courses! […]
[Video] Office Hours: Brent’s Cursed Technology Edition
I first answered these while standing at a harbor in Maine, but upon arriving home, I realized my […]
[Video] Office Hours in Camden Harbor
On an overcast morning in scenic Camden, Maine, I stood on the docks and took your top-voted questions […]
Why Haven’t You Disabled SA? Wrong Answers Only.
On social media, I asked folks, “Why haven’t you disabled the SA account in your SQL Servers? Wrong […]
[Video] Office Hours at Megunticook Falls in Camden, Maine
While in historic and beautiful Camden to hang out with friends, I went to Megunticook Falls and answered […]
Office Hours, Silent Film Edition
Hey, remember in yesterday’s video how I said I was having a really bad day? Well, here’s how […]
The Black Friday Sale is Here: Save Big on Training ...
My Annual Black Friday Sale is On! I’m running a giant Black Friday sale on my training courses! […]
The Real Problem with SQL Server’s Licensing Costs
At least once a month, a client has The Postgres Conversation™ with me. It happens at the end […]
Office Hours: “Read This” Edition
Sometimes when people post questions at https://pollgab.com/room/brento, the answer is just a link, nothing more, nothing less. It […]
[Video] Office Hours: Having a Bad Day Edition
The first day back after a long vacation is always rough, and today’s no exception. I took your […]
[Video] Office Hours: Yes, I’m In the Same Shirt
Why yes, I’m wearing the same shirt as the video from “yesterday”. Why do you ask? Stop paying […]
Free Webcast: How to Think Like the Engine, Live
You’re comfortable writing queries to get the data you need. But you’re uncomfortable if someone asks you how it […]
Who’s Hiring in the Microsoft Data Platform Community? November 2023 ...
Is your company hiring for a database position as of November 2023? Do you wanna work with the […]
The Black Friday Sale is Live!
You’ve used sp_Blitz and the First Responder Kit to learn a lot about your databases. You read the […]
[Video] Halloween Office Hours in Salem, MA
I visited friends in Salem, Massachusetts, home of the 1692 witch trials, and it turns out Salem is […]
Announcing Buy-Now-Pay-Later, Just in Time for the Black Friday Sale!
It’s almost time for my annual Black Friday sale, and some of you are staring longingly at the […]
Announcing My 2023 Black Friday Sale!
You’ve used sp_Blitz and the First Responder Kit to learn a lot about your databases. You read the […]
Announcing Live Online Mastering Classes!
In the last 2 years since I last taught my Mastering classes, the SQL Server performance tuning game […]
Updated First Responder Kit and Consultant Toolkit for October 2023
The last couple of releases have focused on running sp_Blitz with limited permissions, like not being able to […]
[Video] Office Hours: Back in the Vegas Home Studio
After a long trip through Scandinavia, I’m back in the desert. You posted questions at https://pollgab.com/room/brento and I […]
SQL ConstantCare® Population Report: Fall 2023
The short story for this quarter: SQL Server 2019 is on fire, dominating the market. For the long […]