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
415

Lesson Learned #509: KeepAliveTime parameter in HikariCP

Jose_Manuel_Jurado on Sep 27 2024 06:01 AM
Today, I have been working on a service request where, at certain times, we observed that connections could be disconnec...
1,092

Lesson Learned #508: Monitoring Wait Stats and Handling Large Data Set

Jose_Manuel_Jurado on Sep 09 2024 08:52 AM
Sometimes, we get asked how much data the client application is receiving from Azure SQL Database, along with the time s...
2,028

General Purpose to Business Critical Azure SQL database upgrade

sakshigupta on Aug 18 2024 01:28 AM
This article will help if you would like to upgrade Azure SQL databases.
1,341

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

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

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

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
1,472

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

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
1,322

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

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

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

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

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

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

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

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

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

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

Latest Comments

binhcao1
in Lesson Learned #296:The value of the property '' is invalid: Value does not fall within the expected on Oct 04 2024 10:16 PM
to add your ADF to Azure SQLMI using a system managed identity: 1. go to your Azure Data Factory blade in Azure Portal and enable Managed Identity 2. use SQL SSMS to connect to Azure SQLMI with Entra Admin ID that you set when you created Azure SQLMI 3. add ADF MSI service name (this is the name of ...
0 Likes
SandeepK2205
in SQL Azure Blob Auditing Basic Power BI Dashboard on Oct 02 2024 10:24 AM
how can we download the template? 
0 Likes
m60freeman
in How to get Azure SQL database size on Sep 27 2024 01:04 PM
@JSBSF You are definitely solving a different problem than I am trying to. 🙂 I am glad you found a solution that works. You can do what you need by comparing used vs. allocated, whereas I need to compare allocated vs MAXSIZE and they just don't make the latter available via TSQL for user databases ...
0 Likes
JSBSF
in How to get Azure SQL database size on Sep 27 2024 09:33 AM
Also I should mention that if you are comparing to the stats displayed on Azure portal, if you shrinkdatabase Azure will reflect the change pretty quickly. This query will take a few minutes to update the sizes. It's as if there is some polling or something going on, and while I was shrinking databa...
0 Likes
JSBSF
in How to get Azure SQL database size on Sep 27 2024 09:27 AM
I just checked. I had modified the query to look like this instead, and this is the one I was eventually using: SELECT rs2.database_name, rs2.storage_in_megabytes , rs2.allocated_storage_in_megabytes, allocated_storage_in_megabytes - storage_in_megabytes differenceFROM sys.resource_stats rs2JOIN (SE...
0 Likes