SQL PowerShell Blog
I’ve been working in data for a long time. After a while, you recognize the issues that everyone runs into sooner or later—and hopefully, can come up with some pretty creative solutions.
Popular Blog Posts
SQL Server
September 10, 2024
Insights from your Database using PowerShell and TSQL
2024-09-10
Hello All. I have been looking for ways for quite sometime to understand my databases better. There are a lot of DMVs and even some DMFs that help us get some information from the SQL Server engine that can be very insightful. Many shops use monitoring tools and they are great because they watch things
SMO
September 10, 2024
Why Become a PowerShell DBA
2024-09-10
If you find this article valuable and you decide that you want to get your learn on with PowerShell and SQL Server, there is a SQLSkills class that I am teaching this year, please join me to get a great start in how to get your toolset growing by adding PowerShell to your toolbelt. Early Bird discount
Recent Blog Posts
SQL Server
September 10, 2024
Insights from your Database using PowerShell and TSQL
Hello All. I have been looking for ways for quite sometime to understand my databases better. There are a lot of DMVs and even some DMFs that help us get some information from the SQL Server engine that can be very insightful. Many shops use monitoring tools and they are great because they watch things
SMO
September 10, 2024
Why Become a PowerShell DBA
If you find this article valuable and you decide that you want to get your learn on with PowerShell and SQL Server, there is a SQLSkills class that I am teaching this year, please join me to get a great start in how to get your toolset growing by adding PowerShell to your toolbelt. Early Bird discount
Azure Data StudioPowerShell
February 2, 2025
Azure Data Studio and PowerShell Notebooks
Recently there was an update to Azure Data Studio (1.50) that broke PowerShell Notebooks that needed to have Python installed and modules updated. It was bugged (found an issue on Github) Basically in a nutshell version requirements were changed and it broke python installing the needed modules and gave an error saying that there were
SQL Server
September 10, 2024
SQL Server Agent PowerShell Job Step with #NOSQLPS
In researching some things for a presentation, I was to give at Intersections, Spring 2022, I came across this documentation page for SQL Server PowerShell that in the SQL Server Agent section it indicates that there is a way to get the Agent Job Step to skip loading the SQLPS module and you get to use PowerShell