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
12K

Stop Azure SQL Database

Editah on Aug 09 2023 09:40 AM
We have several cases where our customers are looking for ways to stop an Azure SQL Database. Some common scenarios wher...
2,805

Lesson Learned #414: Demystifying Execution Plans and Query Optimization in Azure SQL Database

Jose_Manuel_Jurado on Aug 08 2023 08:06 AM
In the world of database management, achieving optimal query performance is a crucial goal.As data volumes grow and appl...
2,067

Lesson Learned #413:PerfStat: Performance Stats Collection for Azure SQL Database

Jose_Manuel_Jurado on Aug 08 2023 12:40 AM
Some days ago, we published an article in our blog: Lesson Learned #412:PerfStat: Performance Stats Collection for SQL S...
1,889

Lesson Learned #412:PerfStat: Performance Stats Collection for SQL Server (OnPrem) Using DiagManager

Jose_Manuel_Jurado on Aug 07 2023 12:03 AM
Efficient performance monitoring and tuning are critical aspects of ensuring optimal operation for database systems. As ...
2,136

Lesson Learned #411:Troubleshooting "Statement(s) could not be prepared" Error ODBC API Connection

Jose_Manuel_Jurado on Aug 01 2023 12:13 PM
Today, we got an interested case where our customer got the following error message "Statement(s) could not be prepared"...
1,707

Lesson Learned #410:Custom CPU Management in Azure SQL DB: Implementing a Pseudo-Resource Governor

Jose_Manuel_Jurado on Jul 30 2023 12:16 PM
Azure SQL Database is a powerful platform that provides managed database services with built-in intelligence and robust ...
1,850

Lesson Learned #409:Resilient Azure SQL DB: Powering Performance with OpenAsync and ExecuteAsync

Jose_Manuel_Jurado on Jul 29 2023 09:11 AM
Efficiently managing Azure SQL Database and Managed Instance operations is essential for developers and DBAs seeking hig...
1,508

Lesson Learned #408: The Strange Case of the Failover Conundrum

Jose_Manuel_Jurado on Jul 28 2023 10:50 AM
Our protagonist's application is equipped with a failover group, a mechanism enabling automatic redirection to a seconda...
1,738

Lesson Learned #407:Exploring Azure SQL Database Performance with sys.dm_os_performance_counters

Jose_Manuel_Jurado on Jul 27 2023 12:53 PM
In this blog post, we will embark on an exciting journey into the world of Azure SQL Database performance monitoring usi...
2,130

Lesson Learned #406:Monitoring Resource Usage and Open Ports with PowerShell & Bash Script

Jose_Manuel_Jurado on Jul 27 2023 08:44 AM
In today's fast-paced digital landscape, it is crucial for organizations to efficiently monitor and manage their infrast...
1,247

Lesson Learned #405: How many TSQL operations you said?

Jose_Manuel_Jurado on Jul 24 2023 07:46 AM
In today's data-centric landscape, Azure SQL Database has become a preferred choice for organizations seeking to store, ...
2,648

Connect from Azure VM (VNet) to an Azure SQL Database

hugo_sql on Jul 24 2023 06:58 AM
A few different configurations to connect your Azure VM (Vnet) to your Azure SQL Database. I have covered different scen...
5,128

Lesson Learned #404: Understanding and Addressing 100% Worker Utilization

Jose_Manuel_Jurado on Jul 20 2023 07:53 AM
Worker utilization is a critical aspect of Azure SQL Database performance. When the percentage of workers reaches 100%, ...
1,868

Lesson Learned #403:Using Azure SQL Database Activity Monitor for Query Performance Insights

Jose_Manuel_Jurado on Jul 19 2023 12:51 PM
In this article, we will explore a PowerShell script that serves as an Activity Monitor for Azure SQL Database query per...
2,322

Migrate Column Encrypted Database to Azure SQL Managed Instance

KeshavKiran on Jul 18 2023 11:41 PM
This articles explain how to migrate the On-prem Database which is Column Encrypted to Azure SQL Managed Instance.
1,846

