Monitoring SQL Server Instance Version and Builds with PowerShell

In this article we continue our PowerShell monitoring series with scripts that check the current version and build for all SQL Server instances in your environment.

Testing the Effects of PoSh

Finding the Free Space Difference Between Availability Groups Replicas

When was last time you have checked your Always On Availability Groups' replicas storage distribution?

Managing Power BI Workspaces with PowerShell

In this article we look at how to manage Power BI workspaces using PowerShell cmdlets.

Execute SSIS Package from PowerShell - Part 1

In this article we look at how you can execute SSIS package using PowerShell both with and without SSIS package parameters.

Great Power(Shell)...Great Responsibility

-WhatIf you could see what would happen if you ran a command?

Copying an Azure SQL Database with PowerShell

PowerShell Day by Day: Filtering Objects

In my last article, The Basics of PowerShell Day By Day, I covered some basics of getting started. These articles aren't intended to replace some of the getting started information in things like the Stairway to PowerShell. Instead, I am covering some of the tips, tricks, techniques, and bits of knowledge that I wish I'd […]

SQL Server High CPU Query Use Monitoring with PowerShell

In this part of the PowerShell monitoring tips we look at how to capture the top queries that are consuming the most CPU from all monitored instances.

When one of your DBA colleagues leaves the company, what is your checklist?

A colleague left the company, a couple of days after SQL Server processes start failing...what do you do?