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)

554 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

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

The DIY Cost of Masking Test Data For Smaller Organizations

T-SQL Tuesday #196 – Two risky career decisions I made

T-SQL Tuesday #192: What career risks have you taken?

Forums

XACT_ABORT being set to ON by web services

OPENQUERY Flexibility

A Full Shutdown

Question of the Day

OPENQUERY Flexibility