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
442

Lesson Learned #507:Error 4429 - View or function 'XYZ' contains a self-reference.

Jose_Manuel_Jurado on Jul 10 2024 04:26 AM
This last week, we worked on a service request where our customer got the following error message: "Msg 4429, Level 16, ...
1,158

Lesson Learned #506:Why Custom DNS Returns Public IP Instead of Private IP Azure Private Endpoints

Jose_Manuel_Jurado on Jul 06 2024 02:49 AM
These days, I was working on a simulation to understand why custom DNS servers resolve the public IP instead of the priv...
1,102

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

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
782

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

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
730

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Latest Comments

mbourgon_optum
in Lesson Learned #504: Inserting Records from a CSV File using OPENROWSET into TempDB on Jul 06 2024 07:11 PM
It feels like this has improved lately. 6 months ago it HAD to match standard CSV, and things like pipe-separated wouldn’t work - I’d opened tickets and everything. So kudos to the team for improving something that’s largely invisible but definitely needed.
0 Likes
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