What’s In Your Development Database? The Answer: Production Data.
Are your developers working with live production data, completely made-up synthetic data, or something in between? I posted […]
brentozar.com
[Video] SQL Server Always On Availability Groups 101
I got a few closely related Availability Groups questions at https://pollgab.com/room/brento and decided to do a half-hour introduction […]
Updated First Responder Kit and Consultant Toolkit for October 2024
The wording of all of sp_BlitzIndex’s warnings is now much more clear and inclusive thanks to hard work […]
[Video] Office Hours: Back at Home (Briefly)
I took a break from unpacking my SQL Saturday San Diego bags and re-packing for a Boston wedding […]
How Many Indexes Is Too Many?
Let’s start with the Stack Overflow database (any size will work), drop all the indexes on the Users […]
Should That Be One Update Statement or Multiple?
Let’s say we have a couple of update statements we need to run every 15 minutes in the […]
[Video] Consulting Lines
In my consulting work, I often find myself saying the same things to clients – but they’re not […]
[Video] Office Hours on a Calm Sea Day Off Canada
On an unbelievably calm sea day off the shores of Canada, aboard the Norwegian Jewel, I enjoyed a […]
Poll: What’s In Your Development Database?
When your developers work on new queries or testing complaints about existing queries, what database are they working […]
Finished Your Training? Get a Certificate of Completion.
If you want to get a raise or stand out from a crowd of job hunt competitors, you […]
[Video] Office Hours in Haines, Alaska: No Bears Here
While in beautiful Haines, Alaska along the Chilkoot River, I stopped to take your top-voted questions from https://pollgab.com/room/brento. […]
[Video] Office Hours: Icy Strait Point, Alaska
I’m on a boat! We took an Alaska cruise with some friends aboard the Norwegian Jewel. En route […]
Who’s Hiring in the Microsoft Data Platform Community? October 2024 ...
Is your company hiring for a database position as of October 2024? Do you wanna work with the […]
Announcing the Winners of the Biggest Database Regret Contest
I recently asked you to leave a comment with your biggest database regret, and the comments were great! […]
The 2024 Black Friday Sale is Coming Next Month.
Your accounting office Every year during November, we run a big sale all month long. And every year, […]
[Video] Office Hours: Open Q&A on Microsoft Databases
I took your top-voted questions from https://pollgab.com/room/brento while recovering from a late night of partying. Here’s what we […]
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 […]
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 […]