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
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
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
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
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
SQL Server Statistics Issues Part1
Key Concepts About Statistics: Statistics are binary large objects (BLOBs) stored in the database metadata Statistics contain statistical...
George Lin
Nov 1, 20214 min read
SQLMI TDE with: Service-Managed Certificate .VS. Azure Key Vault Key
Basic Concepts: Transparent Data Encryption (TDE) performs encryption and decryption of the database, associated backups, and transaction...
George Lin
Nov 1, 20211 min read
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
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
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
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
How CE Change Should Impact SQL Queries By Examples Part 5: Multiple Join Condition
Part1, Part2, Part3, Part4, Part6, Part7, Part8 , Part9 Case 4: New CE estimate multiple join conditions differently For joins with a...
George Lin
Nov 1, 20212 min read
How CE Change Should Impact SQL Queries By Examples Part 4: Simple Join Calculation
Part1, Part2, Part3, Part5, Part6, Part7, Part8 , Part9 Case 3: New CE calculates simple join differently For joins with a single...
George Lin
Nov 1, 20213 min read
How CE Change Should Impact SQL Queries By Examples Part 3: Ascending Key Problem
Part1, Part2, Part4, Part5, Part6, Part7, Part8 , Part9 Case 2: New CE understands maximum value might be higher than when statistics...
George Lin
Nov 1, 20212 min read
How CE Change Should Impact SQL Queries By Examples Part 2: Filtered Predicates
Part1, Part3, Part4, Part5, Part6, Part7, Part8 , Part9 This article series describe some example cases that benefit from the...
George Lin
Nov 1, 20212 min read
How CE Change Should Impact SQL Queries By Examples Part 1: Basic Concepts
Part2, Part3, Part4, Part5, Part6, Part7, Part8 , Part9 Introduction Microsoft introduced the first major redesign of the SQL Server...
George Lin
Nov 1, 20215 min read
SQL Server Login Password Rotation: Fully Automated
Solution Description: The passwords are created randomly using PowerShell API and are always kept in a secure Azure key vault as a secret...
George Lin
Oct 30, 20215 min read
Home: Blog2
Home: Subscribe
Home: Contact
bottom of page