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

The Project Graveyard

by Bert Wagner

Bert Wagner

This post is a response to this month's T-SQL Tuesday #107 prompt by Jeff Mlakar. T-SQL Tuesday is a way for the SQL Server community to share ideas about...

2018-10-09

2 reads

Shortchanged with International Money in SQL Server

by Bert Wagner

Bert Wagner

Imagine you have to perform some salary analysis for your employer International Mega Corp.
The data you have to work with...

2018-10-03 (first published: 2018-09-25)

1,737 reads

Power BI Dashboards, Reports, and Datasets with the SQL Chefs

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
This week I had the opportunity to learn about dashboards, reports, and datasets in Power BI using the best kind of teaching tool: fresh,...

2018-10-02

4 reads

Power BI Dashboards, Reports, and Datasets with the SQL Chefs

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
This week I had the opportunity to learn about dashboards, reports, and datasets in Power BI using the best kind of teaching tool: fresh,...

2018-10-02

8 reads

Faking Temporal Tables with Triggers

by Bert Wagner

Bert Wagner

This post is a response to this month’s T-SQL Tuesday #106 prompt by Steve Jones. T-SQL Tuesday is a way...

2018-09-26 (first published: 2018-09-11)

2,478 reads

Shortchanged with International Money in SQL Server

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Imagine you have to perform some salary analysis for your employer International Mega Corp.
The data you have to work with looks something like this:
DROP...

2018-09-25

5 reads

Shortchanged with International Money in SQL Server

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Imagine you have to perform some salary analysis for your employer International Mega Corp.
The data you have to work with looks something like this:
DROP...

2018-09-25

5 reads

Extracting JSON Values Longer Than 4000 Characters

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
A while back I built an automated process that parses JSON strings into a relational format.
Up until recently this process had been working great:...

2018-09-18

9 reads

Extracting JSON Values Longer Than 4000 Characters

by Bert Wagner

Bert Wagner

A while back I built an automated process that parses JSON strings into a relational format.
Up until recently this process...

2018-09-18

1,181 reads

Extracting JSON Values Longer Than 4000 Characters

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
A while back I built an automated process that parses JSON strings into a relational format.
Up until recently this process had been working great:...

2018-09-18

6 reads

All authors

Bert Wagner

The Project Graveyard

Shortchanged with International Money in SQL Server

Power BI Dashboards, Reports, and Datasets with the SQL Chefs

Power BI Dashboards, Reports, and Datasets with the SQL Chefs

Faking Temporal Tables with Triggers

Shortchanged with International Money in SQL Server

Shortchanged with International Money in SQL Server

Extracting JSON Values Longer Than 4000 Characters

Extracting JSON Values Longer Than 4000 Characters

Extracting JSON Values Longer Than 4000 Characters

Blogs

Upgrading SQL Server Containers on the Laptop

How to Find Expensive Queries in Amazon Redshift

The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech

Forums

SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade

How Long is a Long I/O?

T-SQL Trigonometric Functions in SQL Server

Question of the Day

How Long is a Long I/O?