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

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

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

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

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,620 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

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

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

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

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

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,075 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

A New Word: on tenderhooks

Ramblings about data communities and your contributions, no excuses

SQL Server Journey till 2025 (brief)

Forums

Ola Hallengren Index Optimize Maintenance can we have data compression = page

how do i map the "current" object entry in for each to one variable

Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)

Question of the Day

String Similarity I