top of page
A Hard Working DBA and Much More
Home: Welcome
Search
George Lin
Nov 10, 20220 min read
0 comments
George Lin
Nov 10, 20220 min read
0 comments
Migrate SQL Server databases to SQLMI through Log Replay Service (In Preview)
MS official document about LRS : https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/log-replay-service-migrate Step 1:...
George Lin
Mar 23, 20223 min read
0 comments
Migrate SQL Server Always ON Availability Group (AG) to use Group Managed Service Account (gMSA)
For detailed introduction about Group Managed Service Account, click here. Key concepts help understand gMSA: A Standalone Managed...
George Lin
Mar 14, 20228 min read
0 comments
Query Azure VM Metadata Through IMDS
For details about IMDS: Azure Instance Metadata Service for Windows - Azure Virtual Machines | Microsoft Docs First, check out the most...
George Lin
Jan 21, 20222 min read
0 comments
Azure Network How To With PowerShell
Task 1: Create a list shows following information in an Azure subscription: Resource Group Name Virtual Network Name Virtual Network...
George Lin
Nov 18, 20212 min read
0 comments
Azure SQL How To - SQL Managed Instance
Task 1: Copy encryption certificate on SQL Server to SQL MI On the source SQL Server machine, in a query window, run script below to...
George Lin
Nov 16, 20211 min read
0 comments
Automatic Alerting High IO Latency On Azure SQL Managed Instances
This article shows my way of monitoring database disk IO latency on General Purpose SQL MI. To learn why IO latency could be a big...
George Lin
Nov 16, 202110 min read
1 comment
Azure SQL How To - SQLVM
Task 1: For licensing purpose, collect the following information of all SQLVMs in the subscription and put the report in an Excel...
George Lin
Nov 15, 20212 min read
0 comments
Create AAA Hybrid Worker Group On VMSS With PowerShell - Part 4
Part 1, Part 2, Part 3, Step 24: Configure VMSS OS custom data First, create a template custom data file named VMSSConfig.txt in...
George Lin
Nov 14, 20215 min read
0 comments
Create AAA Hybrid Worker Group On VMSS With PowerShell - Part 3
Part 1, Part 2, Part4 Step 15: Enable Termination Notifications on VMSS This is a key feature which actually makes VMSS suitable for...
George Lin
Nov 14, 20214 min read
0 comments
Create AAA Hybrid Worker Group On VMSS With PowerShell - Part 2
Part 1, Part 3, Part4 Step 8: Test importing an automation runbook Create a PowerShell script named MytestRunbookScript.ps1 containing...
George Lin
Nov 13, 20214 min read
0 comments
Create AAA Hybrid Worker Group On VMSS With PowerShell - Part 1
Part 2, Part 3, Part4 What is AAA? Azure Automation Account Why Hybrid Work Group? Runbooks in Azure Automation can run on either an...
George Lin
Nov 13, 20215 min read
0 comments
Migrating Thousands Databases To Azure ONLINE? Here Is How We Got It Done - Part4: Sh!t Happens (B)
Part1(A),Part1(B),Part2 ,Part3(A),Part3(B),Part3(C) Part4(A), Note: all the real Azure resource names in the error messages posted below...
George Lin
Nov 12, 20217 min read
0 comments
Migrating Thousands Databases To Azure ONLINE? Here Is How We Got It Done - Part4: Sh!t Happens (A)
Part1(A),Part1(B),Part2 ,Part3(A),Part3(B),Part3(C) Part4(B) Note: all the real Azure resource names in the error messages posted below...
George Lin
Nov 12, 20217 min read
0 comments
Migrating Thousands Databases To Azure ONLINE? Here Is How We Got It Done - Part3: Get It Going (C)
Part1(A), Part1(B) Part2 ,Part3(A), Part3(B), Part4(A), Part4(B) The Other Actions As you may have already noticed, there are some other...
George Lin
Nov 11, 20213 min read
0 comments
Migrating Thousands Databases To Azure ONLINE? Here Is How We Got It Done - Part3: Get It Going (B)
Part1(A), Part1(B) Part2, Part3(A), Part3(C), Part4(A), Part4(B) Step 8, Automatically Create 100 DMS Activities In the same "Please...
George Lin
Nov 11, 20216 min read
0 comments
Migrating Thousands Databases To Azure ONLINE? Here Is How We Got It Done - Part3: Get It Going (A)
Super efficiently migrate hundreds or even thousands database using a single comprehensive PowerShell script with minimum downtime
George Lin
Nov 9, 20216 min read
0 comments
Migrating Thousands Databases To Azure ONLINE? Here Is How We Got It Done - Part2: Configuration
Part1(A), Part1(B), Part3(A), Part3(B), Part3(C), Part4(A), Part4(B) The key to understand this solution is to understand how the rows in...
George Lin
Nov 8, 20213 min read
0 comments
Migrating Thousands Databases To Azure ONLINE? Here Is How We Got It Done - Part1: Set It Up(B)
Part1(A), Part2 ,Part3(A), Part3(B), Part3(C), Part4(A), Part4(B) 8. Configure Azure Key Vault The PowerShell scripts used by this...
George Lin
Nov 8, 20215 min read
0 comments
Home: Blog2
Home: Subscribe
Home: Contact
bottom of page