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…


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…


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…


Lesson Learned #13: SQL Server instance in use does not support column encryption

Today, I worked in a support case that our customer is using the following components: Always Encrypted, Azure Key Vault Microsoft JDBC 6.1. When they connect to local application to their Azure SQL Database, everything works fine. After their code is deployed to Azure App Service they got the error: com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server instance in use does not…


Azure Support Academy (Spanish): SQL Server, Next Station Azure

Welcome to our session delivered in 24Hours Pass Virtual Chapter – Global Spanish, covering the main aspects to start or migrate from an OnPremise model  to one of the two architectures available in SQL Server on Azure, providing the keys to select the more suitable environment  for our requirements. Watch:  SQL Server, Next Station Azure We covered: Red…