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