Currently Browsing: Azure

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

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 Service. Specify a name for the database migration service, and...
read more

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

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 workloads.  More details about DEA and how to download and install...
read more

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

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 SQL Server instance If you want to find more details about...
read more

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

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. I was looking for any compatibility issues such as breaking...
read more

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

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 strings, private and public For the remote access via public...
read more

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

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 security group Route table Virtual cluster As well you will...
read more

Azure / PowerShell / Deploy Azure SQL database DR environment (PaaS) using PowerShell

Azure / PowerShell / Deploy Azure SQL database DR environment (PaaS) using PowerShell
Script Download: The script with usage example is available for download from https://gallery.technet.microsoft.com/Deploy-Azure-SQL-DR-47dfa7f7 Summary: Use PowerShell to create cloud DR environment using Azure SQL Databases (PaaS) and send Email Report with the connection string details   Description: Use PowerShell to deploy cloud service with Azure SQL Database (PaaS) with good resilience to outages (GEO Replications, Failover Groups) PowerShell: Connect to Azure Account, Use existing or create new Resource Group, Create primary Azure Logical SQL Server, Set an admin login and password for...
read more

Azure / SQL Server / Rename an Azure SQL database

Azure / SQL Server / Rename an Azure SQL database
We had one customer who was moving his Azure SQL Database from Elastic Pool to Standalone Database. At the same time, he wanted to change database name as well. Azure database was part of an existing failover group (two elastic pools) and geo-replicated to the new future Azure SQL Server. Changing the database name is not allowed if the database is part of the replication   If the database is not part of replication we can use two different approaches to rename it, using: SQL Server Management Studio or Transact-SQL Note: This refers just to users databases   USING SQL Server Management...
read more

Azure / SQL Server / This location is not available for subscription

Azure / SQL Server / This location is not available for subscription
During deployment of Azure SQL Server in Canada East location (new Azure Subscription) I got the following error: Using Azure Portal   Using Powershell   At the same time if I list all available azure location for the current subscription I can see that Canada East is there Get-AzureRmLocation | select displayname   The reason is that Canada East region is not activated for my new Azure Subscription. To resolve this issue just contact the Azure support to have this enabled for you. You can do this for free using support page on your Azure Portal.   Open a new support request  ...
read more

Powershell / Azure Automation / Delete older Containers from Azure Storage Account

Powershell / Azure Automation / Delete older Containers from Azure Storage Account
This will be a simple example of how you can delete older containers in the Azure storage account. I will use Azure automation to scan storage containers and delete those matching the certain date pattern. First, you need to choose an existing one or create new automation account to run your Runbooks   You should put the script within your Runbooks under the process automation. You will have some useful tutorial Runbooks as well.   We will use connection name with information needed to authenticate with Azure so that we can manage Azure classic resources from...
read more

« Previous Entries