Azure SQL

MAKE IT SIMPLE & GET IT DONE RIGHT

A Hard Working DBA and Much More

Home: Welcome

Mar 23, 20223 min read

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:...

0 comments

George Lin

Mar 14, 20228 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...

0 comments

George Lin

Nov 16, 20211 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...

0 comments

George Lin

Nov 16, 202110 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...

1 comment

George Lin

Nov 15, 20212 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...

0 comments

George Lin

Nov 1, 20214 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...

0 comments

George Lin

Nov 1, 20211 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...

0 comments

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...

0 comments

George Lin

Nov 1, 20212 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...

0 comments

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...

0 comments

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...

0 comments

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...

0 comments

George Lin

Nov 1, 20213 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...

0 comments

George Lin

Nov 1, 20212 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...

0 comments

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...

0 comments

George Lin

Nov 1, 20215 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...

0 comments

George Lin

Oct 30, 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...

0 comments

Home: Blog2

Home: Subscribe

CONTACT

500 Terry Francois Street San Francisco, CA 94158

georgelinca@yahoo.ca

123-456-7890

Home: Contact

MAKE IT SIMPLE & GET IT DONE RIGHT

Subscribe Form

CONTACT