Got my bags packed, and I'm ready to go. Here's what's going on this month in my orbit. read more
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 more
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 more
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 more
It's 10 PM: do you know how many of your database objects contain linked server references? read more
In this not-so-typical post, I describe how hard it is to say goodbye to my favorite piece of technology over the last 21 years. read more
Here's a quick sample of how you can use the SQL Server PowerShell provider in Linux just like you do in Windows. read more
SQL Operations Studio is essentially Visual Studio code, which means you can extend it. Here's a quick demo that adds in a quick check for WHERE clauses in DML statements. read more