As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data. Here are some third-party alternatives. I get to work with a lot of customers, so I get to see a lot of ...

SQL Server Management Studio (SSMS) is the principal interface for working with Microsoft SQL Server. However, many subtleties of this powerful tool evade even the most seasoned professionals. Here ...

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...

There are lots of ways to create MSSQL databases via PowerShell. We could invoke a T-SQL query using the CREATE DATABASE term, we could write some code to use the [Create() method with SMO] or, if ...

If you’ve been managing databases for any length of time, you’ve probably had to contend with the “noisy neighbors” scenario. In this scenario, you have several applications, each with their own ...

In announcing SQL Server Management Studio (SSMS) 21 Preview 1 this week, Microsoft revealed Copilot AI for the tool is also being previewed, privately. A Copilot for the tool that helps users manage, ...