An interesting article and got me to thinking. I am primarily a developer. Although I've served in roles as an "accidental DBA" that is not the situation in my current...

Not a security guy, but had to make a comment on the article. How about a better job of proofreading. When you have to re-read a sentence 3-4 times and...

Wish you'd gone into more detail regarding specific uses for the OUTPUT clause in general and with MERGE specifically.
For one thing, MERGE allows you to also include columns...

Alan,
Wow, what a hostile audience. Maybe you should have addressed this to a .NET developer environment. I am strictly a SQL Server developer. I work primarily in an ETL...

One concern, CREATE PROC and CREATE PROCEDURE are the same. This will not work if procedure was created using CREATE PROC.

I've just recently been reading up on columnstore indexes. We are on SQL Server 2016, and given the original publication date of this article, I am really surprised that you...