A Blog from a PowerShell wielding, SQLServer DBA.
My go to scripts for day-to-day tasks.
Search SQL Server’s errorlog for problems with PowerShell using community tools
How to stop a SQL Server service with PowerShell
What to do if you get NT AUTHORITY\ANONYMOUS LOGON errors with your existing linked server connection in SQL Server.
Some thoughts on maintaining a good work/life balance
Free tools that will make people think you have superpowers.
We take a look at how to find the right verb for naming our PowerShell commands.
Set PowerShell 5.1 Security Protocol to use TLS 1.2
Explore some of the things you can do with containers.
Easily get your query from SQL Server into Excel with PowerShell
Use the dbatools PowerShell module to generate a database restore script.
A straight forward way to remove old versions of dbatools with just a few commands.