Lesson Learned #38: Which is the impact using connection pooling in my application

In this video in Spanish and English we are going to show you an example about which is the impact to use or not connection pooling, using a C# application. As probably you know connection pooling is a special connection cached, that is enabled by default using ADO .NET  with a maximum capacity, by default, of 100 concurrent connections. Using…


Lesson Learned #37: How to use distributed transactions in Azure SQL Database

Currently, there is not possible to update two tables of different databases using a single transaction in Azure SQL Database in the same way that we have in SQL Server If you need to implement in your code a distributed transactions, your application will the coordinator of this distributed transaction using the transaction scope method using .NET….


Lesson Learned #36: Best Practices connecting and executing queries using Azure SQL Database

Very often, we received requests about what are the best practices stablishing the connection or executing queries using Azure SQL Database. In these two videos in Spanish and English we are going to cover these best practices: How the connection work inside / outside of Azure environment. Main configuration points in our client server. How to…


Export Azure SQL Database to local path

We noticed a few requests come to our support queue asking for a feasibility to export Azure SQL Database to local path directly, so following steps below to build  PowerShell script that can do that job to copy Azure SQL Database to another db for consistency, then export Azure SQL Database to blob storage, later…


Lesson Learned #34: Does Azure SQL Database support OPENJSON?

The answer is Yes! but your database needs to have in the compatibility level 130 or above. If your database compatibility level is less than 130 you could get an error about “incorrect syntax near the keywork with” or “invalid syntax”.   Please, follow these steps to read a JSON file from a Azure Blob…


Stop / Cancel ongoing Azure SQL DB scale operation

Scenario: if you want to cancel updating database pricing tier. this can be due to mistake, or long running scale operation. Resolution: open Azure cloud shell or use your local Azure CLI installation. edit the following command with your database details and execute the script review the output to confirm operation has been canceled.


Extended Events Capture Step by Step Walkthrough

Extended Events Step By Step Introduction I’ve read a few articles about using Extended Events (aka xEvents) to perform troubleshooting, and they do indeed provide a very powerful tool to troubleshoot. This is particularly true in Azure DB where in many cases we don’t have many alternatives, there is no Profiler (or as we’d prefer…