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
812

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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
kartar67
in Migrating an Azure SQL DB to a SQL MI by utilizing SqlPackage/ADF on Mar 05 2024 05:01 AM
I have been searching this for quite some time now, since I do feel that once we get into Azure SQL DB, it is a one way road. While these approaches involve quite some amount of downtime, looking forward to a more straightforward approach to migrate, even if that involves being offered as a professi...
0 Likes
luisaranda
in How to create linked servers from SQL managed instance using Entra Authentication (part 1) on Feb 29 2024 11:54 AM
@phSTC don't see anything wrong in terms of the configuration. But what I can see is that the error message states that an access token was not found on the response from Entra (aka AAD). If the access token was not granted to the managed identity, then it is not possible to connect to the remote Az...
0 Likes