If you're working with SQL Server from Powershell as a DBA, developer, analyst, or anyone else running queries, you've probably used functions like Invoke-SqlCmd or Invoke-DbaQuery. But depending on how you're building your queries, this can introduce errors into your data or even cause a huge security problem for the organization!

With the help of the dbatools module, I'll show you how to make these queries safer and at the same time, make them easier to work into your existing Powershell scripts.