Todd Kleinhans asks us to write about “Mastering A New or Existing Technical Skill”. Todd is one of my favourite people in the data community simply because he sends people hand-written notes. It’s such a nice thing that he does, and it makes people feel better than a simple thank you – like this message […]| LobsterPot Solutions
Taiob Ali is asking how AI is changing our careers. It’s a good question – one question worth reflecting on, even if the general perception among many people I talk to is ‘not much yet’. There are definitely plenty of people who use AI to help with emails, or as a replacement search engine, and […]| LobsterPot Solutions
John Sterrett asks us where the next generation is. Well, not quite. He asks us what we’re doing, or could be, to encourage younger people to get involved in the SQL community while increasing the number of younger speakers. I’ll come back to the ‘what I’m doing’ question. First let’s talk about the age-demographic of […]| LobsterPot Solutions
This month, my good friend and fellow Dune-fan Joe Fleming (@muaddba.bsky.social) from SQL Tailor Consulting asks us about weird problems, and in particular, how we troubleshoot them. Now, ‘weird’ is an interesting word to use, and Joe actually says “weird or unique”. I’m imagining those times when someone looks at something and is surprised by […]| LobsterPot Solutions
There are some things I really like about SQL Agent Jobs, which is why I’m secretly quite fond of this month’s T-SQL Tuesday topic, from Andy Levy. Of course, there are some things that I don’t like about SQL Agent. For example, I’ve never been a big fan of the Operator stuff. I’m sure there […]| LobsterPot Solutions
Erik Darling insisted on a video for T-SQL Tuesday this month. If you’re more of a text person… The video shows how you can get the ‘map mode’ behaviour of the scroll bar in older versions of SSMS – it’s just that SSMS 21 has it this way by default.| LobsterPot Solutions
Mentoring is one of the ways I like to sow into the technical community. I feel like the community is much more about the individuals in it than the masses. Plus, it’s efficient – I can put my own time into things, but if I help other people develop a love for the community and […]| LobsterPot Solutions
Steve Jones (@way0utwest@bluesky), who has coordinated the T-SQL Tuesday blog party since Adam Machanic stepped down, is also hosting this month. And he asks us about database permissions. How we check who has access to what within the database. I’m going to focus on whether people have access to sensitive data, rather than whether people […]| LobsterPot Solutions
I was the host for T-SQL Tuesday this month, inviting people to write about integrity. And because I don’t believe in just providing a list of posts (although I’ve also done that at the end of the post), I have a completely fabricated story for you. And no, this wasn’t created using AI. I have […] The post Round-up for T-SQL Tuesday 182 – Integrity appeared first on LobsterPot Solutions.| LobsterPot Solutions
I am NOT suggesting that data integrity is irrelevant. Not at all. But how often do we need an enforced primary key or foreign key? Be warned – I’m not actually going to come to a conclusion in this post. I’m going to make cases for both sides, and let you choose where you stand. […]| LobsterPot Solutions