The Get-SQLErrorLog cmdlet is a nice addition to the SQL Server PowerShell module, but the tools team "mustn't be afraid to dream a little bigger, darling." read more
All you ever wanted to know about using DNS to manage per-database connections. Also, music! read more
Don't let your servers go (power) hungry! Here's a quick PowerShell script to check your power plan settings. read more
It might be a gateway cmdlet to SQL Server and PowerShell, but it's not one I recommend using if you can. Here's a couple reasons why. read more
It turns out that mixing multiple versions of SQL Server DLL's when loading modules is a bad idea. Who knew?! read more
Here's a quick way to find total row count differences in two SQL Server tables using PowerShell read more
You might be monitoring those servers just fine, champ, but what about the actual data the business uses? Also, lizards. read more
Here's where I'll be speaking in October. Please bring me candy. read more
Or: PSModulePath and you. read more
In my previous post we talked about setting up your local environment to use SQL Server and PowerShell together, so now let’s put this into practice. read more