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

Filtering Tables, Procedures, And Other Objects In SSMS

by Bert Wagner

Bert Wagner

While the text of this post contains good information on SSMS object filters, I highly recommend watching this week’s video...

2018-07-05 (first published: 2018-06-26)

2,502 reads

Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)

by Bert Wagner

Bert Wagner

The recent news about Microsoft acquiring GitHub has me thinking about how amazing it is for us to be part...

2018-07-03

267 reads

Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)

by Bert Wagner

Bert Wagner

The recent news about Microsoft acquiring GitHub has me thinking about how amazing it is for us to be part of today's online code community.
Before modern online programming communities,...

2018-07-03

7 reads

Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)

by Bert Wagner

Bert Wagner

The recent news about Microsoft acquiring GitHub has me thinking about how amazing it is for us to be part of today's online code community.
Before modern online programming communities,...

2018-07-03

2 reads

Filtering Tables, Procedures, And Other Objects In SSMS

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
While the text of this post contains good information on SSMS object filters, I highly recommend watching this week's video on YouTube - I...

2018-06-26

9 reads

Filtering Tables, Procedures, And Other Objects In SSMS

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
While the text of this post contains good information on SSMS object filters, I highly recommend watching this week's video on YouTube - I...

2018-06-26

13 reads

Prioritizing Index Performance Pains – What I Learned From Brent Ozar’s Master Index Tuning Class

by Bert Wagner

Bert Wagner

I love continuing my education in SQL Server. Recently I was fortunate enough to take Brent Ozar’s 3-day live online...

2018-06-21 (first published: 2018-06-12)

2,491 reads

Join Elimination: When SQL Server Removes Unnecessary Tables

by Bert Wagner

Bert Wagner

In this post and video at SQLPerformance.com, I discuss what join elimination is and how it works in SQL Server. ...

2018-06-19

642 reads

Join Elimination: When SQL Server Removes Unnecessary Tables

by Bert Wagner

Bert Wagner

In this post and video at SQLPerformance.com, I discuss what join elimination is and how it works in SQL Server. Join elimination is one of the many techniques that...

2018-06-19

17 reads

Join Elimination: When SQL Server Removes Unnecessary Tables

by Bert Wagner

Bert Wagner

In this post and video at SQLPerformance.com, I discuss what join elimination is and how it works in SQL Server. Join elimination is one of the many techniques that...

2018-06-19

9 reads

All authors

Bert Wagner

Filtering Tables, Procedures, And Other Objects In SSMS

Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)

Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)

Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)

Filtering Tables, Procedures, And Other Objects In SSMS

Filtering Tables, Procedures, And Other Objects In SSMS

Prioritizing Index Performance Pains – What I Learned From Brent Ozar’s Master Index Tuning Class

Join Elimination: When SQL Server Removes Unnecessary Tables

Join Elimination: When SQL Server Removes Unnecessary Tables

Join Elimination: When SQL Server Removes Unnecessary Tables

Blogs

Take Time to Gain Perspective

The Fringe Festival

Demo for Parameter Sniffing and Memory Grant Feedback

Forums

Learn From History

The SQL Server MCP Server

The Hidden Danger of Wildcard Operators In Join Operations

Question of the Day

The SQL Server MCP Server