Category: SQL Server

19 Nov

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

by Nikola

1 Comment

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

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

29 Mar

Databases Lakehouse Microsoft Fabric Relational Databases SQL Server

What is Mirroring in MS Fabric and why do I consider it the next big thing?

by Nikola

2 Comments

Mirroring was the missing puzzle in "One Copy for All Data" mantra! Now it's here, and it's amazing what you can do with it in...

17 Dec

Data Modeling Direct Lake Lakehouse Microsoft Fabric Power BI SQL Server

Rule Them ALL! Create a OneLake shortcut to SQL Server or DAX calculated table!

by Nikola

6 Comments

Game changer! How many times did you hear these words? But, with the latest OneLake integration for semantic models feature in Fabric, we may really...

21 Jul

Data Modeling Databases Relational Databases SQL Server SSAS

Data Modeling for Mere Mortals – Part 2: Dimensional Modeling Fundamentals

by Nikola

4 Comments

Do you know what is PROBABLY the best data model in business intelligence world? Curious to learn 4-step dimensional design process? This article will provide...

29 Sep

Azure Databases Mastering DP-500 Relational Databases SQL Server Synapse Analytics

Mastering DP-500: Synapse Analytics Dedicated SQL Pools – Everything you need to know!

by Nikola

4 Comments

Is the Dedicated SQL pool an "incarnation" of the SQL Server? In this article, you'll learn all the concepts and techniques relevant for performing efficient...

08 Sep

Azure Mastering DP-500 SQL Server Synapse Analytics T-SQL