Lesson Learned #22: How to identify blocking issues?

Today, we were working on a service request where our customer reported that, some TRUNCATE executions are taking more time that they expected. Normally, these TRUNCATE commands just only take 3 or 5 seconds to complete, however, this time, the problem is that they never finish. Using the following TSQL command: select conn.session_id as blockerSession,conn2.session_id as…


Automate Export Azure SQL DB to blob storage use Automation account

I had a support case recently question how to automate Export Azure SQL DB to a storage account (Blob container) to .bacpac files. The first attempt was made to configure a PowerShell Script to Export Azure SQL DB to blob container and to .bacpac format from here . this was successfully completed but on demand, the coming…


Using SQLPackage to import or export Azure SQL DB

Purpose: Explain how to easily and quickly use SQLPackage to import or export your Azure SQL Database. Locating the SQLPackage.exe: The SQLPackage.exe is part of the DacFramework which installed with SSMS or with SQL Server Data Tools Or you can download only the DacFramework if you do not have already the management tools Once the…


Lesson Learned #20: What happen with my connection inside Azure when SQL Auditing is enabled?

Hello Everyone, Here we are with another lesson learned. At this time, I would like to show you what happen with my connection to my Azure SQL Database inside Azure when I have SQL Auditing enabled. The first thing that we need to read is the documentation placed here: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-develop-direct-route-ports-adonet-v12, when we have all information about the…


Connect to your Azure SQL DB behind MsAccess web application

Background: When you create new Custom web application from Ms Access on your Office 365 SharePoint your application will be hosted on Microsoft Cloud. Sometimes you can have more value if you can gain direct access you your Azure SQL DB database. This article explain how to configure and resolve connection problems to the back-end…


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…