Tag: T-SQL

27 May

Data Modeling DP-700 KQL Lakehouse Mastering DP-600 Mastering DP-700 Microsoft Fabric Real-Time Intelligence Spark T-SQL

Triple Five – How to Perform Common Data Transformations in Fabric!

by Nikola

1 Comment

Discover how to perform 5 essential data transformations in Microsoft Fabric using PySpark, T-SQL, and KQL. Whether you're coding in Python, SQL, or Kusto, this...

13 May

Data Modeling DP-700 KQL Lakehouse Mastering DP-600 Mastering DP-700 Microsoft Fabric OneLake Spark T-SQL

Stop Guessing! Choose the Right Fabric Engine for Your Data!

by Nikola

2 Comments

Microsoft Fabric is all about the options. This article provides a guidance on the most common Fabric dilemma - which analytical storage engine to choose?

19 Nov

Databases Lakehouse Microsoft Fabric Relational Databases SQL Server T-SQL

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

by Nikola

11 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

8 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

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