Azure SQL Managed Instance / Database Migration Service (DMS) / Online Data Migration / Migrate your database to Azure SQL Managed Instance

Posted by in Azure, SQL Server, SQL Tips and Tricks on Dec 23rd, 2019 | 0 comments
Azure SQL Managed Instance / Database Migration Service (DMS) / Online Data Migration / Migrate your database to Azure SQL Managed Instance
Using Azure Database Migration Service (DMS) you can easily migrate your databases from multiple sources to Azure Data platforms with minimal downtime. For this example we are going to use following: Azure Database Migration Service (DMS), Premium tier (4 vCores) DMS Project: Online Data Migration Source: SQL Server 2017, 8CPU, 64GB Memory Target: Azure SQL Managed Instance, 16 vCores, 80GB Memory   More details about DMS and how to download and install you can find in this MS article. First step we will be to deploy Database Migration...
read more

Azure SQL Managed Instance / Migration / Database Experimentation Assistant (DEA) / Evaluate your workload before you migrate your database to Azure SQL Managed Instance

Posted by in Azure, SQL Server on Nov 11th, 2019 | 1 comment
Azure SQL Managed Instance / Migration / Database Experimentation Assistant (DEA) / Evaluate your workload before you migrate your database to Azure SQL Managed Instance
Using Database Experimentation Assistant (DEA) you can evaluate your current production workload from your current environment and analyze how will that workload perform in your new targeted environment. For this example we are going to use following:  Source: SQL Server 2017, 32CPU, 256GB Memory Target: Azure SQL Managed Instance, BC Gen5 (16 vCores, 80GB Memory) DEA VM: SQL Server 2017,  4CPU, 32GB Memory Workload: 10minutes XE trace (XEL), size 19.9GB I will use DEA to capture, analyze and compare source and target...
read more

Azure SQL Managed Instance / Migration / Data Migration Assistant (DMA) / Assess on-premises SQL Server instance

Posted by in Azure, SQL Server on Oct 30th, 2019 | 0 comments
Azure SQL Managed Instance / Migration / Data Migration Assistant (DMA) / Assess on-premises SQL Server instance
Before we migrate our database to the cloud we need to assess our on-premises SQL Server instance and Data Migration Assistant (DMA) tool can help us with that. Using Data Migration Assistant (DMA) tool we can detect potential compatibility issues which may impact our database functionality after migration to Azure SQL managed Instance. DMA main functionalities: Discover issues that can affect an upgrade to an on-premises SQL Server Discover new features in the target SQL Server platform Migrate an on-premises SQL Server instance to a modern...
read more

Azure SQL Managed Instance / Migration from on-premises SQL Server instance to Azure SQL Managed Instance

Posted by in Azure, SQL Server on Oct 9th, 2019 | 0 comments
Azure SQL Managed Instance / Migration from on-premises SQL Server instance to Azure SQL Managed Instance
Database migration from on premises SQL Server instance (SQL Server 2017) to Azure SQL Managed Instance. With series of posts I will try to describe whole database migration process from on premise SQL Server to the cloud. First step will be to determine whether Azure SQL Managed Instance is compatible with the database requirements of business application. Step 1. Assess managed instance compatibility I used Data Migration Assistant (DMA) to detect potential compatibility issues impacting database functionality on Azure SQL managed Instance....
read more

Azure SQL Managed Instances / SSMS / Connect to SQL Managed Instance / Public Endpoint

Posted by in Azure, SQL Server, SQL Tips and Tricks on Sep 5th, 2019 | 0 comments
Azure SQL Managed Instances / SSMS / Connect to SQL Managed Instance / Public Endpoint
In the previous post we had example how to connect to Azure SQL Managed Instance from Azure VM within same VNet using private endpoint Now I will show you how to connect to the SQL Managed Instance from your remote location using public endpoint. First go to your SQL MI and select Virtual Network    Enable Public Endpoint (data) option Public endpoint provides the ability to connect to Managed Instance from the Internet without using VPN and is for data communication (TDS) only.   After enabling your SQL MI will have 2 connection...
read more

Azure SQL Managed Instances / SSMS / Connect to SQL Managed Instance / Private Endpoint

