Tips & Tricks : What you need to do to creat SQL Login to authenticate to Azure SQL DBs members in Auto-Failover Group

Sometimes we found it is tricky to setup SQL Login account other than default built-in SQL Admin and using them to allow SQL application access to login to Azure Server and Databases members in Auto-Failover Group! First I would like to briefly summarize Auto-Failover Group feature introduced to Azure SQL DB as a part of…


Export Azure SQL DB Error: “Missing the required ‘administratorLogin’ parameters for ImportExport operation.”

Few days ago, I have been working on an issue that customer trying to Export Azure SQL Database using Azure Portal, facing this Error Message: ErrorCode: 400 ErrorMessage: Missing the required ‘administratorLogin’ parameters for ImportExport operation. Symptom: Customer is using Google Chrome browser connect to Azure Portal and trying to Export Azure SQL DB, frequently…


What will happen with CATALOG_COLLATION and Case Sensitive vs Case Insensitive

One of the options available when creating a database is the CATALOG_COLLATION, by default this is going to be SQL_Latin1_General_CP1_CI_AS , even if you take the trouble of specifying a database collation , the catalog collation will be SQL_Latin1_General_CP1_CI_AS unless you say otherwise. If you do not set this parameter it will not use the…


Using Certificates in Azure SQL Database : Import

In these last days security is being a common topic on the news not for the best reasons and to help to avoid being the subject of one of those news I will share how to increase the security on our Azure SQL Databases. One way to increase the security on our Azure SQL Database…

0

How to change Azure SQL DB LTR Recovery Service Vault ?

Received a comment saying ‘Can’t Change the server Recovery Service Vault’, took a breathe and start a new Lab on Azure Portal trying to find out how it can be changed, after a lot of tries unfortunately I realized that it can’t be done through the portal, so what is our best friend Solution ?……

0

REST API Sample for exporting a database

While working on an Azure SQL Database support case, I needed to provide a REST API sample for exporting a database. I struggled a bit to get it to work, as the syntax is not really intuitive and requires creating an Azure AD application. To save you from the same struggle, here is the sample…


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…


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…