Last Week Reading (2019-06-30)

Another week and another round-up over data area. Take a look at what I have found for you last week.

Press

Azure DevOps – Build SSIS project (CI)
Let’s build Continous Integration for SSIS from scratch.

How to Setup SQL Server Big Data Cluster in Azure (AKS) – Part 1
Mohammad (T) presents how to start with BDC.

Mapping Data Flow Parameters
This new feature allows you to pass parameters from Azure Data Factory Pipeline to its Mapping Data Flow.

The Recording for Using the Azure Data Factory Lookup and ForEach Activities
Andy Leonard’s video about a useful scenario.

Workload replay with WorkloadTools
Gianluca (T) explains how to replay a Workload from production. Do make sure that you know what you looking for.

SQL Server NOLOCK Anomalies, Issues and Inconsistencies
Aaron Bertrand (T) illustrates the hazards associated with the use of NOLOCK.

Quick Tip: Power Query column by example
Matthew Roche (T) shows briefly when Power BI can do the work for you.

A word from (former) Microsoft’s CEO

My friendship with Paul Allen changed my life. I loved sharing some of my favorite stories about him (and a few old photos!) at the Forbes Philanthropy Summit yesterday: https://t.co/3i6SFNg9q4 pic.twitter.com/t2t7yTBVie

— Bill Gates (@BillGates) 28 June 2019

Smile Corner