Erik Darling insisted on a video for T-SQL Tuesday this month. https://www.youtube.com/watch?v=g_H6haG99l8 If you're more of a text person... The video shows how you can get the 'map mode' behaviour…

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.…

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…

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…

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…

It's my turn to host T-SQL Tuesday again. It's been a while for me. I think the last time was when the topic was Plan Operators and my round-up included…

As we approach the end of another remarkable year at LobsterPot Solutions, it's time to reflect on our journey, celebrate our achievements, thank our customers, team members and the community,…

Nine Christmases ago, in late November 2015, Microsoft released Service Pack 3 for SQL Server 2012, and included a gift just for me! Only kind of just for me, really…

I don't like to write about client situations, but this one seemed worth mentioning for the sake of other people experiencing the same thing, so I asked my client for…

The French philosopher Montesquieu wrote, “Le mieux est le mortel ennemi du bien”, which means, “The best is the mortal enemy of the good.” Montesquieu was an interesting man who…