Synapse Serverless SQL & Power BI – having fun with PIVOT!
Check how the latest improvements to Synapse Serverless SQL pool can help you create one of the most popular Power BI transformations in more optimal...
Write back to a database using SSRS!
Despite not being a best practice, this trick will enable you to solve some edge case challenges!
Check Power BI usage metrics on Report Server!
Are you jealous because Power BI Service gives you nice overview of Usage metrics? No need, because you can get similar thing on your Report...
Rows or Columns – where should I put my index on?
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...
Azure Data Studio or SSMS – which should I use?
Azure Data Studio or SSMS? Why can't be Azure Data Studio AND SSMS? Check how you can take the best from both worlds
How (not) to kill your SQL Server performance with implicit conversion
Learn how to avoid performance killer and help SQL Server choose optimal execution plan for your queries
Datetime2 – Why you should (not) use it
Choosing right data type is not so straightforward as you might think at first sight
Island adventures with T-SQL Window Functions
Traditional "Gaps and Islands" problem can be easily solved using T-SQL Window Functions
How SQL Server “thinks” – Indexes & Parameter Sniffing
Simple primer on index usage and parameter sniffing
Indexing for better performance – real use case
Indexing is always a trade-off between performance gain and maintenance overhead.