Data Mozart
Data Mozart

Category: SQL Server

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.
20 Jan
SQL Server SSRS

Who’s running my SSRS reports?

by Nikola
1 Comment
Want to check details of your SSRS reports executions?
16 Jan
SQL Server SSAS

Time Intelligence in SSAS

by Nikola
No Comments
Time Intelligence gives your multidimensional data model much more power and flexibility
10 Jan
SQL Server SSIS

Sort (Out) your SSIS slowness

by Nikola
No Comments
Did you know that some tasks in your SSIS package can be fully blocking? Read how you can avoid some of the pitfalls.
28 Dec
Databases SQL Server T-SQL

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.