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 190 posts

Blogger, speaker. Data Platform MVP, MCSE. Senior Data Engineer & data geek. Member of Data Community Poland, co-organizer of SQLDay, Happy husband & father.

View all posts by this author →

You might also like

Last Week Reading 0 Comments

Last week reading (2018-07-15)

Structured Streaming with Databricks into Power BI & Cosmos DB Giuliano Rapoz (Microsoft) is showing the concept of Structured Streaming with all these puzzles. Lightning fast query performance with Azure

Last week reading (2018-06-17)

Auditing in Azure SQL Data Warehouse It’s not a common case we’re sharing an internal link to this blog. But this is unusual moment: the first guest post written by

Last Week Reading 3 Comments

Last week reading (2018-05-14)

Good day SQL folks! SQLDay has just started! We have a workshop about DevOps and Kamil promises to publish a great series of posts about SSDT and topics around that.


No Comments Yet!

You can be first to comment this post!

Leave a Reply