Posts From Kamil Nowinski

Kamil Nowinski
Kamil Nowinski 165 posts

Blogger, speaker. Data Platform MVP, MCSE. Senior Data Engineer & data geek. Member of Data Community Poland, co-organizer of SQLDay, Happy husband & father.

View all posts by this author →

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

SQLGrillen 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

sp_send_dbmail fails with query result attached as file

Sometimes a message coming from SQL Server engine can be misleading and confusing. I had such cases many times and decided to put a post every time I meet it

Last week reading (2017-12-17)

How Can I Become A Microsoft MVP? Many people ask how to achieve the title, so Kevin Kline [T] answers. Forget, it’s not a recipe – just do what you