This month’s T-SQL Tuesday is hosted by Tom Zika. Tom’s topic is a good one: “Which quality makes code production grade?” I can hear data minds thinking, “It depends.” I prefer all code to be idempotent, a $3 word that means whenever the code is executed, the post-execution state is predictable (even if the initial …
Continue reading T-SQL Tuesday #156 – On Production Code
Category:T-SQL Tuesday
T-SQL Tuesday #138 – Managing Technology Changes – Wrap-Up
This month’s T-SQL Tuesday attracted some great responses! Thank you to everyone who participated! Reitse Eskens checked in with T-SQL Tuesday #138 – Keeping up with change. For whatever reason, his pingback did not make it to my blog. I apologize for the oversight, Reitse. Thank you for reaching out so I could get this corrected. …
Continue reading T-SQL Tuesday #138 – Managing Technology Changes – Wrap-Up
T-SQL Tuesday 138: Managing Technology Changes
I’m honored to host T-SQL Tuesday for May 2021. One point I make (repeatedly) in my latest book – titled Building Custom Tasks for SQL Server Integration Services – is “software changes.” In fact, software changed on me between the completion of editing and the release of the book! I wrote about the changes in a …
Continue reading T-SQL Tuesday 138: Managing Technology Changes
T-SQL Tuesday #112 – The Cookie Jar
This month, Shane O’Neill hosts T-SQL Tuesday. His topic is titled Dipping into the Cookie Jar and is inspired by David Goggins‘ book titled Can’t Hurt Me. Coincidence: I am currently listening to the Can’t Hurt Me audio book. I made several recent mini-road-trips to Richmond to visit my Dad (more later) – a 75-mile …
Continue reading T-SQL Tuesday #112 – The Cookie Jar
T-SQL Tuesday #111 Roundup
Thank You! First, we owe a debt of gratitude to my friend Adam Machanic (blog | @adammachanic | Data Education) for starting T-SQL Tuesday in the first place. Thank you, Adam! Next, we owe a huge shout-out to Steve Jones (blog | @way0utwest | SQL Server Central) for carrying the torch by maintaining tsqltuesday.com. Finally, thank you …
Continue reading T-SQL Tuesday #111 Roundup
T-SQL Tuesday #111 – What is Your “Why?”
“Why do you do what you do?” This month’s T-SQL Tuesday topic by Andy Leonard.
T-SQL Tuesday: When Good Projects Go Bad
Thanks to Jeff Mlakar for hosting this month’s T-SQL Tuesday, a monthly collection of blog posts by data bloggers who work and live in the Microsoft SQL Server space. This month’s topic is about projects that have gone wrong. “Why Do Good Projects Go Bad, Andy?” Deltas. That’s all. Deltas. Allow me to explain. In …
Continue reading T-SQL Tuesday: When Good Projects Go Bad
T-SQL Tuesday #106: Regarding Triggers
In my experience, people either love or hate triggers in Transact-SQL. As a consultant, I get to see some interesting solutions involving triggers. In one case, I saw several thousand lines of T-SQL in a single trigger. My first thought was, “I bet there’s a different way to do that.” I was right. The people …
Continue reading T-SQL Tuesday #106: Regarding Triggers
T-SQL Tuesday 102: Giving Back
I enjoy the privilege and honor of participating in the SQL Server Community alongside many who read this blog. And I know from past experience that some reading this post will make the switch from consumers-only in our community to sharers and consumers one day. For my part, I consume more than I contribute. I …
Continue reading T-SQL Tuesday 102: Giving Back
Learning Goals for 2018 – T-SQL Tuesday #97
My friend and #SqlFamily sister Mala hosts this month’s T-SQL Tuesday topic: Setting learning goals for 2018. It’s a timely topic for me as I’ve recently engaged in more formalized training. Mala’s questions: What do you want to learn? (specific skills and talents) How and when do you want to learn? (methods of learning and …
Continue reading Learning Goals for 2018 – T-SQL Tuesday #97