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...
2018-12-11
18 reads
Bert Wagner
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...
2018-12-11
9 reads
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...
2018-12-04
229 reads
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...
2018-12-04
17 reads
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...
2018-12-04
6 reads
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...
2018-11-27
1,033 reads
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...
2018-11-27
2 reads
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...
2018-11-27
8 reads
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,...
2018-12-05 (first published: 2018-11-20)
3,374 reads
4 SQL Injection Techniques For Stealing Data
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
7 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
When SQL Server Central Went Down
Comments posted to this topic are about the item When SQL Server Central Went...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers