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

Lesson Learned #22: How to identify blocking issues?

Today, we were working on a service request where our customer reported that, some TRUNCATE...

Author: Jose M Jurado - MSFT Date: 02/21/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

Next>