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…

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…

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…

If you've found this post because you're trying to figure out how to get SQL Server to run locally on a Copilot+ PC with a Qualcomm Snapdragon processor, then I'm…