Category: Databases
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
4 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...
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...
05
Sep
3 reasons to use views instead of tables in Power BI!
by Nikola
7 Comments
When using a relational database as the data source for Power BI solutions, most report creators choose to take an easier path - import the...
11
Aug
Rows or Columns – where should I put my index on?
by Nikola
No Comments
Choosing optimal indexing strategy for your SQL Server workloads is one of the most challenging tasks. Learn in which scenarios you can benefit from using...
14
Jun
Azure Data Studio or SSMS – which should I use?
by Nikola
2 Comments
Azure Data Studio or SSMS? Why can't be Azure Data Studio AND SSMS? Check how you can take the best from both worlds
05
Jun
How (not) to kill your SQL Server performance with implicit conversion
by Nikola
No Comments
Learn how to avoid performance killer and help SQL Server choose optimal execution plan for your queries
28
May
Datetime2 – Why you should (not) use it
by Nikola
5 Comments
Choosing right data type is not so straightforward as you might think at first sight