Category: Relational Databases

19 Nov

SQL Database in Fabric – What, Why, and How?

by Nikola

11 Comments

Once upon a time, there was a SQL Server, an undisputed emperor of operational databases! In this article, we examine the key characteristics of the...

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

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

25 Jul

Data Modeling Databases Relational Databases

Data Modeling for Mere Mortals – Part 3: All we need is a Data Lakehouse?!

by Nikola

4 Comments

Is data lakehouse the concept to rule them all? Do we all need to implement it now? This article will provide you with the answers...

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

15 Comments

New data flavors require new ways for storing it! Learn everything you need to know about the Parquet file format

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

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

05 Sep

Data Modeling Databases Power BI Relational Databases T-SQL