SQL Spot – Part 1

It has been going fast in 2016 for Microsoft BI. If we continue to move on like this, we’re in for a treat in 2017. However, more technical growth means more ground to cover and more knowledge to be gathered. In this blog series I want to share some interesting articles, which crossed my path in the past month, either professionally or out of personal interest. You can expect information ranging from business perspective to technical insights on various topics like SQL Server News, business perspectives, Power BI, SQL Server BI stack, features, data science, accidental DBA stuff and interesting learning or study materials. All rights go out the great blogging community.

I am mainly a BI developer being an accidental DBA sometimes. I like to pick up on the basics of things to help me out in occasions I’m forced to pick up the role. Also, with SP1 a lot of new features became available on standard editions as well. So, it is a good idea to have some of the enterprise’s feature fundamentals well understood. This month I tried to gather some highlights regarding SQL Server 2016 features or news you might have missed out on.

Business, releases and news

Power BI



  • SSAS Tabular v.next promises even more great new features such as the integration of the M language. Find out more here.
  • Azure SSAS , why and when is it interesting for you. Kasper does a great job of summing them it up here.
  • How to document your tabular or Power BI models.
  • The appraised cross directional filtering has made its way to the SQL Server 2016 SSAS tabular mode.
  • There are a lot of new functions for DAX, but I think the variables feature is really interesting in SQL Server 2016.
  • Have Marco Russo help you out with monitoring your tabular and multidimensional models with SSAS Events Analyzer.
  • SSAS Activity Monitor is an open source tool to monitor the current activity (sessions, transactions, connections, and locks) on an Analysis Services instance. It works for both Tabular and Multidimensional mode.


Data science





Vote of the month

Your Modernization Journey starts now
Recently Microsoft introduced SQL server 2022. We wrote this post to make sure you won’t be missing out on all the fun and exciting new...
Parameter sniffing solved with new Parameter Sensitive Plan Optimization feature
If you’re someone that works a lot with Microsoft SQL Server, there’s no doubt that you’ve had issues with an issue called “Parameter sniffing” before....
Creating maps with R and Power BI
The possibilities are infinite when it comes to creating custom visuals in Power BI. As long as you are creative and have knowledge about the...
Reading monitoring alerts in Telegram
Sending monitoring alerts through Telegram
What if you could get the ease of phone notifications for whatever monitoring alerts you need? Then we have a solution for you with the...
Send mails with Azure Elastic Database Jobs
The DatabaseMail feature in SQL Server and Managed Instance is widely used by many professionals. But what if you want similar functionality in Azure SQL...
Sorting matrices in Power BI
Recently I worked on a Power BI project for a client. They had a SharePoint site where they regularly published articles and wanted to pour...