Early in my dev career, I often (unwittingly) abused my systems. My code didn't care about things like databases or networks, as long as the results were right. I had a cfHammer, and I needed to pound out a solution. I never knew I was an anti-pattern.

I plan this talk to cover some of the things that I’ve learned as both a CF developer and a SQL developer/DBA. I’ve seen a lot of queries that could be made a lot more efficient with a little bit of SQL knowledge. It will be fairly basic SQL, but topics that the average developer may not be aware of.

So far, I plan to talk a little bit about: 1) Why SELECT * can be bad 2) Why looping over queries is bad. 3) Improving queries with JOINs 4) NOLOCK and how it may not be doing what’s expected 5) Some datatype considerations 6) Basic SQL performance and set-based querying 7) NULL 8) Being put in the position of Accidental DBA 9-n) etc.

I plan to talk about some of the things I’ve learned about the things I used to do and how I should do them differently.

Presented at Online ColdFusion Meetup #283 (Feb 2021)
https://www.youtube.com/watch?v=tq2t6ulM4hY&list=PLG2EHzEbhy0-QirMKgSxhjkUyTSSTvHjL&index=13