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
554

Lesson Learned #311:Error-1117 the request could not be performed because of an I/O device error

Jose_Manuel_Jurado on Jan 28 2023 09:20 AM
Our customer got the following error message performing a backup very large database to a blog storage - Error-1117 the ...
555

Lesson Learned #310: Parameter Sniffing

Jose_Manuel_Jurado on Jan 27 2023 06:03 PM
When we are using parameterized queries with object such as stored proecdure and functions, the engine can take the valu...
560

Lesson Learned #309: Create a DDL Trigger on Database in Azure SQL

Jose_Manuel_Jurado on Jan 27 2023 05:33 PM
Today, I've an interested way to add an additional logical at the moment that we create or drop a table, basically using...
389

Lesson Learned #308:Extended properties are not permitted on 'dbo.xyz', or the object does not exist

Jose_Manuel_Jurado on Jan 27 2023 05:18 PM
Today, we worked on a service request that our customer is implementing DATASYNC and they got the following error messag...
550

Lesson Learned #307:Reference to database and/or server name is not supported in this version

Jose_Manuel_Jurado on Jan 27 2023 02:24 AM
Our customer got the following error message: Msg 40515, Level 15, State 1, Line 19 - Reference to database and/or serve...
599

Lesson Learned #306: TCP Provider, error: 2 - Connection was terminated

Jose_Manuel_Jurado on Jan 27 2023 01:50 AM
In some situations, we found that our application reported the following error message: A transport-level error has occu...
519

Lesson Learned #305: Client Connection marked as broken because of SQLSTATE(08S01)

Jose_Manuel_Jurado on Jan 27 2023 12:58 AM
Today, we worked on a service request that our customer is using Hikaki pooler and time to time they got the following e...
390

Lesson Learned #304: TCP Provider, error: 35 - An internal exception was caught

Jose_Manuel_Jurado on Jan 26 2023 11:21 AM
In the last months our customers reported several connectivity issues with the error message: provider: TCP Provider, er...
550

Lesson Learned #303: Can not connect to the database in its current state.

Jose_Manuel_Jurado on Jan 25 2023 12:33 AM
Today, we worked on a service request where our customer faced the following error message: Database is currently inacce...
468

Lesson Learned #302: System.InvalidCastException: Specified cast is not valid

Jose_Manuel_Jurado on Jan 24 2023 06:33 AM
Today, we have a service request that our customer faced the following error message: System.InvalidCastException: Speci...
1,757

Lesson Learned #301:How to check the performance of my database? Resource Consumption and Wait Stats

Jose_Manuel_Jurado on Jan 22 2023 12:15 PM
In several service requests our customers asked how to check the performance of a database. During this discussion we re...
1,078

Lesson Learned #300: Exporting a database to storage account that is behind a firewall

Jose_Manuel_Jurado on Jan 22 2023 02:21 AM
In some situations, we saw that our customers are trying to export their database to a blob storage that is behind a fir...
750

Lesson Learned #299: Blocking user connections in Azure SQL Managed Instance

Jose_Manuel_Jurado on Jan 22 2023 02:05 AM
In some specific situations, our customer needs to block a connection from a single user. For example, users that they h...
1,167

Lesson Learned #298: Huge duration of database export using sqlpackage

Jose_Manuel_Jurado on Jan 21 2023 02:04 AM
We used to have situations where our customer needs to export 2 TB of data using SQLPackage in Azure SQL Database. Expor...
898

Lesson Learned #297: High SATELLITE_SERVICE_SETUP waits stats in Azure SQL Managed Instance

Jose_Manuel_Jurado on Jan 21 2023 01:46 AM
Yesterday, we got an interested service request where our customer saw SATELLITE_SERVICE_SETUP waits stat in their query...
877

Lesson Learned #296:The value of the property '' is invalid: Value does not fall within the expected

Jose_Manuel_Jurado on Jan 21 2023 01:24 AM
Today, we got an new service request that our customer is facing an error message when testing the connection in a Linke...
566

Lesson Learned #295:The specified buffer size is less than the minimum size.

Jose_Manuel_Jurado on Jan 20 2023 10:13 AM
We recently found an issue enabling an Extended Event that our customer got the following error message: Msg 25632, Leve...
643

Lesson Learned #294: Logins are not syncing in failover group

Jose_Manuel_Jurado on Jan 20 2023 12:31 AM
This is because the Login is mapped to the "master" database of each server. So, when we configure FailOver Groups, only...
602

Lesson Learned #293: Common errors connecting to Azure SQL DB using Azure Active Directory

