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
2,617

Lesson Learned #442: Determining CPU Usage in Azure SQL Database: One Query or Many?

Jose_Manuel_Jurado on Oct 12 2023 08:52 AM
When managing Azure SQL Databases, it's crucial to monitor performance metrics, especially CPU usage. One of the challen...
2,012

Lesson Learned #441: Monitoring TempDB Transactions Space in Azure SQL Elastic Pools with PowerShell

Jose_Manuel_Jurado on Oct 06 2023 04:12 PM
Today, we addressed a service request from our customer who needed to identify both the session and the text of the quer...
64.9K

Lesson Learned #438:Sync failed with state: SyncSucceededWithWarnings, Syncgroup: XXX

Jose_Manuel_Jurado on Sep 30 2023 09:14 AM
Working on a service request our customer reported the following error message: Sync failed with state: SyncSucceededWit...
2,030

Lesson Learned #437:Why Does Your SQL Query Run Faster Here Than There?

Jose_Manuel_Jurado on Sep 30 2023 06:40 AM
Ever faced a scenario where the exact SQL query yields different execution times on two databases? We'll dissect this ph...
2,062

Lesson Learned #436: Implementing Retry Mechanism with sqlcmd in Bash (Linux)

Jose_Manuel_Jurado on Sep 27 2023 11:41 AM
Efficiently managing temporary failures and timeouts is crucial in production environments when connecting to databases....
14.8K

Lesson Learned #433:Azure SQL Pre-login Handshake Error 64:"The specified network name is no longer"

Jose_Manuel_Jurado on Sep 24 2023 03:27 AM
Encountering error code 64 while connecting to an Azure SQL Database can be a frustrating experience for both DBAs and d...
2,443

Lesson Learned #432: Resolving DataSync Failures in Azure SQL Database Caused by Custom Triggers

Jose_Manuel_Jurado on Sep 23 2023 04:41 AM
Azure SQL Database provides a robust DataSync service to synchronize data across multiple Azure SQL databases or between...
1,894

Lesson Learned #429:Leveraging the Full Range SQL Server INT Data Type: Negative and Positive Values

Jose_Manuel_Jurado on Sep 18 2023 11:05 AM
SQL Server's INT data type, by design, provides a range from -2,147,483,648 to 2,147,483,647. But often, developers only...
4,256

Lesson Learned #428: SqlError Number:229 provisioning DataSync in Azure SQL Database

Jose_Manuel_Jurado on Sep 17 2023 05:19 AM
We got a new issue when our customer found provisioning a Sync Group named 'XXX' failed with error: Database re-provisio...
2,026

Lesson Learned #426:Identifying and Mitigating Query Regressions in Azure SQL using Query Data Store

Jose_Manuel_Jurado on Sep 11 2023 09:57 AM
SQL performance is often a critical aspect for most business applications. Over time, the execution characteristics of a...
1,903

Lesson Learned #425:Azure SQL Database Failover Group Endpoint: A Deep Dive into DNS Resolution

Jose_Manuel_Jurado on Sep 11 2023 03:31 AM
Today, we got a service request where our customer is facing connectivity issue using Azure SQL Database Failover Group ...
2,991

Lesson Learned #422: Retrieving Database Connection Strings with Azure Key Vault

Jose_Manuel_Jurado on Sep 05 2023 06:42 AM
Today, we worked on a service request that our customer wants to use Azure Key Vault for saving the connectionstring for...
1,613

Lesson Learned #421:Understanding and Troubleshooting Transaction Log Truncation in Azure SQL DB

Jose_Manuel_Jurado on Sep 05 2023 05:07 AM
Azure SQL Database, Microsoft's cloud-based database service, manages many administrative functions automatically, such ...
4,415

Calculating CPU percentage for active queries

SamGarth on Sep 04 2023 06:37 AM
This article helps you to identify and calculate CPU percentage for active queries.
13K

Stop Azure SQL Database

Editah on Aug 09 2023 09:40 AM
We have several cases where our customers are looking for ways to stop an Azure SQL Database. Some common scenarios wher...
1,522

Lesson Learned #408: The Strange Case of the Failover Conundrum

Jose_Manuel_Jurado on Jul 28 2023 10:50 AM
Our protagonist's application is equipped with a failover group, a mechanism enabling automatic redirection to a seconda...
5,644

Lesson Learned #404: Understanding and Addressing 100% Worker Utilization

Jose_Manuel_Jurado on Jul 20 2023 07:53 AM
Worker utilization is a critical aspect of Azure SQL Database performance. When the percentage of workers reaches 100%, ...
1,906

Lesson Learned #403:Using Azure SQL Database Activity Monitor for Query Performance Insights

Jose_Manuel_Jurado on Jul 19 2023 12:51 PM
In this article, we will explore a PowerShell script that serves as an Activity Monitor for Azure SQL Database query per...
1,921

Lesson Learned #402:Automated Monitoring of Table Growth in SQL Databases Using PowerShell

