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
360

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

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

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

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

Lesson Learned #207: Hands-On-Labs: 40613-Database ‘xxx' on server ‘xxxx' 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 ‘xxxx' on server ‘xxxx' is n...
658

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

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

How to restore database using LTR backups with PowerShell

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

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

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

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

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
1,979

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

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

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

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

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

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

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

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

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

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

VA Failed message: Could not authenticate to storage account 'storageaccount.blob.core.windows.net'

Mohamed_Baioumy_MSFT on Apr 20 2022 03:55 AM
In this article we share a live experience from working on support cases with customers for issue affecting update vulne...
1,100

Lesson Learned #199:Collect data for performance comparison Azure SQL Managed Instance vs SQL Server

Jose_Manuel_Jurado on Apr 18 2022 01:16 PM
Today, I worked on a customer service request that they are comparing workload between Azure SQL Managed Instance and SQ...
1,051

Lesson Learned #198: Getting the error "has an unresolved reference to object " exporting to bacpac

Jose_Manuel_Jurado on Apr 18 2022 09:03 AM
When you are exporting a bacpac you could face the following error message: "Error SQL71562: Error validating element [d...

Latest Comments

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
RoshnaNazir
in Get creation dates of all Azure resources under an Azure subscription on Jun 21 2022 03:05 AM
@sd_blogs Are you talking about the creation of a storage account for cloud shell?
0 Likes
Raviteja_Devarakonda
in Learning from Expertise#10: Why no restore point available?! on Jun 17 2022 01:19 AM
Your appreciation means a lot. Rest assured that we will continue to do best and keep our customers happy.
0 Likes