Administration, PowerShell February 13, 2017 I contributed to dbatools, and you can too Want to learn how to contribute to an awesome community PowerShell project? It's easier than you think! read more 6415 2 0
Administration January 9, 2017 DROP TABLE and replication in SQL Server 2016 SP1 and 2014 SP2 Are you constantly getting bitten by DROP TABLE statements throwing errors because an object is replicated? There's a solution. Sort of. read more 10501 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 43822 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 7434 4 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 6958 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 4514 6 0
Automation, PowerShell April 26, 2015 SQL Server Backup and Restores with PowerShell Part 1: Setting up Using PowerShell to automate backup and restores of your databases. It's not as crazy as it sounds. read more 8166 4 0
Automation, PowerShell April 9, 2015 Blog Series: SQL Server Backup and Restores with PowerShell Let's build something! read more 6409 1 0