Category: SQL Server

21 Jul

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

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

08 Sep

Azure Mastering DP-500 SQL Server Synapse Analytics T-SQL

Mastering DP-500: Synapse Serverless SQL and file types – the ultimate guide!

by Nikola

2 Comments

CSV? Parquet? Delta? Which file format should you use to get the best out of Synapse Serverless SQL pool? Let's demistify pros and cons of...

25 May

Data Modeling Power BI SQL Server T-SQL

Solved! Query folding for native SQL in Power BI

by Nikola

3 Comments

Writing a native SQL query in Power BI will break query folding, right? Well, not anymore...

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!

09 Dec

Data Visualization SQL Server SSRS T-SQL

Write back to a database using SSRS!

by Nikola

1 Comment

Despite not being a best practice, this trick will enable you to solve some edge case challenges!

04 Nov

Azure Power BI SQL Server Synapse Analytics

Power BI & Synapse Part 1 – The Art of (im)possible!

by Nikola

1 Comment

In the 1st part of the blog series related to integration between Power BI and Synapse Analytics, learn about enormous flexibility that Serverless SQL pool...

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