Last week reading (2018-11-25)

Good day SQL folks!

Here is your weekly list of articles worth to read!

Failover Detection Utility – Availability Group Failover Analysis Made Easy

To analyze the root cause for the failover of an Availability group, users are required to perform coordinated analysis of various logs including the Cluster Logs, SQL Error Logs, and the Availability groups extended events logs.

Connecting Apache Kafka to Azure CosmosDB — Part II

Part one gave a quick introduction into building a very simple, near real-time data integration pipeline between any JSON data that is written to Apache Kafka topics and Azure CosmosDB. The 2nd part of this blog post series will dig a little deeper in order to explore how to setup a data pipeline which allows to fully replicate all changes originating from various disparate data stores into CosmosDB.

SSMS 18.0 Public Preview 5 Released

This is the announcement of the release of Public Preview 5 of SQL Server Management Studio (SSMS) 18.0. This release has a number of new features and capabilities and several bug fixes across SQL Server Management Objects (SMO), UI, etc.

Columnstore Indexes – part 127 (“Batch Mode on Rowstore – is it a Columnstore Killer?”)

Great post as always. Check it out. Niko delivers great knowledge as always.

Synchronizing Azure Cosmos DB Collections for Blazing Fast Queries

Azure Cosmos DB is the fastest growing data service in Azure – and for good reason. The service offers global distribution in a few clicks, seamless horizontal scaling, automatic indexing, and 99.99% guarantees for availability, throughput, latency, and consistency. Enabling Cosmos DB multi-master mode provides a service-level agreement backed read and write availability of 99.999% – financially backed by Microsoft.

Cheers,

Damian