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 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,310 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

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

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

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

3,813 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,381 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

5 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

4 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

1 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,362 reads

All authors

Bert Wagner

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

Should You Use Index Hints?

Blogs

My 2024 in Data: Music

A New Word: Suente

Side Projects

Forums

DTEXEC Not working for my project: Cannot create a task from XML for task

Migrated to new server, 2019 enterprise, jobs taking 300% longer to run. Ideas?

2 identical tables reads on Table1 PK is 53394 reads on table2 PK 2246847

Question of the Day

DCL