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

11,881 reads

Forums

STRING_SPLIT with Index as Table-Valued Function

By bteague

Comments posted to this topic are about the item STRING_SPLIT with Index as Table-Valued...

Protecting Data from the Inside

By Phil Factor

Comments posted to this topic are about the item Protecting Data from the Inside

Remove the middle of a string between wildcards

By ncraigg

I have a field called 'jsonpayload' in a table called 'auditlog' that is populated...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers