John Liu Blog

Every drop counts

2026

01/23 — Grant user access to Azure MSDN subscription
01/23 — Fabric Capacity
01/09 — Fabric Mirrored SQL Server Data Gateway Issue

2025

12/30 — Generate Self-signed Certificate
12/27 — Fabric KQL Database
12/26 — SQL Read Parquet File
12/26 — SQL Generate Parquet File
12/25 — SQL Server Change Tracking (CT)
12/25 — SQL Server Change Data Capture (CDC)
12/25 — SQL export to Parquet file
11/02 — SQL Server MCP
10/26 — Create embeddings in SQL2025
09/07 — SQL Server Scientific Notation
08/15 — Extract Excel Columns
08/15 — Convert Excel to CSV
06/04 — SQL Query External Dta
05/19 — Spark examples
02/15 — Snowflake notes

2024

12/18 — Fabric Study Notes
08/14 — SQL Server Firewall
08/13 — Fabric References
08/07 — Power BI Dynamic Parameter in Direct Query
08/06 — Power BI M functions
07/29 — Power Automate Remove Elements from JSON Array
07/27 — Excel Tips
07/25 — SQL Server Replication Setup
07/24 — Reallocate Windows Recovery Partition
07/23 — Windows settings - GodMode
07/17 — PowerShell script to update hosts file
07/17 — PowerShell File Format Conversion
07/10 — VS Community 2019 Installer
07/09 — Hyper-v: Convert Generation 1 VM to Generation 2 VM
04/25 — Install Python Library in Visual Studio Code
03/26 — Power Automate with Snowflake
03/26 — Power Automate notes
03/05 — Setup R and Python on SQL Server 2022
02/28 — Power Automate retry policy interval setting
02/26 — Data API Builder notes
02/21 — Qt Designer notes
02/04 — QGIS get data from API
02/04 — Python cheatsheet
01/14 — Run container in Azure VM

2023

10/14 — SQL Playground Setup
10/14 — Hyper-v: Connect Host and Guest
09/21 — Power BI Embed Report in Application
09/17 — Power BI Smart Axis
09/17 — Power BI Page Navigation
09/17 — Power BI Auto Select KPI using Field Parameter
09/17 — Hugo Tips
09/09 — Power Platform ADFS Authentication
09/09 — Azure SQL DB call external API
09/09 — Azure Cosmos DB study notes
08/17 — SQL Server Run Different Version of Python
07/20 — Power BI Excel file
07/19 — Azure Cosmos DB Emulator
07/16 — Docker Cheat Sheet
07/07 — SQL Count DISTINCT with partition
07/07 — SQL CLR
07/01 — PowerShell export data to file
06/18 — SQL Server Relocate Tempdb file location
06/16 — Docker notes
06/11 — SQL Server with minimal configuration
06/05 — Azure OpenAI Troubleshooting
05/01 — SSMS Default Query Template
04/10 — How to convert a single-client database to multi-client database
04/09 — SQL Server Performance tool scripts
03/23 — SQL Agent Job Name
03/19 — SQL Server File Size
03/17 — SSMS Extensions
03/01 — SQL Server Extended Events
02/23 — Power BI hierarchy
02/23 — Power BI CALCULATE() examples
01/28 — Configure application auto start after reboot
01/24 — SQL Server Session Settings

2022

12/23 — SQL Server Python integration
12/23 — Power BI notes
10/27 — Check SQL DB size and free disk space
10/26 — Draw digram using Mermaid
09/06 — SQL Server Replication
09/05 — Remove SQL Server Replication
07/22 — Power BI DAX handle duplicate values
07/22 — Linked Server DTC
07/19 — Upgrade SQL SSISDB
04/16 — Power Automate extract email alias address
03/29 — Power Automate file contents base64
03/24 — Power BI Date Table
03/07 — Automate email process
03/03 — Reset Brother printer drum count
01/05 — Find out the actual public IP address

2021

12/30 — Disable Chrome incognito mode
12/21 — Wi-fi connection issue
12/16 — HttpWebRequest SSL/TLS error
12/16 — Change NIC category
11/27 — Regex
11/25 — SQL error
11/24 — SQL NoLock query hint
11/22 — SQL Wait Statistics
11/21 — SQL Execution Plan
11/17 — SQL Server on Azure VM
11/15 — SQL string split
11/14 — SQL database roles
11/11 — SQL Table Expression
11/09 — Software working with Azure SQL Database
11/08 — SQL Server Geometry data conversion
11/07 — SQL Server on Azure config best practice
11/07 — Availability % and downtime mapping
11/05 — Some networking commands
11/02 — Small table big performance impact
11/01 — Azure sign-in methods in PowerShell script
07/25 — Run VMWare and Docker on the same computer

2019

12/26 — VMWare p2v keyboard not working

2007

11/07 — Effectively mapping primary key – foreign key relations