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

Faking Temporal Tables with Triggers

by Bert Wagner

Bert Wagner

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

2018-09-11

3 reads

FizzBuzz and Multiple Recursive Member CTEs

by Bert Wagner

Bert Wagner

Watch this week’s episode on YouTube.
Last week I needed to write a recursive common table expression. I’ve written them before,...

2018-09-07 (first published: 2018-08-21)

2,328 reads

Does The Order Of Index Columns Matter?

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
When beginning to learn SQL, at some point you learn that indexes can be created to help improve the performance of queries.
Creating your first...

2018-09-04

3 reads

Does The Order Of Index Columns Matter?

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
When beginning to learn SQL, at some point you learn that indexes can be created to help improve the performance of queries.
Creating your first...

2018-09-04

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...

2018-08-30 (first published: 2018-08-14)

3,819 reads

Ignoring NULLs with FIRST_VALUE

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
The SQL Server FIRST_VALUE function makes it easy to return the "first value in an ordered set of values."
The problem is that if that...

2018-08-28

10 reads

Ignoring NULLs with FIRST_VALUE

by Bert Wagner

Bert Wagner

Watch this week’s episode on YouTube.
The SQL Server FIRST_VALUE function makes it easy to return the “first value in an...

2018-08-28

8,811 reads

Ignoring NULLs with FIRST_VALUE

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
The SQL Server FIRST_VALUE function makes it easy to return the "first value in an ordered set of values."
The problem is that if that...

2018-08-28

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

5 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

6 reads

All authors

Bert Wagner

Faking Temporal Tables with Triggers

FizzBuzz and Multiple Recursive Member CTEs

Does The Order Of Index Columns Matter?

Does The Order Of Index Columns Matter?

6 Techniques For Troubleshooting Your Code

Ignoring NULLs with FIRST_VALUE

Ignoring NULLs with FIRST_VALUE

Ignoring NULLs with FIRST_VALUE

FizzBuzz and Multiple Recursive Member CTEs

FizzBuzz and Multiple Recursive Member CTEs

Blogs

T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement

The Book of Redgate: What Our Customers Say

Export a Power BI Report that cannot be Downloaded

Forums

fast farward curson vs while loop on @table

Economics of AI: What is the Real Cost to Profit?

Poor Name Choice

Question of the Day

Getting the Indexed Columns