Azure SQL Database Hyperscale (or Hyperscale for short) takes your database to the next level by removing size and query limitations typically found in cloud databases. Your database can scale up to 100 TB in size and handle more queries ... continue reading

Hardware generation on Azure SQL Managed Instance defines the characteristics of the underlying hardware resources. Currently, Managed Instance supports two generations Gen4 and Gen5(recommended). Some features are not supported in some generations - as an example you cannot have 4-core ... continue reading

One of the most common tasks that you are performing while migrating from SQL Server to Managed Instance is a comparison of workload performance between the source and destination instance. In this post you will see some recommended tools and ... continue reading

Monitoring CPU usage on your SQL Server or Azure SQL is one of the most important monitoring tasks in performance monitoring and troubleshooting. In addition, CPU usage is one of the most important parameters that you need to measure to ... continue reading

First published on MSDN on Nov 14, 2018 Azure SQL Managed Instance is fully-managed SQL Server Database Engine hosted in Azure cloud. With Managed Instance you can easily add/remove cores associated to the instance and change the reserved size of ... continue reading

Azure SQL Database (single database and Managed Instance) enables you to load files from Azure Blob Storage. If you experience some issue while you are loading files from Azure blob storage, here you can find the actions that can help ... continue reading

Azure SQL Managed Instance enables you to choose the amount of storage that you would need. You would need to monitor your database to see do you have enough storage to operate, and take some corrective actions if you are ... continue reading

First published on MSDN on Jan 21, 2019. Note: This version of article is adjusted for the latest Az Powershell moduleAzure SQL Database - Managed Instance is fully-managed PaaS service that provides advanced disaster-recovery capabilities. Even if you accidentally drop ... continue reading

Transparent Data Encryption (TDE) is security feature in Azure SQL Database (Single Database and Managed Instance) that transparently encrypts data pages when they are exchanged between memory and underlying storage. Managed Instance has automatic backups that are stored on Azure ... continue reading

Managed Instance takes automatic backups (full backups every week, differential every 12 hours, and log backups every 5-10 min) that you can use to restore a database to some point of time in past within the retention period, restore accidentally ... continue reading