Last week reading (2018-03-18)
Last week reading (2018-03-18)
Good day SQL folks! Thanks for visiting our blog again! Here is the information you need to calmly start the new week. Indexing and partitioning An interesting example was done
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-03-04)
Good day SQL folks! Thanks for visiting our blog again! It’s March already and we are looking for the Spring to come. Columnstore Indexes – part 120 (“Merge Replication 2016-2017”)
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
Last week reading (2018-02-18)
Good day SQL folks! Thanks for visiting our blog again! Have a great week! Bob Ward’s demos github repo This is not for reading per se but I would definitely
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-11)
Good day SQL folks! Thanks for visiting our blog again! I have just come back after almost 2 weeks of vacations and here you are – fresh, good content for
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,