2.5 Ways Your ORM Is Vulnerable To SQL Injection

Someone recently told me that they don’t need to worry about SQL injection because they are using an ORM.
Oh boy.
ORMs don’t...

2.5 Ways Your ORM Is Vulnerable To SQL Injection

Someone recently told me that they don't need to worry about SQL injection because they are using an ORM.
Oh boy.
ORMs don't automatically prevent SQL injection

Watch this week's video on YouTube
Object-relational...

Splitting It Up: Side by Side Queries In SSMS

There are times when you are writing a query while referencing another piece of information: the results of another query,...

Splitting It Up: Side by Side Queries In SSMS

There are times when you are writing a query while referencing another piece of information: the results of another query, a variable value, a webpage, etc...
If using two monitors...

OR vs UNION ALL – Is One Better For Performance?

Today I want to show you a trick that could make your queries run faster.
It won’t always work, but when...

OR vs UNION ALL - Is One Better For Performance?

Today I want to show you a trick that could make your queries run faster.
It won't always work, but when it does everyone will be impressed with your performance...

What I Do When I’m NOT Writing SQL

This post is a response to this month’s T-SQL Tuesday prompt created by Aaron Bertrand.  Adam Machanic created T-SQL Tuesday...

What I Do When I'm NOT Writing SQL

This post is a response to this month's T-SQL Tuesday prompt created by Aaron Bertrand.  Adam Machanic created T-SQL Tuesday as a way for SQL users to share ideas...

“How do I contribute to dbatools?” with Drew Furgiuele

This weekend I caught up with Drew Furgiuele at SQL Saturday Cleveland and learned how to get involved with the...

"How do I contribute to dbatools?" with Drew Furgiuele

Watch this week's video on YouTube
This weekend I caught up with Drew Furgiuele at SQL Saturday Cleveland and learned how to get involved with the open-source dbatools PowerShell module.
If...