[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 […]
brentozar.com
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 […]
[Video] Creepy Office Hours in Vancouver
While in a hotel room in Vancouver for PGconf.dev, I strapped on my Apple Vision Pro headset to […]
Query Exercise: Beat ChatGPT at Finding Good Question Times
What are the best days of the week and times of the day to post a question at […]
There’s a 6-Month Statute of Limitations on “The Last Person.”
“The last person must have set it up that way.” “The last person wrote that code.” “The last […]
[Video] Office Hours in a Hotel Room
While in Nashville for a creators conference, I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we […]
Two Tweaks for Faster Backups with Ola Hallengren’s Scripts
Ola Hallengren’s free maintenance solution is widely used as a replacement for SQL Server maintenance plans. It’s a […]
Who’s Hiring in the Microsoft Data Platform Community? June 2024 ...
Is your company hiring for a database position as of June 2024? Do you wanna work with the […]
[Video] Office Hours: 16 Questions
Like Sixteen Candles, but different: I go through your top-voted questions from https://pollgab.com/room/brento. Strangely, my video and audio […]
Coming in Entity Framework 9: Better Query Parameterization
Hallelujah. With current versions of Entity Framework, when developers add a mix of parameters and specific values to […]
This Is It! The Last 3 Days of My Anniversary ...
Every year in May, I look back at when I first registered BrentOzar.com way back in May 2001. […]
Updated First Responder Kit and Consultant Toolkit for May 2024
If you’ve hard-coded installer file names, there’s a big change in this release. There are now just 2 […]
Okay, About That SmartPostgres.com Thing.
In some of the Query Exercises posts here, you might have noticed links over to similar query exercises […]
[Video] Office Hours: I Feel Like an Amateur Edition
I started with audio problems, then had video problems halfway in. It’s amusing because we also discuss feeling […]
The Future of DBAs: History Rhymes
Eitan Blumin recently wrote a post about the future of the DBA career in which he talked about […]
[Video] Office Hours: Answers for Your Database Questions
Y’all post questions and upvote the best ones at https://pollgab.com/room/brento, and I discuss ’em in my home office […]
Getting Data Out of an Audit Table: Answers & Discussion
In last week’s post, I gave you a trigger that populated a history table with all changes to […]
Why Generative AI Scares the Hell Out of DBAs
I was chatting with a client’s DBA about this thought-provoking blog post about data governance in the age […]
I’m Getting Antsy for SQL Server vNext.
Historically, Microsoft publicly announces the next version of SQL Server about a year before it ships. For example: […]
Who’s Changing the Table? Answers and Discussion
Your challenge for this week was to find out who keeps mangling the contents of the AboutMe column […]
SQL ConstantCare® Population Report: Spring 2024
The short story: SQL Server 2019 appears poised to swallow the SQL Server market altogether, hahaha. The long […]
[Video] Office Hours: Ask Me Anything About Azure and Microsoft ...
Back at home in the office, time to settle in with a nice caffeine-free Diet Coke and go […]
Who’s Hiring in the Microsoft Data Platform Community? May 2024 ...
Is your company hiring for a database position as of May 2024? Do you wanna work with the […]
Query Exercise: Who’s Changing the Table?
For this week’s Query Exercise, your challenge is to find out who keeps messing up the rows in […]
It’s Time For Our Annual Anniversary Sale!
I first registered BrentOzar.com way back in May 2001. Over the years, some things in databases have changed […]