Hang Liu

With over 25 years of experience in database technology, I've excelled across diverse industries such as Financial Services, CRM, Retail, Entertainment, and Healthcare. Currently serving as a Data Architect at Healthcare Logic in Gold Coast, Australia, I embarked on my BI/DW journey in 2005. Bringing 15+ years of expertise in BI/DW, data analysis, and report development, I leverage technologies like SQL Server, Azure, Oracle, and Power BI. Actively contributing to the global DW community, I share insights on the Kimball Forum: http://forum.kimballgroup.com/spa/hang

All authors

All authors

Blogs

Advice I Like: Pyramid Schemes

By

If someone is trying to convince you it’s not a pyramid scheme, it’s a...

Using Prompt AI for a Travel Data Analysis

By

I was looking back at my year and decided to see if SQL Prompt...

FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency

By

In the era of cloud-native applications, Kubernetes has become the default standard platform for...

Read the latest Blogs

Forums

Database file shrink issue.

By Tac11

Hi experts, I have a 3+ TB database on a 2019 sql server which...

The North Star for the Year

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The North Star for the...

Multiple Escape Characters

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Escape Characters

Visit the forum

Question of the Day

Multiple Escape Characters

In SQL Server 2025, I run this code (in a database with the appropriate collation): 

SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned?

See possible answers