Category: T-SQL
18
Dec
Looking through the WINDOW – Calculating customer lifetime value with new DAX functions!
by Nikola
3 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
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
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
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
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
3 reasons to use views instead of tables in Power BI!
by Nikola
6 Comments
When using a relational database as the data source for Power BI solutions, most report creators choose to take an easier path - import the...
25
May
Solved! Query folding for native SQL in Power BI
by Nikola
3 Comments
Writing a native SQL query in Power BI will break query folding, right? Well, not anymore...
14
Mar
Query folding – tricks, lies & ultimate performance test!
by Nikola
3 Comments
In the final part of the Query folding series, learn more tricks, find out when the View Native Query lies, and finally spot the difference...
15
Jan
How to capture SQL queries generated by Power BI
by Nikola
No Comments
Put smile on your face and provide your DBA with all the necessary info about SQL queries generated by Power BI!
19
Dec
Synapse Serverless SQL & Power BI – having fun with PIVOT!
by Nikola
No Comments
Check how the latest improvements to Synapse Serverless SQL pool can help you create one of the most popular Power BI transformations in more optimal...