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