Join Me at the PASS Data Community Summit in November!
On November 4 in Seattle, I’m presenting a new pre-conference workshop! Tuning T-SQL for SQL Server 2019 and […]
brentozar.com
[Video] Database Answers in Hong Kong
As my time in Hong Kong came to an end, I sat inside on a foggy morning and […]
Troubleshooting Mysterious Blocking Caused By sp_getapplock
I’m kinda weird. I get excited when I’m troubleshooting a SQL Server problem, and I keep hitting walls. […]
It’s almost time for Fundamentals Week! Have you signed up ...
The Monday after next, I’ll be getting together with dozens of smart people who are a lot like […]
[Video] Office Hours: Hong Kong Harbor
I recently went to Shanghai & Hong Kong, and stopped to take your questions from https://pollgab.com/room/brento while sitting […]
How to Have a Conversation About Software Licensing
As a consultant, I sometimes see SQL Servers with high CPU core counts relative to their workload. For […]
Announcing Offline Access to Your BrentOzar.com Courses
So you’ve got an iPhone or iPad or Vision Pro, and you bought one of my training classes […]
[Video] Office Hours: Career & Data Q&A
A few career and security questions found their way into the queue at https://pollgab.com/room/brento for this episode: Here’s […]
Your Teammates Need the Fundamentals.
You’ve been reading my site for a while, watching videos, keeping up with the best SQL Server techniques. […]
Using ChatGPT for T-SQL Code Reviews
For this month’s T-SQL Tuesday, Pinal Dave asked us if AI has helped us with our SQL Server […]
[Video] Office Hours: Just Three Questions
Sometimes y’all post questions at https://pollgab.com/room/brento that require extended answers. Today, I’m hitting just 3 questions: Here’s what […]
Who’s Hiring in the Microsoft Data Platform Community? April 2024 ...
Is your company hiring for a database position as of April 2024? Do you wanna work with the […]
Announcing Fundamentals Week, May 6-10
You’ve attended some of my free online streams, read my blog posts, and you use the First Responder […]
Tomorrow’s the Big Day: Free Live Webcasts!
No fooling here. Tomorrow, I’m teaching my very favorite class live online, for free, two different ways – […]
[Video] Office Hours: 25 Answers in 10 Minutes
It’s time for a speed round, a rapid-fire tour of your top-voted questions from https://pollgab.com/room/brento: Here’s what we […]
[Video] Office Hours: The Long One
You posted a lot of great questions at https://pollgab.com/room/brento and I spent almost an hour covering these: Here’s […]
Join Me for Free Live SQL Server Training Next Week.
Next week, I’m teaching my very favorite class live online, for free, two different ways – one with […]
[Video] Office Hours in Snowy Telluride, Colorado
On a beautiful sunny afternoon in the mountains, I went through your top-voted questions from https://pollgab.com/room/brento. Audio is […]
Does Your GROUP BY Order Matter?
Sometimes when you do GROUP BY, the order of the columns does matter. For example, these two SELECT […]
Free Live Webcasts: Slide & Demo Versions of How to ...
You’re comfortable writing queries to get the data you need. But you’re uncomfortable if someone asks you how it […]
[Video] Office Hours: Speed Round
Not all of the questions y’all post at https://pollgab.com/room/brento require long-winded answers. Let’s conquer 22 questions in 15 […]
Option Recompile is a Magic Turbo Button That Actually Works.
I didn’t say that – Guy Glantser did. Guy Glantser is an Israeli SQL Server guru with a […]
What Happens When Multiple Queries Compile at Once?
An interesting question came in on PollGab. DBAmusing asked: If a query takes 5-7s to calculate the execution […]
Finding Sister Locations to Help Each Other: Answers & Discussion
This week’s query exercise asked you to find two kinds of locations in the Stack Overflow database: Locations […]
[Video] Office Hours From the Future
To answer today’s questions from https://pollgab.com/room/brento, I strapped on my Apple Vision Pro and recorded my persona as […]
Read This Before Your Users Install SSMS 20
SQL Server Management Studio 20 Preview 1 is out, and the new connection dialog has a big change: […]
Updated First Responder Kit and Consultant Toolkit for February 2024
New this month: better sp_BlitzIndex performance on databases with tens of thousands of objects, sp_DatabaseRestore can run test […]
Query Exercise: Finding Sister Locations to Help Each Other
For this week’s query exercise, let’s start with a brief query to get a quick preview of what […]
Find Recent Superstars: Answers & Discussion
Your query exercise for this week was to write a query to find users created in the last […]
Join Me in Orange County for Tuning Databases in One ...
You’ve got production databases in SQL Server or Azure SQL DB, and you want to make ’em faster. […]
Sessions You Should Attend at SQLBits Online 2024
SQLBits 2024 is next month, and the session agenda is out, including the Microsoft-led sessions. If you’re going […]
[Video] Office Hours: Hot Tub Edition
Today’s Office Hours comes from a very different office! I climbed into the hot tub to review your […]
Query Exercise: Find Recent Superstars
For this week’s Query Exercise, we’re working with the Stack Overflow database, and our business users have asked […]
Finding Long Values Faster: Answers & Discussion
In last week’s Query Exercise, our developers had a query that wasn’t going as fast as they’d like: […]
#TSQL2sday Roundup: The Most Recent Issues You Closed.
For this month’s TSQLTuesday, I asked y’all to describe the most recent issues you closed. If you ask […]
[Video] Office Hours: Ask Me Anything About Microsoft Databases
Post your database questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss on the […]
Query Exercise: Finding Long Values Faster
Our developers have come to us with a problem query that isn’t as fast as they’d like. Using […]
Improving Cardinality Estimation: Answers & Discussion
Your challenge for last week was to take this Stack Overflow database query to show the top-ranking users […]
The Last Ticket/Issue I Closed #TSQL2sday
For this month’s T-SQL Tuesday, I asked y’all to write about the most recent ticket or issue that […]
SQL ConstantCare® Population Report: Winter 2023
The short story: SQL Server 2019 continues its utter domination of the Microsoft data platform landscape this quarter. […]
[Video] Office Hours: Lumberjack Edition
On a chilly January day, I went through your top-voted questions from https://pollgab.com/room/brento. Yes, it actually gets cold […]
Query Exercise: Improving Cardinality Estimation
Your challenge for this week is to tune a query. Say Stack Overflow has a dashboard that shows […]
Database Changes to Find Tagged Questions Faster: Answers and Discussion
In the last Query Exercise discussion, we hit a performance wall when we were trying to quickly find […]
#TSQL2sday Invitation: Describe the Most Recent Issue You Closed.
T-SQL Tuesday is a monthly blogothon where we get together and write about a different topic. I’m hosting […]
Office Hours: PowerBI & Fabric Q&A with Eugene Meidinger
Today’s Office Hours has a different topic. Eugene Meidinger dropped by to answer your business intelligence questions. Follow […]
Who’s Hiring in the Microsoft Data Platform Community? February 2024 ...
Is your company hiring for a database position as of February 2024? Do you wanna work with the […]
Finding Tagged Questions Faster: Answers & Discussion
Your query exercise was to take this Stack Overflow query to find the top-voted questions for any given […]
Free Video Training: Estimation and Statistics by Dave Ballantyne
It’s hard to find good 400-500 level SQL Server training at any price, let alone free. Dave Ballantyne’s […]
What PowerBI Questions Do You Have for Eugene Meidinger?
Eugene Meidinger, aka SQLGene.com, makes Power BI concepts easy and accessible. He’s got a free introduction to Power […]
Query Exercise: Find Tagged Questions Faster.
For this week’s Query Exercise, we’re going to start with an existing query that has performance problems from […]