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

2.5 Ways Your ORM Is Vulnerable To SQL Injection

by Bert Wagner

Bert Wagner

Someone recently told me that they don't need to worry about SQL injection because they are using an ORM.
Oh boy.
ORMs don't automatically prevent SQL injection

Watch this week's video on YouTube
Object-relational...

2018-03-06

7 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, a variable value, a webpage, etc...
If using two monitors...

2018-02-27

10 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

282 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

6 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

201 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

132 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

4 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

3 reads