Category: SQL Server
Mastering DP-500: Synapse Analytics Dedicated SQL Pools – Everything you need to know!
Is the Dedicated SQL pool an "incarnation" of the SQL Server? In this article, you'll learn all the concepts and techniques relevant for performing efficient...
Mastering DP-500: Synapse Serverless SQL and file types – the ultimate guide!
CSV? Parquet? Delta? Which file format should you use to get the best out of Synapse Serverless SQL pool? Let's demistify pros and cons of...
Solved! Query folding for native SQL in Power BI
Writing a native SQL query in Power BI will break query folding, right? Well, not anymore...
How to capture SQL queries generated by Power BI
Put smile on your face and provide your DBA with all the necessary info about SQL queries generated by Power BI!
Write back to a database using SSRS!
Despite not being a best practice, this trick will enable you to solve some edge case challenges!
Power BI & Synapse Part 1 – The Art of (im)possible!
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...
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