Jose_Manuel_Jurado on Jan 19 2023 10:09 AM
Common errors connecting to Azure SQL DB using Azure Active Directory due to a firewall or DNS issues.
868

Lesson Learned #292: The database 'UserDB' has reached its size quota. Partition or delete data

Jose_Manuel_Jurado on Jan 18 2023 04:42 PM
We got a new customer service request where they got the following error message: The database 'UserDB' has reached its ...
949

Lesson Learned #291: Cannot find SSL Trust Store File connecting to Azure SQL Database

Jose_Manuel_Jurado on Jan 18 2023 04:16 PM
Our customer faced the following error message Cannot find SSL Trust Store File connecting to Azure SQL Database normall...
643

Lesson Learned #290: Elastic pool SQL server extended not able to start

Jose_Manuel_Jurado on Jan 18 2023 11:44 AM
Elastic pool SQL server extended not able to start due to a session memory limit is exceeded.
887

Lesson Learned #289: Hands-On-Labs: Understand and reading an execution plan

Jose_Manuel_Jurado on Jan 18 2023 01:49 AM
We used to have cases where our customers reported a performance problem, in the execution of a query, they need to know...
682

Read only replica corrupted statistics

Laith_Ayesh on Jan 17 2023 10:49 PM
We recently came across an issue where a select query against a read-only replica fails with one of the following errors...
1,202

Lesson Learned #288:Server principal 'XXX' is not able to access the database under current security

Jose_Manuel_Jurado on Jan 17 2023 10:52 AM
Today, we got a service request where our customer got the following error message: The server principal 'XXX' is not ab...
553

Lesson Learned #287: Contains an unresolved reference to an object due to database collation

Jose_Manuel_Jurado on Jan 17 2023 10:43 AM
Today, we worked on a new service request that our customer got the following error message exporting the database to a ...
779

Windows Authentication for SQL Managed Instance - LsaCreateTrustedDomainEx 0x549

rmaia8 on Jan 17 2023 03:44 AM
LsaCreateTrustedDomainEx 0x549 error when creating TDO
816

Subquery returned more than 1 value when open Azure Managed Instance Database properties

Mohamed_Baioumy_MSFT on Jan 15 2023 10:55 PM
Subquery returned more than 1 value when open Azure Managed Instance Database properties
1,300

Lesson Learned #286: Compilation vs Execution time running a TSQL query

Jose_Manuel_Jurado on Jan 15 2023 03:03 AM
In several situations we found that our customer reported that their query is taking too much time to execute, but, it i...
1,005

Lesson Learned #285: Why can I still telnet to port 1433?

Jose_Manuel_Jurado on Jan 15 2023 01:23 AM
Some days ago, we received a question from a customer that has a firewall rule on from selected networks on the Azure SQ...

Latest Comments

hugo_sql
in Lesson Learned #298: Huge duration of database export using sqlpackage on Jan 25 2023 11:13 AM
This blog post also helps: https://techcommunity.microsoft.com/t5/azure-sql-blog/using-data-tier-applications-bacpac-to-migrate-a-database-from/ba-p/2335643
0 Likes
victor1490
in How to create a Network trace from Azure WebApp PaaS on Jan 24 2023 02:34 PM
Has "Collect a Network Trace" feature has been removed from AppServices or is it in preview? I cannot find it.
0 Likes
Yochanan_MSFT
in Automating Azure SQL DB index and statistics maintenance using Azure Automation on Jan 12 2023 07:37 AM
This is the limit on Automation account which is limited to 3hrs exactly. Runbook execution in Azure Automation | Microsoft Learn however, by default on the next execution the maintenance will resume its work as the state of the operation is kept in the database. so, in case the job terminated by th...
0 Likes
tjestesjr
in Automating Azure SQL DB index and statistics maintenance using Azure Automation on Jan 12 2023 07:20 AM
Yochanan, Thank you for the write-up and the detailed information, it is most helpful. I have setup a new runbook and schedule per the instructions and the runbook ran as I can see the AzureSQLMaintenanceLog table with entries in the database, but I am not seeing any details in the Runbook Output. A...
0 Likes
sam-mfb
in Principle 'XYZ' could not be found or this principal type is not supported - Azure SQL DB and MI on Jan 12 2023 01:23 AM
If you are trying to do this in Powershell (or via any other mechanism where the SQL cmd executes quickly after the AAD object creation), you may find this fails on the first few tries because of a lag in AAD syncing, as documented in this old, but still open, issue. In other words, it takes some ti...
0 Likes