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

547 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,693 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

SQL Server Security: Always Encryption

SQL Server Security – TDE Encryption

A Las Vegas Break

Forums

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

This Week's AI Trust Problem Became Everyone’s Problem

Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025

Question of the Day

Identities and Sequences III