Lesson Learned #31: How to measure a TSQL execution time against Azure Database for MySQL

Often, our customers asked about the connection latency or execution time of a query between their servers and their Azure Database for MySQL. Trying to identify what is the time spent in each step I created this PowerShell Script called SQLMySQLConnectivityTest.ps1 that in based on SHOW PROFILE ALL results shows the time spent in different steps of the query….


Lesson Learned #30: How to measure a TSQL execution time against Azure SQL Database

Very often, our customers asked about the connection latency or execution time of a query between their servers and their Azure SQL Database. Trying to identify what is the time spent in each step I created this PowerShell Script that measures several counters like Network Server Time, Execution time, Connection Time, etc.. based on the statistics data…


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…