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