Last week reading (2018-08-05)

Microsoft Azure Data welcomes Data Platform Summit attendees
Rohan Kumar [B|T] invites to have a look at today’s mobile-first, cloud-first world and what has been changed in the area by Azure Data team.

Automated Script-generation with Powershell and SMO
Old enough (but still handy) post how to leverage PowerShell with SMO in order to generate a script of database DLL.

A successful Git branching model
A way of managing branches in Git is not such obvious, specifically when you’re beginning with it.

Execute all SSIS packages in parallel with ADFv2 lookup and FOREACH activities
As ADF version 2 supports expressions and parameters, Paul [T|B] shows more dynamic method of run SSIS packages in the SSIS Integration Runtime (IR).

My thoughts on session levels
It’s not mine – it’s Hugo [T] thoughts and definitely worth to understand what the levels are. No matter whether you have just started attending on events or you’re a regular attendee and want to verify your assumptions.

T-SQL Tuesday #104 Roundup
Find out Bert’s [T] recap of 104th T-SQL Tuesday where the topic was “What code would you hate to live without?”. Certainly, you’ll find out tons of useful scripts.

Building a data model to support 1 trillion rows of data and more with Microsoft Power BI Premium
In this video, Christian Wade [T] presents incredible new feature in Power BI: Dual model which allow combining Big data and Dimensional modelling scenarios.
Using that technique you can have import mode for some tables, Direct Query mode for the others and even create a virtual table with aggregated values.
Amazing! I’m truly waiting for this feature as it’s not fully released yet.