Category: Relational Databases
Parquet file format – everything you need to know!
New data flavors require new ways for storing it! Learn everything you need to know about the Parquet file format
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...
3 reasons to use views instead of tables in Power BI!
When using a relational database as the data source for Power BI solutions, most report creators choose to take an easier path - import the...
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!
Power BI & Synapse Part 3 – Keep the Tradition!
Are you a fan of traditional data warehouse? Then check 3rd part of the series to see how Power BI seamlessly integrate with relational data...
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...
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.