Posts by Brent Ozar

[Video] Office Hours in the Home Bar

[Video] Office Hours in the Home Bar

Videos
0
On a sunny Saturday afternoon, I made myself a highball and went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:57 jrl: Do you have any advice about communicating effectively in a fully remote workplace where all discussion is centered around a messaging platform like Slack or Teams? The company I…
Read More
You probably don't wanna hire these two.

Your SQL Server Needs Spring Cleaning, Too.

Indexing
5 Comments
First things first: pick up that filthy keyboard, take it over to the trash can, turn it upside down, and give it a good, vigorous shake. Next, go to your biggest SQL Server and run: Transact-SQL EXEC sp_BlitzIndex @GetAllDatabases = 1, @Mode = 2, @SortOrder = 'rows'; 12 EXEC sp_BlitzIndex @GetAllDatabases = 1,  @Mode = 2,…
Read More

The Waitlist is Open Now for My SQLBits Workshop!

SQLBits
3 Comments
I’m excited to return to London for SQLBits again this year! I’ve written about why SQLBits is my favorite conference, and it’s hard to believe it’s been over a decade since I wrote that post. I still feel the same way about Bits – it’s fun, different, and unafraid to run big experiments. This year,…
Read More

[Video] Office Hours in North Bay, Canada

Videos
2 Comments
Every year, Aaron Bertrand runs a curling tournament up in scenic North Bay where he grew up. I joined in this year, and before the tournament, sat on the shores of Lake Napissing to answer your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:25 MyTeaGotCold: Kendra Little’s recent article on the decline…
Read More
Home office filming setup

Tap Tap Tap – Short, Silent SQL Server Tutorials

Videos
6 Comments
One of the things I love about TikTok is that it exposes me to wildly new video ideas like this: @tiipititap ? original sound – tiipititap There’s a whole genre of videos in that style – people using tapping plastic pointer fingers on a grainy screen with no voiceover. One sub-genre (like the video above)…
Read More
Fundamentals of Columnstore

Free Webcast Tomorrow: Fundamentals of Columnstore

Company News
3 Comments
It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free over the next few months. Tomorrow I’m teaching Fundamentals of Columnstore, and we’re going to be covering the internals of how SQL Server and Azure SQL DB store data in columnstore indexes. You’ll learn why people think it’s…
Read More

[Video] Office Hours in My Vegas Backyard

Videos
0
I’m doing a lot of travel this month, but I took a break in my Vegas backyard to go through the top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:29 Nick H: I’m a new starter at an organisation who have lots of rules, one of which is that the use of Intellisense…
Read More
I'm killing your query.

What’s New in SQL Server 2025

Humor
26 Comments
This year’s release of Microsoft’s enterprise-grade relational database focuses on the most highly requested features from customers. Highlights include: Tooling support for SSMS like adding the debugger back in and executing the query where your cursor is on Production DBA enhancements like the ability to restore a single table from backup, and automatic background corruption checks…
Read More

Free Webcast Tomorrow: Fundamentals of TempDB

Company News
0
It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free over the next few months. Tomorrow I’m teaching Fundamentals of TempDB, and we’re going to be covering temp table statistics, execution plans, and plan reuse. There’s a lot more to cover in TempDB, like table variables, memory-optimized…
Read More

[Video] Office Hours: Back in the Home Office

Videos
1 Comment
I’m back home after a 2-week Iceland vacation. Let’s catch up with your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 02:04 Suresh: Hi Brent . Question about 128 GB memory limit for SQL server standard edition.If I set ‘Max SQL Server Memory’ to 228 GB on a 256 GB VM , SQL…
Read More

[Video] Office Hours: Waiting for the Hot Tub to Fill

Videos
2 Comments
While waiting for my Husavik hot tub to fill up, I took your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:28 1440×1080: always on with 2 nodes 1db, readable secondary. I’ve optimized both nodes to a point where the primary can withstand both workloads.i want to downgrade licensing from enterprise to standard.…
Read More

Query Exercise: Looking for Email Addresses

Query Exercises
12 Comments
“They put their password WHERE?!?” Personally identifiable information (PII) is freakin’ everywhere. When companies first start looking to identify and lock down their data, they think it’s going to be as easy as identifying common columns like EmailAddress, DateOfBirth, SocialSecurityNumber, and so forth. They think, “We’ll just encrypt those columns and we’ll be fine.” Ho…
Read More

Free Webcast Tomorrow: Fundamentals of Query Tuning

Company News
0
It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free over the next few months. Tomorrow I’m doing Fundamentals of Query Tuning. It’s for folks who are comfortable writing queries to get the data they want, but wildly uncomfortable reading query plans and trying to explain why queries…
Read More