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

9 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

9 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,641 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

2 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

9 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

7 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

373 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

7 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

7 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

Why I stopped using MCP for AI coding stuff

AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning

AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention

Forums

Dynamic Unpivot

Writing as an Art and a Job

String Similarity II

Question of the Day

String Similarity II