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

CHOOSE() in SQL Server

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
While I know I don't utilize most of the features available in SQL Server, I like to think I'm at least aware that those features exist.
This...

2019-06-04

6 reads

CHOOSE() in SQL Server

by Bert Wagner

Bert Wagner

Watch this week’s episode on YouTube. While I know I don’t utilize most of the features available in SQL Server, I like to think I’m at least aware that those features...

2019-06-04

304 reads

CHOOSE() in SQL Server

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
While I know I don't utilize most of the features available in SQL Server, I like to think I'm at least aware that those features exist.
This...

2019-06-04

10 reads

Predicate Execution Order on Mixed Data Type Columns

by Bert Wagner

Bert Wagner

Watch this week’s episode on YouTube. SQL Server’s cost-based query optimizer does a pretty good job of figuring out what order to filter your data to get fast query...

2019-06-04 (first published: 2019-05-21)

556 reads

12 Ways To Rewrite SQL Queries for Better Performance

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Over the past several week's I've been exploring ways to rewrite queries to improve execution performance.
I learned a lot of these techniques over time from...

2019-05-28

9 reads

12 Ways To Rewrite SQL Queries for Better Performance

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Over the past several week's I've been exploring ways to rewrite queries to improve execution performance.
I learned a lot of these techniques over time from...

2019-05-28

30 reads

Animating a Magic 8 Ball in SQL Server Management Studio

by Bert Wagner

Bert Wagner

This post is a response to this month’s T-SQL Tuesday #114 prompt by Matthew McGiffen. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...

2019-05-24 (first published: 2019-05-14)

866 reads

Predicate Execution Order on Mixed Data Type Columns

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
SQL Server's cost-based query optimizer does a pretty good job of figuring out what order to filter your data to get fast query executions....

2019-05-21

5 reads

Predicate Execution Order on Mixed Data Type Columns

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
SQL Server's cost-based query optimizer does a pretty good job of figuring out what order to filter your data to get fast query executions....

2019-05-21

9 reads

Animating a Magic 8 Ball in SQL Server Management Studio

by Bert Wagner

Bert Wagner

This post is a response to this month's T-SQL Tuesday #114 prompt by Matthew McGiffen. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...

2019-05-14

5 reads

All authors

Bert Wagner

CHOOSE() in SQL Server

CHOOSE() in SQL Server

CHOOSE() in SQL Server

Predicate Execution Order on Mixed Data Type Columns

12 Ways To Rewrite SQL Queries for Better Performance

12 Ways To Rewrite SQL Queries for Better Performance

Animating a Magic 8 Ball in SQL Server Management Studio

Predicate Execution Order on Mixed Data Type Columns

Predicate Execution Order on Mixed Data Type Columns

Animating a Magic 8 Ball in SQL Server Management Studio

Blogs

SQL Server Security: Always Encryption

SQL Server Security – TDE Encryption

A Las Vegas Break

Forums

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

This Week's AI Trust Problem Became Everyone’s Problem

Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025

Question of the Day

Identities and Sequences III