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.

Blog Post

Joker’s Wild

This past weekend I had a blast presenting Joker’s Wild with Erin Stellato (blog|twitter), Andy Mallon (blog|twitter), and Drew Furgiuele (blog|twitter). Watch it here! Table of contents: What is...

2019-06-25 (first published: )

450 reads

Blog Post

Multiple Identity Inserts

Watch this week's video on YouTube
This week I want to share something that surprised me about using SQL Server's SET IDENTITY_INSERT statement.
I started with two tables with identity columns...

2019-06-25

7 reads

Blog Post

Multiple Identity Inserts

Watch this week's video on YouTube
This week I want to share something that surprised me about using SQL Server's SET IDENTITY_INSERT statement.
I started with two tables with identity columns...

2019-06-25

13 reads

Blog Post

Joker's Wild

This past weekend I had a blast presenting Joker's Wild with Erin Stellato (blog|twitter), Andy Mallon (blog|twitter), and Drew Furgiuele (blog|twitter).

Watch this week's video on YouTube
Table of contents:

What is...

2019-06-11

8 reads

Blog Post

Joker's Wild

This past weekend I had a blast presenting Joker's Wild with Erin Stellato (blog|twitter), Andy Mallon (blog|twitter), and Drew Furgiuele (blog|twitter).

Watch this week's video on YouTube
Table of contents:

What is...

2019-06-11

1 reads

Blogs

A New Word: Dolorblindness

By

dolorblindness – n. the frustration that you’ll never be able to understand another person’s...

Claude Code Helps Analyze Test Data Manager Log Files

By

I had a customer ask about analyzing their Test Data Manager (TDM) usage to...

PowerPoint to HTML with Claude AI

By

I had an idea for an animated view of a sales tool, and started...

Read the latest Blogs

Forums

Optimism Without Illusion or Why AI Needs Blunt Technologists

By dbakevlar

Comments posted to this topic are about the item Optimism Without Illusion or Why...

SSIS with VS2022 64/32 issue with Excel files

By mario17

Hi all, I'm trying to do classic scenario for loading multiple Excel files into...

Case part is sloooooow

By krypto69

Hi So the case statement is slowing this down - but for the life...

Visit the forum

Question of the Day

The String Distance I

In SQL Server 2025, what is returned by this code:

SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled.

See possible answers