What is your role in Cloud?

As I interact with more & more customers who are onboarding on Azure which is the Microsoft Cloud solution, one of the common myth or assumptions which I hear or encounter is  “We just need to deploy the application or database in cloud &  Microsoft will take care of the OS, Storage, patching etc” “After… Continue reading What is your role in Cloud?

Script to monitor Free Space of the data file and send alert

Recently I had to create a script which will monitor free space of all the datafiles and send alert if the free space within a datafile falls below 10% of the Total file space. The following script should help to achieve the objective so sharing with the larger audience SET NOCOUNT ON DECLARE @Tbl Table… Continue reading Script to monitor Free Space of the data file and send alert

How to change the keys for the Encryption for an already encrypted database

Have you ever wondered how to change the keys for the encryption for an already encrypted database. For this you can use “Key Rotation”. Key rotation is the process of decrypting data with the old encryption key and encrypting the data with the new encryption key. But how to use the Key Rotation with SQL… Continue reading How to change the keys for the Encryption for an already encrypted database