Toggle navigation
John Liu Blog
Home
ARCHIVE
ABOUT
John Liu Blog
Every drop counts
2025
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
—
Microsoft 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
FEATURED TAGS
ai
api
automation
azure
azure cosmos db
azure openai
azure vm
base64
dax
docker
excel
execution plan
hyper-v
infrastructure
m
machine learning
machine learning services
network
network card
performance
power automate
power bi
power bi report tricks
power query
powershell
python
qgis
query performance
regex
replication
snowflake
sql
sql script
sql server
sql server admin
sql server config
ssl
ssms
troubleshooting
unicode
vmware