sql-management

Update SSMS With PS1

1 minute read

Installing and Updating SSMS with a simple PowerShell script can be a nice little timesaver…

Track Creation of Databases

1 minute read

Sys.Databases has some create information, but I was looking for a way to track aging, last access, and if databases got dropped. In a development environmen...

Attaching Database Using SMO & Powershell

less than 1 minute read

Steve Jones wrote a great article on using this automation here titled The Demo Setup-Attaching Databases with Powershell. I threw together a completed scrip...

Get Backup History for All Databases in Server

less than 1 minute read

Here’s a quick snippet to get a listing of the database backups that last occurred on a server. Most solutions provided a single backup listing, but not the ...

Failover all databases to other server

less than 1 minute read

Quick snippet I threw together to help with failing over synchronized databases to the other server in bulk. No way I want to click that darn Fail-over butto...