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

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

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

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

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...
2,292

QTip: Connect to Azure SQL DB using Entra SPN (service principal)

jaigarcimicrosoft on Feb 02 2024 10:54 AM
Connect to Azure SQL DB using Entra SPN
1,729

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

Lesson Learned #477:NEXT VALUE FOR function cannot be used if ROWCOUNT option has been set

Jose_Manuel_Jurado on Jan 16 2024 04:46 AM
In the realm of SQL Server, certain combinations of commands and functions can lead to unexpected conflicts and errors. ...
1,870

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

QTip: Configure Azure SQL DB to receive alert when failover occurs in failover group or geo replica

jaigarcimicrosoft on Jan 16 2024 01:50 AM
How to receive notification when failover happens in failover group and geo replica
2,420

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

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

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

Lesson Learned #472:Why It's Important to Add the TCP Protocol When Connecting to Azure SQL Database

Jose_Manuel_Jurado on Jan 11 2024 03:50 AM
In certain service requests, our customers encounter the following error while connecting to the database, similar like ...
1,283

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...
2,481

Lesson Learned #470: Resolving 'EXECUTE Permission Denied' Error on sp_send_dbmail in Azure SQL MI

Jose_Manuel_Jurado on Jan 08 2024 01:14 AM
We worked on a service request that our customer encountering an error message "Executed as user: user1. The EXECUTE per...
2,960

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

Lesson Learned #468: Understanding and Resolving the "Could not find prepared statement with handle"

Jose_Manuel_Jurado on Jan 05 2024 01:46 AM
In the realm of SQL Server, encountering errors is a part of the development process. One such common error is "Could no...
1,681

Lesson Learned #467:Enhancing SQLCMD Script Reliability with C# and JSON

Jose_Manuel_Jurado on Jan 03 2024 11:21 AM
In the dynamic realm of database management, particularly with Azure SQL Database, professionals often encounter unique ...
1,867

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

Lesson Learned #465:Unraveling DNS Errors in "myserver.database.windows.net": Nonauthoritative host

Jose_Manuel_Jurado on Jan 03 2024 02:00 AM
Today, I got a service request with the following error message: .Net SqlClient Data Provider,SqlErrorNumber=11002,Class...
1,919

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

Latest Comments

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
mbourgon_optum
in Lesson Learned #295:The specified buffer size is less than the minimum size. on Mar 22 2024 01:32 PM
Any idea what determines that size? I ran into the same issue with Azure Data Studio and it seemed like a WTF. Microsoft's own tool can't figure out the min size when it's creating the event session?
0 Likes
Ireneab
in Testing connectivity against a Managed Instance using a CNAME on Mar 15 2024 11:48 AM
Thank you @luisaranda for this useful article. 
1 Likes