Tag: Relational Database
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...
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
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...
22
Mar
How SQL Server “thinks” – Indexes & Parameter Sniffing
by Nikola
No Comments
Simple primer on index usage and parameter sniffing
28
Dec
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.