Archive
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
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
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-21)
Good day SQL folks! Thanks for visiting our blog again! Here you can find some great articles I have found for you. Here you are – this week readings. Start
DevOps workshop during the SQLDay 2018 – SQLPlayer Team
Good news! We (Kamil and I ) are going to have a full day workshop during the upcoming SQLDay 2018 in Wrocław. The workshop is dedicated to DevOps in SQL Server.
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
ASF 005: Marcin Szeliga interview
Introduction Marcin Szeliga – Data Philosopher. Since 2006 invariably awarded Microsoft Most Valuable Professional title in the Data Platform category. A speaker at numerous conferences across Europe, as well as at
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
Last week reading (2018-01-07)
Thanks for visiting the page. Hope you will find some time to read great articles I have found for you. Here you are – this week readings. Start reading on Monday morning
- 1
- 2