Bert Wagner

Bert Wagner is a Business Intelligence Developer at Progressive Insurance. He enjoys solving challenging data transformations with T-SQL and optimizing for query performance. In addition to BI development, Bert loves building ASP.NET MVC web apps and building Internet of Things projects.

All authors

Epic Life Quests

by Bert Wagner

Bert Wagner

It is easy to get caught up in the daily details of life and not take the time to reflect on longer term goals and accomplishments.
Inspired by Brent Ozar...

2017-01-03

11 reads

XmlReader vs XmlDocument Performance

by Bert Wagner

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

16 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

10 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

9 reads

All authors

Bert Wagner

Epic Life Quests

XmlReader vs XmlDocument Performance

Coffee's Variety Problem

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

Blogs

Take Time to Gain Perspective

The Fringe Festival

Demo for Parameter Sniffing and Memory Grant Feedback

Forums

Learn From History

The SQL Server MCP Server

The Hidden Danger of Wildcard Operators In Join Operations

Question of the Day

The SQL Server MCP Server