Posts From Kamil Nowinski

Kamil Nowinski
Kamil Nowinski 39 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 009: Pedro Lopes interview

Introduction Pedro Lopes is a Senior Program Manager in the Database Systems Group, based in Redmond, WA, USA. He over 15 years of industry experience. He is currently responsible for Program

T-SQL Tuesday 2 Comments

T-SQL Tuesday #101: My Essential SQL Server Tools

April 2018 is the 101st episode of T-SQL Tuesday – and it’s my second contribution in the series (damn it, I’m still working on my constant frequency of writing) This

Last Week Reading 2 Comments

Last week reading (2018-04-08)

Good morning folks, We (me & Damian) are preparing our workshop which will take place at SQLDay conference in Wroclaw (time is ticking, sooooo fast), but in the meantime I’d

Last Week Reading 0 Comments

Last week reading (2018-03-25)

SQL Server on Linux: overview Learn how to get started using #SQLServer on #Linux. Watch the demos via @ch9 Columnstore Indexes on Standard Tier of Azure SQL DB Several days

Podcast 0 Comments

ASF 008: Michael Rys interview

Introduction Michael has been doing data processing and query languages since the 1980s. Among other things he has been representing Microsoft on the XQuery and SQL design committees and has

Last week reading (2018-03-11)

SET IMPLICIT_TRANSACTIONS ON Is One Hell of a Bad Idea How dangerous IMPLICIT_TRANSACTIONS might be What is a Managed Instance (preview)? Yaay! Microsoft has just introduced Managed Instance which allows

Last Week Reading 0 Comments

Last week reading (2018-02-25)

It’s was very busy and pleasant week for me. Tenth SQLBits which has taken in London this year finished yesterday. I have been working as a volunteer (one of the

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