JovanPop, Author at Argon Systems

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 to Managed Instance using Azure PowerShell and DbaTools. The approach used in this article is …

Automate migration to SQL Managed Instance using Azure PowerShell and DbaTools Continue Reading

Automate migration to Managed Instance using PowerShell

Automate migration to Managed Instance using PowerShell Continue Reading

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 will see how to increase performance of HammerDB workload from 20K transactions/minute to 100K-300K transactions/minute …

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

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 databases to the Azure Blob Storage container. This feature can be used for manual transfer …

Track unauthorized backups using Azure SQL Managed Instance Audits 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. One of the constraint that might be an issue is the fact that SQL Agent …

Persisting SQL Agent job history in Managed Instance Continue Reading

Azure SQL Managed Instance Business Critical tier is Generally Available

First published on MSDN on Dec 04, 2018 We are happy to announce General availability of Business Critical tier in Azure SQL Managed Instance – architectural model built for high-performance and IO demanding databases. After 5 months of public preview period Azure SQL Managed Instance Business Critical Service tier is generally available . Azure SQL …

Azure SQL Managed Instance Business Critical tier is Generally Available 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 the instance. You can use Azure CLI to easily manage size of the instance and …

Modify Azure SQL Database Managed Instance using Azure CLI Continue Reading

The easiest way to create Azure VM that can access your Azure SQL Managed Instance

First published on MSDN on Sep 21, 2018 Azure SQL Managed Instance is fully managed and secured SQL Server Database engine hosted in Azure cloud, placed in your private Azure VNet. In order to access your Managed Instance, you need to create VM in your VNet where you will access the instance using SSMS. Azure …

The easiest way to create Azure VM that can access your Azure SQL Managed Instance Continue Reading

Reaching Azure disk storage limit on General Purpose Azure SQL Database Managed Instance

First published on MSDN on Aug 20, 2018 Azure SQL Database Managed Instance General Purpose (GP) is SQL Server implementation on Azure cloud that keeps all database files on Azure storage. In this post you will learn how Managed Instance General Purpose allocates disks in the storage layer at the back end and why this …

Reaching Azure disk storage limit on General Purpose Azure SQL Database Managed Instance Continue Reading

Quick-start script: Create Azure SQL Managed Instance using PowerShell library

First published on MSDN on Jun 27, 2018 Azure SQL Database Managed Instance is a fully managed SQL Server Database Engine hosted in Azure cloud. In this post you can find a simple PowerShell script that you can use to quickly create a new Managed Instance. As a prerequisite, you would need to create VNET/subnet …

Quick-start script: Create Azure SQL Managed Instance using PowerShell library Continue Reading