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

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

Lesson Learned #463: Synchronizing Large Data Volumes Between SQL Databases: A Python Solution

Jose_Manuel_Jurado on Dec 27 2023 11:04 AM
While working on a support case, we faced the need to replicate a substantial volume of data in a table to conduct perfo...
2,095

Lesson Learned #462: Understanding the Key Updates in SQL Server Management Studio (SSMS) 19.1

Jose_Manuel_Jurado on Dec 22 2023 01:57 AM
SQL Server Management Studio (SSMS) 19.1 has introduced a range of updates and changes, enhancing its database managemen...
2,005

Lesson Learned #461:Effective Load Balancing in Azure SQL Database: A Practical Approach

Jose_Manuel_Jurado on Dec 21 2023 10:55 AM
In today's data-driven landscape, we are presented with numerous alternatives like Elastic Queries, Data Sync, Geo-Repli...
2,599

Auto Scale - Azure SQL elastic pools

Sabrin_Alsahsah on Dec 18 2023 03:09 AM
We have received a few inquiries and service requests regarding having an automatic scale for Azure SQL elastic pools an...
2,011

Lesson Learned #460: DataIO vs Buffer Pool

Jose_Manuel_Jurado on Dec 17 2023 01:33 AM
In the past week, we have dedicated our efforts to a service request where our customer asked questions: Whether DataIO ...
1,697

Lesson Learned #459:HikariCP - Unusual system clock change detected, soft-evicting connections pool

Jose_Manuel_Jurado on Dec 16 2023 04:07 AM
This week, we've been tackling a support case where our client encountered the following error message: '[HikariPool] 20...
1,746

Lesson Learned #458: High Login Impact on Azure SQL Database Worker Utilization: A Case Study.

Jose_Manuel_Jurado on Dec 15 2023 10:14 AM
Today, we encountered an interesting scenario with one of our customers. They reported a rapid increase in the number of...
1,766

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

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

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

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

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

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 ...
5,304

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...
3,178

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

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...
9,147

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

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...
5,974

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...
6,908

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

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

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

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

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

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

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

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

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

Latest Comments

anoop50
in Lesson Learned #251: Error 40532 using Private Endpoint IP in the server name on Apr 25 2024 01:57 AM
I used this method, but I am still unable to connect using private end point ip and useraname as username@servername to my managed instance. My username looks like email address removed for privacy reasons. Also I able to connect to port 1433 using IP from destination. Please let me know what else i...
0 Likes
saeed_aliakbarian
in Lesson Learned #287: Contains an unresolved reference to an object due to database collation on Apr 20 2024 06:04 AM
In brief the error happens when trying to create a dacpac/bacpac from a database or database project (or build the database project) that has one of the following situations:1. SELECT * : using star(*) in a SELECT statement in a view2. 3 Part names: Including database name when referencing a table (...
0 Likes
SightBeyondSight
in Lesson Learned #482: Identifying Potential Duplicate Statistics on Apr 19 2024 06:02 AM
Great lesson and something one would not even think about.Suggestion to change code @line 21 to :STRING_AGG(CONVERT(VARCHAR(max),sc1.StatisticName),'', '') WITHIN GROUP (ORDER BY sc1.StatisticName) AS StatisticsNames,This will prevent error when the comma delimeted statistics names exceed 8000 chara...
0 Likes
luisperalta
in Lesson Learned #8: Monitoring the geo-replicated databases. on Apr 16 2024 02:55 PM
Hi, I'm facing a high CPU consumption on Named Replica, does rebuilding indexes and update statistics for the primary database also execute on a named replica?
0 Likes
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