Data Mozart
Data Mozart

Tag: SQL Server

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
No 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...
15 Jan
Data Modeling Power BI Relational Databases SQL Server T-SQL

How to capture SQL queries generated by Power BI

by Nikola
No Comments
Put smile on your face and provide your DBA with all the necessary info about SQL queries generated by Power BI!
09 Dec
Data Visualization SQL Server SSRS T-SQL

Write back to a database using SSRS!

by Nikola
1 Comment
Despite not being a best practice, this trick will enable you to solve some edge case challenges!
11 Aug
Databases Relational Databases SQL Server T-SQL

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
Databases SQL Server T-SQL

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
Databases SQL Server T-SQL

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
Data Modeling Databases Relational Databases SQL Server T-SQL

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
19 May
Relational Databases SQL Server T-SQL

Island adventures with T-SQL Window Functions

by Nikola
1 Comment
Traditional "Gaps and Islands" problem can be easily solved using T-SQL Window Functions
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
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.