Data Mozart
Data Mozart

Tag: Relational Database

29 Mar
Databases Lakehouse Microsoft Fabric Relational Databases SQL Server

What is Mirroring in MS Fabric and why do I consider it the next big thing?

by Nikola
No Comments
Mirroring was the missing puzzle in "One Copy for All Data" mantra! Now it's here, and it's amazing what you can do with it in...
21 Jul
Data Modeling Databases Relational Databases SQL Server SSAS

Data Modeling for Mere Mortals – Part 2: Dimensional Modeling Fundamentals

by Nikola
4 Comments
Do you know what is PROBABLY the best data model in business intelligence world? Curious to learn 4-step dimensional design process? This article will provide...
01 Jul
Data Modeling Databases Relational Databases

Data Modeling for Mere Mortals – Part 1: What is Data Modeling?!

by Nikola
5 Comments
Why is data modeling sometimes intimidating? Maybe because you feel lost when you see all these diagrams that look so complex and complicated... But, data...
24 Apr
Direct Lake Lakehouse Mastering DP-600 Microsoft Fabric Relational Databases Synapse Analytics

Parquet file format – everything you need to know!

by Nikola
8 Comments
New data flavors require new ways for storing it! Learn everything you need to know about the Parquet file format
05 Sep
Data Modeling Databases Power BI Relational Databases T-SQL

3 reasons to use views instead of tables in Power BI!

by Nikola
9 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...
22 Mar
Databases Relational Databases SQL Server T-SQL

How SQL Server “thinks” – Indexes & Parameter Sniffing

by Nikola
No Comments
Simple primer on index usage and parameter sniffing
28 Dec
Databases SQL Server T-SQL

Secret life of CTEs

by Nikola
1 Comment
Common Table Expressions (CTEs for friends) is one of the most powerful, but still much underestimated, techniques in T-SQL.