Posts by Brent Ozar

Brent Ozar

2789 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.

Who’s Hiring in the Microsoft Data Platform Community? February 2023 Edition

Last Updated April 1, 2023

Brent Ozar

Who's Hiring

It’s Valentine’s day – let’s do some matchmaking! Is your company hiring for a database position as of February 2023? 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…

[Video] Office Hours: Quiet Sunday Edition

Last Updated February 5, 2023

Brent Ozar

Videos

While waiting for the dry cleaner to open, I went live to stream a quiet session going through a bunch of y’all’s questions from https://pollgab.com/room/brento. Office Hours: Ask Me Anything About SQL ServerWatch this video on YouTube Here’s what we covered: 00:00 Start 01:45 Rollback is single threaded: Hi Brent! In microservices application architecture, Using…

Free Training Coming Up! March is PowerShell Month.

Last Updated March 21, 2023

Brent Ozar

PowerShell

You’re a production database administrator responsible for the health, security, and uptime of many database servers. You’ve been pointing and clicking your way through SSMS for years, scripting out T-SQL to files, but… when you need to do the same task repeatedly across several servers, it’s a bit of a pain. You’ve told yourself someday…

[Video] Office Hours: Snowy Michigan Edition

Last Updated February 1, 2023

Brent Ozar

Videos

We went up to Michigan to see my dad’s side of the family, and the snow came down just in time for our arrival. Always love the fresh snow look. So I stood outside and took your top-voted questions from https://pollgab.com/room/brento. Let’s see what y’all came up with today: Office Hours: Chilly Michigan EditionWatch this…

[Video] Office Hours: 22 Good Questions and a Stinker

Last Updated January 29, 2023

Brent Ozar

Videos

Lots of good questions on today’s broadcast! If you’d like to submit one, go to https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. Office Hours Live: Jan 23, 2023Watch this video on YouTube Here’s what we covered today: 00:00 Start 01:05 Testing123: When inserting or updating data into a table, from a…

[Video] Office Hours: Quickie Before Dinner

Last Updated January 29, 2023

Brent Ozar

Videos

Before heading out to dinner, I went through your highly-upvoted questions from https://pollgab.com/room/brento. Office Hours: Quickie Before DinnerWatch this video on YouTube Here’s what we covered in this episode: 00:00 Start 00:20 Mert: Hi Brent, what is the relation between AlwaysOn and Windows Failover Cluster? Is WFC an obligation or a choice for creating an…

Office Hours, ChatGPT Edition: AI Answers 4 of Your Questions

Last Updated January 31, 2023

Brent Ozar

Production Database Administration

In a recent Office Hours post, David Reabow suggested letting ChatGPT answer a few of the questions y’all posted at http://pollgab.com/room/brento/. Brilliant! Let’s see how it does. I purposely cherry-picked the questions that I thought ChatGPT would have the easiest time answering. Rollback is single threaded asks: Hi Brent! An update statement has blocked all…

[Video] Office Hours: Ten Minutes of SQL Server Answers

Last Updated January 16, 2023

Brent Ozar

Videos

ChatGPT, Resource Governor, manually created stats, Always Encrypted, and as always, fragmentation: let’s answer your questions from https://pollgab.com/room/brento. Office Hours: Ten Minutes of SQL Server AnswersWatch this video on YouTube Here’s what we covered today: 00:00 Start 01:13 Timbalero: Hi Brent. my friend knows your view on rebuilding indexes. He also thinks that external index…

Bite-Sized Office Hours: Q&A on TikTok

Last Updated January 16, 2023

Brent Ozar

Company News

Wanna learn about SQL Server and the Microsoft data platform, but you don’t wanna sit through long videos? Enjoy short videos on TikTok? I’ve got just the thing: I’m taking the best Q&A from Office Hours and putting ’em out as individual videos. That way, as you’re swiping through practical jokes, friendship goals, candid idiocy, music…

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

Last Updated January 14, 2023

Brent Ozar

Videos

Y’all just never run out of interesting questions at https://pollgab.com/room/brento! I’m impressed, got another great round today. Office Hours: Ask Me Anything About SQL ServerWatch this video on YouTube Here’s what we covered: 00:00 Start 00:25 Chrisbell: Recently we’ve been facing thread starvation issues. How can we troubleshoot it when even sp_whoisactive ( even with…

