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,017 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,340 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

7 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

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

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

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

SQL Server Security: Always Encryption

SQL Server Security – TDE Encryption

A Las Vegas Break

Forums

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

This Week's AI Trust Problem Became Everyone’s Problem

Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025

Question of the Day

Identities and Sequences III