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

Group of computer programmers working in the office. Focus is on blond woman showing something to her colleague on PC.
Updating your Azure SQL server OAuth2 credentials in Power BI via PowerShell for automation purposes
The better way to update OAuth2 credentials in Power BI is by automating the process of updating Azure SQL Server...
Under (memory) pressure
A few weeks ago, a client asked me if they were experiencing memory pressure and how they could monitor it...
Managing files from other devices in a Fabric Lakehouse using the Python Azure SDK
In this blogpost, you’ll see how to manage files in OneLake programmatically using the Python Azure SDK. Very little coding...
Database specific security in SQL Server
There are many different ways to secure your database. In this blog post we will give most of them a...
SQL Server security made easy on the server level
In this blog, we’re going to look at the options we have for server level security. In SQL Server we...
Microsoft SQL Server history
Since its inception in 1989, Microsoft SQL Server is a critical component of many organizations' data infrastructure. As data has...