Bert Wagner

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

2018-03-16 (first published: 2018-03-06)

2,845 reads

2.5 Ways Your ORM Is Vulnerable To SQL Injection

by Bert Wagner

Bert Wagner

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

2018-03-06

17 reads

Splitting It Up: Side by Side Queries In SSMS

by Bert Wagner

Bert Wagner

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

2018-02-27

285 reads

Splitting It Up: Side by Side Queries In SSMS

by Bert Wagner

Bert Wagner

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

2018-02-27

16 reads

OR vs UNION ALL – Is One Better For Performance?

by Bert Wagner

Bert Wagner

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

2018-02-20

209 reads

OR vs UNION ALL - Is One Better For Performance?

by Bert Wagner

Bert Wagner

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

2018-02-20

9 reads

What I Do When I’m NOT Writing SQL

by Bert Wagner

Bert Wagner

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

2018-02-13

135 reads

What I Do When I'm NOT Writing SQL

by Bert Wagner

Bert Wagner

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

2018-02-13

8 reads

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

by Bert Wagner

Bert Wagner

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

2018-02-06

111 reads

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

by Bert Wagner

Bert Wagner

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

2018-02-06

6 reads

Bert Wagner

2.5 Ways Your ORM Is Vulnerable To SQL Injection

2.5 Ways Your ORM Is Vulnerable To SQL Injection

Splitting It Up: Side by Side Queries In SSMS

Splitting It Up: Side by Side Queries In SSMS

OR vs UNION ALL – Is One Better For Performance?

OR vs UNION ALL - Is One Better For Performance?

What I Do When I’m NOT Writing SQL

What I Do When I'm NOT Writing SQL

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

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

Blogs

Demo for Parameter Sniffing and Memory Grant Feedback

My Social Media Rules

Why Use TRY_PARSE(): #SQLNewBlogger

Forums

Partitioning a table with TEXTIMAGE_ON option

OUTER APPLY Fundamentals: Part 2

Building Great Software

Question of the Day

The Range of Customers