Categories
Personal SQL T-SQL Tuesday

T-SQL Tuesday #150 – My First Tech Job

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 […]

Categories
SQL T-SQL Tuesday

T-SQL Tuesday #149 – T-SQL Advice You’d Give To Your Younger Self

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 […]

Categories
SQL Server T-SQL Tuesday

T-SQL Tuesday #147 – Upgrade Strategies

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 […]

Categories
T-SQL Tuesday

T-SQL Tuesday #146: Upending Preconceived Notions

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 […]

Categories
SQL T-SQL Tuesday

T-SQL Tuesday #143 – Short Code Examples

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 […]

Categories
T-SQL Tuesday

T-SQL Tuesday #128 – Learn From Others

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 […]