Posts by Brent Ozar

Brent Ozar

2348 posts

https://www.brentozar.com

I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. I'm based out of Las Vegas. He/him.

Join #TeamHugo and Help Fight Leukemia.

Last Updated November 16, 2022

Brent Ozar

#SQLPass

If you’ve been reading this blog for a while or subscribed to my email newsletters, you’ve learned something from Hugo Kornelis. Hugo is the wildly productive and selfless guy behind the Execution Plan Reference, SQLServerFast.com, tons of SQLBits sessions, videos on YouTube, and he’s @Hugo_Kornelis. He’s unbelievably upbeat and positive. He loves what he does, and…

SQL Server 2022 Release Date: November 16, 2022

Last Updated November 16, 2022

Brent Ozar

SQL Server 2022

Microsoft released SQL Server 2022 today, November 16, 2022. The footnotes indicate: SQL Server 2022 free editions (Developer edition, Express edition) are available to download starting today. SQL Server 2022 paid editions (Enterprise edition, Standard edition) will be available in Volume Licensing (Enterprise Agreement, Enterprise Agreement Subscriptions) customers starting today, which represents the majority of…

#PASSdataCommunitySummit Keynote Day 1 Live Blog: SQL Server 2022 is Out Now.

Last Updated November 16, 2022

Brent Ozar

#SQLPass

I’m in Seattle for the biggest annual gathering of Microsoft data platform professionals, the PASS Data Community Summit. This is the first in-person Summit since the pandemic, and the first since Redgate took over ownership from the old PASS organization. I’m really excited – this is like a family reunion for me. Microsoft’s Rohan Kumar…

Office Hours: Read This, Watch This Edition

Last Updated November 10, 2022

Brent Ozar

SQL Server

This week, a lot of the questions you posted at https://pollgab.com/room/brento just need pointers to resources at other places. Welcome to the Read This, Watch This series of answers. Don’t Blame Anthony: Our developers prefer writing TSQL queries directly in their .NET code rather than writing sprocs and calling them. What are the pros /…

[Video] Office Hours: Sponsored By Black Friday Edition

Last Updated November 10, 2022

Brent Ozar

Videos

Y’all post questions at https://pollgab.com/room/brento, upvote the ones you’d like to see me cover, and then I talk through ’em. Here’s what we covered today: 00:00 Start 00:22 CKI: Could please give me pointers how to answer the question “Do we need to create a new instance for the new application or can use the…

[Video] Office Hours: Surprise Edition

Last Updated November 6, 2022

Brent Ozar

Videos

Y’all post questions at https://pollgab.com/room/brento, upvote the ones you’d like to see me cover, and then I talk through ’em. There’s a slight problem with this episode: I forgot to hit the Record Questions button in PollGab, so I can’t quickly/easily generate the list of questions we covered. If you asked a highly voted question…

Is There a Bug in SQL Server’s MAXDOP Calculation? (Update: Yes!)

Last Updated November 3, 2022

Brent Ozar

Configuration Settings

I think I’ve found a bug in SQL Server setup’s MAXDOP calculation, and I need you to take a second look. Setup is recommending MAXDOP 8: Which is odd, because this is running on an AWS i3.16xlarge with 2 sockets, 2 NUMA nodes, 32 logical processors per node, 64 logical processors altogether. In this screenshot, I’ve laid…

Who’s Hiring in the Microsoft Data Platform Community? November 2022 Edition

Last Updated December 6, 2022

Brent Ozar

Who's Hiring

Is your company hiring for a database position as of November 2022? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must include the job title, and either a link to the full…

[Video] Office Hours: Answering Your Microsoft Data Platform Questions

Last Updated October 24, 2022

Brent Ozar

Videos

Ask questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. Here’s what we covered today: 00:00 Start 00:59 neil: is it dangerous/risky to expand a drive in azure with SQL data files on it? sql on azure vm. dont know what happens behind the scenes 02:07 Brett: I am a consultant…

[Video] Office Hours: Nine Minutes of Answers

Last Updated October 22, 2022

Brent Ozar

Videos

Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss during my live streams. This week, I took a break from working on my PASS Summit sessions in order to chat: Here’s what we covered: 00:00 Start 00:32 Jeremy: We have an older web app we’re going to be rewriting…

