Posts by Brent Ozar

I flew into Wales a couple days early to get used to the time zones, and showed up at the conference center where SQLBits would be located. Let’s go through your top-voted questions from https://pollgab.com/room/brento on a very chilly morning: Here’s what we covered: 00:00 Start 01:02 Jersey: Has Microsoft fixed any of the bugs…

When you’ve got questions about architecture, development, or best practices, post ’em at https://pollgab.com/room/brento, and upvote the ones you’d like to see me cover. It’s like free bite-sized consulting. Here’s what we covered this week: 00:00 Start 01:37 DBAInAction: Hi Brent, could you please suggest an archival/purging strategy for multi-TB tables to free up disk…

Let’s go through a LOT of your top-voted questions from https://pollgab.com/room/brento on a VERY early Saturday morning. 00:00 Start 01:52 DBAInAction: Hi Brent Microsoft just announced Automatic Index Compaction for Azure SQL and Fabric. do you see this finally killing off the traditional ‘index maintenance’ debate? Also, any gut feeling on whether this will eventually…