Last week reading (2018-03-11)

SET IMPLICIT_TRANSACTIONS ON Is One Hell of a Bad Idea
How dangerous IMPLICIT_TRANSACTIONS might be

What is a Managed Instance (preview)?
Yaay! Microsoft has just introduced Managed Instance which allows you lift and shift entire on-premises SQL Server instance to the cloud with minimal application and database changes.

Getting Started with DAX Studio
Another helpful manual, full of examples about DAX Studio.

Deploying Power BI: Scaling from 5 to 5000
Eugene Meidinger [T] shows you why a deployment of Power BI reports maybe pretty difficult. See all options.

Preparing for Exam 70-774 – Perform Cloud Data Science with Azure Machine Learning
Ginger Grant [T] reveals a few preparation tips and many useful links if you want to commence your journey towards Azure ML.

Biml Case Study: Automate an Extract for Patrick LeBlanc’s K12 Solution
Patrick LeBlanc [T|Y] has created nice Power BI solution for the US’ education system and Andy Leonard [T] helped building an extract process in SSIS using his secret weapon. Guess what?

Magic Quadrant for Analytics and Business Intelligence Platforms
Full Gartner’s report. Microsoft is a leader again. Congratulations!

Unlock Query Performance with SQL Data Warehouse using Graphical Execution Plans
Find performance bottlenecks in your Azure SQL DW directly within the SSMS window by reading Graphical Execution Plan

Power BI Desktop March Feature Summary
The latest update from Power BI team. My favorite feature is Report page tooltips (preview).

Introducing SQL Information Protection for Azure SQL Database and on-premises SQL Server!
Discover, classify and label sensitive data in your database environment. In this new feature (public preview) you don’t have to do this manually. Also, use SQL IP to generate reports from these metadata.

[PL] Będę na SQLDay 2018
Do you know that 50% sessions will be in English? Check out why Pawel Potasinski feels that it’s worth to be on SQLDay. Join him, join us.