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

SQL and NOT SQL: Best of 2017

by Bert Wagner

Bert Wagner

Photo by Rick Meyers on UnsplashWith only a few days left in 2017, I thought it would be fun to do a year...

2017-12-26

422 reads

SQL and NOT SQL: Best of 2017

by Bert Wagner

Bert Wagner

With only a few days left in 2017, I thought it would be fun to do a year in review post. Below you'll find some of my top 5...

2017-12-26

3 reads

How To Create Multi-Object JSON Arrays in SQL Server

by Bert Wagner

Bert Wagner

Recently I was discussing with Peter Saverman whether it would be possible to take some database tables that look like...

2017-12-19

7,638 reads

How To Create Multi-Object JSON Arrays in SQL Server

by Bert Wagner

Bert Wagner

Recently I was discussing with Peter Saverman whether it would be possible to take some database tables that look like this:

And output them so that the Cars and Toys...

2017-12-19

112 reads

Learning Through Blogging and Speaking

by Bert Wagner

Bert Wagner

This post is a response to this month’s T-SQL Tuesday prompt created by Mala Mahadevan. T-SQL Tuesday was created by...

2017-12-12

164 reads

Learning Through Blogging and Speaking

by Bert Wagner

Bert Wagner

This post is a response to this month's T-SQL Tuesday prompt created by Mala Mahadevan. T-SQL Tuesday was created by Adam Machanic and is a way for SQL users...

2017-12-12

3 reads

Reducing the Number of Reads in Your Queries

by Bert Wagner

Bert Wagner

“A-Bridged” – reducing reads – get it? I’m sorry you’re reading this. Photo by Jamie Street on UnsplashIn last week’s post, we went over how...

2017-12-12

215 reads

Reducing the Number of Reads in Your Queries

by Bert Wagner

Bert Wagner

In last week's post, we went over how one of best ways to improve query performance was to reduce the number of reads that your query has to do.
Less reads...

2017-12-12

7 reads

How to use Statistics IO to Improve Your Query Performance

by Bert Wagner

Bert Wagner

SQL Server’s STATISTICS IO reporting is a great tool to help you performance tune queries.Usually the goal of performance tuning...

2017-12-05

3,109 reads

How to use Statistics IO to Improve Your Query Performance

by Bert Wagner

Bert Wagner

SQL Server's STATISTICS IO reporting is a great tool to help you performance tune queries.
Usually the goal of performance tuning is to make your query run faster. One of...

2017-12-05

60 reads

All authors

Bert Wagner

SQL and NOT SQL: Best of 2017

SQL and NOT SQL: Best of 2017

How To Create Multi-Object JSON Arrays in SQL Server

How To Create Multi-Object JSON Arrays in SQL Server

Learning Through Blogging and Speaking

Learning Through Blogging and Speaking

Reducing the Number of Reads in Your Queries

Reducing the Number of Reads in Your Queries

How to use Statistics IO to Improve Your Query Performance

How to use Statistics IO to Improve Your Query Performance

Blogs

AI: Blog a Day – Day 7: Vector and Vector Databases

AI: Blog a Day – Day 6: Embeddings – How AI Understands

The Book of Redgate: Mistakes

Forums

Why End-User Testing Is Even More Important with AI

Dynamic Unpivot

Writing as an Art and a Job

Question of the Day

String Similarity II