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

How to Safely Parameterize Table Names

by Bert Wagner

Bert Wagner

Protecting against SQL Injection Part 2

Watch this week's video on YouTube
Last week we talked about building dynamic SQL queries and how doing so might leave you open to SQL injection...

2017-09-05

3 reads

Warning! Are your queries vulnerable to SQL injection?

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Looking for a script to find possible SQL injection vulnerabilities on your server? Scroll to the bottom of this post.

OWASP names SQL injection as...

2017-08-29

9 reads

How to Search and Destroy Non-SARGable Queries on Your Server

by Bert Wagner

Bert Wagner

Unexpected SQL Server Performance Killers #3

Watch this week's video on YouTube
In this series I explore scenarios that hurt SQL Server performance and show you how to avoid them. Pulled...

2017-08-22

8 reads

How to Eliminate Ugly Nested REPLACE() Functions

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
How many times have you had to transform some column value and ended up stacking several nested SQL REPLACE() functions like this?
-- Input: Red,...

2017-08-15

8 reads

SQLskills is Giving Away Free Training!

by Bert Wagner

Bert Wagner

SQLskills is giving away free training for their performance tuning and optimization classes. My entry for the competition is below. If you decide to enter for yourself, entries are...

2017-08-11

1 reads

Why Parameter Sniffing Isn't Always A Bad Thing (But Usually Is)

by Bert Wagner

Bert Wagner

In this series I explore scenarios that hurt SQL Server performance and show you how to avoid them. Pulled from my collection of "things I didn't know I was...

2017-08-08

5 reads

Are your indexes being thwarted by mismatched datatypes?

by Bert Wagner

Bert Wagner

In this series I explore scenarios that hurt SQL Server performance and show you how to avoid them. Pulled from my collection of "things I didn't know I was...

2017-08-01

2 reads

One SSMS Trick That Will Make You a Faster Query Builder

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Here's the scenario: you copy and paste some code into a query you are building. A few minutes later you need that same snippet...

2017-07-25

5 reads

How to Use SQL Temporal Tables For Easy Point-In-Time Analysis

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Have you ever needed to look at what data in a table used to look like?
If you have, it probably took a knuckle-cracking filled...

2017-07-20

5 reads

Here's a Quick Way To Generate a Running Total in SQL Server

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Historically it's been difficult to accomplish certain tasks in SQL Server.
Probably the most annoying problem I had to do regularly before SQL Server 2012...

2017-07-18

23 reads

All authors

Bert Wagner

How to Safely Parameterize Table Names

Warning! Are your queries vulnerable to SQL injection?

How to Search and Destroy Non-SARGable Queries on Your Server

How to Eliminate Ugly Nested REPLACE() Functions

SQLskills is Giving Away Free Training!

Why Parameter Sniffing Isn't Always A Bad Thing (But Usually Is)

Are your indexes being thwarted by mismatched datatypes?

One SSMS Trick That Will Make You a Faster Query Builder

How to Use SQL Temporal Tables For Easy Point-In-Time Analysis

Here's a Quick Way To Generate a Running Total in SQL Server

Blogs

My 2024 in Data: Reading

Book Review – Agile Data Warehouse Design

My 2024 in Data: Speaking

Forums

Need ADF pipeline suggestion to copy 1 million files

Backup issues

Function Defaults

Question of the Day

Function Defaults