Sometimes you need to extract a large number of tables into some other format. I’ve written about BCP earlier as a quick option to move…

I ran into a concern to quickly audit all current users and role members for a set of Azure SQL databases, spread across multiple resource…

I recently had a need to add certificates to SQL Servers throughout an organization. There were quite a few servers to update and the certificates…

This seems oddly specific, but someone or something had cleared out many files from the Windows\Installer folder, probably to save space. (Sidenote, you can actually…

I have often run into a situation where it’s been necessary to execute a bunch of scripts handed to me by developers or others. When…

I’ll admit that I typically use VSCode for most of my scripting, but Milosh Djuric put together some neat PS to make the console window…

Drew Furgiuele came up with a PS script to import your SSMS Registered Servers into Azure Data Studio. He wrote it up in much more…

I was recently trying to generate a bunch of data that I needed to pass through one of our in-house DLLs in order to use…

Here are some of the more interesting Powershell links I came across recently, along with some thoughts about them. Powershell, String Encryption, and GPG –…

While with the time and knowledge we can write a lot of the things we’ll use in Powershell, it’s often not worth it to re-invent…