Jeff Moden - Thursday, January 25, 2018 7:48 AM
I'll also add "silo-ing" to that. In the various companies that I've worked for in the past, it seemed to be rampant and seems to continue even in today's world of DevOps. What I'm talking about is people who just don't know something in T-SQL even though it may be super simple to accomplish. Rather than asking for a bit of help, they limit themselves to the tools that they do know and that's wrong at so many levels. They may even teach themselves how to do something in R or whatever. While such learning isn't a bad thing, they didn't take the time to learn the right thing nor even ask if there was an easy way to do what they need in T-SQL.
I also get the tired ol' lecture of "Just because you can do something in SQL Server, doesn't mean you should". While I do agree with that, a lot of people use that as an uniformed, ring-knocker, ad hominem attack to make up for their lack of even simple knowledge of SQL Server. They typical follow that with the totally over used and totally desperate attempt to save face by saying that "SQL Server isn't the center of the universe". My normal response is, "Fine. Let's turn it off and see if you're right". 😉
I definitely subscribe to the idea of using the right tool for the right thing but the right tool isn't always something outside of SQL Server. That's why I have the play on words in my signature of "Just because you can do something in SQL Server, does mean you SHOULDN'T". 😉 At the very least, ask someone who might know if T-SQL is the right tool or if the tool you're familiar with is a better tool, especially if you don't know squat about T-SQL.
--Jeff Moden
Change is inevitable... Change for the better is not.