Select Page

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

Troubleshooting Database Mail issues in Azure SQL Managed Instance

Azure SQL Database - Managed Instance enables you to directly send the email messages to the external email servers. You can send email messages directly using sp_send_dbmail procedure or via SQL Agent Jobs as alerts. Learn more about Database Mail ... continue reading

Do you need to 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