Last Week Reading (2020-02-02)

Hello. We have a beautiful date today, haven’t we? And LWR posts are coming back after a long one-month break.

Press

Columnstore Indexes – part 130 (“Columnstore Indexes on Azure SQL DB”)
Niko is gonna create the same CCI across many different version/plans of SQL engine.

Late binding vs. Early binding in ADF Data Flows
Check the differences and when late binding scenario might be useful to use.

Overview of load-balancing options in Azure
Great overview, particularly the decision-diagram.

Processing Geospatial Data at Scale With Databricks
Take a look at how the Databricks Unified Data Analytics Platform can easily scale geospatial workloads.

Different ways to update XML using XQuery in SQL Server
Sometimes still you need to do the stuff with XML.

Polybase User Guide – Part 2: Unrestricted Storage the original Configuration
Make a connection using Polybase as quickly as possible.

Using the Azure Data Factory switch activity
With example to run different size of a cluster as per the environment.

Strange PowerShell Notebook Behavior When Comments Are Involved
It’s worth to remind how PS Notebook works in Azure Data Studio.

A word from Microsoft’s CEO

This is the decade for urgent action to address our world’s most pressing challenges. We know no one company can solve these issues alone, but here are my thoughts on how we must commit to do more in order for us to collectively achieve more. https://t.co/5GDjVu7mCU

— Satya Nadella (@satyanadella) January 19, 2020

Video: Using Azure DevOps for Microsoft SQL Databases with SSDT

Smile Corner