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?

Searching for orphaned DB files on the SQL server

See how to find those files that are not in use, but are taking up space on your instance.

SQL Server Wait Stats Monitoring with PowerShell

In this article we add another module to the PowerShell monitoring process to capture wait stats for all monitored SQL Server instances.

How to Use Parameters in PowerShell Part II

PowerShell is a basic skill any administrator working in Windows or Azure should know. After writing his first article about PowerShell parameters, Greg Moore realized that there is even more to talk about. This article covers using pipelined parameters and more.

Getting Debug Messages in PowerShell

Basic Git for DBAs: Managing PowerShell Scripts

This next article in the git series looks at managing powershell code in Git.

Calling Procs from PowerShell with Parameters

Building on his last article, Frank shows how to add parameters to your stored procedure calls from PoSh.