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

How To Use 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-05-23

17 reads

XML vs JSON Shootout: Which is Superior in SQL Server 2016?

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Additional performance comparisons available in an updated post.
Starting with the 2016 release, SQL Server offers native JSON support. Although the implementation is not perfect,...

2017-05-16

26 reads

One SQL Cheat Code For Amazingly Fast JSON Queries

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Recently I've been working with JSON in SQL Server 2016 a lot.
One of the hesitations many people have with using JSON in SQL Server...

2017-05-09

43 reads

How to fix your terribly slow SQL job

by Bert Wagner

Bert Wagner

How many times have you written a program, ETL, analysis job, etc… that seemed like it would never finish running?
Although poor performance can be caused in a multitude of...

2017-05-02

17 reads

Three Changes You Should Always Make Before Checking In Any Code

by Bert Wagner

Bert Wagner

This story originally appeared in Hacker Noon on March 11, 2017.
A code refactor always leaves me with a feeling of accomplishment. Although major refactorings are the most satisfying, every...

2017-04-25

40 reads

How to write understandable code for your future self

by Bert Wagner

Bert Wagner

This story originally appeared in Hacker Noon on February 10, 2017.
I can't tell you the number of times the title of this post has crossed my mind as I...

2017-04-18

11 reads

Will Technology Eliminate Your Tech Job?

by Bert Wagner

Bert Wagner

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 SQL users to share ideas about...

2017-04-11

5 reads

[Video] JSON Usage and Performance in SQL Server 2016

by Bert Wagner

Bert Wagner

Last night I had the privilege to present to the Ohio North SQL Server User Group about JSON in SQL Server 2016. There was a great crowd present (they...

2017-04-05

6 reads

Who Stuck These Letters In My DateTimes?

by Bert Wagner

Bert Wagner

Parsing, creating, and modifying JSON in SQL Server 2016 is really easy. JSON dates and times are not.
Coming from a predominantly SQL background, the JSON DateTime format took some...

2017-03-28

15 reads

C#'s foreach ruined my afternoon

by Bert Wagner

Bert Wagner

The other afternoon I ran into some nightmarish debugging with the following code:
private static void StartThreads()
{
var values = new List<int>() { 1, 2, 3 };
...

2017-03-21

7 reads

All authors

Bert Wagner

How To Use Temporal Tables For Easy Point-In-Time Analysis

XML vs JSON Shootout: Which is Superior in SQL Server 2016?

One SQL Cheat Code For Amazingly Fast JSON Queries

How to fix your terribly slow SQL job

Three Changes You Should Always Make Before Checking In Any Code

How to write understandable code for your future self

Will Technology Eliminate Your Tech Job?

[Video] JSON Usage and Performance in SQL Server 2016

Who Stuck These Letters In My DateTimes?

C#'s foreach ruined my afternoon

Blogs

AI: Blog a Day – Day 7: Vector and Vector Databases

AI: Blog a Day – Day 6: Embeddings – How AI Understands

The Book of Redgate: Mistakes

Forums

Why End-User Testing Is Even More Important with AI

Dynamic Unpivot

Writing as an Art and a Job

Question of the Day

String Similarity II