Last week reading (2018-06-03)

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!

Previous New DB project with SSDT and import existing database
Next Last week reading (2018-06-11)

About author

Kamil Nowinski
Kamil Nowinski 69 posts

Data Architect, MCSE Data Platform, MS BI Developer, Member of PLSSUG, co-organizer of SQLDay, speaker. Happy husband & father. #SQLFamily member.

View all posts by this author →

You might also like

Last week reading (2018-01-14)

The top 7 business benefits of establishing DevOps in your organization No comments, find and understand the benefits. Columnstore Indexes – part 116 (“Partitioning Specifics”) What do you need to

Events 0 Comments

SQLDay 2017

Almost one month ago has been ended (15-17 of May 2017) one of the biggest conferences in that part of Europe. Speech of course about SQLDay Conference in Wroclaw, Poland.

Last Week Reading 0 Comments

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

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Reply

2 + 4 =

Protected with IP Blacklist CloudIP Blacklist Cloud