How to use Statistics IO to Improve Your Query Performance

SQL Server’s STATISTICS IO reporting is a great tool to help you performance tune queries.Usually the goal of performance tuning...

My Favorite SSMS Shortcut (After Copy/Paste)

If there's one keyboard shortcut I use more than any other (with the exception of copy and paste) it would be the ALT + highlight multi-line edit/block selection shortcut.
Let's...

My Favorite SSMS Shortcut (After Copy/Paste)

Photo by Abhishek Desai on UnsplashIf there’s one keyboard shortcut I use more than any other (with the exception of...

Does The Join Order of My Tables Matter?

I had a great question submitted to me (thank you Brandman!) that I thought would make for a good blog post:

...I've been wondering if it really matters from a...

Does The Join Order of My Tables Matter?

Photo by pan xiaozhen on UnsplashI had a great question submitted to me (thank you Brandman!) that I thought would make for a...

How to Search Stored Procedures and Ad-Hoc Queries

Have you ever wanted to find something that was referenced in the body of a SQL query?
Maybe you need to know what queries you will have to modify for...

How to Search Stored Procedures and Ad-Hoc Queries

Photo by Louis Blythe on UnsplashHave you ever wanted to find something that was referenced in the body of a SQL query?
Maybe you...

4 Common Misconceptions About SQL Injection Attacks

Photo by Jaanus Jagomägi on Unsplash
Interested in learning more about SQL injection attacks, including how to prevent them?  Attend my online webcast on Tuesday November 14, 2017 at 1PM Eastern at the...

4 Common Misconceptions About SQL Injection Attacks

Photo by Jaanus Jagomägi on UnsplashInterested in learning more about SQL injection attacks, including how to prevent them?  Attend my online webcast on...

The Quickest Way To Get SQL Command Help

Every once in a while I discover a SQL Server Management Studio trick that's apparently been around forever but is completely new to me.
Today I want to point out...