Interacting with MS SQL

There are many ways of interacting with Microsoft SQL Server from within PowerShell. While there is the old SQLPS module as well as the new and improved SqlServer module, neither are fully compatible with PowerShell Core.

Instead, we can turn to .NET and to the much more convenient dbatools module from the community.

Getting ready

Install and start PowerShell Core. If you want to follow along with lab SQL Servers instead of your own infrastructure, you can use AutomatedLab and the lab recipe found at https://github.com/AutomatedLab/DscWorkshop/blob/master/Lab/03.10%20Full%20Lab%20with%20DSC%20and%20TFS.ps1.

...