cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Azure Database Support Blog

  • 277Blog Articles
Options
669

Learnings from the Trenches - Azure SQL Database Best Practice Performance recommendations

Diego_N on 10-28-2020 09:04 AM
This article will guide you through a series of recommendations to improve performance on your database. In addition, it...
342

Snapshot isolation transaction fails when querying metadata

MelaniaNitu on 10-28-2020 07:37 AM
Snapshot isolation transaction failed in database '%.*ls' because the object accessed by the statement has been modified...
734

Restore a DB encrypted with a TDE key into a server/instance having a different encryption key

Thamires_Lemes on 10-23-2020 09:55 AM
Steps on how to restore of a database encrypted with a Transparent Data Encryption (TDE) customer-managed key into a ser...
820

Azure SQL Database Auditing not writing to Storage Account behind firewall

Thamires_Lemes on 10-23-2020 09:29 AM
Mitigation steps for when the Azure SQL Database Auditing is not writing to a Storage Account behind firewall.
1,134

Lesson Learned #141: The target principal name is incorrect connecting to Azure SQL Database.

Jose_Manuel_Jurado on 10-21-2020 04:26 PM
Today, I worked on an interesting service request where our customer tried to connect using the FQDN of their private li...
1,091

Lesson Learned #140: Is it possible to connect from Azure SQL DB to Synapse using External Tables?

Jose_Manuel_Jurado on 10-21-2020 03:50 PM
Today, I got a very good question from a customer that they want to connect using Azure SQL DB to several tables of Azur...
1,185

SSMA dropping connection

MelaniaNitu on 10-20-2020 01:28 AM
Migration of MySQL database to Azure Database using SQL Server Migration Assistant (SSMA) repeatedly dropping connection...
1,425

SSIS package fails with 'Communication link failure'

MelaniaNitu on 10-20-2020 01:28 AM
SSIS failure when loading data to Azure SQL Database
1,195

Logins in secondary server not mapped correctly from primary server

MelaniaNitu on 10-20-2020 01:28 AM
After server failover user cannot login to the database: "The server principal '' is not able to access the database '' ...
623

How to query Azure SQL Metrics using Powershell

FonsecaSergio on 10-08-2020 06:48 AM
One way you can quickly search and query metrics data is using Azure Portal, where you have chart data. But maybe you wa...
621

Lesson Learned #138: Transferring data between two tables is taking too much resources

Jose_Manuel_Jurado on 09-30-2020 05:22 PM
Today, I worked on a service request that our customer has an internal process that every night they transferred data fr...
565

Lesson Learned #139: Operating system error code 80(The file exists.) running a bulk insert

Jose_Manuel_Jurado on 09-30-2020 03:56 PM
Today, I worked on a service request when our customer wants to have an error file in case that any issue may happen run...
677

How to Change collation for production Azure SQL databases

Mousa_Janini on 09-29-2020 04:24 AM
Azure SQL Database only supports changing collation by modifying the model.xml file for .bacpac files. Schedule a mainte...
633

Lesson Learned #137: Running SQLPackage .NET Core

Jose_Manuel_Jurado on 09-11-2020 11:57 AM
This last week, I found an interesting issue. Our customer exported a database to bacpac file using SQLPackage .NET Core...
715

Lesson Learned #136: Deadlock inserting data with multiple threads running at the same time

Jose_Manuel_Jurado on 09-11-2020 11:36 AM
This week I worked on a very interesting service request about a deadlock issue when our customer is running 32 threads ...
974

Lesson Learned #135: Row Level Security based on Is_RoleMember

Jose_Manuel_Jurado on 09-11-2020 07:11 AM
Today, I worked on a service request that our customer needs to avoid that some users could retrieve some rows depending...
738

Lesson Learned #134: Row Level Security and Session Context

Jose_Manuel_Jurado on 09-11-2020 02:54 AM
Today, I worked on a service request that our customer needs to avoid that some users could retrieve some rows but depen...
891

Lesson Learned #133: Running Bulk Insert command using Managed Identity credential.

Jose_Manuel_Jurado on 09-10-2020 04:46 PM
Today, I worked on a service request that our customer needs to know how to run a bulk insert for reading CSV file using...
1,441

Query Design performance issues #02 - Column-side conversions and Function usage in WHERE

FonsecaSergio on 08-06-2020 04:28 AM
When designing queries and filters (WHERE) sometimes we need to convert some data before filtering, and depending on wha...
2,899

Query Design performance issues #01 - All-in-one query

FonsecaSergio on 08-04-2020 04:15 AM
When looking into performance issues on support cases there is one pattern called ALL-IN-ONE QUERY that we always sees t...
981

Collation conflict when moving Azure SQL DB to SQL server on-premises or Azure VM using SQLPackage.

Mousa_Janini on 07-27-2020 06:52 AM
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_100_CI_AS_KS_WS_SC" whe...
1,334

Lesson Learned #132: Delays connecting to Azure SQL Database from SQL Server Management Studio.

Jose_Manuel_Jurado on 07-01-2020 11:46 AM
Today, I worked on a service request that our customer reported some delays when they are connecting to Azure SQL Databa...
838

Lesson Learned #131: ReadScale Out and Failover Group

Jose_Manuel_Jurado on 06-22-2020 06:55 AM
Today, I worked on a service request that our customer wants to use the parameter of ApplicationIntent=ReadyOnly to conn...

Latest Comments

burhan6341
in Azure SQL Database Auditing not writing to Storage Account behind firewall on 10-27-2020
So, when the logs are not written how do we get alerts? where is the alert coming from and what metric is triggering this alert?
0 Likes
Yochanan_MSFT
in Automating Azure SQL DB index and statistics maintenance using Azure Automation on 10-22-2020
Hi @Myat_Thet , yes, you can wrap the execution in a loop that go trough each database. you need to make sure the procedure created in each database as we have no cross-database query ability for Azure SQL DB. however, I would suggest you to use Elastic Jobs instead, there you can target the databas...
0 Likes
Myat_Thet
in Automating Azure SQL DB index and statistics maintenance using Azure Automation on 10-22-2020
Hi @Yochanan_MSFT Your article is very helpful and thanks for providing very detail information.Is it also possible to loop all databases in the given SQL Server instead of passing specific database name as below? $AzureSQLServerName = "<ServerName>"$AzureSQLDatabaseName = "<DatabaseName>" This is b...
0 Likes
Johannes_Vink
in Lesson Learned #140: Is it possible to connect from Azure SQL DB to Synapse using External Tables? on 10-21-2020
The other way around would be interesting too ;) Let Azure Synapse SQL-on-demand query Azure SQL DB. So that we can enhance the flat files on blob via SQL-on-demand with some lookup tables stored in Azure SQL DB.
1 Likes
FonsecaSergio
in Azure SQL DB Private Link / Private Endpoint - Connectivity Troubleshooting on 10-20-2020
@KMS2222 you may need to open a case to further investigate this issue
0 Likes