Category: SQL Server
04
Nov
Power BI & Synapse Part 1 – The Art of (im)possible!
by Nikola
1 Comment
In the 1st part of the blog series related to integration between Power BI and Synapse Analytics, learn about enormous flexibility that Serverless SQL pool...
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
19
May
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
How SQL Server “thinks” – Indexes & Parameter Sniffing
by Nikola
No Comments
Simple primer on index usage and parameter sniffing
11
Mar
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
Who’s running my SSRS reports?
by Nikola
1 Comment
Want to check details of your SSRS reports executions?
16
Jan
Time Intelligence in SSAS
by Nikola
No Comments
Time Intelligence gives your multidimensional data model much more power and flexibility