BACPAC Export failing with Unable to reconnect – Timeout expired

I had a support case recently where the export of a SQL Server database into a BACPAC file was failing. The first attempt was done through SQL Server Management Studio 2016, by right-clicking the database -> Tasks -> Export Data-Tier Application. Another attempt using the sqlpackage.exe command-line tool showed the identical results though. The following operations…


Unexpected Select queries seen in the Performance Overview of the Azure Portal

Scenario: During a time of low database activity, you may see an unexpected spike of DTU consumption in the performance graphs on the Azure Portal. Drilling into it through the Performance Overview and Query Performance Insight feature, you identify some queries which you do not recognize. The overall DTU consumption for them is rather low…