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

  • 324 Blog Articles
Options
892

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

Azure SQL DB and Managed Instance tempdb

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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
985

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

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

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

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

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

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

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

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

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

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

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

Latest Comments

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
astanton1978
in Using SQLPackage to import or export SQL Server and Azure SQL DB on 04-20-2021
OK, now how to connect using my AAD credentials and MFA enabled (kind of the standard access requirements for most organizations)?
0 Likes