The 20th Anniversary of the SQL Slammer Worm

Last Updated January 10, 2023

Brent Ozar

SQL Server

Twenty years ago this month (next Wednesday to be exact), sysadmins and database administrators started noticing extremely high network traffic related to problems with their SQL Servers. The SQL Slammer worm was infecting Microsoft SQL Servers. Microsoft had known about it and patched the problem 6 months earlier, but people just weren’t patching SQL Server. There…

[Video] Office Hours: Back Live on Twitch Again

Last Updated January 14, 2023

Brent Ozar

Videos

After I stopped selling live classes, I took some time off all live broadcasting period. It was a nice couple of months over the holidays, had a good time with the family, and now I’m starting to fire up my Twitch channel again. I’m not setting a schedule yet, just broadcasting when I have time…

How to Install SQL Server and the Stack Overflow Database on a Mac

Last Updated October 28, 2023

Brent Ozar

SQL Server 2022

To follow along, you’ll need: An Apple Mac with an Apple Silicon processor (M1, M2, etc – not an Intel or AMD CPU) Azure Data Studio Docker Desktop 4.25 or newer An Internet connection 1. Download & Run the SQL Server Container We’ll follow the instructions from Microsoft’s documentation, but I’m going to abbreviate ’em here…

[Video] Office Hours: Bad Hair Edition

Last Updated January 9, 2023

Brent Ozar

Videos

I am waaaay overdue for a haircut, but instead of being a responsible adult, I stopped to take your questions from https://pollgab.com/room/brento. Office Hours: Brent Needs a HaircutWatch this video on YouTube 00:00 Start 00:43 Mike: We have 3 Dell PowerEdge R630 servers with SQL Server installed. Everything functions for 3.5 years straight. How long…

Office Hours: Bad Questions Edition

Last Updated January 5, 2023

Brent Ozar

Videos

Normally, y’all post and upvote great questions at https://pollgab.com/room/brento, but in today’s episode, y’all upvoted some stinkers. Buckle up. Office Hours: Bad Questions EditionWatch this video on YouTube 00:00 Start 00:47 SQLKB: Hi, according to sp_BlitzCache I usually have more than 260k plans in cache, created in the past 1 hour, is it a big…

3 Ways to Debug T-SQL Code

Last Updated January 6, 2023

Brent Ozar

T-SQL

Writing new code = bugging. That part’s easy. Taking those bugs back out, that’s the hard part. Developers are used to their tools having built-in ways to show what line of code is running now, output the current content of variables, echo back progress messages, etc. For a while, SQL Server Management Studio also had…

How to Find Missing Rows in a Table

Last Updated December 26, 2022

Brent Ozar

T-SQL

When someone says, “Find all the rows that have been deleted,” it’s a lot easier when the table has an Id/Identity column. Let’s take the Stack Overflow Users table: It has Ids -1, 1, 2, 3, 4, 5 … but no 6 or 7. (Or 0.) If someone asks you to find all the Ids…

The SQL Server Posts You Read the Most in 2022

Last Updated December 26, 2022

Brent Ozar

Company News

Here’s what I wrote in 2022 that gathered the most views: #10: Who’s Hiring in the Database Community? February 2022 Edition – I saw the success of Hacker News’ “Who’s Hiring” monthly posts, and I blatantly stole the idea for the Microsoft data platform community. It works out well, very popular, very popular. #9: PSPO:…

Announcing the 2023 Data Professional Salary Survey Results.

Last Updated January 2, 2023

Brent Ozar

Salary

Are your peers being paid more this year? Are they switching job roles? Are they planning on leaving their companies? To find out, I run a salary survey every year for folks in the database industry. Download the raw data here and slice & dice ’em to see what’s important to you. Salaries are on…

Who’s Hiring in the Microsoft Data Platform Community? January 2023 Edition

Last Updated February 8, 2023

Brent Ozar

Who's Hiring

Was your New Year’s resolution to get a new job? Heads up: the comments in this post are for you. Is your company hiring for a database position as of January 2023? 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…