Learn the Fundamentals of TempDB for Free This Week.

Last Updated September 18, 2022

Brent Ozar

TempDB

Every weekday during the month of October, one of the modules from my Fundamentals classes will be absolutely free to watch. But you gotta watch it that day – you snooze, you lose. For this week’s TempDB class, you don’t have hands-on labs, but if you want to follow along with the demos, I’ll be using…

Let’s Hang Out in Person at the PASS Summit Next Month.

Last Updated October 20, 2022

Brent Ozar

#SQLPass

I’m so excited to see everybody again at the PASS Data Community Summit in Seattle on November 14-18. I’M BACK IN PERSON! Here’s the crazy part: I’m not going to attend a single session. Not one. (Well, except the ones I’m teaching, and the keynotes.) Instead, I’m gonna spend every single conference hour hanging out in…

Updated First Responder Kit and Consultant Toolkit for October 2022

Last Updated October 18, 2022

Brent Ozar

First Responder Kit Updates

It’s fall – time to review your SQL Servers’ configurations, health, backups, and performance before fall turns into fail. To help, we’ve got a new version of the First Responder Kit. Wanna watch me use it? Take the class. To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First…

Learn Columnstore Indexes for Free This Week.

Last Updated September 18, 2022

Brent Ozar

Columnstore Indexes

Every weekday during the month of October, one of the modules from my Fundamentals classes will be absolutely free to watch. But you gotta watch it that day – you snooze, you lose. For this week’s Fundamentals of Columnstore class, you don’t have hands-on labs, and you’re not meant to follow along with the demos. Columnstore…

Office Hours: One-Word Answers Edition

Last Updated October 13, 2022

Brent Ozar

Production Database Administration

Some of the questions y’all post at https://pollgab.com/room/brento are pretty straightforward. Let’s get ‘er done. LetTheDbaHandleIt: My friend needs to track who has accessed what data. This is easy at OS and app level, but how can my friend verify that those who have direct DB access are not snooping on data inappropriately? e.g. payroll or…

[Video] Office Hours Live: Ask Me Anything

Last Updated October 3, 2022

Brent Ozar

Videos

Got a question for me? Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss. Before heading to NYC for vacation, I recorded a live Office Hours on my Twitch channel. Here’s what we covered: 00:00 Start 04:40 neil: are there any ‘band aids’ a DBA can apply for a…

#tsql2sday: Start Your Dynamic SQL with a Comment.

Last Updated October 7, 2022

Brent Ozar

T-SQL

When you write dynamic SQL, start like this: CREATE OR ALTER PROC dbo.MyProc AS BEGIN DECLARE @StringToExecute NVARCHAR(4000); SET @StringToExecute = N'SELECT /* MyProc */ '; ... 12345 CREATE OR ALTER PROC dbo.MyProc ASBEGIN DECLARE @StringToExecute NVARCHAR(4000); SET @StringToExecute = N'SELECT /* MyProc */ '; ... Right after the SELECT (or INSERT or UPDATE or whatever),…

This Week, Fundamentals of Query Tuning Classes are Free!

Last Updated October 9, 2022

Brent Ozar

Execution Plans

Every weekday during the month of October, one of the modules from my Fundamentals classes will be absolutely free to watch. But you gotta watch it that day – you snooze, you lose. This week is Fundamentals of Query Tuning. Last week’s class had hands-on labs you had to follow, but this week’s doesn’t. You’re welcome…

[Video] Office Hours Silent Edition

Last Updated September 29, 2022

Brent Ozar

Videos

Okay, I, uh, forgot to unmute the microphone for this one: So here are the answers in text form instead. <sigh> Thank goodness it was a speed round! Mike: When Brent Ozar’s certification exams for SQL Server will be available? Looking forward to having exams like “Fundamentals of QT”, “Mastering Server Tuning” etc, so you…

Who’s Hiring in the Microsoft Data Platform Community? October 2022 Edition

Last Updated September 18, 2022

Brent Ozar

Who's Hiring

Is your company hiring for a database position as of October 2022? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must include the job title, and either a link to the full…

Posts by Brent Ozar

Save your cart?