Tag: Relational Database

05 Sep

Data Modeling Databases Power BI Relational Databases T-SQL

3 reasons to use views instead of tables in Power BI!

by Nikola

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