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…

Tip: Don’t do it, do this instead In this series of blog posts, I want to explain different ways to extrapolate business requirements to write great reports. In this post,…

This is the question posed by Tim Mitchell over at https://www.timmitchell.net/post/2024/10/01/t-sql-tuesday-179-whats-in-your-data-detective-toolkit. The context is around what techniques are used when I’m faced with a new environment, or even just a…

Sometimes it's the little things - the small issues that aren't actually what we do (ie, not data-related, or processes, or whatever) - that drive you the most crazy. The…