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

Visualizing Merge Join Internals And Understanding Their Implications

by Bert Wagner

Bert Wagner

This post is part 2 in a series about physical join operators (be sure to check out part 1 - nested loops joins, and part 3 - hash match...

2018-12-18

10 reads

Visualizing Nested Loops Joins And Understanding Their Implications

by Bert Wagner

Bert Wagner

This post is the first in a series about physical join operators (be sure to check out part 2 - merge joins, and part 3 - hash match joins).

Watch...

2018-12-11

21 reads

Visualizing Nested Loops Joins And Understanding Their Implications

by Bert Wagner

Bert Wagner

This post is the first in a series about physical join operators (be sure to check out part 2 – merge...

2018-12-11

983 reads

Visualizing Nested Loops Joins And Understanding Their Implications

by Bert Wagner

Bert Wagner

This post is the first in a series about physical join operators (be sure to check out part 2 - merge joins, and part 3 - hash match joins).

Watch...

2018-12-11

17 reads

4 SQL Injection Techniques For Stealing Data

by Bert Wagner

Bert Wagner

Watch this week’s episode on YouTubeI’m not advocating that you start using SQL injection to start stealing other people’s data.

However,...

2018-12-05 (first published: 2018-11-20)

3,377 reads

Two Words For Faster Scalar Functions

by Bert Wagner

Bert Wagner

Watch this week’s episode on YouTube.WITH SCHEMABINDING optimizations were added all the way back in SQL Server 2005. So why...

2018-12-04

233 reads

Two Words For Faster Scalar Functions

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
WITH SCHEMABINDING optimizations were added all the way back in SQL Server 2005. So why bother talking about them in 2018?
Because no one is...

2018-12-04

18 reads

Two Words For Faster Scalar Functions

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
WITH SCHEMABINDING optimizations were added all the way back in SQL Server 2005. So why bother talking about them in 2018?
Because no one is...

2018-12-04

9 reads

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

5 reads

Brute Forcing SQL Logins and Passwords

by Bert Wagner

Bert Wagner

Watch this week’s episode on YouTube.Following up on last week’s post about the different types of SQL injection, this week...

2018-11-27

1,043 reads

All authors

Bert Wagner

Visualizing Merge Join Internals And Understanding Their Implications

Visualizing Nested Loops Joins And Understanding Their Implications

Visualizing Nested Loops Joins And Understanding Their Implications

Visualizing Nested Loops Joins And Understanding Their Implications

4 SQL Injection Techniques For Stealing Data

Two Words For Faster Scalar Functions

Two Words For Faster Scalar Functions

Two Words For Faster Scalar Functions

Brute Forcing SQL Logins and Passwords

Brute Forcing SQL Logins and Passwords

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