Change the server name of the SQL Server Instance

How to change the server name of SQL Server Instance?

Remove Database Encryption Key on all user databases

Below script will remove database encryption key, database certificate and master key on all the user databases.

For tempdb database, you need to restart the SQL Server Instance to complete the process.

Note: It is advisable to take transaction log backup before this activity is performed.

Transparent Database Encryption on all User Databases

How to apply Transparent Database encryption?

Fix Orphan Users for All databases

Fix orphan database users on all user databases.

Move End of Month file from source to destination

The script below executes on the first of every month and moves files from source to destination location.