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

Deployment fails with ‘Unable to connect to master or target server ‘mydb_svr’. You must have a user with the same password in master or target server ‘mydb-db’

This will be a very short post to address what appears to be a slight trend in support at the moment. When attempting a deployment fails with an exception, attempting a deployment of the dacpac for the database via sqlpackage.exe also fails with the error: ‘Unable to connect to master or target server ‘mydb_svr’. You…


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

Providing the server name explicitly in user names for Azure SQL DB, MySQL and PostgreSQL

Often, users will want to create their SQL Logins in the user@mydomain.com format.  While a perfectly valid format, this can lead to login failures if not accounted for. Cannot open server “mydomain.com” requested by the login.  The login failed. (Microsoft SQL Server, Error: 40532) Below you can see that my server has been entered as…


How to get more information about failed import to Azure SQL DB

Scenario: If you try to import bacpac to Azure SQL DB and it failed you will probably get this indication from the notification Figure 1 – notification on failed import operation. Also, in “Import / Export History” sometimes (depend on the failure reason) you may not see any records for the failed import Figure 2…


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…


How to create an Azure AD application in PowerShell

For several tasks related to Azure services, you need to specify the tenant ID and secret of an Azure Active Directory application in order to implement proper authentication. This post provides you with a PowerShell sample for creating such an Azure AD application. # Sign in to Azure. Login-AzureRmAccount # If your Azure account is…


PolyBase export of datetime values does not use DATE_FORMAT

This topic came up on a recent support case I had worked on. The customer had stored the data in an Azure SQL Data Warehouse database, but needed to move it into Azure blob storage for consolidating data from different sources. This also required to write the datetime values in a specific format. The idea…