SqlServer PowerShell Modules NuGet Package Now Available
Howdy. Back in the July Update of SSMS 2016, a bunch of new SQL PowerShell functions were added, plus two neat additions toInvoke-Sqlcmd: -outputas, which allowed you to output the result set into a data object (eg, data row, data table etc), and -ConnectionString, which allows you to pass in a connection string instead of using the pre-defined parameters. All very useful stuff, go and have a read. However, this update has two issues: firstly, it’s not updating the classic sqlps module, but rather has created a new module: sqlserver.