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 …

SQL Server: Copy Data from Large Tables to Target in a Resumable Fashion!

If you are looking for something that copies a set of tables from one SQL Server instance to another with all the indexes included, you can use my PowerShell Table Copy script that I have blogged about before. A single large table copy - Say No to "All or nothing"! The purpose of this post …

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 …