Last week reading (2018-04-01)

Good day SQL folks! It’s April Fool day! But don’t worry. All the cool stuff you find here is real & has been read already.

The Challenge Is on: Maintain a Custom Letter-Based Sequence

The challenge presented by Itzik Ben-Gan who will be also our guest during the SQLDay 2018 conference in May in Wr0cław. As Itzik stated this nice little puzzle was presented by a student Nicolas Barreau.

Released: Microsoft OLE DB Driver for SQL Server

Pedro Lopes, who will be our guest in the ASF 009 podcast has informed that Microsoft OLE DB Driver for SQL Server is ready. And you can go and download it. This is a 3rd generation driver of the OLE DB series for the SQL Server. It has multi-subnet failover capabilities.

Tuning performance in Azure SQL Database

Learn about using recommendations to improve Azure SQL Database query performance

Cardinality Estimation Process

I love how Dmitry Piliugin writes his articles. He goes to a very deep level of the engine. That requires a lot of knowledge and experimenting as well.

Power BI Licensing Walk-through Guide

All about licensing in Power BI. All you need to know but yet been afraid to ask. Reza Rad is the best person to explain all the details.

Cheers,

Damian