Previously we discussed how to take encrypted backups in SQL server, in this post will continue the encryption topic and implement Transparent Data Encryption (TDE)…
When the order of pages in a index does not match the physical order in a datafile, we consider it as fragmentation. This happens in…
Dynamic data masking or DDM was first introduced in SQL Server 2016, which limits sensitive data exposure by masking it to non-privileged users. It is…
In this post, I will explain how to take encrypted backup in SQL server using T-SQL and SQL Server Management Studio (SSMS). Encrypting the database backups…