Month: March 2019

First published on MSDN on Jan 13, 2019

Hello,

I found several service requests that our customers are trying to proceed with a backup of a Azure SQL Managed Instance to Azure Storage Account and they are facing an error, … Continue reading Lesson Learned #55: Azure SQL Managed Instance – Backup failed for Server “servername”. Failed: 1117 -The request could not be performed because of an I/O device error→

First published on MSDN on Jan 13, 2019

Hello Team,

Some days ago, I worked in a very interesting service request.

Our customer created a Azure Active Directory group adding two members and they added this gro… Continue reading Lesson Learned #54: The specified schema name name@domain.com either does not exist or you do not have permission to use it→

First published on MSDN on Jan 12, 2019

Hello,

This week I worked in a new issue that remembered me the importance to use the dynamic management view called

dm_operation_status

in every operation that I’m doing … Continue reading Lesson Learned #53: Why do you need to use dm_operation_status dynamic management view?→

First published on MSDN on Jan 02, 2019

Hello,

Several days ago, I worked in a service request that our customer had configured all elements ( VPN, Site-to-Site, etc…) but they are getting an error:

ERROR 9009 (28000): Se… Continue reading Lesson Learned #52: Azure Database for MySQL – Server is not configured to allow ipv6 connections→

First published on MSDN on Dec 29, 2018

Some days ago, I have been working in a service request that our customer faced the following issue:

They’ve downloaded the newest version of Sqlpackage.exe tool (18.0) and they… Continue reading Lesson Learned #51: Managed Instance – Import via Sqlpackage.exe doesn’t allow autogrow→

First published on MSDN on Dec 28, 2018

Hello,

It is common to have this type of cases where our customer has millions of rows in a table and when they need to add a column and they reached the error transaction log full.
… Continue reading Lesson Learned #50: Adding PK led to transaction log full error→

First published on MSDN on Dec 03, 2018

Some customers already noticed that we are retiring Azure Service Manager REST APIs for Azure SQL Database on December 1, 2019 and may get confused about what this means. In case you haven’t seen… Continue reading Move to Azure Resource Manager REST APIs for Azure SQL Database→

First published on MSDN on Nov 20, 2018

Azure Database for PostgreSQL and MySQL have similar architectures for performance tiers. While Microsoft recommends to choose between the General Purpose and the Memory Optimized versions, some … Continue reading Understanding Performance in Basic Tier for Azure Database PostgreSQL and MySQL→