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

Cardinality: Not Just For The Birds

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
When building indexes for your queries, the order of your index key columns matters. SQL Server can make the most effective use of an...

2019-01-29

3 reads

SQL FAILS with Andy Mallon, Erin Stellato, and Mr. Anonymous!

by Bert Wagner

Bert Wagner

Watch this week’s video on YouTube.
While most of us strive to make as few mistakes as possible when it comes...

2019-01-25 (first published: 2019-01-15)

2,196 reads

Optimizing for Ad Hoc Workloads

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
The execution plan cache is a great feature: after SQL Server goes through the effort of generating a query plan, SQL Servers saves that...

2019-01-22

3 reads

Optimizing for Ad Hoc Workloads

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
The execution plan cache is a great feature: after SQL Server goes through the effort of generating a query plan, SQL Servers saves that...

2019-01-22

6 reads

SQL FAILS with Andy Mallon, Erin Stellato, and Mr. Anonymous!

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
While most of us strive to make as few mistakes as possible when it comes to our servers and data, accidents do occasionally happen.
Sometimes...

2019-01-15

1 reads

SQL FAILS with Andy Mallon, Erin Stellato, and Mr. Anonymous!

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
While most of us strive to make as few mistakes as possible when it comes to our servers and data, accidents do occasionally happen.
Sometimes...

2019-01-15

Visualizing Hash Match Join Internals And Understanding Their Implications

by Bert Wagner

Bert Wagner

This post is part 3 in a series about physical join operators (be sure to check out part 1 – nested...

2019-01-10 (first published: 2019-01-02)

2,628 reads

T-SQL Documentation Generator

by Bert Wagner

Bert Wagner

This post is a response to this month’s T-SQL Tuesday #110 prompt by Garry Bargsley. T-SQL Tuesday is a way...

2019-01-08

255 reads

T-SQL Documentation Generator

by Bert Wagner

Bert Wagner

This post is a response to this month's T-SQL Tuesday #110 prompt by Garry Bargsley. T-SQL Tuesday is a way for the SQL Server community to share ideas about...

2019-01-08

13 reads

T-SQL Documentation Generator

by Bert Wagner

Bert Wagner

This post is a response to this month's T-SQL Tuesday #110 prompt by Garry Bargsley. T-SQL Tuesday is a way for the SQL Server community to share ideas about...

2019-01-08

1 reads

All authors

Bert Wagner

Cardinality: Not Just For The Birds

SQL FAILS with Andy Mallon, Erin Stellato, and Mr. Anonymous!

Optimizing for Ad Hoc Workloads

Optimizing for Ad Hoc Workloads

SQL FAILS with Andy Mallon, Erin Stellato, and Mr. Anonymous!

SQL FAILS with Andy Mallon, Erin Stellato, and Mr. Anonymous!

Visualizing Hash Match Join Internals And Understanding Their Implications

T-SQL Documentation Generator

T-SQL Documentation Generator

T-SQL Documentation Generator

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?