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

  • 350 Blog Articles
Options
1,607

Azure SQL Database - GEO Replication across subscription with private endpoints

Sabrin_Alsahsah on Oct 10 2021 03:13 AM
This article describes how to set up GEO replication between two Azure SQL servers across subscriptions using private en...
589

Azure SQL Database unavailable after switching from BYOK CMK to system-managed TDE key

Holger_Linke on Oct 07 2021 08:08 AM
Recently we have received a support case where an Azure SQL Database became unavailable after switching from BYOK Custom...
893

Performance degradation due to implicit conversion

Thamires_Lemes on Sep 17 2021 07:49 AM
Implicit conversion is a common cause of performance degradation. It happens when a client/application runs a query in w...
1,080

Tagging all the Columns to Data classification in the Azure SQL DB

KeshavKiran on Sep 09 2021 02:23 PM
In Azure SQL Database Data Classification, currently for the columns which don't qualify for any of the pattern matching...
1,101

Cross database queries between Azure SQL database and Managed instance using external table

Sabrin_Alsahsah on Sep 01 2021 06:43 AM
In this article, we consider the scenario where customers would like to query data from Azure SQL managed instance to Az...
1,468

Restore database across servers(Azure SQL Database and Azure SQL managed instance)- Azure Automation

Sabrin_Alsahsah on Aug 30 2021 12:05 AM
In this article, we consider the scenario where customers would like to restore their Azure SQL database and managed dat...
1,801

Troubleshooting Azure Active Directory Integrated Authentication in Azure SQL

luisaranda on Aug 27 2021 09:39 AM
Troubleshooting Azure Active Directory Integrated authentication in Azure SQL
1,381

Database Parameterization

tarashee on Aug 22 2021 12:42 AM
On SQL Server, there is a database setting called parameterization. Parametrization has two values, Simple (the default)...
5,685

PKIX path building failed - unable to find valid certification path to requested target

MelaniaNitu on Jul 27 2021 07:33 AM
Failed to authenticate to Azure SQL using AAD - Caused by: AuthenticationException: PKIX path building failed: sun.secur...
1,215

Using extended events to capture deletion operations

Palomag_MSFT on Jul 16 2021 02:50 AM
How configure extended events to capture deletion operations
815

Lesson Learned #178: What is the command timeout when we are querying an External Table?

Jose_Manuel_Jurado on Jun 29 2021 08:57 AM
Today, I received a very good question from a customer about what is the command timeout that external tables is using. ...
1,782

Automate exporting of azure sql database as .bacpac to blog storage.

v-pekapa on Jun 22 2021 07:37 AM
In azure sql database, we know the sql server agent is not available. In order to automate the exporting of the database...
1,074

Lesson Learned #177: Is possible to use Private Endpoint with Azure SQL External Tables?

Jose_Manuel_Jurado on Jun 17 2021 11:08 AM
Today, we had a question from a customer asking if could be possible to connect to the Private Endpoint of Azure SQL DB ...
1,194

Import BACPAC fails if schema has a large number of tables, indexes and/or views

Palomag_MSFT on Jun 15 2021 02:53 PM
Import BACPAC fails if database schema is large
927

Lesson Learned #176: Using Polybase to connect from SQL OnPremises to Azure Managed Instance/SQLDB

Jose_Manuel_Jurado on Jun 15 2021 02:23 PM
Today, I got a very interesting question about if could be possible to connect from external tables to Azure SQL Managed...
1,587

Lesson Learned #175: Connecting to Private EndPoint of Azure SQL Database from Managed Instance

Jose_Manuel_Jurado on Jun 15 2021 10:20 AM
Today, I worked on a very interesting case when our customer wants to connect to the Private EndPoint/Link of Azure SQL ...
1,111

Lesson Learned #174: Using Synonyms in Azure SQL Managed Instance for Linked Server tables

Jose_Manuel_Jurado on Jun 15 2021 12:09 AM
Today, I worked on a very interesting case when our customer has a linked server to Azure SQL Database, but, they want t...
843

Managed Instance - WASDRGTenantMonitoringRO and xtsuser logins

Palomag_MSFT on Jun 11 2021 03:59 AM
Two logins are created by default for any Managed Instance: WASDRGTenantMonitoringRO and xtsuser
2,441

Tips & Tricks #1: Creating alerts for Azure SQL Managed Instance

Mustafa_Ashour on May 28 2021 08:14 AM
Azure SQL Analytics collects and visualizes key performance metrics with built-in intelligence for performance troublesh...
1,217

Lesson Learned #173: MSDTC on server 'xxxxx' is unavailable

Jose_Manuel_Jurado on May 21 2021 11:20 AM
Today, I worked on a very interesting service request that our customer is facing the following error message "MSDTC on ...
1,029

Lesson Learned #172: ApplicationIntent=Readonly in General Purpose database tier?

Jose_Manuel_Jurado on May 21 2021 08:56 AM
I saw in several situations that our customers are trying to use applicationIntent=Readonly parameter in their connectio...
2,019

'Lock request time out period exceeded' when connecting to the database from SSMS

Thamires_Lemes on May 19 2021 09:48 AM
When you connect to the database using SQL Server Management Studio (SSMS), It will perform several queries to gather th...
1,410

Troubleshooting high lock wait time and lock time-out

Thamires_Lemes on May 19 2021 09:35 AM
Locks are held in the database to ensure data consistency. If there are errors due to lock time-out or performance issue...
854

Lesson Learned #171: Testing a connection from multiple PowerShell script instances

Jose_Manuel_Jurado on May 12 2021 12:50 AM
Today, I worked on a very interesting situation. Our customer wants to check a connection but instead of from a single a...
1,198

Lesson Learned #170: Connection Pooling caches IP address

Jose_Manuel_Jurado on Apr 23 2021 08:38 AM
Today, I had a discussion with a colleague with a very interesting situation. All points to that the IP address is part ...
4,495

Azure SQL DB and Managed Instance tempdb

Alexandru Dinica on Apr 21 2021 01:22 PM
     
2,191

Revocation of the SSL certificate failed for AAD authentication

MelaniaNitu on Apr 20 2021 01:45 AM
Error when connecting with AAD (Password/Integrated/MFA) from SSMS : "Revocation of the SSL certificate failed".

Latest Comments

Frank_Ruiter
in How to copy an Azure SQL Database to a different server or subscription using Azure Automation on Oct 24 2021 11:30 PM
Wow, that is great, thx! gonna use it for sure!
0 Likes
atulram
in Quickly test connectivity from Azure Website to SQL DB on Oct 24 2021 10:14 AM
What if I am using a Linux-based app service plan, which command will help me, troubleshoot connectivity.
0 Likes
juliocalderon
in How-to auto-scale Azure SQL Databases on Oct 06 2021 09:05 AM
@VinitSatam Correct, to downscale you'll just need to invert that. Unfortunately, I did not develop nor test a scale down script :(
0 Likes
VinitSatam
in How-to auto-scale Azure SQL Databases on Oct 06 2021 08:24 AM
@juliocalderon To scale Down do we only need to change the increment value from +1 to -1$newvCoreCount = $coresArrayToBeUsed[$i+1] Do you have scale down script handy with you ? We have implement Scale Up script and works successfully. Thank you.
0 Likes
PsychoData
in Lesson Learned #144: Identifying the query that is taking too much time/resources on Oct 06 2021 07:20 AM
I think the idea is that if they make content rated for "kids", then it is acceptable for any company to advertise onBUT it means that they cannot work with many of YouTube's tools It's a shame that @Jose_Manuel_Jurado and them haven't sorted it out yet. I noticed the video about a year ago, but nev...
0 Likes