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

7 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,687 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

14 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

Using CAT for Testing of Data Agents

Are you getting value from your reporting?

The Book of Redgate: SQL Server Central

Forums

Foreach Loop still executes after process and delete all the folders

Which 'Where' statement conditional upon a variable

Backup to Immutable Storage

Question of the Day

Backup to Immutable Storage