Category: Relational Databases

24 Apr

Relational Databases Synapse Analytics

Parquet file format – everything you need to know!

by Nikola

No Comments

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

29 Sep

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

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

15 Jan

Data Modeling Power BI Relational Databases SQL Server T-SQL

How to capture SQL queries generated by Power BI

by Nikola

No Comments

Put smile on your face and provide your DBA with all the necessary info about SQL queries generated by Power BI!

12 Nov

Azure Data Modeling Data Visualization Power BI Relational Databases Synapse Analytics

Power BI & Synapse Part 3 – Keep the Tradition!

by Nikola

No Comments

Are you a fan of traditional data warehouse? Then check 3rd part of the series to see how Power BI seamlessly integrate with relational data...

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

28 May

Data Modeling Databases Relational Databases SQL Server T-SQL