Microsoft SQL Server has long been a cornerstone for data management across industries. With the release of SQL Server 2025, ...

Learn why the Excel AGGREGATE function fails with arrays and how to fix value errors using helper columns or dynamic LAMBDA and BYROW formulas.

The error “Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause” appears when a query uses ...

To include aggregated values in your paginated report, you can use built-in aggregate functions in expressions. The default aggregate function for numeric fields is SUM. You can edit the expression ...

1 What is an inner join in SQL? 1 What is an outer join in SQL? 1 What is full join in SQL? 1 What is left join in SQL Server? 1 What is a right join in SQL Server? 1 What is database engine in SQL ...

I’m a big fan of Phil Seamark’s “visualise your refresh” pbix file, which allows you to analyse the different operations of an Import mode semantic model refresh operation (similar functionality has ...

A Technical Project Manager with expertise in agile methodologies, project planning, quality assurance, and more. SQL (Structured Query Language) is the universal language for managing and interacting ...

A few years ago I blogged about the Table.Profile M function and how you could use it to create a table of descriptive statistics for your data: Since that post was written a new, optional second ...