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
Options
1,000

[Azure SQL DB] - How to create and manage your cross subscription Auto-Failover groups (FoG)

joaoantunes on Nov 30 2022 02:53 AM
[Azure SQL DB] - How to create and manage your cross subscription Auto-Failover groups (FoG)
1,061

[Replication consistency] Compare all tables between two databases at once with Table Diff

joaoantunes on Nov 24 2022 08:52 AM
Create the tablediff command to compare all tables between two databases at once
2,052

Can Certain SQL User Roles Avoid Blocking?

Francisco_do_O on Nov 20 2022 01:15 PM
We recently came across a case where blocking was being observed when performing a DDL operation, while querying system ...
793

Lesson Learned #246: Performance Series-Detectando un problema de rendimiento en Azure SQL (Spanish)

Jose_Manuel_Jurado on Nov 13 2022 11:37 AM
English: In this chapter, we are going to review with Pablo Javier Fernandez Salazar, our Cloud SQL Architect colleague,...
848

Azure SQL Hyperscale Named replica audit files "There are no audit files for the selected criteria"

Palomag_MSFT on Nov 09 2022 10:25 AM
Hyperscale Named replica audit files. Error "There are no audit files for the selected criteria"
1,238

Lesson Learned #245: Azure SQL Database - Lessons Learned from the Trenches in PASS Summit 2019

Jose_Manuel_Jurado on Oct 31 2022 06:26 AM
Today, I worked on a case that reminds me of the session that I had the great honor to deliver with my friend and collea...
1,934

How monitor PITR restore in Managed Instance

Palomag_MSFT on Oct 29 2022 10:17 AM
How monitor PITR restore in Managed Instance
990

Lesson Learned #244: No such host is known connecting to Azure SQL Managed Instance Private Endpoint

Jose_Manuel_Jurado on Oct 26 2022 02:59 AM
Today, I worked on a service request where our customer got the following error: provider: TCP Provider, error: 0 - No s...
1,388

Lesson Learned #243: Enabling ODBC connection pooling in PHP

Jose_Manuel_Jurado on Oct 26 2022 01:26 AM
Connection Pooling is key for many applications to reduce the latency connecting to Azure SQL Database, in this post, I ...
2,221

Restore or copy an Azure SQL Database with resource tags

hugo_sql on Oct 19 2022 01:16 AM
When we restore or copy an Azure SQL Database and this database has resource tags, we cannot restore the tags because th...
1,021

Lesson Learned #242: The server principal "xyz" is not able to access the database "Yzxxx"

Jose_Manuel_Jurado on Oct 18 2022 12:58 PM
Today, I worked on a service request that our customer got the following error message: Msg 916, Level 14, State 4, Proc...
1,745

Lesson Learned #241: Lessons Learned from the Azure Database Support Blog Series with Anna Hoffman

Jose_Manuel_Jurado on Oct 16 2022 04:56 AM
We had the great honor of being able to talk about the lessons learned from the Azure Database Support Blog Series in Da...
2,217

TDE High availability with customer-managed key for Azure SQL Databases

Mousa_Janini on Oct 16 2022 03:53 AM
If the server loses access to the stored Database Encryption Key (DEK) in AKV, in up to 10 minutes a database will start...
1,791

Lesson Learned #240: Checking connection and execution latency in Azure SQL DB and Managed Instance

Jose_Manuel_Jurado on Oct 14 2022 11:48 AM
Today, I worked on a service request that our customer asks about: How to know the connection time invested to connect t...
933

Tales From the Field channel

Palomag_MSFT on Oct 14 2022 06:06 AM
Tales From the Field channel
1,990

Lesson Learned #239: Attempt was made to access a socket in a way forbidden by its access permission

Jose_Manuel_Jurado on Oct 05 2022 11:23 AM
Today, I worked on a service request where our customer is facing the following error message:TCP Provider, error: 0 - A...
2,140

Azure SQL idle sessions are killed after about 30 minutes

hugo_sql on Sep 29 2022 01:16 AM
Today, I worked on a Service Request where the customer wanted to understand the expected behavior of idle sessions that...
2,254

Deleted Azure SQL Database with existing diagnostic settings

emregokoglu on Sep 29 2022 12:37 AM
In this article, we consider the scenario where customers would like to delete Azure SQL database which has an existing ...
1,107

Could not connect to mail server. (No such host is known)

Palomag_MSFT on Sep 27 2022 04:45 AM
Azure SQL Managed Instance. Could not connect to mail server. (No such host is known)
1,355

Azure SQL and Azure SQL Managed Instance - Backup retention polices Loading ...

Palomag_MSFT on Sep 27 2022 03:43 AM
Azure SQL and Azure SQL Managed Instance - Backup retention polices Loading ...
2,311

Lesson Learned #238: Configuring Private Endpoint Connections in Azure SQL Managed Instance

Jose_Manuel_Jurado on Sep 22 2022 07:49 AM
Today, I worked on a service request that our customer had some doubts about how to Configure Private Endpoint Connectio...

Latest Comments

ahzyad
in How to copy an Azure SQL Database to a different server or subscription using Azure Automation on Dec 03 2022 07:17 AM
Thank you, @mohammad_belbaisi for the great post. This only works if the Elastic pool name is the same in Source and Target servers. Is there any way you could also provide a script that will work to copy the azure SQL databases to a different Elastic pool?I tried but it failed. Source Server: elast...
0 Likes
Prakruthi2290
in Auto scale up/down the Managed instance on Nov 29 2022 10:38 PM
Hi Amanda , I am getting one error:Error: Resource Group not found.I found another ‘service bus Namespace’ name that is similar when I searched for the resource group name. Need your help
0 Likes
banderson1962
in Azure SQL Database Token-based authentication with PowerShell on Nov 26 2022 05:19 PM
Where is AAD->App Registrations->Settings? This is all I see:  
0 Likes
Ben-Howard
in How to maintain Azure SQL Indexes and Statistics on Nov 23 2022 03:34 AM
I've submitted a PR to address the issue whereby the same indexes are rebuilt/reorged multiple times if the table is partitioned.
0 Likes
Masm_mastersql
in Lesson Learned #60: Using Partition Option in Azure SQL Managed Instance on Nov 17 2022 08:51 AM
quick question, creating different file groups to add multiple data file can assure us that in will be distributed across several disks or how will work internally in azure operations?
0 Likes