Lesson Learned #41: Using VNET with Azure SQL Database

Recently, I had multiple questions about the implementation of VNET in Azure SQL Database. In this Chapter number 17 of our Azure Support Academy, we are going to cover in Spanish and English how to configure it and how it works. Also, we are going to explain the 3 different options within Azure SQL Server Firewall…


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

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…


Fix identities after migrating through SQL Replica

One of the most common migration procedures to SQL Azure is by configuring replication from your previous environment to your brand new SQL DB: https://msdn.microsoft.com/en-US/library/mt589530.aspx   This is a very nice migration process, as it allows original database to be available in Production until very few moments before SQL Database goes live. However, if your…

0

Lesson Learned #10: Monitoring TempDB usage

We are receiving several support cases when our customers are getting the following error message “The database ‘TEMPDB’ has reached its size quota. Partition or delete data, drop indexes, or consult the documentation for possible resolutions.” and their query ends with an exception. As any SQL Server instance every Azure SQL Database Tier has a…