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 5 Scariest Moments for a SQL Server Developer

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
While families and friends are scaring each other this Halloween week with stories of ghosts and ghouls, I thought it'd be way scarier to talk...

2018-10-30

4 reads

The 5 Scariest Moments for a SQL Server Developer

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
While families and friends are scaring each other this Halloween week with stories of ghosts and ghouls, I thought it'd be way scarier to talk...

2018-10-30

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

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

2,807 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,664 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

7 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

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

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

2,724 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

53 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

6 reads

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

All authors

Bert Wagner

The 5 Scariest Moments for a SQL Server Developer

The 5 Scariest Moments for a SQL Server Developer

Unexpected Shorthand Date Implicit Conversions

Conditionally Returning Rows Based On Query Results

Unexpected Shorthand Date Implicit Conversions

Unexpected Shorthand Date Implicit Conversions

The Project Graveyard

Conditionally Returning Rows Based On Query Results

Conditionally Returning Rows Based On Query Results

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

Blogs

Rambling about Data on Wheels – origins, branding, expansion

Think Twice Before Enabling Fabric’s Inbound Network Protection

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

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