Last Week Reading (2019-09-22)

Hello #datafolks! Let’s review what happened last week in Data World. It’s hard to admit but I missed last week’s post due to my visit to Sweden (SQLSaturday) and not too many read post.

Press

One-On-One With Satya Nadella Full Interview
Today data is everything. Worth a watch!

The Unkillable DBCC CHECKDB
Check when you can see ROLLBACK of CHECKDB session’s operation.

sp_WhoIsActive Is Now Open Source
In fact, it happened a few months ago. Thanks to Adam Machanic for open-sourcing the code.

SQL Server Change Stream
Debezium provides a modern, easy to use, Change Data Capture experience.

Minimal Logging with INSERT…SELECT into Empty Clustered Tables
Paul White explains what kind of role DMLRequestSort plays in here. Great demo!

Ordered queue processing in Azure Functions with Sessions
Processing at scale might (and for sure do) cause out of order.

Cognitive Search – Azure Search with AI | Azure Friday
Check out how Cognitive Services can work along with Azure Search.

Azure portal September 2019 update
Regular update from Azure portal.

Microsoft Professional program is ending
Sad to see Microsoft Professional Program discontinued.

GDPR Consent
Make sure you (and your company) do understand what that does mean.

Common Data Warehouse Functionality Redefined By CTAS
Great review of all scenarios you should use CTAS in Azure SQL DW.

A word from Microsoft’s CEO

Tools and Weapons from my colleagues @BradSmi and @CarolAnnBrowne is out today. It’s an important book on some of the biggest tech issues of our time and their impact on all of our lives – and well worth reading. https://t.co/N9KL0oycbV

— Satya Nadella (@satyanadella) September 10, 2019

Video: PowerShell in Azure Data Studio

Smile Corner