Query Plan Pop Quiz Answers 2 and 3: I’ve Got ...
In the Query Plan Pop Quiz, questions 2 and 3 asked you about what the sizes of arrows […]
brentozar.com
TempDB Filling Up? Try Resource Governor.
TempDB is one of the banes of my existence. Anybody, anybody who can query your server can run a […]
Query Plans Pop Quiz Answer #1: Costs are Garbage.
In last week’s Query Plans Pop Quiz, the first question was, someone hands you these two queries and […]
Announcing the 2025 Black Friday and Doorbusters Deals!
You’ve been telling yourself, “One of these days, I’ll finally take Brent’s classes.” Get ready, because that day […]
Announcing Free MASTERING Week 2025!
You’ve been working with SQL Server, Azure SQL DB, or Amazon RDS SQL Server for years. You’re jaded. […]
Updated First Responder Kit and Consultant Toolkit for October 2025
This quarter’s release includes new checks for SQL Server 2025’s new memory pressure warnings, Azure SQL DB’s operations […]
Query Plans Pop Quiz: Three Simple Questions
Question 1: Pick the Problematic Plan: someone hands you a pair of queries, and you get the estimated […]
Free Fundamentals Classes Are Coming Next Week! Register Now.
You’re a developer, analyst, database administrator, or anybody else working with SQL Server, Azure SQL DB, or Amazon […]
Who’s Hiring Microsoft Data People? October 2025 Edition
Is your company hiring for a database position as of October 2025? Do you wanna work with the […]
Which Should You Use: VARCHAR or NVARCHAR?
You’re building a new table or adding a column, and you wanna know which datatype to use: VARCHAR […]
Set MAXDOP in Azure SQL DB or You’ll Get This ...
Max Degrees of Parallelism (MAXDOP) tells the database engine, “If you decide to parallelize a query, go parallel […]
Here Are the YouTube Channels We Both Loved.
Last week, I announced that we’ve hit 50,000 YouTube subscribers, and I celebrated by letting y’all submit your […]
We Hit 50,000 YouTube Subscribers! Let’s Run a Contest.
This is kinda amazing to me: our YouTube channel has broken the 50,000 subscriber mark! That’s wild to […]
Microsoft Now Recommends You Set Max Memory to 75% and ...
Somehow I missed this a few years ago, and I bet a lot of y’all did too. Note […]
Announcing Free Fundamentals Week 2025!
You’re a developer, analyst, database administrator, or anybody else working with SQL Server, Azure SQL DB, or Amazon […]
[Video] Office Hours: Database Questions & Answers
In between clients, I hopped onto my Twitch channel to take your top-voted questions from https://pollgab.com/room/brento. If you’d […]
Your Developers Need Cheap SQL Training.
Your developers haven’t ever been to formal Microsoft database training on SQL Server or Azure SQL DB. They’re […]
SQL Server 2025 Makes Memory Troubleshooting Easier.
SQL Server 2025 introduces a new sys.dm_os_memory_health_history view to make it easier for meatbags like you and robots […]
Free Webcasts Tomorrow & Wednesday
I’m teaching my two most important classes live, online, completely free! These are the two fundamentals classes that […]
[Video] Office Hours on the Beach in Cancun
In retrospect, I should have put on sunscreen – even for just a 20-minute Office Hours session on […]
Home Office Studio Tour
Ever wonder what it takes to do this stuff behind the scenes? I’ll show you. If you’re thinking […]
[Video] Office Hours Back at Home in Vegas
I’m back in Vegas, at least for the moment, so let’s hang out in my home office and […]
Who’s Hiring in the Microsoft Database Community? September 2025 Edition
Is your company hiring for a database position as of September 2025? Do you wanna work with the […]
Free Live SQL Server Classes This Month!
This month, I’m teaching two of my classes live, online, completely free! These are the two fundamentals classes […]
[Video] Office Hours in Icy Strait Point, Alaska
For the last couple of months, I’ve been trying to get my on-location Office Hours episodes filmed with […]
Why Aren’t People Going to Local and Regional In-Person Events ...
Steve Jones recently posted an update about SQL Saturday’s status, and it includes some news we need to […]
SQL Server 2025 RC0 Is Out with New Preview Features ...
The release of SQL Server 2025 keeps inching closer. Release Candidate 0 is out now, and here are […]
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 […]
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 […]