Lesson Learned #5: Deploy SQL DB V12 from ARM templates

When you deploy SQL Database servers using Azure Resource Manager (ARM) templates , if you don’t specify any version, servers will be created on V11 instead of V12. SQL Database V12 has a long list of features beyond those of V11 and we will continue to add new features only to V12. You can check…


Lesson Learned #4: Modifying the default time zone for your local time zone.

Currently, the default time zone on Azure SQL DB is UTC. Unfortunately, there is not possible to change by server configuration or database configuration. All Azure services use UTC time zone settings, regardless of their physical location. This also applies for SQL Azure, so if you need a custom time zone you’ll have to manage that in…


Lesson Learned #3: Modifying the fulltext stopword list in Azure SQL Database.

Hello everyone This morning I was working in a new very interesting situation is using fulltext, as you, probably know, Azure SQL Database V12 is possible to use fulltext with partial implementation, until today. In this situation, we are not able to obtain any row running the following query SELECT [Key] as OrgId, [Rank] as Score FROM CONTAINSTABLE(Company, Name,…


Lesson Learned #2: Do you need SQL Server Agent for Azure SQL DB?

Many questions came to us, about SQL Server Agent for Azure SQL DB. Unfortunately, we don’t have the SQL Agent service in the same way that you have in OnPremise, but we have a multiple solutions for it: If you are able to maintain the SQL Agent, you could create a linked server against to…


Lesson Learned #1: Capturing a TSQL Command Timeout

In many support cases that we worked our customer needs to know that is the query that caused a Command Timeout issue. In this example below, you could find out the extended event that we share to our customers in order to capture it.   CREATE EVENT SESSION ssEventoTimeout ON DATABASE ADD EVENT sqlserver.sql_batch_completed ( ACTION …


How to move Azure SQL server to another subscription

This post is about what we DO NOT want you to do and how to do it right. if you want to move Azure SQL server from one subscription to another do not delete it assuming you will be able to create the server in the other subscription. this will not work for you (read why…


Server name has already been used after you deleted it

Symptoms: after you delete Azure SQL server, you are trying to create the same server name in a different subscription you own the server creation process failed with error 60080 – Server name has already been used Cause: This happen because we keep the server name for couple of days in case the original subscription still…


How to maintain Azure SQL Indexes and Statistics

There are a lot of work that Azure SQL saves from you, and most of the users we meet seems to believe that maintain the database indexes and statistics is one the missions you can forget when you migrate to Azure SQL. Statistics objects, like in the box version of SQL have by default “Auto update”…