Lesson Learned #19: How to obtain the deadlocks of your Azure SQL Database?

In Azure SQL Database we have already running an Extended Event that captures the deadlocks without any additionally action for customer side. In this post we are going to learn how to obtain the deadlocks, how to obtain the deadlock graphic and how to reproduce a deadlock for testing.   How to obtain the deadlocks  …


Lesson Learned #18: Database cannot be downgraded to a lower database tier.

Hello again, I worked on another very interesting service request when our customer received the message: “MODIFY FILE failed. Size is greater than MAXSIZE. Please query sys.database_files and use DBCC SHRINKFILE to reduce the file size first” trying to scale down the Azure database tier. This message happens when the database file size is greater…


Lesson Learned #17: Should I cancel or kill a session running a huge transaction?

Hello Everyone,   We are receiving multiple service requests where our customers cancelled or kill a session that was running a huge transaction (delete/insert/update). After this cancelation, they were waiting for the same time that the huge transaction took to be able to do any action with the tables involved in this transaction. This situation is normal in any SQL Server edition,…


Lesson Learned #16: How to change the default language of Azure SQL Database

Hello Everyone, We got several questions how is possible to change the default language using server level ( trough sp_configure ) or login definition.   Option 1: Change the default language using ‘sp_configure’  Unfortunately, there is not possible to configure a server level the default language , if you try to change it running EXEC sp_configure ‘default…


Lesson Learned #15: Securing our Azure SQL Datawarehouse

Hello Everyone, Nowdays, the security is a key element for all databases, for this reason, in Azure SQL we have several options depending on our needs. In this picture you could see the different available options that we have right now. In this post, I would like to share some points about two important topics…


ARM Template to deploy server with Auditing and Threat Detection turned ON

I would like to share an example of a template that can be used to deploy server with multiple databases and to turn ON Auditing and Threat Detection at server and individual database levels. A few guidelines: Auditing server policy can be set after creation of all databases, so you should add dependency on all databases to…

0

ARM template – turning on blob auditing

Azure SQL Database Auditing is a popular feature which helps to track events on the databases. Recently Blob Auditing was introduced, at the time of writing this post it is still a preview feature.The advantages of blob auditing over table auditing are higher performance and higher granularity. To turn on blob auditing you can use…


Accessing Azure SQL DB from Azure VM using a static Public IP adress

As it’s known Azure SQL DB relies on the FQDN of the server the database is on for resolution. So how can we access Azure SQL DB from an Azure VM using a Public IP and make sure that it remains the same?further how we can disallow arbitrary machines from within the Windows Azure environment…

0

Sample: Joining tables from different Azure SQL Databases

Abstract: The Elastic Database Query feature allows you to perform cross-database queries to access remote tables. It is a great feature if you plan to send straight-forward queries with well-defined Where clauses to the remote database. But as soon as you need to join a remote table with a local table, you are in for…