This month’s T-SQL Tuesday is being hosted by Taiob and he’s posed a great point to consider: How is AI changing our careers? Oh boy, this could be a divisive topic with plenty of opinions – I’m seeing submissions roll in as I’m finalising this and I’m very much looking forward to the community’s views on the topic. […]
Rounding out T-SQL Tuesday for 2024, Kevin’s invitation brings it together with the Festive Tech Calendar (more on that at the end), and asks us to write about a Microsoft Data Platform announcement that could be considered a gift. For context, this post is targeted at developers or engineers who don’t have the time to dig into SQL Server […]
This month, Josephine has asked how we achieve good enough without burning out in the pursuit of perfect. When designing data solutions, aiming for perfection can lead to endless iterations, moving targets, delays, and – as Josephine points out – burnout. A quote which encapsulates the essence of this for me: Perfection is the enemy of progress Winston Churchill If […]
This month’s invitation from Louis looks for One piece of advice you wish your past self had. T-SQL Tuesday #149 had a similar topic where we gave advice to our younger selves and I made a few points. With a little more experience, I wanted to distill a couple of those: Sharing (knowledge)is caring (for yourself) Within a business, sharing […]
Tickets. Each one helps make the solutions we support more feature complete, bigger, faster, and fixed-er. This month’s invitation from Brent asks us to describe one of the last tickets which was closed to give an insight into our day to day. As an introduction: this is a response from a Development DBA who is relatively new into a […]
This month’s invitation from Reitse asks us to talk about learnings from abandoned or failed projects. This one will sit somewhere squarely between those two points. It was an opportunity to learn about scalability. Let’s set the scene. A point of sale system being rolled out across hundreds of physical locations. Transaction data collected each night to […]
This month’s invitation from Kay asks us to look back through the year and consider those who we are thankful for. Whilst I should be thanking those close to me for their ongoing support through a lot this year – the fact of it is that they aren’t the type of folks to be reading a blog about SQL […]
This month’s invitation from Steve asks us to about how window functions have made life easier for us. Before we get into that let’s have a brief recap of what window functions are for those who aren’t familiar. What are they? Window functions are like regular functions we’d use in a result set such as SUM() or MIN() but more […]
Well I’m a little late to the party this month, I got my weeks mixed and was only reading about this month’s T-SQL Tuesday as the community was posting their responses. So here we go, finally. This month’s ask from Josephine was to consider our understanding or expectations from data job roles. When we see […]
It’s that time of the month again and this invitation from Reitse has asked us about some fun we’ve had with T-SQL in the past. Whilst I’ve used SQL Server over the years and it’s features as part of various solutions for others, I enjoy the time I can put it to work for solving […]
Andy Brownsword 