Category: 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

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

8 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

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!

02 Feb

Data Modeling Power BI SSAS T-SQL

Hybrid tables in Power BI: extending beyond time-related scenarios!

by Nikola

2 Comments

Hybrid tables are one of the most powerful features in Power BI! And, it's not (just) about separating "hot" and "cold" data...You can basically leverage...