Standardize SQL Server Maintenance Quickly and Easily Using Install-DbaMaintenanceSolution
May 14, 2025
Introduction In this blog post, we will audit the dbatools command Install-DbaMaintenanceSolution. I will test, review, and evaluate the script based on a series of identical steps. Our goal is to provide insights, warnings, and recommendations to help you use this script effectively and safely Install-DbaMaintenanceSolution is the key to simple, reliable, and comprehensive SQL
Why Invoke-DbaQuery Is My Most-Used dbatools Query
April 24, 2025
In this blog post, we will audit the dbatools command Invoke-DbaQuery. I will test, review, and evaluate the script based on a series of identical steps. Our goal is to provide insights, warnings, and recommendations to help you use this script effectively and safely. Invoke-DbaQuery is the Swiss army knife of all dbatools commands as
How to Troubleshoot SQL Server With PowerShell.
April 25, 2024
PowerShell is an essential tool for SQL Server database administrators looking to streamline their workflow and automate repetitive tasks. When it comes to troubleshooting your SQL Server instances, PowerShell is an essential tool for the DBA toolbox. As a versatile scripting language and command-line shell, PowerShell enables seamless integration of commands, arguments, variables, and modules
Adding SQL Server Access When You’re Locked Out
August 29, 2023
As consultants we are sometimes asked the following question: “We have an old version of SQL that we can’t turn off and no one has access to it. Is there a way to create an account on a server you don’t have access to?” The answer is YES, and it isn’t as difficult as you
6 Common Pitfalls of SQL Server Migrations and Upgrades
November 30, 2022
If you’ve ever tried migrating a SQL Server database from one server to another, you know it can be a white-knuckle ride from start to finish. You need to wait forever while you backup and restore, change all your connection strings to point to the new server, and forget to change the data sources for