Last week reading (2018-07-22)

Good day SQL folks!

Now and it is almost Tuesday morning, let me give you some things to read for the rest of the day!

Execute all SSIS packages in parallel with ADFV2 looup and foreach activities

Follow up from the SQL Saturday in Manchester where Paul Andrew demonstrated how to use ADF with expressions and parameteres.

Storage mode in Power BI Desktop (Preview)

In Power BI Desktop you can specify the storage mode of tables, providing you with control over whether table data is cached in-memory for reports.

Simpler, smarter transformation and integration of enterprise data with Power Query and Data Integration Platform

Power Query gets simpler and better… For example you can extract data from PDF files and HTML pages. And lot more…

Hash partitions in SQL Server

In SQL Server, when talking about table partitions, basically, SQL Server doesn’t directly support hash partitions. It has an own logically built function using persisted computed columns for distributing data across horizontal partitions called a Hash partition.

ASF 012: Rob Sewell interview

Don’t forget to hear to this great interview we did with Rob!

Cheers,

Damian