JovanPop

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

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 Managed Instance using PowerShell 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

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

Create database on Azure SQL Managed Instance using Azure.Rm PowerShell library

First published on MSDN on Jun 04, 2018 Azure SQL Managed Instance is a fully managed SQL Server instance hosted in Microsoft Azure cloud that enables you to work with your databases using standard TSQL or PowerShell. In this post you will see how to create your database using PowerShell. Prerequisites In Azure SQL Managed

Create database on Azure SQL Managed Instance using Azure.Rm PowerShell library Continue Reading

Configure Azure Storage for SQL Database backups

First published on MSDN on Oct 17, 2017 SQL Server 2012+ and Azure SQL Managed Instance support native BACKUP commands that can backup a database to Azure Blob Storage URL. Setting-up Azure Storage account might not be so easy as you think because there are some constraints. You can learn about backup to Azure storage

Configure Azure Storage for SQL Database backups Continue Reading

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 instances if you are on Gen4. In that case you would need to change the

Change hardware generation on Managed Instance 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 best practices that you should apply while doing performance comparison. The recommended performance comparison process

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