Category: Databases

19 Nov

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

by Nikola

1 Comment

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

13 Oct

Data Modeling Databases Lakehouse Microsoft Fabric T-SQL

How to overcome the Identity column limitation in Microsoft Fabric

by Nikola

7 Comments

Identity column feature is an excellent example of the "missing puzzle" in Microsoft Fabric. Hence, we still have to rely on some workarounds and "hacks"...

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

28 Aug

Data Modeling Databases

Data Modeling for Mere Mortals – Part 4: Medallion Architecture Essentials

by Nikola

No Comments

Bronze, silver, gold...We are wrapping up our data modeling series by explaining how to set different layers for the lakehouse architecture

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

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

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

11 Aug

Databases Relational Databases SQL Server T-SQL

Rows or Columns – where should I put my index on?

by Nikola

No Comments

Choosing optimal indexing strategy for your SQL Server workloads is one of the most challenging tasks. Learn in which scenarios you can benefit from using...