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

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

1 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

1 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,486 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

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

607 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

11 reads

4 Ways To Define Lookup Values In A Query

by Bert Wagner

Bert Wagner

Watch this week’s episode on YouTube.
Occasionally you may need to create a lookup table of values for a single query. ...

2018-06-13 (first published: 2018-06-05)

3,636 reads

Prioritizing Index Performance Pains - What I Learned From Brent Ozar's Master Index Tuning Class

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
I love continuing my education in SQL Server.
Recently I was fortunate enough to take Brent Ozar's 3-day live online Master Index Tuning training class.
Since...

2018-06-12

1 reads

Prioritizing Index Performance Pains - What I Learned From Brent Ozar's Master Index Tuning Class

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
I love continuing my education in SQL Server.
Recently I was fortunate enough to take Brent Ozar's 3-day live online Master Index Tuning training class.
Since...

2018-06-12

1 reads

What Does The GO Command Do?

by Bert Wagner

Bert Wagner

Watch this week’s episode on YouTube.
When I started working with T-SQL, I thought the GO command was optional, kind of...

2018-06-08 (first published: 2018-05-29)

3,431 reads

All authors

Bert Wagner

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

4 Ways To Define Lookup Values In A Query

Prioritizing Index Performance Pains - What I Learned From Brent Ozar's Master Index Tuning Class

Prioritizing Index Performance Pains - What I Learned From Brent Ozar's Master Index Tuning Class

What Does The GO Command Do?

Blogs

My 2024 in Data: Health and Workouts

My 2024 in Data: Reading

Book Review – Agile Data Warehouse Design

Forums

Connecting Streamlit to Upload Data to Snowflake

Comforting Habits

DCL

Question of the Day

DCL