PowerShell in Azure Data Studio

• Daniel Calbimonte

  SSCertifiable

  Points: 6271

  More actions

  February 14, 2022 at 12:00 am

  #3975717

  Comments posted to this topic are about the item PowerShell in Azure Data Studio

• qbrt

  SSCrazy

  Points: 2737

  More actions

  February 14, 2022 at 4:42 pm

  #3983465

  Thank you for the great intro article to ADS!

  Would like to point out that per Microsoft, "There are two SQL Server PowerShell modules; SqlServer and SQLPS. The SqlServer module is the current PowerShell module to use." Do not use SQLPS. No support there anymore.

  Also, for any SQL Server related tasks within PowerShell, use dbatools. (https://dbatools.io)

  Intro here: https://octopus.com/blog/sql-server-powershell-dbatools