Posts by Brent Ozar

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

[Video] Office Hours: Cabo Balcony Edition

Videos
1 Comment
Post your questions at https://pollgab.com/room/brento and upvote the questions you’d like to see me discuss. The light balance on this video is all over the place, getting brighter and darker constantly, so you might wanna leave this one playing in the background and just listen to it rather than watch. Here’s what we covered: 00:00…
Read More

[Video] Office Hours: Cabo Pool Edition

Videos
0
You posted SQL Server  questions and upvoted the ones you’d like to see at https://pollgab.com/room/brento, and before the Cabo Clasico finals start for the day, I sat by the pool to talk through ’em: Here’s what we covered: 00:00 Introductions 00:53 Neil: Does putting up a giant monitor on the wall with SQL Server info…
Read More

The Top Feature Requests for SQL Server

SQL Server
28 Comments
If you want to get a look at where Microsoft SQL Server is heading in the future, it helps to get an idea of what users are repeatedly asking for. Here’s a quick rundown of the top requests from feedback.azure.com as voted by the people who cared enough to log in and upvote ’em: 10:…
Read More

“Index Seek” Doesn’t Mean Much.

Execution Plans
13 Comments
When you see “index seek” on an execution plan, that doesn’t mean SQL Server is jumping to exactly the row you’re looking for. It only means that SQL Server is seeking on the first column of the index. This is especially misleading on indexes where the first column isn’t very selective. To explain, I’ll take…
Read More

[Video] Office Hours: New Las Vegas Home Office Edition

Videos
2 Comments
It’s the first webcast I’ve done from my new Vegas pad. You posted questions at https://pollgab.com/room/brento/ and I discussed the highest-upvoted ones: 00:00 Introductions 02:15 Jim D: Should I use full backups or log shipping for migrations? 03:53 Sev A: What are the top misuses of SQL Server that are better accomplished without SQL Server?…
Read More
Brent Reading Book

What DBAs Need to Know About Snapshots

Storage
5 Comments
Snapshots by Polaroid? That’s not right. You’re a DBA responsible for making sure SQL Server databases are online, backed up, corruption-free, and fast. Your databases have gradually grown in size over time, and you’re starting to hit new size issues you haven’t encountered before. Nightly maintenance windows are getting smaller, you’re not able to refresh…
Read More

[Video] Office Hours: Last San Diego Balcony Edition

Videos
0
It’s the last San Diego balcony edition of Office Hours! You posted your questions at https://pollgab.com/room/brento and upvoted the ones you’d like to see. Here’s what we covered this week: 00:00 Introductions 00:50 Steve E: Hi Brent, How are you enjoying the Porsche 944? 01:55 Midwest DBA: Hey Brent, The wife says my DBA oncall…
Read More