Azure Database Support Blog

335 Blog Articles

Options

452

Jose_Manuel_Jurado on 06-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 ...

639

Palomag_MSFT on 06-15-2021 02:53 PM

Import BACPAC fails if database schema is large

561

Jose_Manuel_Jurado on 06-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...

608

Jose_Manuel_Jurado on 06-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 ...

593

Jose_Manuel_Jurado on 06-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...

503

Palomag_MSFT on 06-11-2021 03:59 AM

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

1,686

Mustafa_Ashour on 05-28-2021 08:14 AM

Azure SQL Analytics collects and visualizes key performance metrics with built-in intelligence for performance troublesh...

831

Jose_Manuel_Jurado on 05-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 ...

785

Jose_Manuel_Jurado on 05-21-2021 08:56 AM

I saw in several situations that our customers are trying to use applicationIntent=Readonly parameter in their connectio...

1,462

Thamires_Lemes on 05-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...

985

Thamires_Lemes on 05-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...

606

Jose_Manuel_Jurado on 05-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,007

Jose_Manuel_Jurado on 04-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 ...

2,342

Alexandru Dinica on 04-21-2021 01:22 PM

1,456

MelaniaNitu on 04-20-2021 01:45 AM

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

3,750

juliocalderon on 04-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,558

Jose_Manuel_Jurado on 04-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,396

MelaniaNitu on 04-13-2021 07:15 AM

Custom RBAC to access Query Performance Insight's query text with minimal permissions. The solution described in this ar...

915

Jose_Manuel_Jurado on 03-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...

899

Jose_Manuel_Jurado on 03-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,212

Jose_Manuel_Jurado on 03-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,542

Mousa_Janini on 03-03-2021 10:38 AM

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

869

mohammad_belbaisi on 03-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,086

Jose_Manuel_Jurado on 02-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,195

Sabrin_Alsahsah on 02-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...

2,156

Ahmed_S_Mahmoud on 02-23-2021 01:05 AM

In this article, we will provide a guideline on Azure solutions to secure, protect, recover, audit and monitor Azure SQL...

1,301

Jose_Manuel_Jurado on 02-19-2021 10:56 AM

Today, I worked on a service request that our customer reported that a query that they are using is taking more time if ...

992

Palomag_MSFT on 02-18-2021 02:25 PM

Lesson Learned #163: Failed to save Auditing settings for server: xxx .Principal xxx does not exist

1,027

Jose_Manuel_Jurado on 02-15-2021 04:29 AM

Today, I saw this error message when our customer is trying to obtain the properties of a database. This issue sometimes...

2,614

Jose_Manuel_Jurado on 02-11-2021 09:02 AM

Today, I worked on an interesting service request where our customer is facing the error message "Connection to database...

Latest Comments

in Lesson Learned #16: How to change the default language of Azure SQL Database on 05-25-2021

Thanks for sharing this information!

0 Likes

in Restore a DB encrypted with a TDE key into a server/instance having a different encryption key on 05-12-2021

Ok, this is for Azure SQL. Using an on-premise SQL server on a VM in Azure I have to recreate the chain, Mapped AsyKey -> DEK, using a credential/login and set the thumbprint of the mapped key to the same value as the source SQL Server that performed the backup with the Key (I obviously must have th...

0 Likes

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 04-29-2021

Hello @Jose_Manuel_Jurado , having encountered the issue you described, I am wondering: how can I inspect the default_schema of an existing Active Directory group?I work with a couple of Azure SQL databases tied to different directories. In one of these databases, when I 'select SCHEMA_NAME()' I see...

0 Likes

in Automating Azure SQL DB index and statistics maintenance using Azure Automation on 04-25-2021

Hi @sreedxc - I was trying to run it just now and no error shown, can you please be more specific about the error itself and where it pops up. I will be happy to help

0 Likes

in Automating Azure SQL DB index and statistics maintenance using Azure Automation on 04-23-2021

getting error on line 529

0 Likes