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

Splitting It Up: Side by Side Queries In SSMS

by Bert Wagner

Bert Wagner

There are times when you are writing a query while referencing another piece of information: the results of another query, a variable value, a webpage, etc...
If using two monitors...

2018-02-27

8 reads

Splitting It Up: Side by Side Queries In SSMS

by Bert Wagner

Bert Wagner

There are times when you are writing a query while referencing another piece of information: the results of another query,...

2018-02-27

279 reads

OR vs UNION ALL - Is One Better For Performance?

by Bert Wagner

Bert Wagner

Today I want to show you a trick that could make your queries run faster.
It won't always work, but when it does everyone will be impressed with your performance...

2018-02-20

3 reads

OR vs UNION ALL – Is One Better For Performance?

by Bert Wagner

Bert Wagner

Today I want to show you a trick that could make your queries run faster.
It won’t always work, but when...

2018-02-20

198 reads

What I Do When I’m NOT Writing SQL

by Bert Wagner

Bert Wagner

This post is a response to this month’s T-SQL Tuesday prompt created by Aaron Bertrand. Adam Machanic created T-SQL Tuesday...

2018-02-13

127 reads

What I Do When I'm NOT Writing SQL

by Bert Wagner

Bert Wagner

This post is a response to this month's T-SQL Tuesday prompt created by Aaron Bertrand. Adam Machanic created T-SQL Tuesday as a way for SQL users to share ideas...

2018-02-13

3 reads

"How do I contribute to dbatools?" with Drew Furgiuele

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
This weekend I caught up with Drew Furgiuele at SQL Saturday Cleveland and learned how to get involved with the open-source dbatools PowerShell module.
If...

2018-02-06

“How do I contribute to dbatools?” with Drew Furgiuele

by Bert Wagner

Bert Wagner

This weekend I caught up with Drew Furgiuele at SQL Saturday Cleveland and learned how to get involved with the...

2018-02-06

105 reads

The Fastest Way To Locate Errors In Your SQL Query

by Bert Wagner

Bert Wagner

Photo by N. on UnsplashIn about 60 seconds you will never debug error messages in SQL Server Management Studio the same way again.
Coming...

2018-01-30

1,931 reads

The Fastest Way To Locate Errors In Your SQL Query

by Bert Wagner

Bert Wagner

In about 60 seconds you will never debug error messages in SQL Server Management Studio the same way again.
Coming from a .NET background, I'm used to receiving relatively helpful...

2018-01-30

4 reads

All authors

Bert Wagner

Splitting It Up: Side by Side Queries In SSMS

Splitting It Up: Side by Side Queries In SSMS

OR vs UNION ALL - Is One Better For Performance?

OR vs UNION ALL – Is One Better For Performance?

What I Do When I’m NOT Writing SQL

What I Do When I'm NOT Writing SQL

"How do I contribute to dbatools?" with Drew Furgiuele

“How do I contribute to dbatools?” with Drew Furgiuele

The Fastest Way To Locate Errors In Your SQL Query

The Fastest Way To Locate Errors In Your SQL Query

Blogs

SQL Training Black Friday Deals

Dry-run xp_delete_file Before Actually Deleting Files?

Happy Thanksgiving! (USA Holiday)

Forums

Which Object Definitions Are Available?

What's Your Theme Music?

T-SQL in SQL Server 2025: The PRODUCT Function

Question of the Day

Which Object Definitions Are Available?