Finding Database Indexes: “They’re coming outta the walls! They’re coming outta the goddamn walls!”
For this month's #tsql2sday post, I'm sharing a script I use to capture all a databases indexes. You know... in case you ever need to nuke them all from orbit (it's really the only way to be sure).
PowerShell quickie: space used per database by table objects
Sometimes the most useful scripts are the most straightforward: here's how you can return all your space used by your table objects on an entire SQL Server instance.
Ever wanted to know what a 5oz SQL Server looks like? Curious about how we're going to power it? What about sensors? Let's take a tour of the HASSP hardware! read more
This project isn't possible without some pretty awesome people. Fortunately for me, I didn't have to look too far to find the best. Here are the people helping make this a reality. read more
Did you know that you can enable system-versioned temporal tables on something that's marked for replication, even though it isn't supported? Yeah, me either. Here's what happened, and how you can fix it. read more
Replication latency is usually the result of large transactions and the number of rows they insert into the distribution database. There's a way around that, though. A very dangerous way, it turns out. read more
