How to change the server name of SQL Server Instance?
2018-03-27 (first published: 2018-03-19)
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.
2018-02-08 (first published: 2018-01-29)
How to apply Transparent Database encryption?
2017-05-25 (first published: 2017-05-15)
Fix orphan database users on all user databases.
2017-03-30 (first published: 2017-03-16)
The script below executes on the first of every month and moves files from source to destination location.
2014-07-24 (first published: 2014-06-16)