"I thought LEFT JOIN would keep the data on the left, but the number of records decreased when I added WHERE."When creating ...

The theme for this time is SQL "execution plans."Execution plans are one of the technologies you absolutely must understand when considering database performance.However, this content might also be a ...

This sample showcases the in-memory OLTP feature. It shows memory-optimized tables and natively compiled stored procedures, and can be used to demonstrate performance benefits of in-memory OLTP. The ...

A popular performance tuning book gets updated for SQL Server 2025, how does it fare? Ian Stirk takes and in depth look and finds it pretty good. This well-liked SQL Server book examines performance ...

The addition of Direct Lake as a third storage mode in Fabric didn’t change the situation. While there are some really good reasons to use Direct Lake instead of Import mode (which I should really ...

Power Query and Power Pivot help Excel users manage large datasets more efficiently. Power Query focuses on cleaning and preparing data, while Power Pivot handles analysis and reporting. Together, ...

databricks-training/ │ ├── README.md (this file - main documentation) │ ├── week1/ │ ├── day1/ │ │ ├── README.md (day-specific learning notes) │ │ ├── queries.sql (practice queries) │ │ ├── solutions ...

Over the past few years, database and analytics vendors have hopped on a bandwagon that may take us all to a destination where common data queries are free from the constraints of the specialist query ...

SQL developers manage structured databases that power payments, healthcare, retail, and cloud systems. Cloud platforms increase demand for SQL skills, including scaling, backup systems, and security ...

One very common cause of Power BI performance problems is having a table with a large number of rows on your report. It’s a problem I wrote about here, and while I used an Import mode for my example ...

Recursive SQL expressions allow you to reference previous results in a hierarchical data set in order to extract information. Here’s how it works. The post will not go into the details of those many ...