OutSystems Developer at Paua, building smarter EV charging solutions. Passionate about SQL, performance tuning, and clean data. It has been almost three years since I began working as an OutSystems ...

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

CREATE TABLE InvoiceHeader ( InvoiceId INT IDENTITY PRIMARY KEY, InvoiceNumber VARCHAR(50) NOT NULL, CustomerCode VARCHAR(50), InvoiceDate DATE, TotalAmount DECIMAL(12,2), LastUpdatedAt DATETIME2 ...

Who are these scripts for? You need to troubleshoot performance problems with SQL Server, and you need to do it now. You don't have time to track down a bunch of DMVs, figure out Extended Events, ...

In-memory database engine, improved integration with Windows Azure, and new indexing technology for high performance data warehousing applications - there's plenty to like in SQL Server 2014, released ...

Twice in the past couple of months I’ve gotten tripped up by the same data issue when using LINQ to Entities in the .NET framework. I create a simple view in my database which performs some ...