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
580

Lesson Learned #213: Cannot set the AccessToken property if the Integrated Security has been set

Jose_Manuel_Jurado on Jul 01 2022 01:43 AM
Today, I worked on a service request where using SQLPackage and Azure Active Directory user our customer got the followi...
764

Stuck operation in Azure SQL Managed Instance due to private DNS zone name

Sabrin_Alsahsah on Jun 30 2022 02:11 AM
In this article, we will be covering one of the reasons that can cause a stuck operation in Azure SQL managed instance a...
978

Lesson Learned #212: Hands-On-Labs:TCP Provider: The semaphore timeout period has expired

Jose_Manuel_Jurado on Jun 28 2022 04:11 PM
We used to have cases where our customer faced the following error message: "TCP Provider: The semaphore timeout period ...
642

Lesson Learned #211: Monitoring SQLPackage Import Process

Jose_Manuel_Jurado on Jun 27 2022 06:08 PM
We used to have cases where our customer asked what is current of SqlPackage state, do I need more resources in my datab...
558

Lesson Learned #210: Hands-On-Labs:A transport-level error has occurred when receiving results.

Jose_Manuel_Jurado on Jun 26 2022 05:37 AM
We used to have cases where our customer faced the following error message: "A transport-level error has occurred when r...
610

Lesson Learned #209: Hands-On-Labs:10928-Resource ID:1.The request limit for the database is reached

Jose_Manuel_Jurado on Jun 26 2022 04:50 AM
We used to have cases where our customer faced the following error message: "10928-Resource ID : 1. The request limit fo...
1,592

Lesson Learned #208: Hands-On-Labs:10928-Resource ID:2.The session limit for the database is reached

Jose_Manuel_Jurado on Jun 26 2022 03:30 AM
We used to have cases where our customer faced the following error message: "10928-Resource ID : 2. The session limit fo...
232K

Lesson Learned #207: Hands-On-Labs: 40613-Database ‘xyz' on server ‘xyz2' is not currently available

Jose_Manuel_Jurado on Jun 26 2022 03:10 AM
We used to have cases where our customer faced the following error message: "40613-Database ‘xyz' on server ‘xyz2' is no...
2,836

Lesson Learned #206: Hands-On-Labs: The timeout period elapsed prior to obtaining a connection

Jose_Manuel_Jurado on Jun 26 2022 02:42 AM
We used to have cases where our customer faced the following error message: "Timeout expired. The timeout period elapsed...
865

Lesson Learned #205: Best Practices connecting to Azure SQL Database and Managed Instance

Jose_Manuel_Jurado on Jun 26 2022 02:11 AM
We often get a lot of questions from our customers about best practices when connecting to a database. In this video we ...
1,135

How to restore database using LTR backups with PowerShell

Palomag_MSFT on Jun 16 2022 01:47 PM
Restoring LTR backup 
957

Azure SQL Data Exfiltration Controls: Outbound Firewall Rules aka OFRs

abhijit_shah on May 23 2022 10:12 AM
Data loss prevention is a major concern with all customers who would like to have granular control over their data and h...
1,162

Control Data Exfiltration using Outbound Firewall Rules

abhijit_shah on May 23 2022 01:42 AM
Data Loss Prevention measures help control/prevent data exfiltration and protect data loss. Such measures are critical t...
1,194

Azure SQL Database to ADF connectivity using Azure Private Endpoint

YoBelwal on May 23 2022 01:26 AM
Connecting to Azure SQL Database from Azure Data Factory using Azure Private Endpoint.
2,043

Cross-Subscription Failover Group - Azure SQL Managed Instance

Swabhiman_Das on May 18 2022 05:10 AM
Setting up Cross-Subscription Failover Group - Azure SQL Managed Instance
2,023

How to setup email alerts to monitor automation jobs for Azure SQL DB maintenance

Mousa_Janini on May 16 2022 03:00 AM
When we automate Azure SQL DB index and statistics maintenance using Azure Automation, we can monitor the automation job...
1,059

Lesson Learned #204: Elastic Query and firewall issues

