Free Webcast: How to Think Like the Engine, Big Data ...
Brent, Big Coat Edition You’ve watched my free How to Think Like the Engine class that focuses on […]
brentozar.com
Yes, Cardinality Estimation Keeps Changing After SQL Server 2014.
About 10 years ago, Microsoft made changes to the Cardinality Estimator (CE) which caused some problems for SQL […]
TRY/CATCH Doesn’t Always Work.
If you’re using TRY/CATCH to do exception handling in T-SQL, you need to be aware that there are […]
[Video] Office Hours: Open Q&A About Databases
I went through your top-voted questions from https://pollgab.com/room/brento plus hit live ones from the TikTok viewers. Here’s what […]
Query Exercise Answers: Why Are These 3 Estimates So Wrong?
This week’s Query Exercise challenged you to figure out why these 3 estimates went so badly: SELECT TOP […]
Contest: What’s Your Biggest Database Regret?
PAST ME, WHAT WERE YOU THINKING We all make mistakes. I certainly have. I’ll give you a recent […]
[Video] Office Hours: Database Q&A
I went live on TikTok and took your top-voted questions from https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start […]
Query Exercise: Why Are These 3 Estimates So Wrong?
Our prior Query Exercise introduced SQL Server’s 201 buckets problem: its inability to accurately estimate rows for more […]
PASS Data Community Summit Prices Are About to Go Up!
Next Tuesday, pricing on the 3-day tickets for the PASS Data Community Summit goes up to $2,295. But […]
[Video] Office Hours Q&A: Abrupt Exit Edition
Last week, we had an abrupt intro, and this week, we have an abrupt ending when my camera […]
Geographic Sharding is Usually a Pretty Bad Idea.
Let’s say you built a web app and it became globally popular. You’ve got users scattered across North […]
Who’s Hiring in the Microsoft Data Platform Community? September 2024 ...
Is your company hiring for a database position as of September 2024? Do you wanna work with the […]
[Video] Office Hours: Abrupt Intro Edition
Today’s Office Hours had a ton of technical difficulties because it was my first live stream on both […]
Query Exercise Answers: Solving the 201 Buckets Problem
In this week’s Query Exercise challenge, I explained SQL Server’s 201 buckets problem. SQL Server’s statistics only handle […]
About Half Of You Don’t Have Your Databases Under Control.
I ran a poll over on LinkedIn to find out if people have 100% of their databases under […]
[Video] Office Hours: Professional Development Q&A
I was supposed to be on a flight to Mexico, but had to cancel at the last minute. […]
Query Exercise: Solving The 201 Buckets Problem
When you run a query, SQL Server needs to estimate the number of matching rows it’ll find – […]
Make Money Referring Folks to My Training!
YOU! Wanna make easy money? Black Friday is coming. Every November, we run a big sale on our […]
[Video] Office Hours: Ask Me Anything About #SQLServer
I took your top-voted questions from https://pollgab.com/room/brento, including a few career-oriented ones: Here’s what we covered: 00:00 Start […]
Query Exercise Answer: What Makes SELECT TOP 1 or SELECT ...
This Query Exercise was very different: I didn’t ask you to solve a particular problem. I pointed out […]
SQL ConstantCare® Population Report: Summer 2024 (And Upcoming Gamification Badges)
The short story: SQL Server 2022 finally saw some growth this quarter! Two years after the release, 1 […]
As a SQL Server DBA, Postgres Backups Surprised Me.
Over the last week, I’ve been working on putting together a Postgres version of the Stack Overflow database, […]
Free DBA Job Interview Q&A Course This Weekend
If you’re facing an upcoming SQL Server DBA job interview, or if you’re a manager who has to […]
[Video] Office Hours with a Special Guest: Count Distinct
I was busy, so I asked a friend to fill in for me and answer your top-voted questions […]
Query Exercise: What Makes SELECT TOP 1 or SELECT MAX ...
These two queries both get the same answer from the Stack Overflow database: SELECT TOP 1 LastAccessDate FROM […]
[Video] I Must Be an Idiot: Automatic Tuning Never Works ...
I don’t get it. I’ve given this feature one chance after another, and every time, it takes a […]
Who’s Hiring in the Microsoft Data Platform Community? August 2024 ...
Is your company hiring for a database position as of August 2024? Do you wanna work with the […]
[Video] Office Hours in Cabo San Lucas, Mexico
What a comfy morning to sit down with a breakfast margarita and tackle your top-voted questions from https://pollgab.com/room/brento. […]
Free Online SQL Server Internals Conference Next Week
The EightKB conference is a free event that focuses on SQL Server internals. You can get the session […]
Thoughts About Stack Overflow’s Annual Developer Survey
Every year, Stack Overflow runs a developer survey about technology, work, community, and more. This year’s results include […]
[Video] Office Hours in a Mexican Hot Tub
While taking a dip in Cabo, I went through your top-voted questions from https://pollgab.com/room/brento. https://www.youtube.com/watch?v=OaHImrIMM6YVideo can’t be loaded […]
Query Exercise Answer: Fixing a Slow Computed Column
In last week’s Query Exercise, we added a user-defined function to the Users table to check whether their […]
Announcing New Membership Tiers: Free & Mentoring
I give away a lot of stuff in various places on the internet: videos, scripts, the new free tier […]
Today’s a Good Day to Talk to Your Manager About ...
Last night, two major IT disasters struck: Microsoft Azure’s Central region went down for about 4 hours. The […]
[Video] Office Hours in My Backyard
On a pleasantly mild morning, I sat down on the patio and took your top-voted questions from https://pollgab.com/room/brento. […]
Query Exercise: Fix This Computed Column.
Take any size of the Stack Overflow database and check out the WebsiteUrl column of the Users table: […]
Updated, Larger Stack Overflow Demo Database
Stack Overflow publishes a data dump with all user-contributed content, and it’s a fun set of data to […]
[Video] Office Hours in Bulgaria
I went through your top-voted questions from https://pollgab.com/room/brento while in front of the National Gallery for Foreign Art […]
Announcing Free SQL Server Monitoring.
You already use sp_Blitz and the rest of the free, open source First Responder Kit to give your […]
Use “We” Not “You”. #tsql2sday
For T-SQL Tuesday this month, Louis Davidson suggested we give our past self some advice. I’d tell myself, […]
[Video] Office Hours in Sofia, Bulgaria
I was honored to speak at the Present to Succeed conference in Sofia, Bulgaria, run by a former […]
Save $350 on the PASS Summit if You Register Now.
Next Tuesday, pricing on the 3-day tickets for the PASS Data Community Summit goes up to $2,095. But […]
Does Bit Column Order Matter in Tables?
At the PGConf.dev, where Postgres developers get together and strategize the work they wanna do for the next […]
Updated First Responder Kit and Consultant Toolkit for July 2024
The next release would normally be August, but I’m doing a release a little early in order to […]
[Video] Office Hours: I Don’t Have All the Answers
When I went through the top-voted questions at https://pollgab.com/room/brento, I didn’t have all the answers today: Here’s what […]
Join Me in Seattle for Watch Brent Tune a Query ...
The PASS Data Community Summit session lineup for Nov 4-8 in Seattle was just announced, and I’ve been […]
The SQL Language is Just a Hurdle You Gotta Overcome.
I’m not talking just about Microsoft SQL Server specifically here, nor T-SQL. Let’s zoom out a little and […]
[Video] Office Hours: Database Answers from a Hotel Room
I went through your top-voted questions from https://pollgab.com/room/brento before heading out to PGConf.dev in Vancouver. Here’s what we […]
Query Exercise Answer: Beating ChatGPT at Finding Good Question Times
For this week’s Query Exercise, I asked you to write a better query than ChatGPT wrote. Your goal […]
Join Me in San Diego for SQL Saturday!
I’m coming to San Diego on Sept 13-14 for SQL Saturday San Diego! I’m teaching a one-day pre-conference […]