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

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

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

4 reads

All authors

Question of the Day

I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:

SELECT JARO_WINKLER_DISTANCE('tim', 'tom')

Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.

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

AI Step 1

RANK() vs DENSE_RANK(): #SQLNewBlogger

Using CAT for Testing of Data Agents

Forums

Missing the Jaro Winkler Distance

25 Years Later: What SQLServerCentral Meant to Me

Doing Good at SQL Server Central

Question of the Day

Missing the Jaro Winkler Distance