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

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-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

SQLDay 2 Comments

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 0 Comments

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

Podcast 0 Comments

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

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

Last Week Reading 0 Comments

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