Last week reading (2018-07-01)

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.

Previous ASF 011: Grant Fritchey interview
Next Last week reading (2018-07-08)

About author

Kamil Nowinski
Kamil Nowinski 52 posts

Data Architect, MCSE Data Platform, MS BI Developer, Member of PLSSUG, co-organizer of SQLDay, speaker. Happy husband & father. #SQLFamily member.

View all posts by this author →

You might also like

Last Week Reading 2 Comments

Last week reading (2018-04-08)

Good morning folks, We (me & Damian) are preparing our workshop which will take place at SQLDay conference in Wroclaw (time is ticking, sooooo fast), but in the meantime I’d

Last Week Reading 1Comments

Last week reading (2018-06-11)

Good day SQL folks! Last week was pretty hot not because of the weather. Microsoft has bought GitHub and this was the news number one for most of the time.

Last Week Reading 0 Comments

Last week reading (2018-03-18)

Good day SQL folks! Thanks for visiting our blog again! Here is the information you need to calmly start the new week. Indexing and partitioning An interesting example was done

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Reply

− 3 = 3

Protected with IP Blacklist CloudIP Blacklist Cloud