Category: T-SQL

13 May

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

by Nikola

No 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

15 Jan

Data Modeling DAX Direct Lake External Tools Lakehouse Learning Mastering DP-600 Microsoft Fabric Power BI T-SQL

DP-600 Fabric Analytics Engineer Exam: First Impressions and Learning Tips!

by Nikola

10 Comments

Considering taking the DP-600 exam? This article will give you a hint on what to expect and how to prepare for the exam!

26 May

Microsoft Fabric Power BI Synapse Analytics T-SQL

Killing me softly – Has Microsoft Fabric just “overwritten” Synapse Analytics?

by Nikola

5 Comments

Have you invested heavily in Synapse Analytics and wondering what to do when Fabric is around? In this article, we are exploring possibilities and answer...

18 Dec

Data Modeling DAX Power BI T-SQL

Looking through the WINDOW – Calculating customer lifetime value with new DAX functions!

by Nikola

4 Comments

New window functions are one of the most important enhancements to the DAX language ever! Learn how to leverage them to calculate a customer lifetime...

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

14 Aug

Data Modeling Mastering DP-500 Synapse Analytics T-SQL

Mastering DP-500 Exam: Dedicated vs Serverless SQL in Synapse – Which should I use?!

by Nikola

2 Comments

Which Synapse pool should I use in different business scenarios? If you've asked yourself this question, keep reading and by the end of this article...

01 May

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