Posts by Brent Ozar

Office Hours - ask me anything.

Live Office Hours Next Week

Company News
1 Comment
Tuesday & Wednesday afternoon at 2PM Pacific, 5PM Eastern, I’ll be streaming Office Hours live in my Twitch channel. I’ll post the recordings on my YouTube channel. Post your questions and upvote the ones you’d like to see here. Here are calendar reminders for Tuesday and for Wednesday. I’ve been doing these disconnected – recording…
Read More

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

Videos
0
Ask me questions at https://pollgab.com/room/brento and upvote the ones you’d like to see covered. I can pretty well guarantee that your favorite question this time is going to be the last one I answered. Here’s what we discussed today: 00:00 Introductions 00:57 Sean W: New app with data model TBD; what is the thought process…
Read More

[Video] Office Hours: Morning in Mexico Edition

Videos
2 Comments
Got SQL Server questions? Post ’em at https://pollgab.com/room/brento and upvote the questions you’d like to see me discuss. Here’s what we covered this morning: 00:00 Introductions 00:45 SQL Simian: Everybody loves free advice, but we want war stories. I have heard your 174 indexes story twice now during recorded classes. Got any more? What are…
Read More

SQLBits 2022 Day 1 Keynote

SQLBits
9 Comments
Conferences are back, baby! I’m in London for SQLBits 2022, the biggest Microsoft data conference in Europe. This year’s theme is classic video games, and it’s been really cool to see the 8-bit logos and games all over the ExCel Center. Today is the Microsoft keynote. It’s called Level Up with Azure Data, hosted by…
Read More

[Video] Office Hours: Cabo Home Studio Edition

Videos
0
Got questions about SQL Server? Post them at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. This episode was the first live one I shot in my home studio in Cabo: Here’s what we covered: 00:00 Introductions 02:19 Nullpointer: What are your thoughts on temporal tables, I don’t hear you talk much…
Read More

Building PollGab.com: Designing the Data Model

PollGab
9 Comments
In the last post, I talked about how Richie and I sketched out the goals of PollGab.com, the site where you can post questions for other folks to answer during their live streams. I challenged you to decide: What data needs to be stored to make all this work? What database or persistence layer should…
Read More

Big Data Clusters: Out of Aces

SQL Server
16 Comments
When this feature was announced in 2018, I wrote: <sarcasm> It’s like linked servers, but since they don’t perform well, we need to scale out across containers. </sarcasm> I just didn’t get it, and I continued: I like that Microsoft is making a risky bet, planting a flag where nobody else is, saying, “We’re going…
Read More

Meme Week: Queue in the Database

Architecture
11 Comments
When you have a hammer, everything looks like a nail. Unfortunately, a lot of people don’t even know how to use a hammer correctly. You really shouldn’t be doing queues in the database because: They’re a blocking nightmare, constantly locking rows in highly concurrent tables They’re a logging nightmare, constantly pouring data into the transaction…
Read More