Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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...
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...
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,...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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....
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
Date: 07/05/2016