Marco Russo's Blog posts of 2023
Generative AI guidelines at SQLBI
These are pivotal times with the large adoption of new technologies like generative AI systems that will certainly impact how we work, along with a lot of other things. If you look at how Alberto and I answer questions related… Read more
Explaining REDUCED BY in xmSQL batch events
We recently released the second edition of the Optimizing DAX video course. Despite its volume, some details always did not find space in the training material. The REDUCED BY syntax of xmSQL is one of those details. Read more
SQLBI+ updates in March 2023
At the end of March, we released the second update of SQLBI+ with a new session about different types of many-to-many relationships in DAX. The goal is to explain the difference between the many-to-many cardinality relationship available in Power BI… Read more
Behind the scenes of an April Fools’ Day
Yesterday we published an April Fool: Navigating the Data Ecosystem: A Revolutionary Analytics Architecture. The idea of writing a piece about a new architecture that could immediately make the latest cool buzzwords obsolete rounded my mind for a few weeks.… Read more
SQLBI+ updates in January 2023
After the SQLBI+ launch in November 2022, we released the first update with additional content: two sessions about Time Intelligence and one whitepaper about the new DAX window functions. This is much more than the single Time Intelligence session we… Read more
Creating database aliases on SQL Server 2022
If you create server aliases for SQL Server connections, you should be aware of the changes introduced in SQL Server 2022. At SQLBI we use aliases to identify the server’s name in the connection of our sample files (Power BI… Read more