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!
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.
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.
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.
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
https://www.youtube.com/watch?v=Wan6gC2ui-U
Smile Corner
