Posts by Brent Ozar

[Video] Office Hours in the Valley of Fire State Park

Videos
0
I drove the Ferrari out through the Valley of Fire State Park and stopped out in the middle of nowhere to take the questions you’d upvoted at https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:39 Saket Mittal: Hi Brent, I am working with a developer on a query, this query has lots of join ,…
Read More
And it looks bad even in shades.

Here’s What I’m Teaching at the 2022 PASS Summit.

#SQLPass
2 Comments
The lineup for the PASS Data Community Summit is out, and in addition to my pre-conference workshop on Mastering Parameter Sniffing, I’m also teaching two sessions: Everything You Know About Parallelism Is Wrong. Just because you see parallelism icons on execution plans doesn’t mean the query went parallel. SQL Server doesn’t load-balance work across CPU cores.…
Read More
Office Hours - ask me anything.

[Video] Office Hours Speed Round

Videos
0
In ten minutes, let’s cover as many questions as possible from https://pollgab.com/room/brento: Here’s what we raced through: 00:00 Introductions 00:17 dbacat: We’ve been fighting an AG issue for a while. Sometimes during failover, one or a few databases go into initializing/recovery state on the new secondary. It’s random, never consistent. Only fix is to drop…
Read More

[Video] Office Hours: Professional Development Questions

Videos
0
Most of the questions y’all post at https://pollgab.com/room/brento are technical ones, but there were a handful of interesting professional development and career ones in the queue, so I cherry-picked those for today’s episode: 00:00 Introductions 00:20 GI Joe DBA: Have you ever refused a consulting project \ opportunity and why? 03:35 Doug E: How do…
Read More

[Video] Office Hours: Ask Me Anything About SQL Server

Videos
9 Comments
You posted questions at https://pollgab.com/room/brento, upvoted the ones you’d like to see me cover, and I did the needful: Here’s what we covered: 00:00 Introductions 01:19 chandwich: Hi Brent. I’ve been unsuccessful in my attempt to convince my employer I need formal SQL training. I help manage hundreds of customers’ SQL Servers and Applications, but…
Read More

[Video] Office Hours: Palm Springs, California Edition

Videos
0
On a road trip from San Diego to Vegas, I stopped in Palm Springs and answered your highly-upvoted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:45 i_use_lowercase_for_select: Hi Brent, just wanted to give you my support on your May 24th blog. 01:19 SQL Crooner: Who would win a SQL trivia contest between Brent…
Read More

[Video] Office Hours: Vail Fireside Chat

Videos
3 Comments
You posted and upvoted questions at https://pollgab.com/room/brento, and I sat down by the fire on a chilly evening in Vail, Colorado to answer ’em. I was driving cross-country, heading back from a road trip to see my mom. Here’s what we covered: 00:00 Introductions 00:46 Ms. Cosmos: What are the top traits for the perfect…
Read More

[Video] Office Hours in Moab, Utah

Videos
15 Comments
On a cross-country trip, I stopped in Moab, Utah and answered your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 01:20 YourbiggestFan: Do you have any plans to write an Azure first version of the first responder kit (sp_blitzfirst and sp_bitzcache)which can get the metrics from query store and thus overcome the issue…
Read More

SQL Server 2022 Tells You Why A Query Can’t Go Parallel.

Until 2022, when a query couldn’t go parallel, all we got was a really cryptic note in the execution plan properties saying NonParallelPlanReason = CouldNotGenerateValidParallelPlan. But starting with SQL Server 2022, even when I’m running under older compatibility levels: ALTER DATABASE CURRENT SET COMPATIBILITY_LEVEL = 140; /* 2017 */ GO DECLARE @TableVariable TABLE(Total BIGINT); INSERT…
Read More