Posted by in Azure, SQL Server, SQL Tips and Tricks on Aug 30th, 2019 | 0 comments
Azure SQL Managed Instances / SSMS / Connect to SQL Managed Instance / Private Endpoint
There are different ways to connect to SQL Managed Instance using SSMS. One of the easiest ways to do that is using Private Endpoint. Azure SQL Managed Instance provides a private endpoint to allow connectivity from inside its virtual network. In this example we are going to use azure VM within the same Virtual Network as SQL Managed Instance. You should create VM inside the same VNet but different subnet. When you create SQL Managed Instance you will have following resources in you Resource Group: SQL managed instance Virtual Network Network...
read more

SQLSATURDAY 866 Auckland, New Zealand / Use PowerShell to deploy and configure Azure SQL Database (PaaS) with good resilience to outages and with integrated Azure SQL Analytics monitoring solution

Posted by in SQL Server, SQLSATURDAY on Aug 16th, 2019 | 0 comments
SQLSATURDAY 866 Auckland, New Zealand / Use PowerShell to deploy and configure Azure SQL Database (PaaS) with good resilience to outages and with integrated Azure SQL Analytics monitoring solution
Last weekend, I had the privilege of speaking at SQLSaturday Auckland 2019. It was a great pleasure being a part of this awesome event and met so many amazing people. Many thanks to all attendees and thanks to Leila Etaati, Reza Rad, Indira Bandari and everyone else for organising yet another great event! Title: Use PowerShell to deploy and configure Azure SQL Database (PaaS) with good resilience to outages and with integrated Azure SQL Analytics monitoring solution. Duration: 30 Minutes Speaker: Zoran Barac Abstract: Use one single...
read more

SQLSATURDAY 866 Auckland, New Zealand

Posted by in SQL Server on Aug 1st, 2019 | 0 comments
SQLSATURDAY 866 Auckland, New Zealand
SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. This event will be held on Aug 10 2019 at Unitec Institute of Technology, 139 Carrington Rd, Mount Albert, Auckland, Auckland, 1025, New Zealand Here you can find more information regarding this event: https://www.sqlsaturday.com/866/EventHome.aspx Here you can find more information regarding full Conference Schedule:...
read more

Auckland SQL User Group Meetup Event / Edwin M. Sarmiento, Microsoft MVP / Designing a SQL Server AlwaysOn AG Topology Without Losing Your Sanity

Posted by in SQL Server on Jul 28th, 2019 | 0 comments
Auckland SQL User Group Meetup Event / Edwin M. Sarmiento, Microsoft MVP / Designing a SQL Server AlwaysOn AG Topology Without Losing Your Sanity
15C Managing Director, Microsoft SQL Server MVP and Microsoft Certified Master from Ottawa, Edwin M. Sarmiento is coming to Auckland on August 8th to deliver a session in front of our Auckland SQL User Group! Designing a SQL Server AlwaysOn AG Topology Without Losing Your Sanity Thursday, Aug 8, 2019, 12:00 PM Microsoft New Zealand LtdLevel 5, 22 Viaduct Harbour Ave Auckland, NZ 11 database professionals Attending 15C Managing Director, Microsoft SQL Server MVP and Microsoft Certified Master from Ottawa, Edwin M. Sarmiento is coming to...
read more

PASS / Modern Migration Tour 2019 – Auckland, New Zealand

Posted by in SQL Server on May 24th, 2019 | 0 comments
PASS / Modern Migration Tour 2019 – Auckland, New Zealand
Modern Migration Tour 2019 – AUCKLAND, NEW ZEALANDhttps://www.eventbrite.ca/e/modern-migration-tour-2019-auckland-new-zealand-tickets-62011870173# LocationMicrosoft New ZealandL5 Microsoft House22 Viaduct Harbour AveAuckland 1010 Date And TimeMon, 27 May 201912:00 PM – 1:30 PM NZST Description: End of support for SQL Server 2008 is almost here (ends in July!), which means it’s time to take flight on your migration strategy. But, do you have a plan in place? What approach should you take to ensure a smooth transition? To guide you...
read more

« Previous Entries