Posts From Kamil Nowinski
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 #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 (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 (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
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 (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
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
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,
