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

4 Ways To Define Lookup Values In A Query

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Occasionally you may need to create a lookup table of values for a single query. Building a permanent table of these values is a...

2018-06-05

8 reads

4 Ways To Define Lookup Values In A Query

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Occasionally you may need to create a lookup table of values for a single query. Building a permanent table of these values is a...

2018-06-05

What Does The GO Command Do?

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
When I started working with T-SQL, I thought the GO command was optional, kind of like semicolons. It appeared in plenty of SSMS generated...

2018-05-29

3 reads

What Does The GO Command Do?

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
When I started working with T-SQL, I thought the GO command was optional, kind of like semicolons. It appeared in plenty of SSMS generated...

2018-05-29

1 reads

Converting JSON to SQL Server CREATE TABLE Statements

by Bert Wagner

Bert Wagner

Watch this week’s episode on YouTube.
Tedious, repetitive tasks are the bane of any lazy programmer. I know, because I am...

2018-05-28 (first published: 2018-05-22)

3,403 reads

Converting JSON to SQL Server CREATE TABLE Statements

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Tedious, repetitive tasks are the bane of any lazy programmer. I know, because I am one.
One such repetitive task that I find comparable to...

2018-05-22

1 reads

Converting JSON to SQL Server CREATE TABLE Statements

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Tedious, repetitive tasks are the bane of any lazy programmer. I know, because I am one.
One such repetitive task that I find comparable to...

2018-05-22

6 reads

Why Is My VARCHAR(MAX) Variable Getting Truncated?

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Watch this week's episode on YouTube.
Sometimes SQL Server doesn't do what you tell it to do.
Normally that's ok - SQL is a declarative language...

2018-05-15

5 reads

Why Is My VARCHAR(MAX) Variable Getting Truncated?

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Watch this week's episode on YouTube.
Sometimes SQL Server doesn't do what you tell it to do.
Normally that's ok - SQL is a declarative language...

2018-05-15

3 reads

Why Is My VARCHAR(MAX) Variable Getting Truncated?

by Bert Wagner

Bert Wagner

Watch this week’s episode on YouTube.
Sometimes SQL Server doesn’t do what you tell it to do.
Normally that’s ok – SQL is...

2018-05-15

750 reads

All authors

Bert Wagner

4 Ways To Define Lookup Values In A Query

4 Ways To Define Lookup Values In A Query

What Does The GO Command Do?

What Does The GO Command Do?

Converting JSON to SQL Server CREATE TABLE Statements

Converting JSON to SQL Server CREATE TABLE Statements

Converting JSON to SQL Server CREATE TABLE Statements

Why Is My VARCHAR(MAX) Variable Getting Truncated?

Why Is My VARCHAR(MAX) Variable Getting Truncated?

Why Is My VARCHAR(MAX) Variable Getting Truncated?

Blogs

My 2024 in Data: Health and Workouts

My 2024 in Data: Reading

Book Review – Agile Data Warehouse Design

Forums

Unlock Huge Savings with Discount Coupons from Coupon Dealz – Your Ultimate Savi

Unlock Huge Savings with Discount Coupons from Coupon Dealz – Your Ultimate Savi

Connecting Streamlit to Upload Data to Snowflake

Question of the Day

DCL