Visualizing Merge Join Internals And Understanding Their Implications

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

Visualizing Nested Loops Joins And Understanding Their Implications

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

Visualizing Nested Loops Joins And Understanding Their Implications

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

Visualizing Nested Loops Joins And Understanding Their Implications

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

4 SQL Injection Techniques For Stealing Data

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

However,...

Two Words For Faster Scalar Functions

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

Two Words For Faster Scalar Functions

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

Two Words For Faster Scalar Functions

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

Brute Forcing SQL Logins and Passwords

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

Brute Forcing SQL Logins and Passwords

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