Lesson Learned #83: How to create my own SQL Auditing file in Azure SQL

Hello Team, Today, I worked in a new service request that our customer besides that they are using my previous article about Monitoring Login-Logout events in Azure SQL Database using Extended Events they requested to add all the TSQLs executed, so, I added more events for taking these TSQL executions. Enjoy!


Lesson Learned #82: Azure SQL Database Managed Instance supports only COPY_ONLY restoring a database backup

Hello Team, I would like to share an error message that we found restoring a backup database in Azure SQL Managed Instance. Our customer tried to restore the backup file using SQL Server Management Studio GUI from an existing database to another database. So, our customer has in their Azure SQL Managed Instance a database…


Lesson Learned #81: How to create a linked server from Azure SQL Managed Instance to SQL Server OnPremise or Azure VM

Hello Team, Today, I worked on a service request where our customer requested information how to create a linked server from Azure SQL Managed Instance to SQL Server OnPremise. In this post, I would like to share with you my lessons learned on it: The first point, we need that our Azure SQL Managed Instance…


Lesson Learned #80: Monitoring Login-Logout events in Azure SQL Database using Extended Events

Hello Team, Today, I created an extended event for monitoring the Login and Logout events for a Azure SQL Database. I did it, because I missed the logout in SQL Auditing Log.   1.- Please, try to add this credential is your database. If you need instrucctions please review this URL.     2.- Add this extended event in…


Lesson Learned #78: DataSync – Cannot enumerate changes at the RelationalSyncProvider for table ‘customertable’ – Execution Timeout Expired

Hello Team, Yesterday, I worked in a service request with a lot of lessons learned when our customer was using Azure SQL Data Sync to synchronize around 15 million of rows. In every process that they tried to synchronize the data they got the following error message: Sync failed with the exception ‘Cannot enumerate changes at the…


Lesson Learned #79: Connecting to Azure SQL Database just using the port 1433 without redirection

Hello Team, Today I worked with a customer that were not able to connect to their Azure SQL Database from their Azure environment. They have protected their environment using different appliances and just having the port 1433 for outbound connections. We found that using Microsoft OLE DB Provider for SQL Server our customer is able to connect but using SQL Server Native…


Lesson Learned #77: Importing data from bacpac using bcp command utility

Hello Team, Today, I worked on a case that our customer needs to load some data from a bacpac to an Azure SQL Database, for different and urgent situations was not possible to export and create again this bacpac. Our customer needs only import some tables and I suggested to perform the following task to import them….


Lesson Learned #75: The importance of having the connection pooling parameter enabled in your connection string using PHP

Hello, As you know, all connections that are made to Azure SQL Database is using the Gateway before reaching the database, for this reason, nowadays, it is very important to have enable in your code the option of connection pooling. Previously, we mentioned it, in our YouTube channel about connection pooling impact using C# in these URLs: English and Spanish  Using open source code…


Lesson Learned #74: The importance of having the Application Name parameter configured in your connection string

Hello Team, Many, many times, we saw service requests that our customers need to identify who runs a specific query but, even after enabling the SQL Auditing feature, in Azure SQL Database they are not able to identify who/which is the application that did it. Why? because they didn’t specify an application name in the…