Harsh Bhaiya


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.

2007-01-10

12,620 reads

Blogs

Daily Coping 13 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Converting a SQL Server Docker image to a WSL2 Distribution

By

Windows Subsystem for Linux is probably my favourite feature of Windows 10. It gives...

Everyone Run a SQL Saturday in 2021

By

With SQL Saturdays being rebooted, and the SQLSaturday.com website live, it’s time for events....

Read the latest Blogs

Forums

Error installing SQL Server 2014 (both 32 & 64 bit versions)

By Michele65

During installation of SQL Express Server 2014 i have this error Title: Microsoft SQL...

Linked server to Access accdb database

By richardmgreen1

Hi all   We've got a linked server from SQL 2016  to an accdb...

performance tuning

By rohitkocharda

Hi everyone, Any good suggestion to tune below query:   --CREATE NONCLUSTERED INDEX nonclust_code...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers