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

FizzBuzz and Multiple Recursive Member CTEs

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Last week I needed to write a recursive common table expression. I've written them before, but it's been a while and needed to visit...

2018-08-21

8 reads

FizzBuzz and Multiple Recursive Member CTEs

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Last week I needed to write a recursive common table expression. I've written them before, but it's been a while and needed to visit...

2018-08-21

8 reads

Should You Use Index Hints?

by Bert Wagner

Bert Wagner

Watch this week’s post on YouTube
One of the things that the SQL Server query optimizer does is determine how to...

2018-08-16 (first published: 2018-07-31)

3,640 reads

6 Techniques For Troubleshooting Your Code

by Bert Wagner

Bert Wagner

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

2018-08-14

1 reads

6 Techniques For Troubleshooting Your Code

by Bert Wagner

Bert Wagner

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

2018-08-14

8 reads

Displaying Long Values in SSMS

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
I write a lot of dynamic SQL and frequently encounter variables that contain many characters:
DECLARE @LongValue NVARCHAR(MAX) = CAST('' AS NVARCHAR(MAX)) +
N'SELECT
...

2018-08-07

6 reads

Displaying Long Values in SSMS

by Bert Wagner

Bert Wagner

Click here to watch this week’s video on YouTube.
I write a lot of dynamic SQL and frequently encounter variables that...

2018-08-07

372 reads

Displaying Long Values in SSMS

by Bert Wagner

Bert Wagner

2018-08-07

12 reads

Should You Use Index Hints?

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
One of the things that the SQL Server query optimizer does is determine how to retrieve the data requested by your query.
Usually it does...

2018-07-31

6 reads

Should You Use Index Hints?

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
One of the things that the SQL Server query optimizer does is determine how to retrieve the data requested by your query.
Usually it does...

2018-07-31

6 reads

All authors

Bert Wagner

FizzBuzz and Multiple Recursive Member CTEs

FizzBuzz and Multiple Recursive Member CTEs

Should You Use Index Hints?

6 Techniques For Troubleshooting Your Code

6 Techniques For Troubleshooting Your Code

Displaying Long Values in SSMS

Displaying Long Values in SSMS

Displaying Long Values in SSMS

Should You Use Index Hints?

Should You Use Index Hints?

Blogs

Setting FK Constraints in Data Modeler

Webinar: Navigating the Database Landscape in 2026

Claude AI Convinced Me Not to Build an iPad App

Forums

SSMS 22 Latest Update Crashing

Transactional Replication setup issue

The Power of Data and Privacy

Question of the Day

What's the Date?