Nonsense, SQL Saturday September 23, 2016 Why I’ll Never Forget SQL Saturday Oslo 2016 Here's why my trip to Oslo (and beyond) was both a career and life changing event for me read more 1879 3 0
Administration, Automation, PowerShell August 3, 2016 Using DNS aliases to manage database connections All you ever wanted to know about using DNS to manage per-database connections. Also, music! read more 3341 10 0
Automation, PowerShell July 13, 2016 PowerShell Quickie: Audit your SQL Server power plan settings Don't let your servers go (power) hungry! Here's a quick PowerShell script to check your power plan settings. read more 1146 4 0
Automation, PowerShell July 8, 2016 Why I don’t use Invoke-SQLCmd 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 4418 5 1
Automation, PowerShell March 28, 2016 Why Your PowerShell Scripts Break When You Install SQL Server Management Studio 2016 It turns out that mixing multiple versions of SQL Server DLL's when loading modules is a bad idea. Who knew?! read more 1592 7 0
PowerShell October 23, 2015 PowerShell Quickie: Compare tables and row counts in two databases on different servers Here's a quick way to find total row count differences in two SQL Server tables using PowerShell read more 1596 0
Automation, PowerShell October 12, 2015 Production Data Monitoring with Stored Procedures and PowerShell You might be monitoring those servers just fine, champ, but what about the actual data the business uses? Also, lizards. read more 692 0
Nonsense, Useful Links September 21, 2015 October 2015 Speaking Schedule Here's where I'll be speaking in October. Please bring me candy. read more 419 0
Automation, PowerShell August 12, 2015 Upgrading to Windows 10 on your workstation? Write PowerShell that uses SQLPS? About that… Or: PSModulePath and you. read more 651 6 0
Nonsense August 11, 2015 SQL Saturday Indianapolis: Everyone remembers their first time (recap) Here's what happened when I decided to start speaking at SQL Saturday. read more 492 0
