Here's what I'm up to and where you can catch me in March. Hope to see you someplace! read more
There's a lot of great training to be had over at Brent Ozar Unlimited, and I'm not the only one who thinks so. 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
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
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
Got non-production instances with different sets of users and permissions and want to automate putting them back in place with refreshes? PowerShell's got you covered. read more
I taught a live, two-day training class for 28 students, and here's how it all went down. read more
Thanks to the magic of PowerShell, JSON, and SQL Ops Studio custom configurations, you can quickly import your registered servers from SSMS. Here's a script to help you. read more