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

Should You Use Index Hints?

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
One of the things that the SQL Server query optimizer does is determine how to retrieve the data requested by your query.
Usually it does...

2018-07-31

15 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...

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

2,681 reads

Pinal Dave Helps Me Fix My Performance Tuning Problems

by Bert Wagner

Bert Wagner

Be sure to check out this week’s video on YouTube.
This week I was fortunate enough to film a video in...

2018-07-24

321 reads

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

10 reads

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

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

7 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

8 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

13 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

22 reads

All authors

Bert Wagner

Should You Use Index Hints?

T-SQL Tuesday #104 Roundup

Pinal Dave Helps Me Fix My Performance Tuning Problems

Pinal Dave Helps Me Fix My Performance Tuning Problems

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

Blogs

The Book of Redgate:A Prehistory

Evidence-bound: what AgentDBA will and won’t link

Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?

Forums

Four Rules for Adding AI Without Breaking What Already Works

SQL Server 2025 section missing?

A design question in a parent child relationship

Question of the Day

Hyperscale Replicas III