Select Page

Change hardware generation on Managed Instance

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

The best practices for performance comparison between Azure SQL Managed Instance and SQL Server

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
SSMS Server Dashboard - CPU.png

Monitor CPU usage on SQL Server and Azure SQL

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
Storage firewall.png

Troubleshooting BULK INSERT and OPENROWSET issues on Azure SQL Database

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

Troubleshooting potential file and storage issues on Managed Instance

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

Restore dropped database on Azure SQL Managed Instance

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

Take a COPY_ONLY backup of TDE protected database on Azure SQL Managed Instance

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

Troubleshooting potential backup/restore issues on Azure SQL Managed Instance

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

Take a backup of TDE protected database on Azure SQL Managed Instance

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. One of the current constraints in TDE protected databases in ... continue reading

Do you need more memory on Azure SQL Managed Instance?

Azure SQL Managed Instance is fully-managed SQL Server database engine where you can easily choose the size of the instance with the amount of resources you want to use. Sometime, it is hard to determine what instance size you need ... continue reading