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

Unexpected Shorthand Date Implicit Conversions

by Bert Wagner

Bert Wagner

I do my best work in the mornings. Evenings are pretty good too once I get a second wind.
Late afternoon...

2018-10-30 (first published: 2018-10-23)

2,793 reads

Conditionally Returning Rows Based On Query Results

by Bert Wagner

Bert Wagner

While I normally prefer formatting my query results in a downstream app/reporting layer, sometimes I can’t get around adding some...

2018-10-29 (first published: 2018-10-16)

2,561 reads

Unexpected Shorthand Date Implicit Conversions

by Bert Wagner

Bert Wagner

I do my best work in the mornings. Evenings are pretty good too once I get a second wind.
Late afternoon are my nemesis for getting any serious technical or...

2018-10-23

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...

2018-10-18 (first published: 2018-10-09)

2,717 reads

Conditionally Returning Rows Based On Query Results

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
While I normally prefer formatting my query results in a downstream app/reporting layer, sometimes I can't get around adding some business formatting logic to...

2018-10-16

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

by Bert Wagner

Bert Wagner

This week I had the opportunity to learn about dashboards, reports, and datasets in Power BI using the best kind...

2018-10-11 (first published: 2018-10-02)

2,980 reads

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

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

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,461 reads

All authors

Bert Wagner

Unexpected Shorthand Date Implicit Conversions

Conditionally Returning Rows Based On Query Results

Unexpected Shorthand Date Implicit Conversions

The Project Graveyard

Conditionally Returning Rows Based On Query Results

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

The Project Graveyard

Shortchanged with International Money in SQL Server

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

Faking Temporal Tables with Triggers

Blogs

Attacking the Weakest Link

Migrate datetime data to datetimeoffset with AT TIME ZONE

The Comprehensive Guide to Mastering Your SQL DBA Skills

Forums

timeout in vs for ssas tabular deploy is 0 but i still timeout deploying

Table variable declared within cursor persists across loop iterations

Multiple processes accessing the same table. some to write others to read / Lock

Question of the Day

The Backup File Extension