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

Does The Order Of Index Columns Matter?

by Bert Wagner

Bert Wagner

When beginning to learn SQL, at some point you learn that indexes can be created to help improve the performance...

2018-09-13 (first published: 2018-09-04)

5,016 reads

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

5 reads

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

5 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,336 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 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,823 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,865 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

11 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

13 reads

All authors

Bert Wagner

Does The Order Of Index Columns Matter?

Faking Temporal Tables with Triggers

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

Blogs

Rolling Back a Broken Release

A bespoke reporting solution doesn’t have to cost the earth

Presenting with Visual Studio Code

Forums

Cross-DB Ownership Chaining problem

Lots of FKs

Real-time On-prem SQL Server Data in Excel – Over the Internet

Question of the Day

Lots of FKs