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

Azure SQL vs Azure Table Storage

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
A year ago I built an app to keep track of pickup volleyball game scores and payments. It works well, but after a year...

2019-12-03

1 reads

When a SQL UPDATE Statement DELETES Rows

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
At first I wasn't going to write this post. I thought it would be too simple.
Then I watched two experienced SQL developers go through...

2019-11-26

6 reads

When a SQL UPDATE Statement DELETES Rows

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
At first I wasn't going to write this post. I thought it would be too simple.
Then I watched two experienced SQL developers go through...

2019-11-26

1 reads

First Time Speaking at PASS Summit

by Bert Wagner

Bert Wagner

This week, I filmed my experience as a first time speaker at PASS Summit in Seattle. No blog post, just a video to relive the experience.

2019-11-12

9 reads

First Time Speaking at PASS Summit

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
This week, I filmed my experience as a first time speaker at PASS Summit in Seattle. No blog post, just a video to relive...

2019-11-12

1 reads

First Time Speaking at PASS Summit

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
This week, I filmed my experience as a first time speaker at PASS Summit in Seattle. No blog post, just a video to relive...

2019-11-12

SQL Server Stored Procedures vs Functions vs Views

by Bert Wagner

Bert Wagner

Watch this week’s episode on YouTube. SQL Server has several ways to store queries for later executions. This makes developers happy because it allows them to follow DRY principles: Don’t Repeat Yourself....

2019-11-04 (first published: 2019-10-22)

2,976 reads

SQL Server 2019 Feature Power Rankings

by Bert Wagner

Bert Wagner

Watch me comment on all of the features in this week’s video. With the release of SQL Server 2019 imminent, I thought it’d be fun to rank which features...

2019-10-29

536 reads

SQL Server 2019 Feature Power Rankings

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
With the release of SQL Server 2019 imminent, I thought it'd be fun to rank which features I am most looking forward to in...

2019-10-29

2 reads

SQL Server 2019 Feature Power Rankings

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
With the release of SQL Server 2019 imminent, I thought it'd be fun to rank which features I am most looking forward to in...

2019-10-29

All authors

Bert Wagner

Azure SQL vs Azure Table Storage

When a SQL UPDATE Statement DELETES Rows

When a SQL UPDATE Statement DELETES Rows

First Time Speaking at PASS Summit

First Time Speaking at PASS Summit

First Time Speaking at PASS Summit

SQL Server Stored Procedures vs Functions vs Views

SQL Server 2019 Feature Power Rankings

SQL Server 2019 Feature Power Rankings

SQL Server 2019 Feature Power Rankings

Blogs

Simple Talks Episode 9–Data masking and subsetting

T-SQL Tuesday #180: Avoid Perfect for Good Enough

Book Review – Humanizing Data Strategy by Tiankai Feng

Forums

DBATools in a agent job

SQL server help (converting rows to columns)

Ingesting Data From REST API endpoints: Data Engineering with Fabric

Question of the Day

The Hash Join I