Quickly test connectivity from Azure Website to SQL DB

In case you have an Azure Website and you need to confirm that your website can reach SQL Database service here is a quick and simple way to test it: 1) navigate to Kudu (it can be accessed at https://{yourwebsitename}.scm.azurewebsites.net ) (Kudu is the engine behind git/hg deployments, WebJobs, and various other features in Azure…


Lesson Learned #23: How to add AAD Security Groups to Azure SQL Database?

In these days, we are receiving multiples cases where our customer needs to add Azure SQL Database groups from Azure Active Directory. This is an example to how to archive it. Using the Portal in Azure: I created a user called SQLMember. I created a group called SQLGroup, adding the member SQLMember.   Using SQL…


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  …