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

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

546 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

8 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

6 reads

Are Stored Procedures Faster Than Stand-Alone Queries?

by Bert Wagner

Bert Wagner

Watch this week’s episode on YouTube. A few months ago I was presenting for a user group when someone asked the following question: Does a query embedded in a...

2019-10-24 (first published: 2019-10-15)

1,690 reads

SQL Server Stored Procedures vs Functions vs Views

by Bert Wagner

Bert Wagner

Watch this week's video 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. The more...

2019-10-22

10 reads

SQL Server Stored Procedures vs Functions vs Views

by Bert Wagner

Bert Wagner

2019-10-22

15 reads

Are Stored Procedures Faster Than Stand-Alone Queries?

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
A few months ago I was presenting for a user group when someone asked the following question:
Does a query embedded in a stored procedure...

2019-10-15

12 reads

Are Stored Procedures Faster Than Stand-Alone Queries?

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
A few months ago I was presenting for a user group when someone asked the following question:
Does a query embedded in a stored procedure...

2019-10-15

6 reads

Communicating Effectively at the Workplace

by Bert Wagner

Bert Wagner

This post is a response to this month’s T-SQL Tuesday #119 prompt by Alex Yates. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...

2019-10-10 (first published: 2019-10-08)

420 reads

Communicating Effectively at the Workplace

by Bert Wagner

Bert Wagner

This post is a response to this month's T-SQL Tuesday #119 prompt by Alex Yates. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...

2019-10-08

3 reads

All authors

Bert Wagner

SQL Server 2019 Feature Power Rankings

SQL Server 2019 Feature Power Rankings

SQL Server 2019 Feature Power Rankings

Are Stored Procedures Faster Than Stand-Alone Queries?

SQL Server Stored Procedures vs Functions vs Views

SQL Server Stored Procedures vs Functions vs Views

Are Stored Procedures Faster Than Stand-Alone Queries?

Are Stored Procedures Faster Than Stand-Alone Queries?

Communicating Effectively at the Workplace

Communicating Effectively at the Workplace

Blogs

How Fabric Mirroring Transformed with SQL Server 2025

The DIY Cost of Masking Test Data For Smaller Organizations

T-SQL Tuesday #196 – Two risky career decisions I made

Forums

XACT_ABORT being set to ON by web services

OPENQUERY Flexibility

A Full Shutdown

Question of the Day

OPENQUERY Flexibility