Issue Modifying search_path Parameter for Azure Database for PostgreSQL

Azure Database for PostgreSQL users have recently reported an issue to us that occurs when setting a custom value for the search_path parameter from the Server parameters blade in the Azure Portal.  The issue is that this custom value is modified automatically by the service when saved.  For example: A value entered of: “$user”, public,…


Restoring Deleted Database to Specific Point in Time

While majority of the time when restoring a deleted database you will want to select the time it was deleted as the restore point, there is however the ability to restore a deleted database to a Point in Time prior to the deletion. With all Azure SQL DB offerings, there is a retention of backups…


Tracking Azure SQL Data Sync Service data changes

Customers often ask for the capability of tracking the Azure SQL Data Sync Service (DSS) data changes. Since we do not have built-in feature in DSS to provide this option, customers need to build their own solutions. To help, we verified that if your DSS login is unique, the trigger/auditing table method could provide the…

0

Using Certificates in Azure SQL Database : Backup

In the previous article we manage to import into Azure SQL Database a certificate so we could improve the security of our system. But there can be situations where we need to backup the certificate to be used in another Azure SQL Database or for any other reason. So how can we backup an already…

0

How to troubleshoot slow performance after moving to azure due to network latency

I’ve heard some customer complain database performance is degraded after moving from on-premise server to azure and they suspect it is network latency. Here are some advice to troubleshoot this scenario. First of all, we want to ensure the update statistics with fullscan is done anyway and the query plan used in on-premise and Azure…

0

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…