Category: SQL Server
19
Nov
SQL Database in Fabric – What, Why, and How?
by Nikola
5 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...
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
29
Mar
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
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 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
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
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...
25
May
Solved! Query folding for native SQL in Power BI
by Nikola
3 Comments
Writing a native SQL query in Power BI will break query folding, right? Well, not anymore...
15
Jan
How to capture SQL queries generated by Power BI
by Nikola
3 Comments
Put smile on your face and provide your DBA with all the necessary info about SQL queries generated by Power BI!
09
Dec
Write back to a database using SSRS!
by Nikola
3 Comments
Despite not being a best practice, this trick will enable you to solve some edge case challenges!