Category: 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
No Comments
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
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
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
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
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
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
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
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...