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

Lesson Learned #482: Identifying Potential Duplicate Statistics

Jose_Manuel_Jurado on Apr 01 2024 11:41 AM
Some time ago, we encountered a support case where a customer experienced significant delays in updating auto-created an...
1,760

Lesson Learned #480:Application-Level Locking in Azure SQL Database - Ensuring Exclusive Access

Jose_Manuel_Jurado on Mar 30 2024 02:41 PM
In certain circumstances, we need to apply production changes or exclusive access to one or more resources by only one i...
1,354

Lesson Learned #481: Query Performance Analysis Tips

Jose_Manuel_Jurado on Mar 18 2024 08:59 AM
When working with databases, high resource usage or a query reporting a timeout could indicate that the statistics of th...
1,618

Lesson Learned #479:Loading Data from Parquet to Azure SQL Database using C# and SqlBulkCopy

Jose_Manuel_Jurado on Mar 15 2024 12:13 PM
In the realm of big data and cloud computing, efficiently managing and transferring data between different platforms and...
1,887

Lesson Learned #478: Identifying TLS Version Using Azure SQL Auditing

Jose_Manuel_Jurado on Jan 16 2024 08:36 AM
Today, we worked on a service request where our customer needs to know the TLS version that their application are using....
2,065

Lesson Learned #476:Identifying Sleeping Sessions with Open Transactions in Azure SQL Database

Jose_Manuel_Jurado on Jan 16 2024 04:14 AM
In SQL Server environments, managing session states and transactions is key to ensuring optimal database performance. A ...
2,584

Lesson Learned #475:Cross-Database Queries Read and Write in Azure SQL Database.

Jose_Manuel_Jurado on Jan 14 2024 04:30 AM
This week, we addressed a service request from a customer who wanted to keep two tables synchronized across different da...
2,654

Lesson Learned #474:Identifying and Preventing Unauthorized Application Access to Azure SQL Database

Jose_Manuel_Jurado on Jan 13 2024 01:29 AM
In recent scenarios encountered with our customers, we have come across a specific need: restricting certain users from ...
1,788

Lesson Learned #473:Harnessing the Synergy of Linked Server, Python, and sp_execute_external_script

Jose_Manuel_Jurado on Jan 11 2024 10:06 AM
In an era where data management transcends individual database systems, SQL Server offers a sophisticated feature set th...
1,425

Lesson Learned #471: Why Can't I Expand the Database Table List from my Application?

Jose_Manuel_Jurado on Jan 08 2024 11:26 AM
In the dynamic world of database management, we encounter unique challenges that impact the efficiency and performance o...
3,180

Lesson Learned #469:Implementing a Linked Server Alternative with Azure SQL Database and C#

Jose_Manuel_Jurado on Jan 07 2024 01:06 AM
In scenarios where direct Linked Server connections are not feasible, such as between Azure SQL Database and an on-premi...
2,026

Lesson Learned #466:Managing SQL Server Workloads:Resolving Error Msg 10928 with DAC and SQL Queries

Jose_Manuel_Jurado on Jan 03 2024 02:46 AM
Dealing with SQL Server's error Msg 10928 is critical for database administrators. This error, indicating that the reque...
1,976

Lesson Learned #464: Utilizing SMO's Scripting Option in Azure SQL Database.

Jose_Manuel_Jurado on Jan 02 2024 03:53 AM
Today, I encountered a unique service request from a customer inquiring about alternative methods to script out a table ...
2,367

Lesson Learned #463: Synchronizing Large Data Volumes Between SQL Databases: A Python Solution

Jose_Manuel_Jurado on Dec 27 2023 11:04 AM
While working on a support case, we faced the need to replicate a substantial volume of data in a table to conduct perfo...
2,018

Lesson Learned #461:Effective Load Balancing in Azure SQL Database: A Practical Approach

Jose_Manuel_Jurado on Dec 21 2023 10:55 AM
In today's data-driven landscape, we are presented with numerous alternatives like Elastic Queries, Data Sync, Geo-Repli...
1,722

Lesson Learned #459:HikariCP - Unusual system clock change detected, soft-evicting connections pool

Jose_Manuel_Jurado on Dec 16 2023 04:07 AM
This week, we've been tackling a support case where our client encountered the following error message: '[HikariPool] 20...
1,774

Lesson Learned #458: High Login Impact on Azure SQL Database Worker Utilization: A Case Study.

Jose_Manuel_Jurado on Dec 15 2023 10:14 AM
Today, we encountered an interesting scenario with one of our customers. They reported a rapid increase in the number of...
1,850

Lesson Learned #455:Optimizing Connection Pooling for Application Workloads: Thread Contention

Jose_Manuel_Jurado on Nov 26 2023 10:41 AM
This week, I have been working on a support case where our client experienced a 5-second delay in database connectivity....
2,181

Lesson Learned #453:Optimizing Connection Pooling for Application Workloads: A single journey

Jose_Manuel_Jurado on Nov 25 2023 09:10 AM
In recent days, we have received several requests how to reduce the latency of a connection for an application designed ...
3,323

Lesson Learned #451:Deep Dive into Physical and Logical Reads in Azure SQL Database: Hands-On-Lab

Jose_Manuel_Jurado on Nov 10 2023 10:34 AM
This week, I addressed a customer's request to understand the differences between Physical and Logical Reads and how the...
1,729

Lesson Learned #446: Simplifying SQLPackage Log Debugging with PowerShell

Jose_Manuel_Jurado on Oct 20 2023 10:00 AM
Handling massive SQLPackage diagnostic logs, like those spanning over 4 million rows, can be an overwhelming task when t...
1,776

Lesson Learned #445:Unlocking the Mystery of Recompilations in SQL Server: A Practical Lab

Jose_Manuel_Jurado on Oct 18 2023 11:18 PM
Some days ago, I worked on a service request that our customer saw a CPU speaks time to time. This issue was cause a rec...
1,777

Lesson Learned #443:Improve Application Resilience:Connection,Execution,and ResultSet Retry Policies

Jose_Manuel_Jurado on Oct 14 2023 04:18 AM
We worked on a scenario where a customer is connected to a database with billions of records, processing data in batches...
2,567

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

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

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

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

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

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

Latest Comments

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
luisperalta
in Lesson Learned #8: Monitoring the geo-replicated databases. on Apr 16 2024 02:55 PM
Hi, I'm facing a high CPU consumption on Named Replica, does rebuilding indexes and update statistics for the primary database also execute on a named replica?
0 Likes
yuem2024
in Azure SQL DB Private Link / Private Endpoint - Connectivity Troubleshooting on Apr 04 2024 09:20 AM
@FonsecaSergio great article! we have intermittent issues with on-prem VM to SQL PE by using Azure DNS private resolver. can this article be updated with some best practices for trouble shooting with the Azure DNS private resolver architecture?
1 Likes