Andrew Pruski shows how to integrate dbatools Powershell commands into Visual Studio Code:
The first dbatools commands that I looked at are: –
These commands do exactly what they say on the tin. Pretty standard stuff for DBAs but what’s cool is how we can use Visual Studio Code to quickly and easily check that all our databases are being backed up and have a recent (good) CHECK DB.
I’m going to setup two scripts to run the dbatools commands against my SQL instances via Visual Studio Code Tasks.
Read on to see how Andrew did it.