This article focuses on the steps on how to configure the Always Encrypted (AE) feature for SQL Databases using Azure Key Vault as the key store provider; which is still in preview at the time of this writing. In order to try out what I have explained here you should have January 2016 preview or … Continue reading Provisioning Always Encrypted in SQL Databases with Azure Key Vault, using SSMS 2016.
You have implemented the Dynamic Date Masking (DDM) in your SQL Database, but still you get the unmasked data. Are you using the correct role permissions and the correct logins? I published a post before the general availability (GA) of DDM about what you need to know about the DDM GA. There were two key … Continue reading SQL Server Dynamic Data Masking not working. Are you using the correct role permissions?
Please read this post after reading this, as some critical changes have gone to the DDM feature of SQL Databases in GA SQL Database Dynamic Data Masking will be Generally Available (GA) very soon by the end of this month. For more information about Dynamic Database Masking please read this article. As per the article … Continue reading What you need to know about SQL Database Dynamic Data Masking before the GA
If you have multiple SQL databases in Azure and looking for a centralized management solution, then Elastic Database Pool is the one you've been looking for. Elastic Database Pool is a feature that you can enable in SQL Database Servers which has V12 update. Elastic Database Pool is still in preview as of this writing, … Continue reading Azure Elastic Database Pool – Managing SQL Databases in breeze
This post summarizes the set of good practices you should follow when developing application on SQL Azure and how to arrange TDD or unit tests based on those practices. Before continue reading this post, I assume that you are familiar with SQL Azure Databases, Entity Framework and TDD. One of the highly regarded and strongly … Continue reading SQL Azure Database best practices and TDD