Tag: Databases
16
Sep
The query finished…Why is my Fabric SQL database still consuming CUs?
by Nikola
1 Comment
Two minutes of database activity can mean 17 minutes of compute billing. And a CPU chart doesn't tell the whole story. Let's work through SQL...
21
Nov
Microsoft Fabric API for GraphQL – Everything you need to know!
by Nikola
No Comments
Although API for GraphQL might not look like a groundbreaking feature at first glance and probably won’t be frequently used by data engineers and Fabric...
28
Aug
Data Modeling for Mere Mortals – Part 4: Medallion Architecture Essentials
by Nikola
No Comments
Bronze, silver, gold...We are wrapping up our data modeling series by explaining how to set different layers for the lakehouse architecture
25
Jul
Data Modeling for Mere Mortals – Part 3: All we need is a Data Lakehouse?!
by Nikola
4 Comments
Is data lakehouse the concept to rule them all? Do we all need to implement it now? This article will provide you with the answers...
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...
01
Jul
Data Modeling for Mere Mortals – Part 1: What is Data Modeling?!
by Nikola
5 Comments
Why is data modeling sometimes intimidating? Maybe because you feel lost when you see all these diagrams that look so complex and complicated... But, data...
28
Dec
Secret life of CTEs
by Nikola
1 Comment
Common Table Expressions (CTEs for friends) is one of the most powerful, but still much underestimated, techniques in T-SQL.