Last week reading (2018-07-01)

Apart of standard portion of news which we have for you every week – there is another extra info from us. Firstly, we’re proudly to announce that Damian Widera has been honoured 10th time in a row with MVP award! MVP is a very prestigious title being awarded by Microsoft to people who have an excellent technical knowledge and significant impact into the community. Most of our guests are MVP, so also we’re very often touching this topic during the podcasts. Congratulations Damian!

Second thing is about my coming activities. On Wednesday I will be presenting my session about Azure SQL DataWarehouse at Southampton Data Platform and Cloud Group Meeting [T]. Furthermore, 9th of July (Monday) I will show this session again, this time at local group in Guildford at SQLSurrey PASS User Group [T]. I’m very excited about this but bit nervous at the same time as it’s my first time when presenting in England. Not my first time to present a session in English though, but first time in England to native people.

Ok, it’s time for usual news. Have a good week!

Process more files than ever and use Parquet with Azure Data Lake Analytics
Michael Rys reveals how ADLA is now more efficient processing hundreds of thousands files and supporting native Parquet format.

Receive SQL Server Alerts through Slack
Check this trick out – how to send alerts from SQL Server to Slack.

Event trigger based data integration with Azure Data Factory
New feature in Azure Data Factory (ADF) pipelines, where now you can trigger an event based on files changes (appeared or deleted) in your blob storage.

Azure Data Architecture Guide – Blog #1: Introduction
Amount and capabilities of technology about the (big) data are continuously growing. This Guide prepared by Microsoft AzureCAT (Customer Advisory Team) explains when which particular technology should be used in which scenarios.

Azure SQL DW Performance: CTAS/Partition Switching VS UPDATE/DELETE
UPDATE and DELETE are not very performant operations in CCI. What is the CTAS then and why it’s much faster than UPDATE? Check this in a practical example.

The emerging big data architectural pattern
Lambda architecture is a popular pattern in building Big Data pipelines where we distinguish speed and batch layers. What kind of problems it introduced and which it solves?

Azure Elastic Database jobs is now in public preview
This is cool – you can have SQL jobs in Azure. No, not in neither VM nor Azure SQL Managed Instance. Just on Azure SQL Server level.