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

5 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

9 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)

551 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

7 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

29 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)

864 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

4 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

4 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

PowerPoint to HTML with Claude AI

Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!

Monday Monitor Tips: SQL Auditing Preview

Forums

Level 28: DAX Text Functions: The DAX Extract & Modify Functions: LEFT(), RIGHT(), MID(), REPLACE(), SUBSTITUTE()

Creating JSON I

Expensive CPUs

Question of the Day

Creating JSON I