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

Are your indexes being thwarted by mismatched datatypes?

by Bert Wagner

Bert Wagner

In this series I explore scenarios that hurt SQL Server performance and show you how to avoid them. Pulled from my collection of "things I didn't know I was...

2017-08-01

14 reads

One SSMS Trick That Will Make You a Faster Query Builder

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Here's the scenario: you copy and paste some code into a query you are building. A few minutes later you need that same snippet...

2017-07-25

9 reads

How to Use SQL Temporal Tables For Easy Point-In-Time Analysis

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Have you ever needed to look at what data in a table used to look like?
If you have, it probably took a knuckle-cracking filled...

2017-07-20

13 reads

Here's a Quick Way To Generate a Running Total in SQL Server

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Historically it's been difficult to accomplish certain tasks in SQL Server.
Probably the most annoying problem I had to do regularly before SQL Server 2012...

2017-07-18

29 reads

My Most Embarrassing SQL Moment

by Bert Wagner

Bert Wagner

T-SQL Tuesday #92: Lessons Learned the Hard Way

This post is a response to this month's T-SQL Tuesday prompt. T-SQL Tuesday was created by Adam Machanic and is a way for...

2017-07-11

11 reads

How to Automatically Purge Historical Data From a Temporal Table

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Temporal Tables are awesome.
They make analyzing time-series data a cinch, and because they automatically track row-level history, rolling-back from an "oops" scenario doesn't mean...

2017-07-04

28 reads

How to Put SQL Column Names Onto Multiple Lines in SSMS

by Bert Wagner

Bert Wagner

SQL in 60 Seconds is a series where I share SQL tips and tricks that you can learn and start using in less than a minute.

Watch this week's video...

2017-06-27

20 reads

5 Business Problems You Can Solve With Temporal Tables

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
It's 4:30 pm on Friday and Mr. Manager comes along to tell you that he needs you to run some important ad-hoc analysis for...

2017-06-20

25 reads

Behind the Scenes of an Online Presentation

by Bert Wagner

Bert Wagner

Last week I presented my session "DBAs vs Developers: JSON in SQL Server 2016" at the online GroupBy Conference.
As I prepared for the event, I thought about all of...

2017-06-13

12 reads

5 Things You Need to Do When Performance Testing JSON in SQL and C#

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Want to learn more about using JSON in SQL Server? Watch me present at the online GroupBy conference on June 9, 2017 at 8am.
I've...

2017-06-06

27 reads

All authors

Bert Wagner

Are your indexes being thwarted by mismatched datatypes?

One SSMS Trick That Will Make You a Faster Query Builder

How to Use SQL Temporal Tables For Easy Point-In-Time Analysis

Here's a Quick Way To Generate a Running Total in SQL Server

My Most Embarrassing SQL Moment

How to Automatically Purge Historical Data From a Temporal Table

How to Put SQL Column Names Onto Multiple Lines in SSMS

5 Business Problems You Can Solve With Temporal Tables

Behind the Scenes of an Online Presentation

5 Things You Need to Do When Performance Testing JSON in SQL and C#

Blogs

Think Twice Before Enabling Fabric’s Inbound Network Protection

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

Advice I Like: Responsibility

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