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

  • 300 Blog Articles
Options
17.1K

Automate and Send Alerts for Elastic Jobs Failures

MelaniaNitu on 12-12-2020 05:49 AM
Alerts can be sent for any particular state of an elastic job. In this article, we discuss the case of 'Failed' jobs, ho...
765

Lesson Learned #155: Timeout period elapsed prior to obtaining a connection from the pool.

Jose_Manuel_Jurado on 12-11-2020 01:03 PM
Connection pooling is one of the best practices that we could implement in our code due to the improvement in the time s...
590

Lesson Learned #154: JAVA Console Script for Testing connection in Azure SQL

Jose_Manuel_Jurado on 12-11-2020 11:38 AM
To connect to Azure SQL Database we could use multiple tools or coding languages like C#, PHP, Java, etc.. In some situa...
1,045

Lesson Learned #153: PHP Console Script for Testing connection in Azure SQL

Jose_Manuel_Jurado on 12-10-2020 01:17 PM
To connect to Azure SQL Database we could use multiple tools or coding languages like C#, PHP, Java, etc.. In some situa...
963

Lesson Learned #152: When the transaction context matters in a blocking issue!

Jose_Manuel_Jurado on 12-03-2020 09:53 AM
Today, we got a service request that our customer reported that the using the following article the blocker and blocked ...
1,169

Lesson Learned #151: External Tables and Private Link connectivity

Jose_Manuel_Jurado on 12-01-2020 12:27 PM
Today, we got a new service request that our customer implemented a private link and they want to use External tables. U...
729

Lesson Learned #150: Calculating the space used by table and per column

Jose_Manuel_Jurado on 12-01-2020 10:16 AM
Today, I got a service request that our customer needs to know the total data size per table and data size per column. I...
771

Lesson Learned #149: Extracting data from Azure SQL DB using different drivers

Jose_Manuel_Jurado on 11-30-2020 11:17 AM
Today, I worked on a service request that our customer got an issue that depending on the driver that they are using the...
640

Learning from Expertise #1: How to audit SQL DB with PITR retention period < 35

Ahmed_S_Mahmoud on 11-30-2020 06:03 AM
Purpose: This article help you create a compliance policy to audit SQL DB with PITR retention period < 35, also it will ...
967

Using partitioned tables or multiple tables to improve big deletes performance

Thamires_Lemes on 11-30-2020 04:00 AM
There are cases in which the time It takes to perform the delete operations are higher than what is acceptable, even if ...
890

Lesson Learned #148: High wait time due to Parameter Sniffing

Jose_Manuel_Jurado on 11-30-2020 12:23 AM
This last week I had a service request where our customer faced a high wait time due to a parameter sniffing. In this si...
977

Lesson Learned #147: Checking the connectivity to Azure SQL DB and MI

Jose_Manuel_Jurado on 11-24-2020 12:04 PM
Sometimes we're used to recieve service request that our customers needs to know the time spent in order to connect to t...
1,220

Lesson Learned #146: Restoring a backup from Azure SQL Managed Instance to OnPremises

Jose_Manuel_Jurado on 11-23-2020 02:38 PM
We saw several service requests where our customer want to restore a backup taken in Azure SQL Managed Instance to SQL S...
1,194

Lesson Learned #145: Cannot communicate, because they do not possess a common algorithm

Jose_Manuel_Jurado on 11-23-2020 01:23 AM
Today, I saw a new service request that our customer is trying to create a linked server but they faced the following er...
815

Lesson Learned #144: Identifying the query that is taking too much time/resources

Jose_Manuel_Jurado on 11-20-2020 05:52 AM
These last weeks we got several cases that our customers reported performance issues. In this YouTube session, we are go...
575

Lesson Learned #143: (Spanish) - I'm not able to find where is the problem in my query

Jose_Manuel_Jurado on 11-19-2020 04:10 AM
These last weeks we got several cases that our customers reported that they need to identify the query that is taking ti...
872

Lesson Learned #142: Login Timeout Expired connecting to Azure SQL Database

Jose_Manuel_Jurado on 11-19-2020 03:40 AM
These last weeks we got several cases that our customers reported the following error message: Login timeout expired - A...
2,215

Learnings from the Trenches - Azure SQL Database Best Practice Performance recommendations

Diego_N on 10-28-2020 09:04 AM
This article will guide you through a series of recommendations to improve performance on your database. In addition, it...
1,088

Snapshot isolation transaction fails when querying metadata

MelaniaNitu on 10-28-2020 07:37 AM
Snapshot isolation transaction failed in database '%.*ls' because the object accessed by the statement has been modified...
1,523

Restore a DB encrypted with a TDE key into a server/instance having a different encryption key

Thamires_Lemes on 10-23-2020 09:55 AM
Steps on how to restore of a database encrypted with a Transparent Data Encryption (TDE) customer-managed key into a ser...
1,717

Azure SQL Database Auditing not writing to Storage Account behind firewall

Thamires_Lemes on 10-23-2020 09:29 AM
Mitigation steps for when the Azure SQL Database Auditing is not writing to a Storage Account behind firewall.
2,104

Lesson Learned #141: The target principal name is incorrect connecting to Azure SQL Database.

Jose_Manuel_Jurado on 10-21-2020 04:26 PM
Today, I worked on an interesting service request where our customer tried to connect using the FQDN of their private li...

Latest Comments

marcselman
in How to maintain Azure SQL Indexes and Statistics on 01-12-2021
Hi @Yochanan_MSFT Thanks for your work! The updated script works perfectly!
0 Likes
proesler
in How to maintain Azure SQL Indexes and Statistics on 01-11-2021
Hello, we want to use Elastic Jobs in Azure to do that. We found that instruction on the web:Automating Azure SQL Database index maintenance using Elastic Job Agents (sqlshack.com)How do we need to adjust your script so it would work with the instructions above? We want to run many jobs parallel.Br,...
0 Likes
Yochanan_MSFT
in Automating Azure SQL DB index and statistics maintenance using Azure Automation on 01-05-2021
@nreddipalle - Thank you for reporting back. I fixed the wrong condition in the procedure. you may download the current version and replace it in your environment. Again - Thank you for your feedback this is very valuable for me to improve this maintenance script. Yochanan.
1 Likes
nreddipalle
in Automating Azure SQL DB index and statistics maintenance using Azure Automation on 12-31-2020
Hello , I am running this script successfully via automation account for the past 18 months. As I noticed recently that the script is being updated, I planned to use the updated script and seeing my automation account job getting timed out.. The old script completes the statistics update in approxim...
0 Likes
mtraudt
in Deployment fails with 'Unable to connect to master or target server 'mydb_svr'. You must have a user with the same password in master or target server 'mydb-db' on 12-28-2020
I had a similar problem. I was able to fix by upgrading the Microsoft.SqlServer.DacFx.x64 package from 140.3745.1 to 150.4897.1 (latest stable).
0 Likes