Last week reading (2018-03-11)

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.

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

About author

Kamil Nowinski
Kamil Nowinski 194 posts

Blogger, speaker. Data Platform MVP, MCSE. Senior Data Engineer & data geek. Member of Data Community Poland, co-organizer of SQLDay, Happy husband & father.

View all posts by this author →

You might also like

Last Week Reading 0 Comments

Last week reading (2018-01-21)

Good day SQL folks! Thanks for visiting our blog again!  Here you can find some great articles I have found for you. Here you are – this week readings. Start

Last week reading (2018-10-14)

Hi guys! Not too much this week as I was very busy on #DataRelay tour across UK whole week (relation soon). Azure Data Factory – Data Flow Monitoring Check what

Last week reading (2018-09-09)

Automatic intelligent insights to optimize performance with SQL Data Warehouse With no additional costs, Azure SQL DW delivers you best practice recommendations in terms of data skew and suboptimal table

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Reply