Lesson Learned #402:Automated Monitoring of Table Growth in SQL Databases Using PowerShell

Jose_Manuel_Jurado on Jul 17 2023 09:40 AM
Uncontrolled table growth in a SQL database can have a significant impact on system performance and efficiency. It is cr...
1,891

Lesson Learned #401:Creating Dynamic Views from Multiple Tables using Stored Procedure

Jose_Manuel_Jurado on Jul 16 2023 02:53 AM
Recently, I encountered an intriguing scenario where our customer needed to dynamically create views based on multiple t...
1,313

Lesson Learned #400:Reigniting a Dormant Extended Event in Azure SQL Database with PowerShell

Jose_Manuel_Jurado on Jul 12 2023 11:04 AM
Extended events provide essential insights in Azure SQL Database, enabling efficient monitoring and troubleshooting. How...
1,659

Lesson Learned #399:Why is Private Link Still Resolving to Private IP Despite Its Removal in Azure?

Jose_Manuel_Jurado on Jul 12 2023 09:57 AM
In Microsoft Azure, Private Link has been a popular feature that enables secure access to Azure services over private ne...
1,159

Lesson Learned #398: Recommended Automatic Indexes Are Excluded from BACPAC Data Export

Jose_Manuel_Jurado on Jul 11 2023 09:05 AM
In the realm of database management, the BACPAC format is widely used for exporting and importing data between databases...
2,297

Lesson Learned #397: Azure SQL Database and Azure SQL Managed Instance vs Ole Automation Process

Jose_Manuel_Jurado on Jul 10 2023 02:22 PM
Today, we found a case that our customer reported the following errors "Msg 229, Level 14, State 5, Procedure sp_OACreat...
9,394

Lesson Learned #396: Fixing 'Invalid value for key 'authentication' using System.Data.SqlClient

Jose_Manuel_Jurado on Jul 09 2023 03:27 AM
Our customer is getting the following error message: Application Error System.ArgumentException: Invalid value for key '...
1,945

Lesson Learned #395:Token Management and Retry Strategy for Azure Active Directory Authentication

Jose_Manuel_Jurado on Jul 07 2023 10:22 AM
In this blog post, we'll explore how to optimize token retrieval from Azure Active Directory (AAD) by implementing token...
1,536

Lesson Learned #394:Resolving Azure SQL DataSync Error: Login Failed During Database Reprovisioning

Jose_Manuel_Jurado on Jul 06 2023 10:46 AM
In this blog article, we will address a common issue encountered during database reprovisioning with Azure SQL DataSync....
1,811

Lesson Learned #393:Troubleshooting Azure SQL DataSync Error:Cannot Insert NULL Value into Column ID

Jose_Manuel_Jurado on Jul 06 2023 10:35 AM
In this blog article, we will delve into a common error encountered when synchronizing data with Azure SQL DataSync. We'...
2,814

Lesson Learned #392:Querying Extended Events and Sending Results via Email using PowerShell

Jose_Manuel_Jurado on Jul 04 2023 01:26 AM
In this article, we will explore how to leverage PowerShell to query extended events in SQL Server and send the results ...
3,013

Lesson Learned #391: Data Loading - Parallel BULK INSERTs with JDBC and Azure Blob Storage

Jose_Manuel_Jurado on Jul 03 2023 11:18 AM
Today, we got a service request that our customer is running in multiple threads using prepared statement. In this artic...
1,378

LicenseType parameter when you scale your Azure SQL Managed Instance

hugo_sql on Jul 03 2023 06:26 AM
When you try to scale your Azure SQL Managed Instance and you face the following error message: "Configured pricing tier...

Latest Comments

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
mbourgon_optum
in Lesson Learned #295:The specified buffer size is less than the minimum size. on Mar 22 2024 01:32 PM
Any idea what determines that size? I ran into the same issue with Azure Data Studio and it seemed like a WTF. Microsoft's own tool can't figure out the min size when it's creating the event session?
0 Likes