Azure Database Support Blog

340 Blog Articles

Options

943

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

746

Palomag_MSFT on Jul 16 2021 02:50 AM

How configure extended events to capture deletion operations

1,935

Ahmed_S_Mahmoud on Jul 05 2021 04:02 AM

664

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

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

853

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

955

Palomag_MSFT on Jun 15 2021 02:53 PM

Import BACPAC fails if database schema is large

769

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

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

897

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

649

Palomag_MSFT on Jun 11 2021 03:59 AM

Two logins are created by default for any Managed Instance: WASDRGTenantMonitoringRO and xtsuser

2,036

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

960

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

878

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

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

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

680

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

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

Alexandru Dinica on Apr 21 2021 01:22 PM

1,676

MelaniaNitu on Apr 20 2021 01:45 AM

Error when connecting with AAD (Password/Integrated/MFA) from SSMS : "Revocation of the SSL certificate failed".

5,400

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

1,858

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

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

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

948

Jose_Manuel_Jurado on Mar 10 2021 10:02 AM

Today, I worked on a service request that our customer is using this CmdLet to obtain all the secure connection string. ...

1,284

Jose_Manuel_Jurado on Mar 08 2021 01:20 AM

Today, we had a very interesting service request that our customer requested to improve the process for inserting 10 mil...

1,747

Mousa_Janini on Mar 03 2021 10:38 AM

This article will explain how to monitor replication lag for Auto-Failover Groups in SQL Managed Instance over time.

956

mohammad_belbaisi on Mar 01 2021 01:25 AM

I worked on a service request that our customer reported that some tables are empty after importing the database using B...

1,132

Jose_Manuel_Jurado on Feb 26 2021 08:33 AM

Today, I worked on a service request that our customer wants to download a large resultset from Azure SQL Database to On...

2,461

Sabrin_Alsahsah on Feb 25 2021 03:07 AM

In this article we consider the scenario where the used size of an Azure SQL Database or SQL Managed Instance Database i...

Latest Comments

in How to maintain Azure SQL Indexes and Statistics on Jul 27 2021 11:44 AM

Step one would be to simply stop using REORGANIZE. Step two would be to stop using the numbers 5 and 30% for logical fragmentation. ;) Take a look at the EightKB presentation I'm putting on tomorrow at 14:30UTC and make adaptations to your code. Let me know how it works out.

0 Likes

in How to maintain Azure SQL Indexes and Statistics on Jul 27 2021 08:36 AM

@Jeff_Moden - Appreciate your detailed feedback. I tend to agree with the points you mentioned. The script never meant to be the best solution to every scenario, however it still fit to most of the scenarios. I will take your inputs and will consider the best way to incorporate it with the maintenan...

0 Likes

in How-to auto-scale Azure SQL Databases on Jul 14 2021 11:26 PM

Is there a way to downscale this in same script?

0 Likes

in Best Practices for Azure SQL DataSync 2.0 tasks on Jul 13 2021 11:40 PM

You mention that reprovisioning is resource intensive. Against which database is it intensive against?Typically we have 3 databases in our sync process. There is the AzureSQL database, the HUB database (resides in AzureSQL, but different to the data source) and also an OnPremise database. Which of t...

0 Likes

in Cross-database Query in Azure SQL Database on Jul 09 2021 12:31 PM

Another thank you for helping clarify the process. @nickappleby I understand what you are thinking about heading with managed identities and External tables between AZ DBs. I had not seen anything to date, but Azure is ever changing.

0 Likes