Category: Relational Databases
19
Nov
SQL Database in Fabric – What, Why, and How?
by Nikola
5 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
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 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 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 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
Parquet file format – everything you need to know!
by Nikola
13 Comments
New data flavors require new ways for storing it! Learn everything you need to know about the Parquet file format
29
Sep
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
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...
15
Jan
How to capture SQL queries generated by Power BI
by Nikola
3 Comments
Put smile on your face and provide your DBA with all the necessary info about SQL queries generated by Power BI!
12
Nov
Power BI & Synapse Part 3 – Keep the Tradition!
by Nikola
No Comments
Are you a fan of traditional data warehouse? Then check 3rd part of the series to see how Power BI seamlessly integrate with relational data...