Azure SQL EMEA Engineers
Posts are provided by the Azure SQL Support Engineers team in EMEA
Lesson Learned #26: How to change the definition of table triggers at the same time
Today, we have been working a very interesting case, when our customer is migrating their database...
Author: Jose M Jurado - MSFT Date: 04/10/2017
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...
Author: Beatriz Garcia Roces Date: 04/06/2017
Lesson Learned #25: Export/Import Azure SQL Database using Azure File Service?
In some situations, we need to import or export our Azure SQL Database using SQLPackage, but,...
Author: Jose M Jurado - MSFT Date: 04/03/2017
Exported database from Azure SQL failed to be imported to Azure SQL or to local SQL Server
Symptoms: When using blob auditing on Azure SQL Server or Database, after you export database to...
Author: Yochanan Rachamim - MSFT Date: 03/30/2017
Lesson Learned #24: How to read or import Azure SQL Auditing Blob file?
As probably, you know we have two different types for Azure SQL Auditing : Table or Blob. For table...
Author: Jose M Jurado - MSFT Date: 03/21/2017
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...
Author: Vitor Faria Tomaz Date: 03/14/2017
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...
Author: Jose M Jurado - MSFT Date: 03/10/2017
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...
Author: Mohamed Baioumy - MSFT Date: 02/07/2017
Lesson Learned #21: There is not enough space on the disk exporting BacPac using SSMS
Depending on the size of your database when you export/import the data to/from a bacpac using SQL...
Author: Jose M Jurado - MSFT Date: 02/02/2017
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...
Author: Yochanan Rachamim - MSFT Date: 01/31/2017
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...
Author: Jose M Jurado - MSFT Date: 01/26/2017
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...
Author: Yochanan Rachamim - MSFT Date: 01/25/2017
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...
Author: Jose M Jurado - MSFT Date: 01/21/2017
Lesson Learned #18: Database cannot be downgraded to a lower database tier.
Hello again, I worked on another very interesting service request when our customer received the...
Author: Jose M Jurado - MSFT Date: 01/20/2017
Lesson Learned #17: Should I cancel or kill a session running a huge transaction?
Hello Everyone, We are receiving multiple service requests where our customers cancelled or kill...
Author: Jose M Jurado - MSFT Date: 01/20/2017
Lesson Learned #16: How to change the default language of Azure SQL Database
Hello Everyone, We got several questions how is possible to change the default language using server...
Author: Jose M Jurado - MSFT Date: 01/13/2017
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...
Author: Jose M Jurado - MSFT Date: 01/12/2017
ARM Template to deploy server with Auditing and Threat Detection turned ON
I would like to share an example of a template that can be used to deploy server with multiple...
Author: Olga Guzheva Date: 01/11/2017
ARM template - turning on blob auditing
Azure SQL Database Auditing is a popular feature which helps to track events on the databases....
Author: Orsolya Gal - MSFT Date: 01/11/2017
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...
Author: Raghda_Aldeen Date: 01/09/2017
Lesson Learned #14: Is it possible to upload a SQL server backup to an Azure database
Hello Everyone, We received a multiple times the question about if is it possible to upload a SQL...
Author: Jose M Jurado - MSFT Date: 01/09/2017
Sample: Joining tables from different Azure SQL Databases
Abstract: The Elastic Database Query feature allows you to perform cross-database queries to access...
Author: Holger Linke (Microsoft) Date: 01/05/2017
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...
Author: Jose M Jurado - MSFT Date: 12/30/2016
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...
Author: Jose M Jurado - MSFT Date: 12/30/2016
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...
Author: Jose M Jurado - MSFT Date: 12/30/2016
Fix identities after migrating through SQL Replica
One of the most common migration procedures to SQL Azure is by configuring replication from your...
Author: Raquel Vicente de la Rosa- Microsoft Support Date: 12/30/2016
Lesson Learned #10: Monitoring TempDB usage
We are receiving several support cases when our customers are getting the following error message...
Author: Jose M Jurado - MSFT Date: 12/28/2016
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...
Author: Jose M Jurado - MSFT Date: 12/28/2016
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...
Author: Holger Linke (Microsoft) Date: 12/15/2016
Azure Support Academy (Spanish): SQL Server, Next Station Azure
Welcome to our session delivered in 24Hours Pass Virtual Chapter - Global Spanish, covering the main...
Author: Jose M Jurado - MSFT Date: 12/13/2016
ARM template outputs for Azure SQL Database
Azure Resource Manager (ARM) templates are a common way to deploy Azure Resources. One of the less...
Author: Orsolya Gal - MSFT Date: 12/01/2016
Azure Support Academy: How to troubleshoot connectivity issues in Azure SQL DB - Part 1
Hello everyone! Just a couple of weeks ago, we recorded our first video of 10 minutes of...
Author: Jose M Jurado - MSFT Date: 11/29/2016
Elastic Database Jobs: Sample for Running T-SQL Code in Multiple Databases
Introduction: After moving from on-premise SQL Server to Azure SQL Database, the SQL Server Agent...
Author: Holger Linke (Microsoft) Date: 11/04/2016
Lesson Learned #8: Monitoring the geo-replicated databases.
We received multiple requests in order to have answered the following questions: Is there needed a...
Author: Jose M Jurado - MSFT Date: 10/31/2016
Lesson Learned #7: Monitoring the transaction log space of my database
In many support cases, our customers want to monitor the available space for the transaction log...
Author: Jose M Jurado - MSFT Date: 10/31/2016
Lesson Learned #6: Working with HAS_PERMS_BY_NAME function and Database Name with dots
There is very common that the name of the database could contains a dot in its name. In this...
Author: Jose M Jurado - MSFT Date: 10/27/2016
No Azure SQL V2 (or as called sometimes V11) anymore
I just want to share quick update that Azure SQL DB V2 cannot be created anymore After long time V2...
Author: Yochanan Rachamim - MSFT Date: 10/25/2016
Create SQL Login and SQL User on your Azure SQL DB
There are multiple options to authenticate with your Azure SQL, in this post I want to discuss only...
Author: Yochanan Rachamim - MSFT Date: 10/05/2016
Azure SQL DB MAXSIZE - what can I do with that?
Information: Azure SQL DB max size is limited by the pricing tier for each DB. for instance Basic...
Author: Yochanan Rachamim - MSFT Date: 09/27/2016
Azure SQL DW - column name is case sensitive with hash distribution
Symptoms: When using PolyBase bulk operation to load data into Azure SQL DW (Data Warehouse) and...
Author: Yochanan Rachamim - MSFT Date: 09/13/2016
Does Azure SQL DB support automatic indexed views?
Are indexed views used automatically in SQL Azure without "WITH (NOEXPAND)"?How does it work?and How...
Author: Raghda_Aldeen Date: 09/04/2016
Unexpected Select queries seen in the Performance Overview of the Azure Portal
Scenario: During a time of low database activity, you may see an unexpected spike of DTU consumption...
Author: Holger Linke (Microsoft) Date: 08/19/2016
Timeout and ADALGetAccessToken Error with AAD connections
Scenario: You have created an Azure SQL Database through the Azure Portal. After opening the...
Author: Holger Linke (Microsoft) Date: 08/17/2016
How big is my Azure SQL database?
First Let me explain how the portal calculating the database size Assuming you have S3 database you...
Author: Yochanan Rachamim - MSFT Date: 08/04/2016
Lesson Learned #5: Deploy SQL DB V12 from ARM templates
When you deploy SQL Database servers using Azure Resource Manager (ARM) templates , if you don’t...
Author: Vitor Faria Tomaz Date: 07/28/2016
Lesson Learned #4: Modifying the default time zone for your local time zone.
Currently, the default time zone on Azure SQL DB is UTC. Unfortunately, there is not possible to...
Author: Jose M Jurado - MSFT Date: 07/27/2016
Lesson Learned #3: Modifying the fulltext stopword list in Azure SQL Database.
Hello everyone This morning I was working in a new very interesting situation is using fulltext, as...
Author: Jose M Jurado - MSFT Date: 07/27/2016
The easy way to manage SQL Logins and users in Azure SQL DB
This time I want to share with all of you one very nice tool from CodePlex - Microsoft's open source...
Author: Yochanan Rachamim - MSFT Date: 07/18/2016
Lesson Learned #2: Do you need SQL Server Agent for Azure SQL DB?
Many questions came to us, about SQL Server Agent for Azure SQL DB. Unfortunately, we don’t have the...
Author: Jose M Jurado - MSFT Date: 07/05/2016