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

12 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,676 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

318 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

9 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

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

6 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

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

9 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

18 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

Measuring RAG Solutions: Are We Retrieving the Right Information?

Advice I Like: Lots of Ideas

Building a DBA Agent for Your SQL Server Estate with MCP

Forums

How do I connect to a SQL Server database on my ISP?

Looking for New Blood

Server-Level Row Counts for Tables and Views

Question of the Day

Hyperscale Replicas I