You searched "sql"
        831 results
From SQL to DAX –

From SQL to DAX: Joining Tables

In SQL there are different types of JOIN, available for different purposes. This article shows the equivalent syntaxes supported in DAX and it was updated in May 2018.  Read more

video –

DAX Optimization Examples – SQLBits 2018

How do you optimize a DAX expression? In this session, Alberto Ferrari analyzes some DAX expressions and Tabular models and, through the usage of DAX Studio and some understanding of the VertiPaq model, we will look at how to optimize…  Watch now

video –

DAX Best Practices – SQLBits 2018

As with any other language, you can write good DAX but you can also write bad DAX. Good DAX works fine, it is fast and reliable and can be updated easily. Bad DAX, on the other hand is… well, just…  Watch now

book –

Tabular Modeling in SQL Server Analysis Services (2nd Edition)

With SQL Server Analysis Services 2016, Microsoft has dramatically upgraded its Tabular approach to business intelligence data modeling, making Tabular the easiest and best solution for most new projects. In this book, two world-renowned experts in Microsoft data modeling and…  Read more

video –

[UPDATED] Synoptic Panel by SQLBI for Power BI

The Synoptic Panel by SQLBI is a powerful visual component for Power BI that connects areas in a custom image with attributes in the data model, filling each area with a color or with a saturation of a color related…  Watch now

blog post –

Internet of Things in 2015 #summit15 #sqlpass

David DeWitt and Rimma Nehme delivered the day 2 keynote at PASS Summit 2015 talking about Internet of Things. Many PASS attendees know David for providing some of the best keynotes every, technical and without vaporware and marketing stuffs. So this  Read more