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

  • 346 Blog Articles
Options
719

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...
966

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...
861

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,287

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,511

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,277

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)...
4,103

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,157

Using extended events to capture deletion operations

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

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,593

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,009

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,107

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
882

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,480

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,039

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...
788

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,308

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,107

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 ...
982

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...
1,857

'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,313

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...
788

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,147

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 ...
3,996

Azure SQL DB and Managed Instance tempdb

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

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".
8,381

How-to auto-scale Azure SQL Databases

juliocalderon on Apr 19 2021 11:00 AM
In this tutorial, we will go over the steps to auto-scale an Azure SQL Database to the next immediate tier using Azure A...
2,247

Lesson Learned #169: Bulk Insert using Python in Azure SQL

Jose_Manuel_Jurado on Apr 17 2021 08:15 AM
Today, I worked in a very interesting case where our customer wants to insert millions of rows using Python. We reviewed...
2,537

Custom RBAC to access QPI's query text with minimal permissions

MelaniaNitu on Apr 13 2021 07:15 AM
Custom RBAC to access Query Performance Insight's query text with minimal permissions. The solution described in this ar...
1,265

Lesson Learned #168: Connection is not available error message using Hikari connection pooling

Jose_Manuel_Jurado on Mar 26 2021 03:59 AM
Today, I worked on a very interesting case that our customer is facing the following error message connecting to Azure S...

Latest Comments

woutt
in Lesson Learned #54: The specified schema name name@domain.com either does not exist or you do not have permission to use it on Sep 15 2021 04:50 AM
I have the same issue while executing `CREATE SCHEMA myNewSchema`, which you can obviously not prefix with the schemaname `dbo`.
0 Likes
Oury_Baoury
in Azure Database for PostgreSQL performance Quick Tips on Sep 13 2021 01:55 PM
Thank you for writing this. Very useful
0 Likes
AnthonyOC
in How-to auto-scale Azure SQL Databases on Sep 07 2021 12:44 PM
Great post Julio, thank you for sharing! Will try this and also modified version to downscale.
0 Likes
jaigarcimicrosoft
in Troubleshooting Azure Active Directory Integrated Authentication in Azure SQL on Sep 07 2021 09:02 AM
Thaks for the info ;)
1 Likes
JaimeGarciadeAlba
in Troubleshooting Azure Active Directory Integrated Authentication in Azure SQL on Sep 07 2021 08:59 AM
Really helpful Luis thanks !!!
1 Likes