How to test SQL database changes with Pester

Making database changes is tough. Fortunately with Pester, testing those changes is as easy as writing a unit test. In this snip, we'll go over how to run Pester tests on a database using the SQL Management assemblies.

Prerequisites include:
SQL Server and the SQL Server Shared Management Objects