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…


Lesson Learned #12: What types of temporary tables can I use in Azure SQL Datawarehouse?

In SQL Datawarehouse we are able just to create tables with #, so, that means that this temporal table will be available during the session that create this table. Other calls, for example, ## ( Global Temporal Tables ) or tempdb..name will return an syntax error like this one. URL: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-temporary CREATE TABLE tempdb..Temporal([OrderArticleId] [int]…


Lesson Learned #11: Connect from Azure SQL DB using an external table where the source of the data is a SQL Datawarehouse

One of our customer tries to connect from Azure SQL DB using an external table where the source of the data is a SQL Datawarehouse database. This first question was if there is supported or not and I received the confirmation from Azure Product Team that there is not supported and they are working on…


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…


Lesson Learned #9: sp_execute_fanout was deprecated and replaced by sp_execute_remote

Within Cross-Database Queries we have the option to run a procedure using parameters using sp_execute_fanout. This execution could be a Transact-SQL statement on a single remote Azure SQL Database or set of databases serving as shards in a horizontal partitioning scheme. From time ago, if you try to execute sp_execute_fanout you will have an error that this…


BACPAC Export failing with Unable to reconnect – Timeout expired

I had a support case recently where the export of a SQL Server database into a BACPAC file was failing. The first attempt was done through SQL Server Management Studio 2016, by right-clicking the database -> Tasks -> Export Data-Tier Application. Another attempt using the sqlpackage.exe command-line tool showed the identical results though. The following operations…


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…


ARM template outputs for Azure SQL Database

Azure Resource Manager (ARM) templates are a common way to deploy Azure Resources. One of the less often used features is the output. You may want to use this with linked templates to pass variables between templates, or if you like to print out some information. Here I describe how you can display Azure SQL…