Unlocking the Power of the SQL Server PowerShell Module
summary
Module installs from PSGallery with Install-Module and SQL Server PowerShell module replaces the dead SQLPS (deprecated 2016); it exposes ~100 cmdlets (PowerShell 7 drops 3) and the SQL Server Provider returns SMO objects so Get-Item/Test-Path/Remove-Item operate on live DB objects. DBAtools sits alongside with 700+ commands but can conflict over Microsoft.Data.SqlClient 6.x. Hidden gem: provider context makes Invoke-Sqlcmd inherit server/database so queries run without repeating connection info. Built-in SQL Assessment API runs rule checks with actionable results and Write-SqlTableData bulk-inserts fast.
AI-written summary · about
chapters (10)
- 0:00SQL Server PowerShell intro
- 1:58Module basics
- 4:04Installing the module
- 11:10SQL Server provider
- 18:49Working with commandlets and objects
- 25:06Hidden module gems
- 27:55SQL Assessment API
- 33:11Key takeaways
- 36:44Live demos
- 51:31Q&A
related talks
39mPowerShell with SQL Statement Data Gathering
44mAnthony's Favorite dbatools cmdlets and Use Cases
50mUnlocking Database Automation with dbatools: Practical Use Cases and Real-World Insights
01h 37mdbatools for Systems Engineers and Accidental DBAs
44mContinuously deploying SQL code using Powershell- 50mUnlocking Database Automation with dbatools: Practical Use Cases and Real-World Insights
- 50mUnlocking Database Automation with dbatools: Practical Use Cases and Real-World Insights
51mSQL Server 2022 and the Wheel of Power