Last week reading (2018-09-23)

Good day SQL folks!

IGNITE IS COMMING!!!!

Stay tuned on our twitter this week but before you check in to the session on Ignite here you are – some exciting news from the the Data Platform world. You can join online if you are not in Orlando.

Locks Taken During Indexed View Modifications
Brent Ozar says he is always a little nervous doing indexing and here you can read why is that.

Azure IoT Hub + Azure function + Azure Cosmos DB — Walkthrough
*** Good for Monday morning ***  This is a simple walkthrough about adding a serverless backend to your existing IoT system.

Developer’s Choice: Hinting Query Execution model
An article describing a new hint available in the SQL Server 2016 SP1. You will be able to tweak the Query Optimizer for a specific intent, including the hints FORCE_LEGACY_CARDINALITY_ESTIMATION and FORCE_DEFAULT_CARDINALITY_ESTIMATION.

Structured streaming with Azure Databricks from IotHub to Cosmos DB
In this article it is explained how to built a data ingestion architecture using Azure Databricks enabling us to stream data through Spark Structured Streaming, from IotHub to Comos DB.

Understanding Neural Networks. From neuron to RNN, CNN, and Deep Learning
Neural Networks is one of the most popular machine learning algorithms at present. It has been decisively proven over time that neural networks outperform other algorithms in accuracy and speed. With various variants like CNN (Convolutional Neural Networks), RNN (Recurrent Neural Networks), AutoEncoders, Deep Learning etc. neural networks are slowly becoming for data scientists or machine learning practitioners what linear regression was one for statisticians.

Cheers,

Damian