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

  • 325 Blog Articles
Options
419

Lesson Learned #171: Testing a connection from multiple PowerShell script instances

Jose_Manuel_Jurado on 05-12-2021 12:50 AM
Today, I worked on a very interesting situation. Our customer wants to check a connection but instead of from a single a...
912

Lesson Learned #170: Connection Pooling caches IP address

Jose_Manuel_Jurado on 04-23-2021 08:38 AM
Today, I had a discussion with a colleague with a very interesting situation. All points to that the IP address is part ...
1,557

Azure SQL DB and Managed Instance tempdb

Alexandru Dinica on 04-21-2021 01:22 PM
     
1,294

Revocation of the SSL certificate failed for AAD authentication

MelaniaNitu on 04-20-2021 01:45 AM
Error when connecting with AAD (Password/Integrated/MFA) from SSMS : "Revocation of the SSL certificate failed".
2,390

How-to auto-scale Azure SQL Databases

juliocalderon on 04-19-2021 11:00 AM
In this tutorial, we will go over the steps to auto-scale an Azure SQL Database to the next immediate tier using Azure A...
1,282

Lesson Learned #169: Bulk Insert using Python in Azure SQL

Jose_Manuel_Jurado on 04-17-2021 08:15 AM
Today, I worked in a very interesting case where our customer wants to insert millions of rows using Python. We reviewed...
2,330

Custom RBAC to access QPI's query text with minimal permissions

MelaniaNitu on 04-13-2021 07:15 AM
Custom RBAC to access Query Performance Insight's query text with minimal permissions. The solution described in this ar...
828

Lesson Learned #168: Connection is not available error message using Hikari connection pooling

Jose_Manuel_Jurado on 03-26-2021 03:59 AM
Today, I worked on a very interesting case that our customer is facing the following error message connecting to Azure S...
850

Lesson Learned #167: Working with Get-AzSqlDatabaseSecureConnectionPolicy

Jose_Manuel_Jurado on 03-10-2021 10:02 AM
Today, I worked on a service request that our customer is using this CmdLet to obtain all the secure connection string. ...
1,149

Lesson Learned #166: How to reduce the time inserting 10 millions of rows

Jose_Manuel_Jurado on 03-08-2021 01:20 AM
Today, we had a very interesting service request that our customer requested to improve the process for inserting 10 mil...
1,341

Monitor replication lag for Auto-Failover Groups in SQL Managed Instance

Mousa_Janini on 03-03-2021 10:38 AM
This article will explain how to monitor replication lag for Auto-Failover Groups in SQL Managed Instance over time.
794

Why my tables are empty after importing the BACPAC file ????

mohammad_belbaisi on 03-01-2021 01:25 AM
I worked on a service request that our customer reported that some tables are empty after importing the database using B...
1,043

Lesson Learned #165: How to reduce the time spent of downloading a large resultset

Jose_Manuel_Jurado on 02-26-2021 08:33 AM
Today, I worked on a service request that our customer wants to download a large resultset from Azure SQL Database to On...
1,886

Azure SQL Database or SQL Managed Instance Database used data space is much larger than expected

Sabrin_Alsahsah on 02-25-2021 03:07 AM
In this article we consider the scenario where the used size of an Azure SQL Database or SQL Managed Instance Database i...
2,007

Learning from Expertise #2: Who Dropped my Azure SQL DB?

Ahmed_S_Mahmoud on 02-23-2021 01:05 AM
In this article, we will provide a guideline on Azure solutions to secure, protect, recover, audit and monitor Azure SQL...
1,226

Lesson Learned #164: Why SQL Server Management Studio runs the query faster than my application

Jose_Manuel_Jurado on 02-19-2021 10:56 AM
Today, I worked on a service request that our customer reported that a query that they are using is taking more time if ...
931

Lesson Learned #163: Failed to save Auditing settings for server: xxx .Principal xxx does not exist

Palomag_MSFT on 02-18-2021 02:25 PM
Lesson Learned #163: Failed to save Auditing settings for server: xxx .Principal xxx does not exist
986

Lesson Learned #162: Cannot show requested dialog obtaining properties database in Managed Instance

Jose_Manuel_Jurado on 02-15-2021 04:29 AM
Today, I saw this error message when our customer is trying to obtain the properties of a database. This issue sometimes...
1,921

Lesson Learned #161: Error 0 - No such host is known in Azure SQL Managed Instance

Jose_Manuel_Jurado on 02-11-2021 09:02 AM
Today, I worked on an interesting service request where our customer is facing the error message "Connection to database...
1,190

Script to restore all the deleted databases from an Azure SQL Server

Ahmed_S_Mahmoud on 02-10-2021 05:15 AM
This article has a script to restore all the deleted databases from an Azure SQL Server.
751

Lesson Learned #160: DDL Trigger FOR ALL SERVERS in Azure SQL Managed Instance

Jose_Manuel_Jurado on 02-08-2021 06:36 AM
Today, I worked on an interesting service request where our customer asked if we could capture creation and deletion of ...
874

Lesson Learned #159: Compressing data and LOB data type in Azure SQL Managed Instance

Jose_Manuel_Jurado on 02-02-2021 10:52 AM
Today, I worked on a service request that our customer asked to compress data because they are reaching the limit of the...
982

Lesson Learned #158: Running a Insert Into .... Select when the source table is a Heap Table

Jose_Manuel_Jurado on 01-26-2021 04:49 PM
Today, I worked on a service request where I found an interesting situation running an Insert Into ... Select command wh...
1,327

Lesson Learned #157: Connecting to Azure Managed Instance Using Oracle Database Gateway for ODBC

Jose_Manuel_Jurado on 01-20-2021 11:19 AM
Today, we received a new service request that our customer wants to connect from Oracle to Azure SQL Managed Instance or...
894

Lesson Learned #156: Creating a Linked Server connecting to Read-Scale Managed Instance Replica

Jose_Manuel_Jurado on 01-19-2021 09:26 AM
Today, a customer asked how to run a query against the read-scale replica using SQL Server Agent in a Azure SQL Managed ...
18.3K

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

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

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

Latest Comments

Axurexia
in Restore a DB encrypted with a TDE key into a server/instance having a different encryption key on 05-12-2021
Ok, this is for Azure SQL. Using an on-premise SQL server on a VM in Azure I have to recreate the chain, Mapped AsyKey -> DEK, using a credential/login and set the thumbprint of the mapped key to the same value as the source SQL Server that performed the backup with the Key (I obviously must have th...
0 Likes
MattHAtCarrot
in Lesson Learned #54: The specified schema name name@domain.com either does not exist or you do not have permission to use it on 04-29-2021
Hello @Jose_Manuel_Jurado , having encountered the issue you described, I am wondering: how can I inspect the default_schema of an existing Active Directory group?I work with a couple of Azure SQL databases tied to different directories. In one of these databases, when I 'select SCHEMA_NAME()' I see...
0 Likes
Yochanan_MSFT
in Automating Azure SQL DB index and statistics maintenance using Azure Automation on 04-25-2021
Hi @sreedxc - I was trying to run it just now and no error shown, can you please be more specific about the error itself and where it pops up. I will be happy to help
0 Likes
sreedxc
in Automating Azure SQL DB index and statistics maintenance using Azure Automation on 04-23-2021
getting error on line 529 
0 Likes
DBYYC
in Copy production database to stage or test environment using PowerShell or TSQL on 04-21-2021
Hello, how about cross subscription copy of DB? I'm interested in copying production data to a different subscription where the pricing is more favorable. Please see my original post
0 Likes