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

In some specific situations, our customer needs to block a connection from a single user. For example, users that they have to connect to the secondary replica using ApplicationIntent=Readonly but they are not doing this change in the connection string… Continue reading Lesson Learned #299: Blocking user connections in Azure SQL Managed Instance

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

We used to have situations where our customer needs to export 2 TB of data using SQLPackage in Azure SQL Database. Exporting this amount of data might take time and following we would like to share with you some best practices for this specific scenari… Continue reading Lesson Learned #298: Huge duration of database export using sqlpackage

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

Yesterday, we got an interested service request where our customer saw SATELLITE_SERVICE_SETUP waits stat in their query execution time. This wait stat is regarding about external execution scripts.
 
Our customer found several performance is… Continue reading Lesson Learned #297: High SATELLITE_SERVICE_SETUP waits stats in Azure SQL Managed Instance

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

Today, we got an new service request that our customer is facing an error message when testing the connection in a Linked Service to Azure SQL MI from ADF:” The value of the property ” is invalid: ‘Value does not fall within the expected ran… Continue reading Lesson Learned #296:The value of the property ” is invalid: Value does not fall within the expected

ACE Your Microsoft Associate Certification and FREE Certification Vouchers

 
Ready to take your Microsoft Fundamentals knowledge to the next level or you are journey to attain professional Microsoft Certifications? You’ve come to the right place!The normal journey with certifications is to start off with the basics i.e…. Continue reading ACE Your Microsoft Associate Certification and FREE Certification Vouchers