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

10 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

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

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)

552 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

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

8 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

9 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

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

6 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

Rolling Back a Broken Release

A bespoke reporting solution doesn’t have to cost the earth

Presenting with Visual Studio Code

Forums

Lots of FKs

Real-time On-prem SQL Server Data in Excel – Over the Internet

Can You Let Go of Determinism

Question of the Day

Lots of FKs