A PowerShell Alias

Incident Response Data

Being prepared for a disaster might mean having a way to collect data when something occurs.

Implement Azure SQL Elastic Jobs with PowerShell

In this article, I will work you through the process of creating elastic jobs in Azure using PowerShell. The elastic jobs are similar to regular agents jobs in SQL Server although they add extra functionality like for example dedicated target groups that can be used in the job step level. Currently, the elastic jobs are […]

PowerShell editors and environments part 2

In this article, Greg Moore demonstrates two additional PowerShell editors: Azure Data Studio Notebooks and Visual Studio Code.

Encrypt and Decrypt Passwords in SQL Server with PowerShell

In this article we look at how to securely store data in text files that could be used for SQL Server authentication or wherever you need to keep data secure.

PowerShell editors and environments: Part 1

There is no shortage of PowerShell editors and environments for developing and running scripts. Greg Moore explains some of his favorites.

Monitor SQL Server Error Logs with PowerShell

Receive email notifications of non-standard entries in your SQL Server Error Log files with a little PowerShell.

Anyone Can Click Through Once

Using some sort of scripting or automation is important for your career.

Import Excel Data into SQL Server with PowerShell

In this article we look at PowerShell code you can use to import Excel data into SQL Server.

PowerShell Day By Day: The Pipeline

In this article, I wanted to discuss the PowerShell (PoSh) pipeline, which was confusing to me at first and took some time to get used to working with. I had used one in Linux before, but the PoSh one is more powerful, but also slightly different. Hopefully I can demystify some of the concepts for […]