default parameter values

When connecting to a SQL Server instance with alternative credentials, it can be tedious to repeat the SQL credential over and over. The great news is that this repetition is …

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 …