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

448 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

6 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

9 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

5 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

Blog Post

CHOOSE() in SQL Server

Watch this week’s episode on YouTube. While I know I don’t utilize most of the features available in SQL Server, I like to think I’m at least aware that those features...

2019-06-04

303 reads

Blog Post

CHOOSE() in SQL Server

Watch this week's video on YouTube
While I know I don't utilize most of the features available in SQL Server, I like to think I'm at least aware that those features exist.
This...

2019-06-04

1 reads

Blogs

SQL Training Black Friday Deals

By

If you're looking for particular "Black Friday" deals, here is what I've seen advertised...

Dry-run xp_delete_file Before Actually Deleting Files?

By

Dry-run xp_delete_file Before Actually Deleting Files? xp_delete_file doesn’t really have a...

Happy Thanksgiving! (USA Holiday)

By

In the United States, today is Thanksgiving. The intent behind the holiday is to...

Read the latest Blogs

Forums

Which Object Definitions Are Available?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Which Object Definitions Are Available?

What's Your Theme Music?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What's Your Theme Music?

T-SQL in SQL Server 2025: The PRODUCT Function

By Steve Jones - SSC Editor

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

Visit the forum

Question of the Day

Which Object Definitions Are Available?

For which of these object types can I get the code when I run the OBJECT_DEFINITION() function in SQL Server 2025? (choose 3)

See possible answers