First of all, I want to thank everyone who took some time to participate in this month’s T-SQL Tuesday: Upending Preconceived Notions. There’s a fantastic line-up of contributions! I was tickled that many of the topics chosen were things I once held one viewpoint on, later learned more, and evolved that viewpoint.
Aaron Bertrand (@AaronBertrand)
Filtered indexes could be SO GREAT but have their fair share of quirks. Aaron tackles two of those quirks, one of which I also thought was true!
Chad Callihan (@callihandata)
Chad shares how he used to be #teamProfiler but was finally converted to #teamXE thanks to XEvent Profiler.
Martin Catherall (@MartyCatherall)
Martin muses about cursors, definitely a divisive topic!
Kevin Chant (@kevchant)
One old school mindset was to not update one’s environment too frequently, as it introduced too much risk. Kevin talks about how times have certainly changed!
Rob Farley (@rob_farley)
Rob takes us back to his University days, to share thoughts on database applications.
Deepthi Goguri (@dbanuggets)
This T-SQL Tuesday has not one, but TWO blog posts, where the author learned something from the fabulous Pam Lahoud (t) and Pam’s TempDB: The Good The Bad The Ugly presentation! This is a fantastic example of how two people can watch the same presentation and walk away with different takeaways.
Jeff Iannucci (@DesertDBA)
Who does Jeff think is really smart?
Extra points for the shoutout to Lycos, Alta Vista, and Excite! I personally favored Alta Vista.
Steve Jones (@way0utwest)
Steve took the opportunity to blog about a technical and non-technical topic. Both hit home for me, especially the non-technical one!
Todd Kleinhans (@toddkleinhans)
Todd took the original topic and reframes it to discuss the grey matter between our ears. Then he too spends a little time sharing some personal thoughts about burnout that has plagued many of us.
Mala Mahadevan (@sqlmal)
Mala blogs about another divisive topic – where should business logic reside?
Deborah Melkin (@dgmelkin)
Deborah’s blog is the other that focuses on a TempDB takeaway from Pam Lahoud. I’ll admit that I used to do exactly what Deb talks about too!
So Jeff didn’t actually write a blog (why doesn’t he have one in the first place?!?!) but instead left a comment, wanting to share a session of his tackling the divisive topic of GUIDs and Fragmentation.
Is it a T-SQL Tuesday blog post? Nope. Do I care? Also nope!
Greg Moore (@stridergdm)
Greg also took the opportunity to blog about a technical and non-technical topic. His technical topic is about how SQL Server writes I/O, which gives me all the feels! Then he takes some time to talk about one of his other hobbies: caving.
Richard Swinbank (@RichardSwinbank)
Richard shares three rules one should never break. Then talks about when to break them anyway. Frankly, I break Richard’s three rules all the time!
Seth Washeck (@swasheck)
Seth contributes a very personal blog, reflecting on parenting.
Andy Yun (@SQLBek)
And finally, I took a few minutes to share thoughts about storage. Is this really a surprise given my recent job change?
That was a lot of fun. And I’m happy to say that I learned some stuff.
Thank you again to everyone who took some time to contribute a blog post!
Dear readers, I hope you take the time to read each and every contribution, and come away learning something new too!