Opinions, tips, and news orbiting Microsoft
First published on MSDN on Nov 20, 2018
One of the common MySQL server errors is “MySQL server has gone away”.
This is a pretty generic error and can happen because of a server error or a client-side error. While Azure has automat… Continue reading Azure Database for MySQL server has gone away
First published on MSDN on Nov 20, 2018
Scaling up from Basic Tier to General Purpose or Memory Optimized servers
is not supported
and the only way to achieve this is by exporting your databases from your Basic Tier server a… Continue reading How to Scale up Azure Database for MySQL from Basic Tier to General Purpose Tier
First published on MSDN on Nov 20, 2018
If you try to create more than 4 geo-replicas in the Portal it will fail with the error message ”
Replication limit reached. The database ‘XXXXX’ cannot have more than 4 replication re… Continue reading Azure SQL DB with more than 4 readable secondaries
First published on MSDN on Nov 14, 2018
How to cross-database query in Azure SQL Database
Explanation of this guide:
This guide will cover the basics on how to create an external table reference f… Continue reading Cross-database Query in Azure SQL Database
First published on MSDN on Nov 13, 2018
Consider that you have configured the LTR Backup for your Azure SQL Database and you are not able to view it on the Portal.
Figure 1: LTR configure policies pane
… Continue reading Unable to view LTR Backups for Azure SQL Database servers
First published on MSDN on Nov 09, 2018
When you are creating a new database you can change the collation in the portal
Or else using TSQL (
https://docs.microsoft.com/en-us/sql/relational-databases/collations/se… Continue reading Change collation of existing Azure SQL database
First published on MSDN on Nov 07, 2018
If you go to servers and select database name it will be opened a window to allow you configure LTR policies, but then these options are not saved.
Reproduction steps:
… Continue reading Long Retention policies configuration are not saved
First published on MSDN on Nov 02, 2018
Understanding Dynamic Data Masking.
When dynamic data masking is applied, the main objective is to limit the exposure of confidential information to users who do not have the neces… Continue reading Understanding Dynamic Data Masking in Azure SQL DB