Tag: Relational Database

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

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

24 Apr

Relational Databases Synapse Analytics

Parquet file format – everything you need to know!

by Nikola

3 Comments

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

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

22 Mar

Databases Relational Databases SQL Server T-SQL

How SQL Server “thinks” – Indexes & Parameter Sniffing

by Nikola

No Comments

Simple primer on index usage and parameter sniffing

28 Dec

Databases SQL Server T-SQL

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.