Jose_Manuel_Jurado on May 12 2022 10:27 AM
Today, I worked on a service request that our customer needs to add the IP of Azure SQL node that is executing any elast...
1,189

Lesson Learned #203: How can I know that my connection is using Redirect connectivity policy?

Jose_Manuel_Jurado on May 12 2022 06:14 AM
Today, I worked on a service request that our customer wanted to confirm if, effectively, they are using Redirect connec...
987

Global Azure 2022 - No encuentro donde esta el problema de la query (Spanish Version Delivered)

Jose_Manuel_Jurado on May 08 2022 02:43 AM
This 7th of May, my colleague Paloma Garcia and I, delivered a session in Spanish "No encuentro donde esté el problema d...
1,160

Global Azure 2022 - Azure SQL Journey: The daily routine of a Cloud DBA (Session Delivered)

Jose_Manuel_Jurado on May 06 2022 11:32 AM
This 6th of May, my colleague Alex Nicu and I, delivered a session about Azure SQL journey: the daily routine of a Cloud...
1,150

Global Azure 2022 - How to get the most from Azure SQL Database (Session Delivered)

Jose_Manuel_Jurado on May 06 2022 01:21 AM
This last 5th of May, my colleague Sabrin Alsahsah and I, deliver a session about how to get the most advantages out fro...
1,550

Lesson Learned #202: How to reproduce and find a SQL command timeout

Jose_Manuel_Jurado on Apr 29 2022 04:46 PM
We often have support cases where our customers need to know the difference between a connectivity and an execution time...
1,637

Lesson Learned #201: Performance comparison using INSERT with and without Begin Transaction

Jose_Manuel_Jurado on Apr 26 2022 01:05 AM
Today, I worked on a case that our customer is testing a bechmark script to measure the INSERT operation in an Azure SQL...
1,415

Lesson Learned #200: Slow when fetching large volume of data compared with PYODBC.

Jose_Manuel_Jurado on Apr 22 2022 03:19 PM
A customer asked today, why using ODBC Driver 17 for SQL Server in Python with PYODBC we have a slightly difference in t...
2,723

Fixing Problematic Index Spools

Francisco_do_O on Apr 20 2022 06:02 AM
In this article we briefly share why sometimes Index Spools may have an impact on performance and what can be done to ea...

Latest Comments

Michael Bourgon
in Lesson Learned #4: Modifying the default time zone for your local time zone. on Jun 30 2022 01:42 PM
Interesting way around it, but running it through a function could cause performance issues, as shown by Jonathon Kehayias elsewhere. It's frustrating.
0 Likes
rafaelfernandez
in How-to auto-scale Azure SQL Databases on Jun 30 2022 12:55 AM
@juliocalderon Thank you for this article, for downtime, make sure that you have implemented some retry logic in the application and components that are using Azure SQL Database while the service tier is changed Serverless is a good option but it depends of your scenario
0 Likes
Yochanan_MSFT
in Using SQLPackage to import or export SQL Server and Azure SQL DB on Jun 27 2022 12:30 AM
Hi @vvasim_s - Thank you for reaching out. There is no option to control the destination path when importing. However, you can create an empty database with the size and path you want and then import to this existing empty database (if the database is not empty the import will fail) By doing that yo...
0 Likes
vvasim_s
in Using SQLPackage to import or export SQL Server and Azure SQL DB on Jun 23 2022 02:51 AM
@Yochanan_MSFT thanks for this useful information. Doubt, how can we customize data path and log path if requirement to restore bacpac on SQL server VM instance? Currently, if we use "sqlpaclage.exe /Action:Import " then Data and Log files go to default location of instance which I dont want. Thanks...
0 Likes
sd_blogs
in Get creation dates of all Azure resources under an Azure subscription on Jun 21 2022 03:31 AM
@RoshnaNazir No not specific to to storage account only. I'm looking in general for all resource "Create Time" attribute value in portal under each resource detail page.And storage account need to create when I choose to go with above solution & but I don't have that want to do that.
0 Likes