Harsh Bhaiya


SQLServerCentral Article

Generating Surrogate-Keys for Type 1 and Type 2 dimensions using SSIS

We published a very interesting article about data warehousing in the SQL Server Standard awhile back. However the article was abridged and the author, a very respected data warehousing professional asked that we publish the entire thing here. So we bring you Harsh Bhaiya's very popular ETL treatise.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-01-10

13,399 reads

Blogs

Power BI Fun With Travels

By

I’m back from a great vacation. I had the chance to visit two new...

DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods

By

Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...

T-SQL Tuesday #203: Risk and Reward

By

This is timely, as I’m currently on a boat in the Adriatic taking a...

Read the latest Blogs

Forums

Communication, For Incidents and Life

By Pat Wright

Comments posted to this topic are about the item Communication, For Incidents and Life

PostgreSQL psql Meta Commands: Tables

By Grant Fritchey

Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables

Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server

By john.martin

Comments posted to this topic are about the item Building a Support Ticket Triage...

Visit the forum

Question of the Day

PostgreSQL psql Meta Commands: Tables

Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?

See possible answers