top of page
A Hard Working DBA and Much More
Home: Welcome
Search
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
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
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
Migrating Thousands Databases To Azure ONLINE? Here Is How We Got It Done - Part1: Set It Up (A)
Super efficiently migrate hundreds or even thousands database using a single comprehensive PowerShell script with minimum downtime
George Lin
Nov 7, 20219 min read
0 comments
How CE Change Should Impact SQL Queries By Examples Part 9: Implicit Data Type Conversions
Part1, Part2, Part3, Part4, Part5, Part6, Part7, Part8 Case 8: New CE assume larger number of rows from implicit data type conversions...
George Lin
Nov 1, 20211 min read
0 comments
How CE Change Should Impact SQL Queries By Examples Part 8: Distinct Value Count
Part1, Part2, Part3, Part4, Part5, Part6, Part7, Part9 Case 7: New CE changes distinct value count estimation For queries where...
George Lin
Nov 1, 20212 min read
0 comments
How CE Change Should Impact SQL Queries By Examples Part 7: Base or Simple Containment
Part1, Part2, Part3, Part4, Part5, Part6, Part8 , Part9 Case 6: New CE use "base containment" instead of "simple containment" The CE...
George Lin
Nov 1, 20212 min read
0 comments
How CE Change Should Impact SQL Queries By Examples Part 6: Complex Join Condition
Part1, Part2, Part3, Part4, Part5, Part7, Part8 , Part9 Case 5: New CE simplify the calculation for complex join condition With more...
George Lin
Nov 1, 20212 min read
0 comments
Home: Blog2
Home: Subscribe
Home: Contact
bottom of page