Lesson Learned #40: Could it be possible to use Intellisense with an Azure Active Directory user in SQL Server Management Studio?

The answer is Yes! but we need to do some additional steps in our environment.   If you are the SQL Login administrator or Azure Active Directory administrator user you will have the list of the objects using Intellisense, but, what happens if I’m connecting with non-adminstrator Azure Active Directory user. Let me show you…


Lesson Learned #39: Best Practices using BCP in Azure SQL Database

In multiple support cases our customers asked questions about what are the best practices to avoid fill up the transaction log or temporal database when they are importing a high number of rows using BCP. In this new video in Spanish and English you could find these best practices, also, how to check the compatibility…


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…