SQLBits 2026 is Going Back to Newport, Wales.
SQLBits 2026 will be back at the International Convention Center Wales in Newport on April 22-25, and I’ll […]
brentozar.com
Save $150 on the Summit with Discount Code BRENT25
The PASS Data Community Summit is the biggest conference in the Microsoft database industry, and over the last […]
[Video] Office Hours: Docked in Miami Beach
On the last day of my Caribbean cruise, as we pull into port in Miami, let’s go through […]
Make the Comment Section Look Like a Junior DBA’s Search ...
Tomorrow’s scheduled webcast for Mastering Parameter Sniffing is off due to a scheduling issue, so in the meantime, […]
AI is Like Outsourcing. #TSQL2sday
When you ask data people how they feel about AI, you get pretty rabid, extreme reactions. People either […]
[Video] Office Hours: 15 Answers in 30 Minutes
The first few questions from this week’s crop at https://pollgab.com/room/brento are very much about what-problem-are-you-trying-to-solve, but they get […]
How to Make Leading Wildcard Searches Fast
99.9% of you are never gonna need this. But let’s say you need to run queries with leading […]
Who’s Hiring in the Microsoft Database Community? August 2025 Edition
Is your company hiring for a database position as of August 2025? Do you wanna work with the […]
[Video] Office Hours: Interview Horror Stories Edition
Wanna hear about my worst job interviews? I drove up to 8,000 feet where it’s 30 degrees colder […]
Poll Results: Yes, Your DBAs Can Read the Data.
Last week, I asked if your database administrators could read all of the data in all databases. The […]
The Query Tuning Trick You Should Use More: Pagination
When I’m tuning queries, the normal answer is to make the query perform better – either via changing […]
[Video] Building a Brand By Sharing Your Work
You’ve got a good job, and some spare time. You’re thinking about giving back to the community by […]
Poll: Can Your DBAs Read the Data?
It’s a simple question: can your database administrators read all of the data in all databases? Yes Yes, […]
Want Me to Train You & Your Coworkers Privately?
Your company doesn’t want to send you off to conferences or training classes in other cities. You’ve looked […]
Microsoft Fabric Has a New Service Status Page.
I’ve been pretty vocal here on the blog and on social media about the reliability problems with Microsoft […]
SQL ConstantCare® Population Report: Summer 2025
In this quarter’s update of our SQL ConstantCare® population report, showing how quickly (or slowly) folks adopt new versions […]
Updated First Responder Kit and Consultant Toolkit for July 2025: ...
I’mma wax philosophical for a second: I love the open source nature of the First Responder Kit because […]
[Video] Office Hours: Finally Back in the Home Office
I’m finally back in the home office after running around Europe for a month. Let’s talk through your […]
Microsoft Introduced AI Integrations for SQL Server.
You know how you put “https://” at the beginning of web site addresses, and your browser can magically […]
[Video] Job Options: Zooming Out to See the Big Picture
One of my readers asked me to give a 30-minute talk to their company’s internal employees discussing the […]
What’s New (And Undocumented) in SQL Server 2025 CTP 2.1
As the SQL Server 2025 previews continue to come out, Microsoft is making changes that they’re not telling […]
Who’s Hiring in the Microsoft Database Community? July 2025 Edition
Is your company hiring for a database position as of July 2025? Do you wanna work with the […]
Mastering Class Updates on Resource_Semaphore, The Ascending Key Problem, and ...
I’ve posted a couple of updated videos to my Mastering courses. In Mastering Server Tuning, I updated and […]
[Video] Office Hours in My London Hotel Room
When I’m on the road, I try to take you along with me to glamorous or scenic locations […]
Poll Results: How Often You’re Running Maintenance Tasks
Last week, I asked y’all how frequently you ran your full backups, corruption checks, index maintenance, and stats […]
SQL Server Reporting Services is Dead. Is SSIS Next?
It’s official: SQL Server 2022 was the last release for SSRS. At SQLBits this week, Microsoft announced that […]
[Video] Office Hours on the Cruise Ship
I’m on a Med cruise, and I stopped the boat today in Corsica to make sure your questions […]
[Poll] How Often Do You Run Maintenance Tasks?
How often do you run backups, corruption checking, index maintenance, and statistics updates? Click here to take the […]
Free Webcast Next Thursday: Tuning Indexes to Avoid Blocking
Indexing can make or break your SQL Server performance. You need just the right balance: enough indexes to […]
[Video] Office Hours at the Barcelona Pavilion
I’ve always wanted to see the Barcelona Pavilion by Mies van der Rohe, and by happy coincidence, I […]
Query Exercise Answers: Returning Routes in the Right Order
In your most recent Query Exercise challenge, I gave you these two tables: DROP TABLE IF EXISTS dbo.Stations; […]
SQLBits Added More Capacity to My Workshop! Move Quick.
I’m coming to London this month for SQLBits, and my Thursday workshop “Faster, Cheaper Cloud Databases” workshop sold […]
[Video] Office Hours in the Detroit Airport
I’m in the Detroit airport today, en route home after a client gig. I’ve got some time to […]
Query Exercise: Return Routes in the Right Order
I’mma be honest with you, dear reader: this query exercise stems from a client problem that I couldn’t […]
Who’s Hiring in the Microsoft Database Community? June 2025 Edition
Is your company hiring for a database position as of June 2025? Do you wanna work with the […]
[Video] Office Hours: Recovering from a Cold Edition
While recovering from a nasty cold, I took your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 […]
Review: SSMS Copilot vs Other AI Tools
I use AI tools constantly in my work, so when the new SSMS v21 came out with Copilot support, […]
Our Anniversary Sale Ends This Week!
Back in May 2001 when I first registered BrentOzar.com, I never would have dreamed how things would go. […]
Free Webcast Tomorrow: Mastering Server Tuning
This is it: the very peak of my free SQL Server Spring Training webcast series. I’ve been teaching […]
How SQL Server 2025’s Optional Parameter Plan Optimization Works
About three years ago, SQL Server 2022 introduced Parameter-Sensitive Plan Optimization (PSPO). At the time, I explained that […]
How I Configure SQL Server Management Studio v21
Several years ago, I wrote a post about how I configure older versions of SQL Server Management Studio, […]
New Objects in SQL Server 2025 – And Thousands of ...
The first public preview of SQL Server 2025 dropped yesterday, and here’s what’s new under the hood as […]
Fabric Is Just Plain Unreliable, and Microsoft’s Hiding It.
Last week, Microsoft Fabric went down yet again for hours on multiple continents. Oh, you didn’t hear about […]
[Video] Office Hours at the Hoover Dam
Dam! I took your top-voted questions from https://pollgab.com/room/brento without making any dam or beaver puns. Rather proud of […]
Predicting When SQL Server Will Hit the CPU Wall
Most of the time, we use wait stats to identify SQL Server’s bottleneck and focus on what to […]
SQL ConstantCare Badges
SQL ConstantCare™, our monitoring app that gives you a simple daily email with actionable tasks to make your […]
Free Webcast Tomorrow: Mastering Query Tuning
This is it: the very peak of my free SQL Server Spring Training webcast series. I’ve been teaching […]
[Video] Office Hours: Speed Round!
Not all of y’all’s questions from https://pollgab.com/room/brento require long, thought-out answers. Let’s do a speed round: Here’s what […]
Don’t Let Your Kids Drop ACID.
We’re heading towards graduation time. In just a few short months, your high school kids are going to […]
Who’s Hiring in the Microsoft Data Platform Community? May 2025 ...
Is your company hiring for a database position as of May 2025? Do you wanna work with the […]