Posts From Kamil Nowinski

Kamil Nowinski
Kamil Nowinski 32 posts

Data Architect, MCSE Data Platform, MS BI Developer, Member of PLSSUG, co-organizer of SQLDay, speaker. Happy husband & father. #SQLFamily member.

View all posts by this author →
Podcast 0 Comments

ASF 007: Cathrine Wilhelmsen interview

Introduction Cathrine loves teaching and sharing knowledge. She works as a consultant, technical architect and developer, focusing on Data Warehouse and Business Intelligence projects. Her core skills are ETL, SSIS,

Last Week Reading 0 Comments

Last week reading (2018-02-04)

Joe Caserta: Exploring Modern Data Platforms What is a key difference between data warehousing and modern data engineering on analytics platforms? Listen to one of the leading authorities on big data

Data Warehousing 0 Comments

SCD type 1 & type 2 in MERGE statement

In my previous article, I have explained what does the SCD and described the most popular types of Slowly Changing Dimensions. I also mentioned that for one process, one table,

Last week reading (2018-01-28)

SQL Server 2017 CU3 adds CXCONSUMER waits, doesn’t mention it New wait is not visible everywhere, but check where you can find it. Sabbatical and the search for a dream

Events 0 Comments

SQLBits 2017

I’ve just realized that I did not publish pictures from SQLBits 2017 on the blog. It’s time to make up for it. Here you are – quick photo relation from

Podcast 0 Comments

ASF 006: Bob Ward interview

Introduction Bob Ward is a Principal Architect for the Microsoft Data Group (Tiger Team) which owns the development and servicing for all SQL Server versions. Bob has worked for Microsoft

Last week reading (2018-01-14)

The top 7 business benefits of establishing DevOps in your organization No comments, find and understand the benefits. Columnstore Indexes – part 116 (“Partitioning Specifics”) What do you need to

Data Warehousing 1 Comment

Slowly Changing Dimensions (SCD)

In today’s article I’d would like to focus on Slowly changing dimension, aka SCD. Dimension is a word excerpted from data warehousing as such. Not without a reason SCD is used

Events 0 Comments

SQLGrillen 2017

History of certain photos… Oughh… some time has gone, I know. Anyway, only now, at the beginning of new year and exactly a half year after the event, I found a

Last week reading (2017-12-31) & Happy New Year!

Yeap, this is last day of the year 2017. So, I do not expect too many readers of this post – almost everyone is preparing to go to New Year