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
341

Lesson Learned #457:Optimizing SQL Connection Management with Single Token Authentication

Jose_Manuel_Jurado on Dec 06 2023 03:05 AM
This week, I addressed a service request highlighting a key issue in client applications with varying workloads. We note...
1,106

Lesson Learned #456: Invalid Key Column Type Error in Azure SQL Database DataSync

Jose_Manuel_Jurado on Dec 01 2023 11:26 PM
One such error for Azure SQL Database users employing DataSync is: "Database provisioning failed with the exception 'Col...
554

Lesson Learned #455:Optimizing Connection Pooling for Application Workloads: Exploring Login Rates

Jose_Manuel_Jurado on Nov 27 2023 05:52 AM
We have a client asking us what the login rate per second is that I can achieve on a S0, S1, S2, and S3 database. It's a...
840

Lesson Learned #455:Optimizing Connection Pooling for Application Workloads: Thread Contention

Jose_Manuel_Jurado on Nov 26 2023 10:41 AM
This week, I have been working on a support case where our client experienced a 5-second delay in database connectivity....
1,086

Lesson Learned #454:Optimizing Connection Pooling for Application Workloads: Active Connections

Jose_Manuel_Jurado on Nov 26 2023 01:39 AM
A few days ago, a customer asked us to find out details about the active connections of a connection pooling, how many c...
1,169

Lesson Learned #453:Optimizing Connection Pooling for Application Workloads: A single journey

Jose_Manuel_Jurado on Nov 25 2023 09:10 AM
In recent days, we have received several requests how to reduce the latency of a connection for an application designed ...
1,241

Lesson Learned #452: Understanding CPU Time and Elapsed Time in SQL Query Execution

Jose_Manuel_Jurado on Nov 19 2023 05:27 AM
Have you ever wondered why some SQL queries take forever to execute, even when the CPU usage is relatively low? In our l...
1,370

Lesson Learned #451:Deep Dive into Physical and Logical Reads in Azure SQL Database: Hands-On-Lab

Jose_Manuel_Jurado on Nov 10 2023 10:34 AM
This week, I addressed a customer's request to understand the differences between Physical and Logical Reads and how the...
1,471

Lesson Learned #450: Automating Alert Notifications for Query Data Store Usage in Azure SQL Database

Jose_Manuel_Jurado on Nov 02 2023 05:30 AM
In this article, we will introduce a PowerShell script that helps monitor the usage of Query Data Store (QDS) in SQL Ser...
7,256

How to Avoid Transaction Isolation Level Issues on Azure SQL Managed Instance

emregokoglu on Oct 30 2023 09:08 AM
Learn how to set and maintain the transaction isolation level for your distributed transactions on Azure SQL Managed Ins...
1,679

Azure custom policy to prevent backup retention period to be below X number - Azure SQL

Sabrin_Alsahsah on Oct 29 2023 05:33 AM
In this blog article, we will cover how to prevent and deny the automated backup retention days for Azure SQL database t...
4,441

Lesson Learned #449: Unleashing Concurrent Threads for Robust Database Health Checks in C#

Jose_Manuel_Jurado on Oct 27 2023 12:26 PM
In the realm of database health checks, performance and concurrency are paramount. As databases grow and applications sc...
2,769

How to copy Azure SQL database to a different subscription and different tenant

tarashee on Oct 27 2023 01:43 AM
Steps to copy a database from Azure SQL server to another one on a different subscription and different tenant (Microsof...
1,120

Lesson Learned #448:Implementing Retry Logic for BCP Command in Linux

Jose_Manuel_Jurado on Oct 26 2023 11:07 AM
When dealing with data migration or integration tasks, it's common to encounter transient issues that may cause the proc...
981

Lesson Learned #447:Deep Dive into JDBC isClosed() vs isValid():Ensuring Resilient DB Connectivity

Jose_Manuel_Jurado on Oct 25 2023 03:12 PM
Today, I worked on a service request that our customer reported several disconnections with ETL process that maintains t...
1,329

Lesson Learned #446: Simplifying SQLPackage Log Debugging with PowerShell

Jose_Manuel_Jurado on Oct 20 2023 10:00 AM
Handling massive SQLPackage diagnostic logs, like those spanning over 4 million rows, can be an overwhelming task when t...
1,332

Lesson Learned #445:Unlocking the Mystery of Recompilations in SQL Server: A Practical Lab

Jose_Manuel_Jurado on Oct 18 2023 11:18 PM
Some days ago, I worked on a service request that our customer saw a CPU speaks time to time. This issue was cause a rec...
4,083

Troubleshooting High Log Utilization Due to ACTIVE_TRANSACTION

Thamires_Lemes on Oct 16 2023 08:07 AM
Uncover the reasons behind transaction log retention and learn strategies for resolving high log usage due to active tra...
1,504

Lesson Learned #444:Handling the "Row Value Expressions Exceeds Maximum Allowed" Error in SQL Server

Jose_Manuel_Jurado on Oct 15 2023 05:19 AM
Some days ago, we faced the following error message: "Msg 10738, Level 15, State 1, Line 2 The number of row value expre...
1,325

Lesson Learned #443:Improve Application Resilience:Connection,Execution,and ResultSet Retry Policies

Jose_Manuel_Jurado on Oct 14 2023 04:18 AM
We worked on a scenario where a customer is connected to a database with billions of records, processing data in batches...
1,592

Lesson Learned #442: Determining CPU Usage in Azure SQL Database: One Query or Many?

Jose_Manuel_Jurado on Oct 12 2023 08:52 AM
When managing Azure SQL Databases, it's crucial to monitor performance metrics, especially CPU usage. One of the challen...
1,448

Lesson Learned #441: Monitoring TempDB Transactions Space in Azure SQL Elastic Pools with PowerShell

Jose_Manuel_Jurado on Oct 06 2023 04:12 PM
Today, we addressed a service request from our customer who needed to identify both the session and the text of the quer...
1,813

Lesson Learned #440: Introducing Our Connectivity Probe for Reliable Database Interaction in C#

Jose_Manuel_Jurado on Oct 06 2023 01:20 PM
Navigating the modern technology landscape requires reliable tools for ensuring consistent and secure database connectiv...
1,350

Lesson Learned #439: Solving Connectivity and Execution Issues in Java and JDBC for VLDB Databases

Jose_Manuel_Jurado on Oct 04 2023 12:01 PM
In the context of a recent service request, a customer encountered connectivity and execution issues while interacting w...
64.3K

Lesson Learned #438:Sync failed with state: SyncSucceededWithWarnings, Syncgroup: XXX

Jose_Manuel_Jurado on Sep 30 2023 09:14 AM
Working on a service request our customer reported the following error message: Sync failed with state: SyncSucceededWit...
1,716

Lesson Learned #437:Why Does Your SQL Query Run Faster Here Than There?

Jose_Manuel_Jurado on Sep 30 2023 06:40 AM
Ever faced a scenario where the exact SQL query yields different execution times on two databases? We'll dissect this ph...
1,661

Configuring backups retention for all Azure SLQ Managed instances under same subscription

Palomag_MSFT on Sep 28 2023 01:03 PM
Sample script to configure Sort time and Long time retention   backups
1,605

Lesson Learned #436: Implementing Retry Mechanism with sqlcmd in Bash (Linux)

Jose_Manuel_Jurado on Sep 27 2023 11:41 AM
Efficiently managing temporary failures and timeouts is crucial in production environments when connecting to databases....
1,454

Lesson Learned #435:How to Know the Status of Your Azure SQL Database:Service Health-Resource Health

Jose_Manuel_Jurado on Sep 25 2023 10:58 AM
Today, we had a service request our our customer wants to understand the health status of their Azure SQL Database. Know...

Latest Comments

AlbertoMorillo
in Automate exporting of azure sql database as .bacpac to blog storage. on Dec 05 2023 06:29 PM
This article is now obsolete. The script relies on Run As accounts and that type of connection is not supported since September 2023. In addition, AzureRM modules will be retire on 29 February 2024.
0 Likes
henrytsang
in Lesson Learned #285: Why can I still telnet to port 1433? on Nov 28 2023 06:18 AM
Thanks for the above explanation. Do you know if this is a recent change in Azure? I could have sworn that I used to use the Telnet technique to check if the Azure resource "Public Network Network Access" is disabled. In the past, I thought once private endpoint is enabled, no more Public Access is ...
0 Likes
Michael Bourgon
in Lesson Learned #450: Automating Alert Notifications for Query Data Store Usage in Azure SQL Database on Nov 20 2023 01:46 PM
@Jose_Manuel_Jurado would it be possible to show us how to turn this into a scheduled Azure Function? (Elastic Jobs are still in preview and our company prohibits the use of preview features). In general, knowing how to do that would be really helpful. Thanks!
0 Likes
johnsonkbs
in Lesson Learned #452: Understanding CPU Time and Elapsed Time in SQL Query Execution on Nov 20 2023 12:57 AM
Thanks for your update
0 Likes
guy_glantser
in Lesson Learned #442: Determining CPU Usage in Azure SQL Database: One Query or Many? on Nov 12 2023 10:18 AM
Thanks, Jose! Here is my version: https://github.com/MadeiraData/MadeiraToolbox/blob/master/Monitoring%20Scripts/Top%20Queries%20by%20CPU%20Time.sql
1 Likes