Category: T-SQL

26 May

Killing me softly – Has Microsoft Fabric just “overwritten” Synapse Analytics?

by Nikola

3 Comments

Have you invested heavily in Synapse Analytics and wondering what to do when Fabric is around? In this article, we are exploring possibilities and answer...

18 Dec

Data Modeling DAX Power BI T-SQL

Looking through the WINDOW – Calculating customer lifetime value with new DAX functions!

by Nikola

4 Comments

New window functions are one of the most important enhancements to the DAX language ever! Learn how to leverage them to calculate a customer lifetime...

08 Sep

Azure Mastering DP-500 SQL Server Synapse Analytics T-SQL

Mastering DP-500: Synapse Serverless SQL and file types – the ultimate guide!

by Nikola

2 Comments

CSV? Parquet? Delta? Which file format should you use to get the best out of Synapse Serverless SQL pool? Let's demistify pros and cons of...

14 Aug

Data Modeling Mastering DP-500 Synapse Analytics T-SQL

Mastering DP-500 Exam: Dedicated vs Serverless SQL in Synapse – Which should I use?!

by Nikola

2 Comments

Which Synapse pool should I use in different business scenarios? If you've asked yourself this question, keep reading and by the end of this article...

01 May

Data Visualization Learning Mastering DP-500 Synapse Analytics T-SQL

Mastering DP-500 Exam: Explore and Visualize Data using Synapse SQL pane

by Nikola

No Comments

Do you fancy a quick data visualization for your ad-hoc queries over SQL pools in Azure Synapse Analytics? Synapse Studio gets you covered!

02 Feb

Data Modeling Power BI SSAS T-SQL

Hybrid tables in Power BI: extending beyond time-related scenarios!

by Nikola

2 Comments

Hybrid tables are one of the most powerful features in Power BI! And, it's not (just) about separating "hot" and "cold" data...You can basically leverage...

05 Sep

Data Modeling Databases Power BI Relational Databases T-SQL