Data Mozart

Although Synapse Analytics is not a go-to platform for Machine learning workloads, you can still perform predictive analytics by using the PREDICT function in Dedicated...

29 Sep

Azure Databases Mastering DP-500 Relational Databases SQL Server Synapse Analytics

Mastering DP-500: Synapse Analytics Dedicated SQL Pools – Everything you need to know!

by Nikola

3 Comments

Is the Dedicated SQL pool an "incarnation" of the SQL Server? In this article, you'll learn all the concepts and techniques relevant for performing efficient...

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...

10 Aug

Data Modeling Power BI

Finding the right PATH – Understanding parent-child hierarchies in Power BI!

by Nikola

No Comments

Different data source systems store the data in different ways! Parent-child hierarchies may be a decent challenge to solve in your data modeling workflow

06 Aug

Data Modeling Mastering DP-500 Power BI