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

Brute Forcing SQL Logins and Passwords

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Following up on last week's post about the different types of SQL injection, this week I want to show how injection can be used...

2018-11-27

10 reads

4 SQL Injection Techniques For Stealing Data

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
I'm not advocating that you start using SQL injection to start stealing other people's data.
However, I do think that you should familiarize...

2018-11-20

15 reads

4 SQL Injection Techniques For Stealing Data

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
I'm not advocating that you start using SQL injection to start stealing other people's data.
However, I do think that you should familiarize...

2018-11-20

5 reads

Learning New Skills

by Bert Wagner

Bert Wagner

This post is a response to this month’s T-SQL Tuesday #108 prompt by Malathi Mahadevan. T-SQL Tuesday is a way...

2018-11-15 (first published: 2018-11-06)

2,669 reads

Bert & Pinal Troubleshoot a Slow Performing SQL Server

by Bert Wagner

Bert Wagner

What happens when you run into performance tuning expert Pinal Dave? Talk about how to troubleshoot a slow performing SQL...

2018-11-13

347 reads

Bert & Pinal Troubleshoot a Slow Performing SQL Server

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
What happens when you run into performance tuning expert Pinal Dave? Talk about how to troubleshoot a slow performing SQL Server of course!
This week...

2018-11-13

6 reads

Bert & Pinal Troubleshoot a Slow Performing SQL Server

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
What happens when you run into performance tuning expert Pinal Dave? Talk about how to troubleshoot a slow performing SQL Server of course!
This week...

2018-11-13

5 reads

The 5 Scariest Moments for a SQL Server Developer

by Bert Wagner

Bert Wagner

While families and friends are scaring each other this Halloween week with stories of ghosts and ghouls, I thought it’d...

2018-11-08 (first published: 2018-10-30)

4,986 reads

Learning New Skills

by Bert Wagner

Bert Wagner

This post is a response to this month's T-SQL Tuesday #108 prompt by Malathi Mahadevan. T-SQL Tuesday is a way for the SQL Server community to share ideas about...

2018-11-06

4 reads

Learning New Skills

by Bert Wagner

Bert Wagner

This post is a response to this month's T-SQL Tuesday #108 prompt by Malathi Mahadevan. T-SQL Tuesday is a way for the SQL Server community to share ideas about...

2018-11-06

5 reads

All authors

Bert Wagner

Brute Forcing SQL Logins and Passwords

4 SQL Injection Techniques For Stealing Data

4 SQL Injection Techniques For Stealing Data

Learning New Skills

Bert & Pinal Troubleshoot a Slow Performing SQL Server

Bert & Pinal Troubleshoot a Slow Performing SQL Server

Bert & Pinal Troubleshoot a Slow Performing SQL Server

The 5 Scariest Moments for a SQL Server Developer

Learning New Skills

Learning New Skills

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