Opinions, tips, and news orbiting Microsoft
First published on MSDN on Jan 28, 2019
The latest version of SQLPackage supports migration to Azure SQL Managed Instance (MI) from multiple SQL sources such as Azure SQL Database.
Export:
Following the below st… Continue reading How to Migrate Azure SQL Database to Azure SQL Managed Instance
First published on MSDN on Jan 25, 2019
Hello,
Yesterday, I worked in a support case that our customer needs to review the connection and if possible the execution time spent for
Azure Database for PostgreSQL
using
… Continue reading Lesson Learned #68: Azure Database – SQL Connectivity Checker
First published on MSDN on Jan 23, 2019
Hello,
Today I worked in a service request when our customer tries to connect using
SSH to the 1433 port from a Linux environment
using a JumpBox in Azure to perform the c… Continue reading Lesson Learned #67: Azure SQL Database – SSH, VNET and Firewall
First published on MSDN on Jan 23, 2019
Hello Team,
I worked on a service request where our customer faced a connectivity issue using Active Directory- Universal with MFA authentication. After our basic troublesh… Continue reading Lesson Learned #66: Azure Active Directory – Universal with MFA authentication – Output Window Trace Level
First published on MSDN on Jan 22, 2019
One of the many great features of Azure SQL Database is the ability to scale up or down depending on the amount of workload an instance is processing, which means there is greater control of the … Continue reading How to auto-scale an Azure Database for MySQL/PostgreSQL instance with Azure run books and Python
First published on MSDN on Jan 21, 2019
Today, I worked on a service request when our customer is using the option to Scale Out to connect to the secondary replicas without creating Geo-Replication. Right now, in Premium and vCore… Continue reading Lesson Learned #65: Azure SQL Database – Using Read Scale Out option
First published on MSDN on Jan 21, 2019
Hello,
I worked on a case that our customer tried to use an external table to retrieve data and they got the error: ‘The type ‘xml’ is not supported with external tables for sharded data…. Continue reading Lesson Learned #64: Azure SQL Database – ‘The type ‘xml’ is not supported with external tables for sharded data.’
First published on MSDN on Jan 19, 2019
The answer is Yes!!! and to create it you only need to follow up the instructions provided in this
URL
Unfortunately, nowadays, you only are able to use the SQL provider… Continue reading Lesson Learned #63: It is possible to create Linked Server in Azure SQL Managed Instance?