Exporting a database that is/was used as SQL Data Sync metadata database

When trying to export a database that is or was used as SQL Data Sync metadata database you can encounter errors like: Error encountered during the service operation. Could not extract package from specified database. The element DataSyncEncryptionKey_1076efa36f054d35a60e717333298486 is not supported in Microsoft Azure SQL Database v12. or Error encountered during the service operation. One…


Updated ARM Template to deploy server with Auditing and Threat Detection turned ON

[2018-07-31] Note: new template version is now available. It includes 3 changes: There is no reason to enable both server policy and database policy. It is enough to enable only server policy. No need to supply storage account for Threat Detection policy. It is needed only for auditing Use the updated API version for auditing…

0

Providing the server name explicitly in user names Part 2: DNS alias for Azure SQL Database

In continuation of the previous blog on needing to provide the server name in your username when connecting, there are other scenarios and new features where this will need to be taken into consideration or make unnecessary! Often times users will want to use custom domains for connecting to their servers, Example: sqlprod01.database.windows.net is our…


Tips & Tricks : What you need to do to create 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…


Lesson Learned #49: Does Azure SQL Database support Azure Active Directory connections using Service Principals?

The answer is Yes!. Just finishing a service request following the instructions placed on this URL  but with a limitation: Service Principal of the Managed Service Identity is not currently supported.  It is supported if you register an application in Azure portal > Azure Active Directory > Application registration.   Just to mention that there it not…


Lesson Learned #48: Does Azure SQL Database Managed Instance support Resource Governor?

The answer is Yes! and it is great to know. Currently, using Azure SQL Database Managed Instance we could configure a subset of the physical resources of an instance of the Database Engine.  SQL Server Resource Governor, enables us to specify limits on the amount of CPU, physical IO, and memory that incoming application requests can…


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…


Lesson Learned #47: Do you have connectivity issues to Azure SQL DB from your PC?

Often, we are working on with service requests that our customers are facing connectivity problem to Azure SQL Database from their office or from home. Time ago, my colleague Raghda and I, recorded this video, that you could watch in our YouTube channel to verify the main issues that may prevent a successful connection to Azure SQL…


Lesson Learned #45: CPU at 100% using nvarchar parameter data type in the filter against varchar column data type.

These last days, I have been working in several service requests with same behavior. Customer has an application that is searching a value per execution. The parameter value that is using the stored procedure is defined a nVarchar data type. The table field is varchar data type. Every execution took few milliseconds but if you…