John Liu Blog

Every drop counts

Config Claude Desktop with DeepSeek

UPDATE: Add a system environment variable using name “NODE_ENV” with value “production” and restart Claude Desktop. Now you can directly add only DeepSeek models to the model list without need to manually modify the config json file mentioned in this post: deepseek-v4-pro deepseek-v4-flash ====================================== To use DeekSeek v4 in Claude Desktop, enable Developer mode in Claude Desktop first. Top left conor main menue –> Help –> Troubleshooting –> Enable Developer Mode.

Posted by John Liu Sunday, May 17, 2026

Terraform Notes

We use Terraform template to reliably deploy Azure resource. Terraform is not an “installable” program. Simply download from Terraform Downloads page the Windows AMD64 zip file and extract the terraform.exe binary and execute it. To initiate terraform terraform init To test/check what the template will change (add/change/destroy) terraform plan To deploy resources in the template terraform apply To remove all resources in the template terraform destory To import existing resources into the templace.

Posted by John Liu Monday, February 23, 2026

Azure Functions Notes

Some Azure function related articals. References: Azure Functions: The Serverless Powerhouse

Posted by John Liu Wednesday, February 18, 2026

Power Automate with Excel

When we work with Excel in Power Automate, we might need to remove the filter on worksheet to be able to create a data table. If filter is enabled, Excel Online for Business connector might not be able to create a data table. We can create Office Script within Excel Online for Business. To save the script so Power Automate can use it, we must open the file in Excel Online (the web version).

Posted by John Liu Friday, February 13, 2026

SQL 2025 Gotcha

SQL 2025 is GA and SQL 2016 is on it’s end of life on Jul 14, 2026. Some changes in SQL 2025 might break things working before. SQL 2025 uses MSOLEDBSQL 19, and its defaults are different from what we have been using, like with old SQL Native Client (SQLNCLI). In SQL 2025, encrypt is on by default, trust server certification is off by default, and it enforces strick certificate chain validation.

Posted by John Liu Monday, February 9, 2026

FEATURED TAGS
agent ai api automation availability availability-sets availability-zones aws-vm azure azure-automation-runbook azure-blob azure-cosmos-db azure-data-lake azure-deployment azure-function-app azure-functions azure-openai azure-sign-in azure-site-recovery azure-sql-database azure-subscription azure-vm base64 certificate change-data-capture change-tracking chrome claude-code-desktop clr container cte data-api-builder data-conversion data-gateway database-mail database-role database-size date-table dax db-config deepseek derived-table diagram direct-query disk-management disk-space docker downtime dtc dynamic-m-parameter embedding encrypted-connection excel excel-online excel-online-for-business execution-plan extended-events external-data fabric fabric-capacity failover-cluster fk geometry hierarchy httpwebrequest hugo hyper-v incognito-mode index infrastructure inline-tvf json kql lakehouse linked-server live-query-statistics llm-model locking m machine-learning machine-learning-model machine-learning-services master-key mcp mdx memory memory-grant mermaid mirrored-sql-server network network-card network-category office-script onedrive onnx-runtime openrowset p2v parquet performance polybase power-automate power-bi power-bi-report-tricks power-platform power-query powershell printer public-ip-address pyspark python qgis qt-designer query-performance query-plan query-troubleshooting r regex replication route s3 schema-design scripting self-signed-certificate server-role sharepoint snowflake software-development sofware-development spark sql sql-2025 sql-agent sql-availability-group sql-error sql-failover-cluster-instance sql-index sql-openjson sql-permission sql-recovery sql-script sql-security sql-server sql-server-admin sql-server-config sql-statistics ssis ssisdb ssl ssl/tls-error ssms table-expression tempdb terraform tips troubleshooting unicode view visual-studio visual-studio-code vmware wait-statistics wi-fi-connection-issue windows-settings