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 ...

When you ask an AI agent to 'analyze last month's sales,' it returns plausible SQL and charts. Why, then, can't we use it for ...

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 ...

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 ...

Apart from semantic model design and query complexity, Direct Lake performance specifically depends on well-tuned Delta tables for efficient and fast column loading (transcoding) and optimal query ...

Organizations depend on fast and accurate data-driven insights to make decisions, and SQL is at the core of how they access that data. With Gemini, Google can generate SQL directly from natural ...

SOQL is Salesforce’s proprietary programming language that’s used to query data directly from your Salesforce. SQL is a language used to query data from a general database. Here’s what you need to ...