Blog posts have been few and far between from SQL Undercover lately but what better to try and get us back in the swing again than with T-SQL Tuesday. This month's invitation comes from Mikey Bronowski https://www.bronowski.it/blog/2021/02/t-sql-tuesday-135-the-outstanding-tools-of-the-trade-that-make-your-job-awesome/ There are so many tools that I use day in and day out to make my life easier... Continue Reading →
T-SQL Tuesday #127 – Non SQL Tips and Tricks, Referencing Multiple PowerShell Array Elements
This month's T-SQL Tuesday invitation is from Ken Fisher and he's asking about non-SQL tips and tricks. This had me thinking for a bit and then something popped into my head, an accidental discovery that I made the other day. I apologise if this is common knowledge among the PoSH guys but it was a... Continue Reading →
T-SQL Tuesday #124 Query Store and Spin Locks #tsql2sday
This month's T-SQL Tuesday invitation comes from Tracy Boggiano and she's asking us to write about our experiences with Query Store. I thought about what I should write, I'm a big fan of query store and I've used it to help me out on a number of occasions recently. I could write about one of... Continue Reading →
SQL Tuesday #118 – Your Fantasy SQL Feature
This month's T-SQL Tuesday invitation comes from Kevin Chant and he's asking us about a fantasy feature that we'd love to see in SQL Server. I had a little think about this and there's one thing that came straight to my mind, it is something that's possible with third party tools but isn't something supported... Continue Reading →
#TSQL2sDay – #112 – Mini cookies
This months TSQL Tuesday is hosted by Shane O'Neill (Blog | Twitter) Shane explains the Topic as: Dipping into the Cookie Jar is about when the going gets tough and you don’t think you can handle anymore, then you think back about your accomplishments and take some sustenance from them. Cookie One: is remembering... Continue Reading →
TSQL Tuesday #112 – Dipping into the Cookie Jar
This month's TSQL Tuesday comes from Shane O'Neil and he's asking us to 'dip into the cookie jar' (or raid the biscuit tin, for us Brits 😉 ), essentially how we use past accomplishments to help us through difficult or challenging times. I've been trying to think about this and while like everyone I've had... Continue Reading →
TSQL Tuesday #106: Triggers and the Spiral To Oblivion
It's the second Tuesday of the month which must mean only one thing... We're all skint and payday feels like a long way off??? Not quite, well maybe... but it's also T SQL Tuesday! This month's invitation comes from Steve Jones and he's asking us to write about triggers and our experiences of them. So...... Continue Reading →
T-SQL Tuesday #104 – My Undercover Toolbox favourites
This months T-SQL Tuesday is being hosted by Bert Wagner , you can find the invitation for this months topic here. Bert has a great topic for this month, he wants us to write about code you’ve written that you would hate to live without. I have found the SQL server community to be extremely helpful... Continue Reading →
T-SQL Tuesday #101 – My day of Essential SQL Server tools.
This month’s T-SQL Tuesday is brought to you by Jens Bestergaard - the subject is Essential SQL Server tools, the original invitation can be found here. Here is how my day of using SQL tools went: It all started at 00:00 this morning with planned maintenance, I was adding a bunch of Clustered indexes... Continue Reading →
TSQL Tuesday #100: A Look To The Future
So for this month's TSQL Tuesday, Adam Mechanic has asked us to take a look into the future and think about what things might look like when TSQL Tuesday #200 comes around (apparently that'll be June 2026). So I thought I'd have a little bit of fun with this by going all sci-fi on you,... Continue Reading →