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 […]
For March’s T-SQL Tuesday invitation, Damien has asked us to consider a wish list for Microsoft’s partnership with OpenAI. AI has been a hot topic in recent months, largely due to the attention from tools such as ChatGPT and DALL-E from OpenAI. These tools and future iterations or derivatives will almost inevitably shape the way […]
This month’s invitation from Garry asks us to talk about what SQL related end of year activities we have to look forward to. Garry has included a few typical DBA examples such as archiving or purging out old data, or updating calendars such as dimension tables or even partition schemes for the new year to come. However […]
This month’s invitation from Tom Zika asks us to consider production code and consider what quality makes the code ‘production grade’. It’s interesting to think about all of the areas we may want to consider before putting some code into production – has it been reviewed, has it gone through sufficient testing, does it perform well […]
This months’ invitation from Steve Jones asks us to write about producing SQL dynamically in some form or another. We can create and execute SQL dynamically within our procedures but what about dynamically creating it from other sources before passing it into SQL Server? The quick I have to admit that Steve’s mention of using Excel […]
This month’s invitation from Glenn is to write about what we’ve been doing with SQL Server 2022 as we’ve now had a release candidate unleashed upon the world. Personally I haven’t had the time to adventure through the new features or put any stress onto the version as of yet – the exception being testing […]
As Deborah’s invitation opens this month she quite rightly points out that there are a lot of professionals out there who have a few (passionate) opinions about what they do or the way they do it. This month we’re invited to … well, have a rant – a rant about those experiences which have shaped […]
This month’s invitation comes from Mala who asks us about the T-SQL coding rules relevant for where we work. There’s certainly a lot of scope in this question and Mala links to a great set of posts from Robert Sheldon which cover quite a number of these points. Whilst larger businesses may well have matured standards in […]
Andy Brownsword 