The Rise and Fall of the OLAP Cube

Learn a definitive history of the rise of the OLAP cube, how it's affected our industry, and what comes next.

The 2020 State of Database DevOps Report from Redgate

The findings from this survey will help shape the business case of any team looking to implement or improve their approach to database DevOps.

Configuring Databricks for Koalas

The Apache Spark open source organization maintains all the documentation for Apache Spark, which is a set of APIs used in Databricks and other big data processing applications. The documentation provides detailed information about the libraries, but the instructions for loading libraries in Databricks are not the same as are used in Databricks, which means that you won’t get anywhere by simply following the Spark installation instructions. Ginger Grant covers the steps to take to get you up and running in no time.

Template for Extracting Report Level Measures from Live Connection PBIX Files

Reid Havens builds a report that connects to any local (PBIX) file that is using a live connection and extracts any report-level measures from that file. Live connections include (PBIX) files connected to SQL Server Analysis Services (SSAS) models, Azure Analysis Services (AAS) models, and Power BI Shared Datasets.  

Copying Data into a Table in Azure SQL DW (Synapse Analytics)

In this article, Niko Neugebauer demonstrates different features used to copy data into Azure Synapse Analytics (SQL DW). He also points out some of the exclusive features on Azure Synapse Analytics.  

Summarise an Azure Data Factory Arm Template Using T-SQL

Paul Andrew explains how to summarise the contents of a complex Data Factory using its ARM Template. He uses T-SQL to parse the ARM Template JSON and output of series of tables containing details about the factory components.  

Calculating Stock on Hand Using DAX: Power BI Inventory Model

You don’t always have the luxury of having a snapshot fact table that has the stock on hand value for every single day, at every single workshop, and for every single product. Even if you want to build such a table, it can easily become gigantic. In this article, Reza Rad shows you how you can use DAX running total calculation to get stock on hand without having the snapshot table in a Power BI inventory model.

Sending Power BI Alerts to Users Via Teams Using Power Automate and Adaptive Cards

Chris Webb presents how to send a message when a Power BI alert is triggered to a user via Teams. Instead of dynamically generating text for the message, he will use an Adaptive Card to format the alert data.

Azure IoT Improves Pharmaceutical Sample Management and Medication Adherence

Sally Frank sheds light on how two innovative companies in the Healthcare Industry are building IoT-enabled solutions with Azure IoT technologies that support medication management and adherence. These solutions address the safety, security, compliance, and inventory use cases highlighted in the report.

Help Build the 2020 Educational Program for PASS

The PASS Educational Program survey is now open! Help shape the direction of PASS by letting us know which content you'd like to see throughout the year and presented at PASS Summit 2020.
Share your thoughts and be in with a chance to win a FREE registration to PASS Summit 2020.

Pre-Conference Call for Interest is Now Open

Have you been thinking about contributing to the amazing content that’s on offer at PASS Summit?

This is your chance—we are now accepting applications for our PASS Summit 2020 Pre-Conference Call for Speakers!

Upcoming Virtual Events

U-SQL in Great Depth - Damian Widera

Saturday, February 29. 18:00 UTC.


We are recruiting community contributors for all PASS Insights newsletter editions:

DBA, BI, Developer, and Analyst.
We’re looking for engaging, in-depth, and technically-focused ideas to feature each month. If you are interested, submit your ideas to
You just might see yourself featured in an upcoming edition!

Looking for more than just BI educational and technical content?
Log in to your PASS account and subscribe to the new Analyst, DBA, and Developer PASS Insights newsletters.