Analytical Databases in the Microsoft Data Platform. A Single Source of Truth.

Join Thomas LeBlanc in discovering the history of Analytical Databases and learn how Analysis Services became a durable way to present calculations in a single database.

Native Scoring with SQL Server Machine Learning Services

Kevin Feasel explains the Native Scoring Functionality in SQL Server Machine Learning Services, along with several demos.

Wish You Had a Better Understanding of the Origin of Your Data—And Who's Handled That Data?

SentryOne Document delivers powerful documentation and data lineage analysis capabilities in a cloud solution. You can easily maintain up-to-date documentation and ensure compliance with business rules and data privacy regulations by accurately tracking data lineage.

Execute Any Azure Data Factory Pipeline With an Azure Function

The Data Factory activity to execute another pipeline is not dynamic. The name of the downstream pipeline cannot be driven by metadata. Replacing this activity with an Azure Function activity is less than ideal and presents different challenges. Paul Andrew demonstrates an understanding of these important caveats and gives an overview of the solution.

Lift-and-Shift to the Cloud with SQL Server on Azure Virtual Machines

Get the combined performance, security, and analytics of SQL Server with the flexibility and hybrid connectivity of Azure.

Maintain a Single Power BI File When Sharing a Report in Multiple Workspaces and Apps

Learn with Reid Havens how to implement a solution where a report can be distributed across multiple Workspaces and Apps, but only require one file and location to make report changes.

Introduction to Many-to-Many Relationships in SSAS

Aveek Das explains many-to-many relationships in SSAS and how to implement the same element in a SQL Server Analysis Services (SSAS) project.

Azure Data Factory Triggers

Triggers in Azure Data Factory are used to run pipelines automatically either on a wall-clock schedule or at a periodic time interval. While there is enough documentation on these two types of triggers with examples, if you're coming from an SSIS background you may be missing details on what happens when the execution duration overlaps with schedule. Follow DP to understand how these pipelines behave.

Power BI Security

James Serra discusses how to prevent users from seeing data they shouldn’t in Power BI and what the various “layers” of security are.

Upcoming Virtual Events

 


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 insights@pass.org.
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.