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 #41: Using VNET with Azure SQL Database

Recently, I had multiple questions about the implementation of VNET in Azure SQL Database. In this Chapter number 17 of our Azure Support Academy, we are going to cover in Spanish and English how to configure it and how it works. Also, we are going to explain the 3 different options within Azure SQL Server Firewall…


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…