Connect from Power BI to Azure SQL Database using AAD authentication

Currently Power BI doesn’t support AAD authentication when connecting to Azure SQL Database, but using Microsoft ODBC Driver 13 it is possible to do it. You can download the driver from here (ODBC Driver 13.1) and install it. After installing the driver, you can connect to the Azure SQL using ODBC connector. Select ODBC and…


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…


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…


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…


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…


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…