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 […]
This month’s invitation from Kenneth Fisher asks us to share our first tech job. As he points out there are a lot of DBAs who don’t start out working with databases and we slowly succumb to the dark side (my words, not his), intentionally or otherwise. During a gap year whilst at university I joined […]
This month’s invitation from Camila Henrique asks us for advice we’d give to our younger selves in our T-SQL journey. Coming from the SQL Server perspective there’s a huge variety of areas within the stack where you might want to provide some advice but I’m going to focus on the scripting and querying as that’s […]
This month’s invitation from Steve is asking about strategies for upgrades with SQL Server. We might be more familiar with patching a SQL environment semi-regularly – and those processes may be tried and trusted – however its much rarer that we have the opportunity to uplift an entire environment to a later version. Here’s a […]
This month’s invitation comes from Andy Yun who asked us to share something we’ve learned and which has subsequently changed our opinions. There were two immediate examples which came to mind, the first on a more technical note and the second somewhat more personal: “Table Variables Are Fast” Many years ago I’d found myself with […]
The ask this month is to share go-to short code snippets with the community. I think its right to start by showing appreciation for some of the widely adopted tooling in the community such as sp_WhoIsActive, the First Responder Kit, Ola’s Maintenance Solution and DbaTools. Without these available we wouldn’t have half the snippets and […]
The topic for this month’s T-SQL Tuesday is to tell folks about something which went wrong and what it took to fix it. Whilst I’m sure there are plenty of more experienced folks out there who’ll have some interesting articles to read, I thought I’d take it in a slightly different direction. As much value […]
Andy Brownsword 