Last Weeks Reading (2019-05-26)

It was tremendously extensive week for me (a week ago) when I spent time between two conferences: SQLDay (Wroclaw, Poland) and SQL Saturday #857 (Kiev, Ukraine). I’ve been helping and speaking. Between the events, I had to sort out certain private stuff. You right – that’s the reason why I omitted previous “Last Week Reading”.

Press

ADF Mapping Data Flows: Optimize for Azure SQL Data Warehouse
What’s worth to consider when Azure SQL DW is your sink (target).

ADF Mapping Data Flows: Create rules to modify column names
Mark Kromer presents a pattern of chaning column name based on their data type.

Comparing Mapping and Wrangling Data Flows in Azure Data Factory
Cathrine nicely explains the differences between these two. You might not have heard about Wrangling Data Flows yet also.

Power BI Desktop May 2019 Feature Summary
Amanda Cofsky‘s about the freshest features in Power BI.

Power BI open-platform connectivity with XMLA endpoints public preview
XMLA is like a Connection String to Power BI Workspace/Dataset in Premium Tier.

DAX 101: Automatic time intelligence in Power BI
This article shows why building custom Date tables is preferable to using the automatic date/time handling capabilities of Power BI.

12 Version Control tools for SQL Server
There are more tools than only SSDT and Redgate thing…

What’s in my backpack? | 2019 | 50k subs thank you! (video)
GuyInACube reached 50k subscribers. Adam confesses himself with the contents of his backpack.

Flattening JSON in Azure Data Factory
Including more complex JSON structures

A word from Microsoft’s CEO

An important piece by @XboxP3 on the opportunity in gaming – and the responsibility that comes along with it. https://t.co/Abhrzwtcfd

— Satya Nadella (@satyanadella) 20 May 2019

Video: These self-driving tractors could make farming easier and greener

Smile Corner