Data Mozart

Month: March 2020

28 Mar
Data Visualization Power BI

Leo Messi meets Power BI

by Nikola
No Comments
All Leo Messi's goals visualized in Power BI report.
22 Mar
Databases Relational Databases SQL Server T-SQL

How SQL Server “thinks” – Indexes & Parameter Sniffing

by Nikola
No Comments
Simple primer on index usage and parameter sniffing
22 Mar
Data Visualization Power BI

Corona data visualized in Power BI

by Nikola
No Comments
Corona is the hottest topic at the moment, so I’ve played around and created Power BI report based on The Johns Hopkins University data. Since...
11 Mar
Databases Relational Databases SQL Server T-SQL

Indexing for better performance – real use case

by Nikola
No Comments
Indexing is always a trade-off between performance gain and maintenance overhead.