Lesson Learned #70: Is ASP Classic able to connect to Azure SQL Database using Azure Active Directory?

Hello, Today, I worked on a service request that our customer has an application developed in ASP Classic and they want to use Azure Active Directory using the validation of User/Password, it is not possible. Initially, Azure Active Directory is possible to use .NET 4.6 based on this URL . I suggested to use the ODBC v.13…


Lesson Learned #69: Azure SQL Database – How are the statistics updated automatically by SQL engine

Hello, Today I worked on a service request that our customer needs to know how the statistics are automatically updated by SQL Engine and what is the impact of this process in terms of consumption resources and distribution of the statistics. STEP 1 – Created the table and statistics. I have created an example table with…


How to Migrate Azure SQL Database to Azure SQL Managed Instance

The latest version of SQLPackage supports migration to Azure SQL Managed Instance (MI) from multiple SQL sources such as Azure SQL Database. Export: Following the below steps, you can export a SQL database using the SQLPackage command-line utility. If possible, use a workstation that has access to the Azure SQL Database and the MI to avoid having…


Lesson Learned #68: Azure Database – SQL Connectivity Checker

Hello, Yesterday, I worked in a support case that our customer needs to review the connection and if possible the execution time spent for Azure Database for PostgreSQL using PGBouncer and not. I developed and upload a new option in our AzureSQLConnectivityChecker for PostgreSQL in our GitHub project, in order to review this connection time spent for…


Lesson Learned #67: Azure SQL Database – SSH, VNET and Firewall

Hello, Today I worked in a service request when our customer tries to connect using SSH to the 1433 port from a Linux environment using a JumpBox in Azure to perform the connection. In this situation, we need to know that in Azure, depending on where is the connection coming, the Gateway that Azure SQL Database has…


Lesson Learned #66: Azure Active Directory – Universal with MFA authentication – Output Window Trace Level

Hello Team, I worked on a service request where our customer faced a connectivity issue using Active Directory- Universal with MFA authentication. After our basic troubleshooting we’re used to suggest taking a network and https traces in order to review the communication between the Application, Azure Active Directory and  Database server. I found a very useful option in SQL Server Management Studio that…


Lesson Learned #65: Azure SQL Database – Using Read Scale Out option

Today, I worked on a service request when our customer is using the option to Scale Out to connect to the secondary replicas without creating Geo-Replication. Right now, in Premium and vCore database Tier we have the option to connect to the secondary replicas that we have for our database in read only mode. See this…


Lesson Learned #64: Azure SQL Database – ‘The type ‘xml’ is not supported with external tables for sharded data.’

Hello, I worked on a case that our customer tried to use an external table to retrieve data and they got the error: ‘The type ‘xml’ is not supported with external tables for sharded data.’ They followed the steps provided on our previous article . The error message is expected because as we could see in this…


Lesson Learned #63: It is possible to create Linked Server in Azure SQL Managed Instance?

The answer is Yes!!! and to create it you only need to follow up the instructions provided in this URL   Unfortunately, nowadays, you only are able to use the SQL provider to connect to Azure SQL Database, SQL Server or Azure SQL Managed Instance. My lessons learned in this situation is you need to pay attention For Azure SQL Database: Please review…