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

Using curl to Automate Multipage Logins

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
I like solving the daily New York Times crossword on paper. However, logging in to download the PDF every day and printing it is...

2022-03-03

7 reads

Recursively Querying Row Groups

by Bert Wagner

Bert Wagner

Recursively Querying Related Rows Recursive queries are fun to plan and write. They can be frustrating too depending on the complexity of the problem you are trying to solve....

2020-09-02 (first published: 2020-08-25)

581 reads

Recursively Querying Row Groups

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Recursively Querying Related Rows
Recursive queries are fun to plan and write. They can be frustrating too depending on the complexity of the problem you...

2020-08-25

16 reads

Recursively Querying Row Groups

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Recursive queries are fun to plan and write. They can be frustrating too depending on the complexity of the problem you are trying to...

2020-08-25

15 reads

Should I Transform My Data In My SQL Query?

by Bert Wagner

Bert Wagner

Watch this week’s video on YouTube. Imagine you need to join two tables of data and filter the results. Perhaps you also need to convert some of the values...

2020-08-10 (first published: 2020-07-29)

581 reads

Moving 1/3 of a heap

by Bert Wagner

Bert Wagner

Watch this week’s video on YouTube. A Giant Heap Recently I had to filter out 1.2 billion records from a 3.5 billion row heap. Don’t ask me why this...

2020-08-03 (first published: 2020-07-22)

287 reads

Should I Transform My Data In My SQL Query?

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Imagine you need to join two tables of data and filter the results. Perhaps you also need to convert some of the values for...

2020-07-29

10 reads

Should I Transform My Data In My SQL Query?

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Imagine you need to join two tables of data and filter the results. Perhaps you also need to convert some of the values for...

2020-07-29

7 reads

Moving 1/3 of a heap

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
A Giant Heap
Recently I had to filter out 1.2 billion records from a 3.5 billion row heap. Don't ask me why this 3.5 billion...

2020-07-22

15 reads

Moving 1/3 of a heap

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
A Giant Heap
Recently I had to filter out 1.2 billion records from a 3.5 billion row heap. Don't ask me why this 3.5 billion...

2020-07-22

6 reads

All authors

Bert Wagner

Using curl to Automate Multipage Logins

Recursively Querying Row Groups

Recursively Querying Row Groups

Recursively Querying Row Groups

Should I Transform My Data In My SQL Query?

Moving 1/3 of a heap

Should I Transform My Data In My SQL Query?

Should I Transform My Data In My SQL Query?

Moving 1/3 of a heap

Moving 1/3 of a heap

Blogs

A New Word: Dolorblindness

Claude Code Helps Analyze Test Data Manager Log Files

PowerPoint to HTML with Claude AI

Forums

Optimism Without Illusion or Why AI Needs Blunt Technologists

SSIS with VS2022 64/32 issue with Excel files

Case part is sloooooow

Question of the Day

The String Distance I