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

12 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

5 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

5 reads

Read the latest Blogs

Visit the forum

Question of the Day

Getting the Average

I have this data in the dbo.Commission table in a SQL Server 2022 database.

salesperson commission
Brian       12
Brian       16
Andy        7
Andy        14
Andy        21
Steve       20
Steve       NULL

All the data is a varchar, and I decide to run this query to get the totals for each salesperson.

SELECT SalesPerson
     , AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
 FROM commission
 GROUP BY SalesPerson
GO

What average commission is calculated for Steve?

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

Automatic Index Compaction

The Goldilocks problem – Materialized Views

Monday Monitor Tips: Virtual Machine Usage and Cost

Forums

SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About

How We Handled a Vendor Retry That Loaded Twice in Snowflake

Cognitive Coverage

Question of the Day

Getting the Average