Posts by Brent Ozar

[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
Office Hours - ask me anything.

[Video] Office Hours: Professional Development Edition

Videos
0
I spent an entire video just talking about 3 questions y’all posted to https://pollgab.com/room/brento because these were pretty big-picture and important. I know it sounds goofy and sentimental, but I genuinely care about y’all’s careers, and I want you to work as little as practical in order to spend as much time with your loved…
Read More