Last week reading (2018-03-11)

Last week reading (2018-03-11)

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.

Previous Last week reading (2018-03-04)
Next ASF 008: Michael Rys interview

About author

Kamil Nowinski
Kamil Nowinski 35 posts

Data Architect, MCSE Data Platform, MS BI Developer, Member of PLSSUG, co-organizer of SQLDay, speaker. Happy husband & father. #SQLFamily member.

View all posts by this author →

You might also like

Big Data 2 Comments

Functions in the USQL – the hidden gem in the Summer 2017 Update

Hello SQL Folks. We all love USQL for its great extensibility and how it makes our life easier in some particular “area of data”. There are a lot of things

The RC1 of SQL Server 2017 has been released!

Hello SQL Folks! I’m happy to announce we Microsoft released RC1 of SQL Server 2017. There are lot of cool features in this release. I bet you know that SQL

Visual Studio 2017 Launch Event and 20th Anniversary

Visual Studio is turning twenty – Microsoft celebrating two decades of Visual Studio!


No Comments Yet!

You can be first to comment this post!

Leave a Reply

5 + 4 =

Protected with IP Blacklist CloudIP Blacklist Cloud