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. We have an idea that the DevOps topic should be alive as this is the growing trend in the IT.

Now let me give you some things to read for the rest of the day.

Azure SQL Data Warehouse now supports automatic creation of statistics

Azure SQL Data Warehouse (Azure SQL DW) now supports automatic creation of column level statistics. Azure SQL DW is a fast, flexible, and secure analytics platform for the enterprise.

Announcing new Async Java SDK for Azure #CosmosDB

A new asynchronous Java SDK for Cosmos DB’s SQL API is now open sourced on GitHub. This SDK leverages the popular RxJava library to add a new async API surface area for composing event-based programs with observable sequences. It also features an improved user experience and is also lighter weight than our previous synchronous Java SDK (yielding a 2x performance improvement on the client-side)!

Event Hubs for Kafka ecosystems

Event Hubs for Kafka ecosystems provides a Kafka endpoint that can be used by your existing Kafka based applications as an alternative to running your own Kafka cluster. Event Hubs for Kafka ecosystem supports Apache Kafka 1.0 and newer client versions, and works with your existing Kafka applications, including MirrorMaker.

Cosmos DB Solves Common Data Challenges in App Development

When considering how to implement your application with a relational database, it can change how you build it dramatically. Some of these challenges include adding an abstract implementation of the schema in the code, mapping data to objects, building queries, and preventing SQL injection attacks.

Optimization Thresholds – Grouping and Aggregating Data, Part 2

This article is the second in a series about optimization thresholds related to grouping and aggregating data. Check also Part 1.

And by the way: SSMS 17.7 is now available. Go, grab and use it!

Cheers,

Damian