top of page
A Hard Working DBA and Much More
Home: Welcome
Search
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
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
0 comments
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
0 comments
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...
George Lin
Nov 1, 20211 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
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
0 comments
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
0 comments
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
0 comments
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
0 comments
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
0 comments
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
0 comments
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...
George Lin
Oct 30, 20213 min read
0 comments
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...
George Lin
Oct 30, 20212 min read
0 comments
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...
George Lin
Oct 30, 20216 min read
0 comments
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:...
George Lin
Oct 30, 20212 min read
0 comments
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...
George Lin
Oct 30, 20212 min read
0 comments
Home: Blog2
Home: Subscribe
Home: Contact
bottom of page