blog

managing central management server

SQL Server’s Central Management Server (CMS), first introduced in SQL Server 2008, “stores a list of instances of SQL Server that is organized into one or more central management server …

simplifying snapshots

I remember the first time I saw database snapshots, I was so excited. Then I right-clicked in SSMS and.. No way to easily create a snapshot. So then I researched …

decreasing module import times

SQL Server Operations Studio by Microsoft is like SSMS for ops, all open source and published on GitHub! They recently updated their wiki’s Performance page, addressing why SQL Operations Studio …

happy belated world backup day

Happy Belated World Backup Day! I wish it was Backup and Restore Day, Test Your Backups Day, or World Recoverability Day, but alas. I’m currently working on my portion of …