Extended Events: Azure Storage Account Types Matter

I recently had a client approach me on an error that they persistently encountered when attempting to start an extended event session in the Azure SQL Database service.  The SqlException error message consisted of the following:   Msg 25602, Level 16, State 1, Line 178 The target, “0DCF1903-7977-40A7-B7A8-339AA9D8D7F0.package0.event_file”, encountered a configuration error during initialization. Object…


How to create a native PowerShell app registration to connect to Azure SQL DB

How to create a native app registration This guide assumes that you already own an Azure Subscription, an Azure Active Directory properly setup and your PowerShell environment properly set for running scripts.  You might want to refer to this article first: https://blogs.msdn.microsoft.com/azuresqldbsupport/2018/10/26/azure-sql-database-token-base-authentication-with-powershell/ Problem summary:  There might be a time when we you will want to…


Database Copy may cause Azure SQL Database to run out of transaction log space

Summary: This article describes how a Copy Database operation may cause the source database to run out of transaction log space. The client applications may then encountered the error 9002: “The transaction log for database ‘xxxxx’ is full due to ‘AVAILABILITY_REPLICA'”. This description is derived from an actual support case.   Scenario: Each day between…


Tips & Tricks : What you need to do to create SQL Login to authenticate to Azure SQL DBs members in Auto-Failover Group

Sometimes we found it is tricky to setup SQL Login account other than default built-in SQL Admin and using them to allow SQL application access to login to Azure Server and Databases members in Auto-Failover Group! First I would like to briefly summarize Auto-Failover Group feature introduced to Azure SQL DB as a part of…


Lesson Learned #49: Does Azure SQL Database support Azure Active Directory connections using Service Principals?

The answer is Yes!. Just finishing a service request following the instructions placed on this URL  but with a limitation: Service Principal of the Managed Service Identity is not currently supported.  It is supported if you register an application in Azure portal > Azure Active Directory > Application registration.   Just to mention that there it not…


Lesson Learned #47: Do you have connectivity issues to Azure SQL DB from your PC?

Often, we are working on with service requests that our customers are facing connectivity problem to Azure SQL Database from their office or from home. Time ago, my colleague Raghda and I, recorded this video, that you could watch in our YouTube channel to verify the main issues that may prevent a successful connection to Azure SQL…


Lesson Learned #45: CPU at 100% using nvarchar parameter data type in the filter against varchar column data type.

These last days, I have been working in several service requests with same behavior. Customer has an application that is searching a value per execution. The parameter value that is using the stored procedure is defined a nVarchar data type. The table field is varchar data type. Every execution took few milliseconds but if you…


Lesson Learned #43: Using partitioning option for Azure SQL database

Some days ago, I have been working on advisory service request where our customer asked for partitioning option for Azure SQL database. They found the guidelines but when they tried to implement it, they got the error message: ‘filegroup’ is not supported in this version of SQL Server. Trying to answering the question, partition is supported on Azure SQL Database but…