Select Page
backup-database-audit.PNG

Track unauthorized backups on Azure SQL Database Managed Instance using Auditing

Azure SQL Database Managed Instance provides T-SQL surface area functionalities that are very close to the SQL Server functional surface area. One of the SQL Server feature that is available in Managed Instance is taking the COPY_ONLY backups of the ... continue reading
backup-database-audit.PNG

Track unauthorized backups on Azure SQL Database Managed Instance using Auditing

Azure SQL Database Managed Instance provides T-SQL surface area functionalities that are very close to the SQL Server functional surface area. One of the SQL Server feature that is available in Managed Instance is taking the COPY_ONLY backups of the ... continue reading

Automate migration to SQL Managed Instance using Azure PowerShell and DbaTools

In Azure cloud, you can easily migrate your databases from SQL Server on-premises or Azure VMs to fully-managed PaaS database service – Azure SQL Managed Instance. In this post you will see how to create PowerShell scripts that automate migration ... continue reading

Automate migration to Managed Instance using PowerShell

In Azure cloud, you can easily migrate your databases from SQL Server on-premises or Azure VMs to fully-managed PaaS database service – Azure SQL Managed Instance. In this post you will see how to create PowerShell scripts that automate migration ... continue reading
io-perf.png

Increase data file size to improve HammerDB workload performance on General Purpose Managed Instance

General Purpose tier of Managed Instance uses Azure Premium Storage to store database files. In Azure Premium Storage IO performance depends on the file size. Increasing file size might be easy way to improve your performance. In this post you ... continue reading
backup-database-audit.PNG

Track unauthorized backups using Azure SQL Managed Instance Audits

Azure SQL Database Managed Instance provides T-SQL surface area functionalities that are very close to the SQL Server functional surface area. One of the SQL Server feature that is available in Managed Instance is taking the COPY_ONLY backups of the ... continue reading

Native database backup in Azure SQL Managed Instance

First published on MSDN on Oct 16, 2017 Azure SQL Managed Instance is a new fully managed PaaS offering in Azure cloud that will be publicly available in the near future. It will expose entire SQL Server Instance, support almost ... continue reading

Persisting SQL Agent job history in Managed Instance

First published on MSDN on Sep 20, 2018 Azure SQL Managed Instance is a fully managed SQL Server hosted in Azure cloud. Although it supports many SQL Server features, there are some constraints compared to SQL Server that you manage ... continue reading

Modify Azure SQL Database Managed Instance using Azure CLI

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

Analysing inventory of Managed Instances using T-SQL

First published on MSDN on Oct 01, 2018 Sometime you would need to know how many Managed Instance you have created in Azure cloud. Although you can find all information about the Azure SQL Managed Instances in Azure portal or ... continue reading