Jose_Manuel_Jurado on Jul 17 2023 09:40 AM
Uncontrolled table growth in a SQL database can have a significant impact on system performance and efficiency. It is cr...
1,935

Lesson Learned #401:Creating Dynamic Views from Multiple Tables using Stored Procedure

Jose_Manuel_Jurado on Jul 16 2023 02:53 AM
Recently, I encountered an intriguing scenario where our customer needed to dynamically create views based on multiple t...
1,326

Lesson Learned #400:Reigniting a Dormant Extended Event in Azure SQL Database with PowerShell

Jose_Manuel_Jurado on Jul 12 2023 11:04 AM
Extended events provide essential insights in Azure SQL Database, enabling efficient monitoring and troubleshooting. How...
1,719

Lesson Learned #399:Why is Private Link Still Resolving to Private IP Despite Its Removal in Azure?

Jose_Manuel_Jurado on Jul 12 2023 09:57 AM
In Microsoft Azure, Private Link has been a popular feature that enables secure access to Azure services over private ne...
9,991

Lesson Learned #396: Fixing 'Invalid value for key 'authentication' using System.Data.SqlClient

Jose_Manuel_Jurado on Jul 09 2023 03:27 AM
Our customer is getting the following error message: Application Error System.ArgumentException: Invalid value for key '...
3,182

Lesson Learne #390:The timeout period elapsed while attempting to consume the pre-login handshake

Jose_Manuel_Jurado on Jul 03 2023 05:39 AM
Today, we got a scenario with the following error message: "Connection Timeout Expired. The timeout period elapsed while...
2,810

Lesson Learned #388:Retrying Execution in case of Connection Drops/Command Timeouts using ODBC API

Jose_Manuel_Jurado on Jul 02 2023 03:15 AM
Based on Lesson Learned #368: Connection Retry-Logic using ODBC API code - Microsoft Community Hub I would like to share...
1,717

Lesson Learned #387:Monitoring Query Data Store State Changes in Azure SQL Database using PowerShell

Jose_Manuel_Jurado on Jun 29 2023 10:47 AM
This morning, I have been working on a support case where our client was not able to see certain queries when querying t...
1,877

Lesson Learned #386: Can I log when Query Data Store (QDS) fails to capture a query?

Jose_Manuel_Jurado on Jun 28 2023 02:46 PM
In a recent service request, a customer asked if there was a way to identify when QDS fails to capture a query due to va...
2,886

Lesson Learned #385: Failed to validate the server name in a certificate during Secure Sockets Layer

Jose_Manuel_Jurado on Jun 28 2023 09:12 AM
The error message "Failed to validate the server name in a certificate during Secure Sockets Layer (SSL) initialization"...
1,741

Lesson Learned #373: Improving download transfer rate for LOB columns in Azure SQL Database

Jose_Manuel_Jurado on Jun 16 2023 12:25 PM
A few days ago, I have been working on reducing the data download transfer rate to improve the download ratio for Proxy ...
1,159

Lesson Learned #369:Size NNN from table 'XYZ' cannot fit within the specified batch size of 24576KB

Jose_Manuel_Jurado on Jun 12 2023 10:10 AM
Today we had a new case where our client encountered the following error message when synchronizing tables using DataSyn...

Latest Comments

Roberto_Carrancio
in Lesson Learned #487: Identifying Parallel and High-Volume Queries in Azure SQL Database on May 17 2024 04:35 AM
Hi @Jose_Manuel_Jurado I can see values ​​up to 500 in max_DOP column if I select the sys.dm_exec_query_stats DMV. What does that value represent? Thanks in advance
0 Likes
Devi49
in Azure Data Warehouse Health Check Query on May 14 2024 02:18 PM
I couldn’t see the query used for checking the quick health check. Could you please share it
0 Likes
anoop50
in Lesson Learned #251: Error 40532 using Private Endpoint IP in the server name on Apr 25 2024 01:57 AM
I used this method, but I am still unable to connect using private end point ip and useraname as username@servername to my managed instance. My username looks like email address removed for privacy reasons. Also I able to connect to port 1433 using IP from destination. Please let me know what else i...
0 Likes
saeed_aliakbarian
in Lesson Learned #287: Contains an unresolved reference to an object due to database collation on Apr 20 2024 06:04 AM
In brief the error happens when trying to create a dacpac/bacpac from a database or database project (or build the database project) that has one of the following situations:1. SELECT * : using star(*) in a SELECT statement in a view2. 3 Part names: Including database name when referencing a table (...
0 Likes
SightBeyondSight
in Lesson Learned #482: Identifying Potential Duplicate Statistics on Apr 19 2024 06:02 AM
Great lesson and something one would not even think about.Suggestion to change code @line 21 to :STRING_AGG(CONVERT(VARCHAR(max),sc1.StatisticName),'', '') WITHIN GROUP (ORDER BY sc1.StatisticName) AS StatisticsNames,This will prevent error when the comma delimeted statistics names exceed 8000 chara...
0 Likes