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

Blog Post

Tracking Who Last Changed a Row

This post is a response to this month's T-SQL Tuesday #118 prompt by Kevin Chant.  T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and professional...

2019-09-10

5 reads

Blog Post

SQL Server Execution Plan Operators

Watch this week’s Execution Plan Operators episode on YouTube. SQL Server Execution Plan Operators When examining a query’s execution plan, certain operators tend to crop up over and over...

2019-08-26 (first published: )

1,510 reads

Blog Post

SQL Server Execution Plan Operators

Watch this week's video on YouTube

Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans

When examining...

2019-08-13

2 reads

Blog Post

Execution Plans: Statistics

Watch this week’s Statistics video on YouTube. Last week we looked at what execution plans are and how you can view them. This week I want to discuss what data...

2019-08-12 (first published: )

677 reads

Blog Post

Execution Plans: Statistics

Watch this week's video on YouTube

Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans

Last week...

2019-07-30

1 reads

All authors

Blogs

Parsing EXE Output in PowerShell

By

I saw a post internally that asked this question: Anyone have a handy powershell...

Connect With More Clients: Our Partner Directory Has Arrived

By

The partner directory connects your agency with new customers.

Can You See Who Forced a Plan

By

I had an excellent group of people in Gothenburg Sweden when I taught there...

Read the latest Blogs

Forums

GIT Configuration and Automated Release for Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item GIT Configuration and Automated Release...

Output to flat file with no delimiter

By stricknyn

Hello all, Is there an easy way to output my records to a flat...

Refactoring Databases: Evolutionary Database Design

By Site Owners

Comments posted to this topic are about the item Refactoring Databases: Evolutionary Database Design

Visit the forum

Question of the Day

Concat Addition

What is the result of this code? 

SELECT CONCAT(1, 2, 3) + 4

See possible answers