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

20 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

24 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

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

The Book of Redgate:A Prehistory

Evidence-bound: what AgentDBA will and won’t link

Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?

Forums

Four Rules for Adding AI Without Breaking What Already Works

SQL Server 2025 section missing?

A design question in a parent child relationship

Question of the Day

Hyperscale Replicas III