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
19 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
230 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
18 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,034 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
3 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
9 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,375 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
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers