Tag: T-SQL

19 Nov

SQL Database in Fabric – What, Why, and How?

by Nikola

7 Comments

Once upon a time, there was a SQL Server, an undisputed emperor of operational databases! In this article, we examine the key characteristics of the...

13 Oct

Data Modeling Databases Lakehouse Microsoft Fabric T-SQL

How to overcome the Identity column limitation in Microsoft Fabric

by Nikola

7 Comments

Identity column feature is an excellent example of the "missing puzzle" in Microsoft Fabric. Hence, we still have to rely on some workarounds and "hacks"...

17 Jun

Direct Lake Lakehouse Microsoft Fabric SQL Server T-SQL

How to bring SQL Server data into Microsoft Fabric

by Nikola

4 Comments

Options, options...In this article, you'll learn what are the possibilities for bringing your on-prem SQL Server data to Microsoft Fabric

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

01 May

Data Visualization Learning Mastering DP-500 Synapse Analytics T-SQL

Mastering DP-500 Exam: Explore and Visualize Data using Synapse SQL pane

by Nikola

No Comments

Do you fancy a quick data visualization for your ad-hoc queries over SQL pools in Azure Synapse Analytics? Synapse Studio gets you covered!

05 Sep

Data Modeling Databases Power BI Relational Databases T-SQL

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

by Nikola

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

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

14 Mar

Data Modeling Power BI T-SQL

Query folding – tricks, lies & ultimate performance test!

by Nikola

4 Comments

In the final part of the Query folding series, learn more tricks, find out when the View Native Query lies, and finally spot the difference...

15 Jan

Data Modeling Power BI Relational Databases SQL Server T-SQL

How to capture SQL queries generated by Power BI

by Nikola

3 Comments

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

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