Home | George Lin

MAKE IT SIMPLE & GET IT DONE RIGHT

A Hard Working DBA and Much More

Home: Welcome

Nov 7, 20219 min read

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

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

Enterprise BI With Azure Synapse Analytics

This architecture shows how to perform incremental loading in an extract, load, and transform (ELT) pipeline. It uses Azure Synapse...

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

George Lin

Oct 30, 20213 min read

Azure Blob Lifecycle Management Part 5: Create Azure Function To Verify Existing Index Tags

Part1, Part2, Part3, Part4 Create a Timer Triggered .NET Azure function to scans all blobs in the target container and report the counts...

0 comments

George Lin

Oct 30, 20212 min read

Azure Blob Lifecycle Management Part 4: Create Azure Function To Add Index Tags on Existing Blobs

Part1, Part2, Part3, Part5 Create a Timer Triggered .NET Azure function to add required index tags to all the existing blob objects...

0 comments

George Lin

Oct 30, 20216 min read

Azure Blob Lifecycle Management Part 3: Create Azure Function to Automatically Set Blob Index Tag

Part1, Part2, Part4, Part5 GitHub Repo (currently private, available upon request): https://github.com/glindba/Add-Blob-Index-Tag-With-Az...

0 comments

George Lin

Oct 30, 20212 min read

Azure Blob Lifecycle Management Part 2: Set Up Your Local Development Environment

Part1, Part3, Part4, Part5 Step 1: Download MS Visual Studio 2019 from here: https://visualstudio.microsoft.com/downloads/ Step 2:...

0 comments

George Lin

Oct 30, 20212 min read

Azure Blobs Lifecycle Management Part 1: Solution Overview

Part2, Part3, Part4, Part5 Real-world Case: A blob container contains more than 20 millions database backup files that occupy more than...

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