Exported database from Azure SQL failed to be imported to Azure SQL or to local SQL Server

Update: (2018-01-30) – Resolved  DacFX version 17.4.1 has been released, this version contains the fix for all of the behaviors related to the master key. you can download it here to confirm you are using the correct version, verify that the file version of SQLPackage.exe is at least 14.0.3917.1 and follow the instructions here: using sqlpackage…


Quickly test connectivity from Azure Website to SQL DB

In case you have an Azure Website and you need to confirm that your website can reach SQL Database service here is a quick and simple way to test it: 1) navigate to Kudu (it can be accessed at https://{yourwebsitename}.scm.azurewebsites.net ) (Kudu is the engine behind git/hg deployments, WebJobs, and various other features in Azure…


Lesson Learned #23: How to add AAD Security Groups to Azure SQL Database?

In these days, we are receiving multiples cases where our customer needs to add Azure SQL Database groups from Azure Active Directory. This is an example to how to archive it. Using the Portal in Azure: I created a user called SQLMember. I created a group called SQLGroup, adding the member SQLMember.   Using SQL…