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

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

8 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

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

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

1 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

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

414 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

1 reads

All authors

Bert Wagner

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

Are Stored Procedures Faster Than Stand-Alone Queries?

SQL Server Stored Procedures vs Functions vs Views

Are Stored Procedures Faster Than Stand-Alone Queries?

Communicating Effectively at the Workplace

Communicating Effectively at the Workplace

Blogs

Migrate datetime data to datetimeoffset with AT TIME ZONE

The Comprehensive Guide to Mastering Your SQL DBA Skills

Friday Basics: Authentication vs. Authorization

Forums

Take Care

WhatsApp+19254941544 La guía definitiva para obtener una licencia de conducir en

Performance

Question of the Day

Two Table Hints