Preparing a presentation on VertiPaq and optimizing models for #PowerBI and #SSAS Tabular only served to convince me of one thing:

#DAX is the path to worse performance. Just don't write it if you can avoid it.

E.g., queries on a table of 8.5M rows are faster than the same on a table of 10K, when the larger needs no DAX and the latter does have some logic.

Les 9 stagiaires que je forme au métier de #DBA depuis le 5/9/2022 recherchent activement un lieu de stage du 1/6 au 27/7.

Ils auront vu les systèmes #Windows Server et #Linux, les technologies de #virtualisation, la #sécurité #informatique et le #forensics, le #SQL (DIL, DML, DDL, DCL), #MariaDB, SQL Server (#MSSQL), #PostgreSQL, #SSIS, #SSAS, #SSRS, #PowerBI, #Grafana.

N'hésitez pas à me contacter au 06 70 37 31 91, si vous avez un stage intéressant à leur proposer dans ces domaines.

Another update from your SQL Experiences team! Read: What’s New in Visual Studio Extensions for SSAS and SSRS https://techcommunity.microsoft.com/t5/sql-server-blog/what-s-new-in-visual-studio-extensions-for-ssas-and-ssrs/ba-p/3700343. #sql #sqlserver #sqlserver2022 #ssas #ssrs

I gave a presentation earlier this week on DAX Studio and Tabular Editor.

Power BI Desktop is optimized for getting started. These tools for experts are optimized for getting things done. Check out the presentation for practical demos of improved dev workflows using these two.

Session recording: https://usergroup.tv/videos/expert-power-bi-development/
Supporting material: https://github.com/powerbiatx/supporting-materials

#powerbi #dax #ssas