Category: Databases

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

4 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

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

14 Jun

Databases SQL Server T-SQL