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…


Lesson Learned #42: Creating an alias for my Azure SQL Database Server

Today, I’ve been working on a service request very interesting. If you need to create an alias for your Azure SQL Server, you have the PowerShell cmdlet called: New-AzureRmSqlServerDnsAlias. The syntax to use is: Login-AzureRmAccount [string]$SubscriptionId = “xxxxxxxxxxxxxxxxxxxxx” $azureCtx = Set-AzureRMConteXt -SubscriptionId $SubscriptionId New-AzureRmSqlServerDnsAlias -ResourceGroupname ‘Resource group’ -ServerName myserver1 -DnsAliasName myserver12   Remember that there is…


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…