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
837

Lesson Learned #505: Verifying IP Resolution in Azure SQL Database in Private Link

Jose_Manuel_Jurado on Jul 02 2024 01:28 AM
This last week, I worked on two service requests that our customers got the following error message: (Reason: An instanc...
982

Qtip: Connect Windows Azure VM to Azure SQL DB using Managed Identity

jaigarcimicrosoft on Jun 28 2024 08:54 AM
Connecting Windows Azure VM to Azure SQL DB using Managed Identiy
581

Lesson Learned #504: Inserting Records from a CSV File using OPENROWSET into TempDB

Jose_Manuel_Jurado on Jun 21 2024 05:25 AM
Today, I would like to share how to insert records from a CSV file stored in Azure Blob Storage into a temporary table i...
1,149

Connect from Azure SQL database to Storage account using Private Endpoint

Editah on Jun 19 2024 11:34 AM
Connect from Azure SQL database to Storage account using Private endpoint
655

Lesson Learned #503: Lessons Learned Using JDBC Logging with Microsoft JDBC Driver for SQL Server

Jose_Manuel_Jurado on Jun 18 2024 01:54 AM
A few days ago, our customer encountered connectivity issues while using HikariCP in their Java application. To troubles...
881

Lesson Learned #502: Comparing and Transferring Azure SQL Databases Table Structures Using SMO

Jose_Manuel_Jurado on Jun 17 2024 07:26 AM
This last week, I worked on a service request that we need to compare the existing tables of a database placed on a Azur...
1,173

Lesson Learned #501: Exporting Multiple Databases Simultaneously with SqlPackage

Jose_Manuel_Jurado on Jun 16 2024 07:52 AM
This week, I've been working on a service request case where we need to export multiple databases using SqlPackage. Foll...
825

Lesson Learned #500: Connection Leaks and Query Execution using HikariCP

Jose_Manuel_Jurado on May 31 2024 11:31 AM
Other lesson learned about HikariCP has been when we enabled setLeakDetectionThreshold working on a service request was ...
11.5K

Lesson Learned #499: HikariCP Retry Policy - The connection is closed

Jose_Manuel_Jurado on May 31 2024 10:55 AM
Today, I worked on a service request that our customer got the following error message: 19:28:43.232 [main] WARN com.zax...
1,190

Lesson Learned #498:Understanding the Role of STATMAN in SQL Server and Its Resource Consumption

Jose_Manuel_Jurado on May 31 2024 01:56 AM
Today, I worked on a service request that our customer reported a performance issue and they reported that this query: S...
1,263

Lesson Learned #497:Understanding the Ordering of uniqueidentifier in SQL Server

Jose_Manuel_Jurado on May 30 2024 07:10 AM
Today, I worked on a service request that our customer asked about how SQL Server sorts the uniqueidentifier data type. ...
1,099

Lesson Learned #496:Verifying Network Route to Azure SQL Database via VPN in Windows

Jose_Manuel_Jurado on May 28 2024 10:17 AM
Today, I worked on a service request where our customer was using a VPN, but the network routes seemed to indicate it wa...
1,075

Lesson Learned #495: Monitoring DNS Resolution with PowerShell of Azure SQL Server

Jose_Manuel_Jurado on May 28 2024 05:15 AM
Today, I worked on a service request where the DNS was providing an incorrect IP address randomly. In this article, I wo...
1,073

Lesson Learned #494: High number of Executions Plans for a Single Query

Jose_Manuel_Jurado on May 27 2024 09:24 AM
Today, I worked on a service request where our customer detected a high number of execution plans consuming resources in...
904

Lesson Learned #493: Monitoring Application Performance with Server Performance Counters

Jose_Manuel_Jurado on May 24 2024 11:57 AM
Today, I worked on a service request where our customer reported several performance issues in their application connect...
976

Lesson Learned #492: Improving Extended Events in Azure SQL

Jose_Manuel_Jurado on May 22 2024 05:46 AM
In the last months, our Product Team has been working to enhance Extended Events for Azure SQL as you could see in their...
988

Lesson Learned #491: Monitoring Blocking Issues in Azure SQL Database

Jose_Manuel_Jurado on May 21 2024 04:43 AM
Time ago, we wrote an article Lesson Learned #22: How to identify blocking issues? today, I would like to enhance this t...
1,207

Lesson Learned #490: Monitoring Access from Specific Applications to Azure SQL Database

Jose_Manuel_Jurado on May 18 2024 08:09 AM
This week, I worked on a service request where our customer needed to ensure that specific applications could not connec...
1,282

Lesson Learned #489:Investigating CPU Spikes with Query Store Overall Resource Consumption Report

Jose_Manuel_Jurado on May 17 2024 01:44 AM
Yesterday, I worked on a customer who experienced a CPU spike that went 90% during the timeframe of 19:00 to 21:00. I wo...
1,340

Lesson Learned #488: A severe error occurred on the current command. Operation cancelled by user.

Jose_Manuel_Jurado on May 16 2024 12:32 AM
Today, I worked on a service request that our customer got this error message: "A severe error occurred on the current c...
1,494

Lesson Learned #487: Identifying Parallel and High-Volume Queries in Azure SQL Database

Jose_Manuel_Jurado on May 15 2024 03:57 AM
Today, I worked on a service request that our customer needs to monitor and optimize queries that can significantly impa...
1,204

Lesson Learned #486: Snapshot Isolation Transaction Failed Due to a Concurrent DDL Statement

Jose_Manuel_Jurado on May 14 2024 01:33 AM
Today, we worked on a service request that our customer faced the following error message: Msg 3961, Level 16, State 1, ...
1,028

Lesson Learned #485: Index Recomendation or the Importance of Index Selection in SQL Server

Jose_Manuel_Jurado on May 13 2024 09:56 AM
Today, I worked on a service request that caught my attention regarding index missing recommendations given by SQL Serve...
1,225

Lesson Learned #484: Database Performance Monitoring with PowerShell and ReadScale-Out Environments

Jose_Manuel_Jurado on May 10 2024 06:20 AM
Today, I handled a service request from our customer seeking additional information on performance monitoring for ReadSc...
2,129

Lesson Learned #483: Optimizing Performance in Azure SQL Database ReadScale Out Databases

Jose_Manuel_Jurado on May 09 2024 08:02 AM
Today, I worked on a service request that our customer has a Business Critical database with 4 vCores and Read-Scale Out...
1,586

SQL MI Restore with valid SAS key failing with Operating System Error 86

SamGarth on Apr 22 2024 01:39 AM
We will provide details about a workaround for resolving the "Operating System Error 86" encountered during database res...
1,888

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

Latest Comments

VladDBA
in Lesson Learned #505: Verifying IP Resolution in Azure SQL Database in Private Link on Jul 02 2024 08:30 AM
One would expect Microsoft to provide code examples that don't rely on hard-coded credentials.I wouldn't be surprised if someone copy-pastes this into their projects, leaves their database credentials in there by accident and then commits it to their repo.
0 Likes
senk-msft
in Lesson Learned #396: Fixing 'Invalid value for key 'authentication' using System.Data.SqlClient on Jun 21 2024 09:45 AM
This the Microsoft.Data.SqlClient library available in Windows OS like System.Data.SqlClient???If NOT, this article needs to be updated to provide the details how to install that library.
0 Likes
Maurice_Pelchat
in Lesson Learned #383: Loading multiple extended file using sys.fn_xe_file_target_read_file on Jun 20 2024 07:53 AM
It is easier to read event file when they are at rest. It is another matter to read them in a continous mode. I'm trying to implement a stored procedure that reads in a loop the results, process them, and read next stuff. I read in the doc that you must supply a wildcard, a file name, and the offset...
0 Likes
jchang6
in TempDB space in Azure SQL DB appears much less than the published values on Jun 20 2024 04:28 AM
I don't see the point of ELSE 'Log file grows to a maximum size of 2 TB.'if max size is not 0, then it is on, -1 is unrestricted, the else should just display the set max value (converted to string).typical of unvetted ISV app to blow something up
0 Likes
Khwaza
in Lesson Learned #257: Encryption scheme mismatch for columns/variables on Jun 18 2024 05:50 AM
When I am trying to load data from encrypted table to temp table, I am getting below error message. Msg 8624, Level 16, State 1, Line 69Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services.
0 Likes