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

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

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

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

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

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

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

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

The Quickest Way To Get SQL Command Help

Formula One …. F1 …. Photo by Jp Valery on UnsplashEvery once in a while I discover a SQL Server Management Studio trick that’s apparently...

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