Opinions, tips, and news orbiting Microsoft
First published on MSDN on Jan 19, 2019
Hello,
This week I worked a service request when our customer reported
performance issues
obtaining data from
External Tables
using Azure SQL Database. They followed… Continue reading Lesson Learned #62: Using Cross Database Queries in Azure SQL Managed Instance
First published on MSDN on Jan 19, 2019
Hello Team,
This week I worked on a service request where our customer asked about the compatibility feature using schemas and partitioning, for this reason and thanks to near 100% compat… Continue reading Lesson Learned #61: Using Schemas in Azure SQL Managed Instance
First published on MSDN on Jan 19, 2019
Hello,
Time ago, we discussed in this
post
about partitioning option in Azure SQL Database.
One of the main differences creating this partition in Azure SQL Database is… Continue reading Lesson Learned #60: Using Partition Option in Azure SQL Managed Instance
First published on MSDN on Jan 19, 2019
demo
First published on MSDN on Jan 17, 2019
Hello Team,
Today, I worked on a service request that our customer asked about to use their own certificate to connect to Azure SQL Database.
Nowadays, there is not possible to us… Continue reading Lesson Learned #59: I would like to upload my own certificate to connect to Azure SQL Database.
First published on MSDN on Jan 16, 2019
Hello Team,
Time Ago I worked in a service request that our customer reported that their outbound IP has changed without any notice. Working on this issue I have found an interested situa… Continue reading Lesson Learned #58: Virtual Machine and its Load Balancer IP
First published on MSDN on Jan 15, 2019
Hello Team,
Today, I worked on a performance case that our customer claimed about a performance issue with a copied database from other one. The source database was working as they expect… Continue reading Lesson Learned #57: Bacpac export process doesn’t include the automatic statistics
First published on MSDN on Jan 13, 2019
Hello Team,
Recently I closed a service request that had the following question
Our customer created external tables to perform SQL Query across Azure SQL Database. We s… Continue reading Lesson Learned #56: External tables and performance issues