Rod Edwards shows off some nice functionality in dbatools:
I often build solutions around the dbatools functions, the below is just some of my Operational favourites. With some I’ve included the output pipe that I use most frequently, but obviously, you can view and use the output however you choose to. Clearly, DBATools has many functions to add/remove/update SQL as well, but i’m just folking on the ‘gets’ here.
Naturally, as mentioned…its powershell, you can programmatically use this for any of your automation needs. Marvellous.
The ever growing list of commands can be found here: command index – dbatools . This can prove daunting to new users of the toolset, so here’s a starter for 10.
Click through for those 10.