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).
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
Thanks to SQL Server Operations Studio, insights into your servers have never been easier to create. Here's a quick demo on how to create custom dashboard visuals. read more
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
