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.
I'm extremely excited to announce I'll be conducting a live, two day, online class centered around PowerShell for the fine folks at Brent Ozar Unlimited! Here's the details. read more
Since we did it on Ubuntu, let's keep the Linux party going: Here's how you can set up SQL Server Active Directory authentication with CentOS. read more
Falling leaves, shorter days, longer nights, SQL Server, PowerShell, Linux, Dog Food, barbells, and even some handcuffs. Here's what I have going on and where you can find me this month. read more
SQL Server on Linux is here, and if you want to use Active Directory authentication, there's a lot of steps involved to get it working. Let's walk through the configuration on Unbuntu! read more
We successfully launched HASSP-2! We achieved our goal of ~100,000 feet and captured some awesome footage. But can we call it a success? Well, "it depends." Here's our launch day diary about how it went. read more
