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

11 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,674 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

316 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

7 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

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

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

3,467 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

4 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

2 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

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

15 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

Rambling about Data on Wheels – origins, branding, expansion

Think Twice Before Enabling Fabric’s Inbound Network Protection

Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python

Forums

AI Observability Challenges in FinOps as a DBA

Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL

SQL Agent Job Automated Change Capture Process

Question of the Day

Finding a Database Master Key