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

Pinal Dave Helps Me Fix My Performance Tuning Problems

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
This week I was fortunate enough to film a video in collaboration with Pinal Dave, the SQL Authority himself. Pinal is creative, hilarious, and...

2018-07-24

1 reads

Building Dynamic Table-Driven Queries

by Bert Wagner

Bert Wagner

This post is a response to this month’s T-SQL Tuesday #104 prompt by me! T-SQL Tuesday is a way for...

2018-07-17 (first published: 2018-07-10)

3,162 reads

T-SQL Tuesday #104 Roundup

by Bert Wagner

Bert Wagner

This month's T-SQL Tuesday topic asked "What code would you hate to live without?" Turns out you like using script and code to automate boring, repetitive, and error-prone tasks.
Thank...

2018-07-17

T-SQL Tuesday #104 Roundup

by Bert Wagner

Bert Wagner

This month's T-SQL Tuesday topic asked "What code would you hate to live without?" Turns out you like using script and code to automate boring, repetitive, and error-prone tasks.
Thank...

2018-07-17

Building Dynamic Table-Driven Queries

by Bert Wagner

Bert Wagner

This post is a response to this month's T-SQL Tuesday #104 prompt by me! T-SQL Tuesday is a way for SQL Server bloggers to share ideas about different database...

2018-07-10

4 reads

Building Dynamic Table-Driven Queries

by Bert Wagner

Bert Wagner

This post is a response to this month's T-SQL Tuesday #104 prompt by me! T-SQL Tuesday is a way for SQL Server bloggers to share ideas about different database...

2018-07-10

6 reads

Filtering Tables, Procedures, And Other Objects In SSMS

by Bert Wagner

Bert Wagner

While the text of this post contains good information on SSMS object filters, I highly recommend watching this week’s video...

2018-07-05 (first published: 2018-06-26)

2,422 reads

Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)

by Bert Wagner

Bert Wagner

The recent news about Microsoft acquiring GitHub has me thinking about how amazing it is for us to be part of today's online code community.
Before modern online programming communities,...

2018-07-03

Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)

by Bert Wagner

Bert Wagner

The recent news about Microsoft acquiring GitHub has me thinking about how amazing it is for us to be part...

2018-07-03

261 reads

Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)

by Bert Wagner

Bert Wagner

The recent news about Microsoft acquiring GitHub has me thinking about how amazing it is for us to be part of today's online code community.
Before modern online programming communities,...

2018-07-03

2 reads

All authors

Bert Wagner

Pinal Dave Helps Me Fix My Performance Tuning Problems

Building Dynamic Table-Driven Queries

T-SQL Tuesday #104 Roundup

T-SQL Tuesday #104 Roundup

Building Dynamic Table-Driven Queries

Building Dynamic Table-Driven Queries

Filtering Tables, Procedures, And Other Objects In SSMS

Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)

Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)

Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)

Blogs

My 2024 in Data: Music

A New Word: Suente

Side Projects

Forums

2 identical tables reads on Table1 PK is 53394 reads on table2 PK 2246847

Azure SSMS SQL Managed instance Windows Authentication

Connecting Streamlit to Upload Data to Snowflake

Question of the Day

DCL