PowerShell: Script Out SQL Server Objects DDL To Folder Using dbatools

Today, I am going to show a simple script that uses dbatools to script out SQL Server Database level objects like Tables, Views, Stored Procedures, SQL Agent Jobs, Triggers, Database Users, etc., With dbatools, it is simple enough to also script out Instance level objects like logins, database mail profiles/accounts, credentials, SQL Agent objects, linked …

PowerShell & SQL Server: Unmask All Masked Columns (Dynamic Data Masking) In Database

Necessity is the mother of new PowerShell code :-)! Today, I had to unmask all the columns I had helped mask using Dynamic Data Masking. This simple post assumes that you are a privileged user with the ability to drop "Column Masking"! Identify Masked Columns The SQL to identify all masked columns is pretty simple …

PowerShell: How To Reverse Alphabetical File Names & Rename

Recently I had shot a bunch of videos on a Video App on my iPhone. By default it saves the videos/photos within the App itself. Later, I can move them to iPhone "Photos". Why are file names in reverse order of how I shot them? In the case of this app, I just did "Select …

SQL Server: Disable/Remove Indexes Across Servers/Databases Using PowerShell & dbatools

This is something I had to do today. In this blog post, I am going to show you how you can disable or remove indexes matching certain name criteria or other condition(s) across multiple servers and databases in various tables. Usually, this is a very painful process if done by hand but with the fantastic …

PowerShell: Prevent Accidental Runs of Scripts

The problem and it's a big one! You might want to read this to the end! You are into PowerShell and have a ton of scripts. The problem is some of them run things that are not meant to be run at any time by anyone except you when you first set it up 🙂 …