Last week reading (2018-06-03)

Modern data warehouse
See how a modern data warehouse works from beginning to end.

Load confidently with SQL Data Warehouse PolyBase Rejected Row Location
Great news for all Azure SQL DW folks! Now, loading data into Azure SQL Data Warehouse using PolyBase is more flexible. The process can redirect invalidated rows to a selected folder.

Using Email Attachments As A Data Source In Power BI
How to load data directly from email to Power BI? Chris Webb [T] reveals it for you.

Cumulative Update #9 for SQL Server 2016 SP1
The 9th cumulative update is now available for download at the Microsoft Downloads site.

How to securely access PaaS resources with ‘Allow access to Azure services’ option disabled?
Janusz [T] shows what is worth to change in default settings after a provisioning within Azure to stick best practices in terms of security.

DateAdd vs ParallelPeriod vs SamePeriodLastYear; DAX Time Intelligence Question
In this post Reza Red [T] explains the difference between SamePeriodLastYear and ParallelPeriod.

GroupBy June recordings are online now
GroupBy [T] just finished up another day of free online training. Have you missed it? You can watch the recordings now on YouTube. Enjoy!