Bert Wagner

Recently I have been working on a project where I needed to parse XML files that were between 5mb and 20mb in size. Performance was critical for the project,...

2016-11-24

25 reads

Coffee's Variety Problem

by Bert Wagner

Bert Wagner

Spaghetti Sauce Origins
During the 1970s consumers had a limited number of spaghetti sauces that they could purchase at their local supermarket. Each store-bought sauce tasted the same, developed in test...

2016-11-15

20 reads

3 Things I Wish I Knew When I Started Using Entity Framework

by Bert Wagner

Bert Wagner

Entity Framework (EF) is Microsoft's object-relational-mapping tool (ORM) that allows programmers to easily map database objects to C# object models. What attracts developers to Entity Framework is the automatic...

2016-04-30

18 reads

Read the latest Blogs

Visit the forum

Question of the Day

The Empty Aggregate

I have this table in a SQL Server 2025 database:

CREATE TABLE [dbo].[CustomerOrder]
(
[OrderID] [int] NULL,
[CustomerID] [int] NULL,
[total] [money] NULL
) ON [PRIMARY]
GO

What is returned from this code? (answers are for the sum and then the count)

SELECT SUM(total) AS sum,
       COUNT(total) AS count
FROM dbo.CustomerOrder;

See possible answers

Bert Wagner

XmlReader vs XmlDocument Performance

Coffee's Variety Problem

3 Things I Wish I Knew When I Started Using Entity Framework

Blogs

How to Clear the SSMS Cache (SSMS 21 and Later)

The flight recorder: Replaying what an AI agent did on my SQL Server

Announcements from the Microsoft Fabric Community Conference — Barcelona 2026

Forums

Let's Talk Certifications

The Hidden Security Risks of Role Combination in SSAS Tabular

The Empty Aggregate

Question of the Day

The Empty Aggregate