Main slider - Background

Where’s Drew, August 2018 Edition

Got my bags packed, and I'm ready to go. Here's what's going on this month in my orbit.

Read
Main slider - Background

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).

Read
Main slider - Background

Where’s Drew, July 2018 Edition

I'm back, and I'm chock full of french fries and burrito coverings. Here's what's going on with me in July.

Read
Main slider - Background

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.

Read