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

Extracting JSON Values Longer Than 4000 Characters

by Bert Wagner

Bert Wagner

A while back I built an automated process that parses JSON strings into a relational format.
Up until recently this process...

2018-09-18

1,647 reads

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

9 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

18 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,359 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

13 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,840 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

26 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,996 reads

All authors

Bert Wagner

Extracting JSON Values Longer Than 4000 Characters

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

Blogs

The Book of Redgate:A Prehistory

Evidence-bound: what AgentDBA will and won’t link

Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?

Forums

Four Rules for Adding AI Without Breaking What Already Works

SQL Server 2025 section missing?

A design question in a parent child relationship

Question of the Day

Hyperscale Replicas III