It’s the little things…
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…
Design a really terrific Star Schema by interpreting an existing report
Previously, I’ve written about tips for designing a really great report model from Agile user stories. Catch up on it here (Useful tips for designing a really great report model…
Snapdragon processors for SQL professionals
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…
Where is the database code managed?
I'm a consultant, so I see a variety of answers to Mala's question. But her question isn't exactly "where does the database code live?", it's "where do you keep your…
Advice for my past self
Louis Davidson (@drsql) asks what advice we wish we'd had - particularly when we were starting out first data platform job. I'm not really sure when that was. I did computing…
Ready or not
When is the right time to move to new technology? Andy Leonard asks about balancing new features and proven technology. And certainly the challenge is real. I see new features…
Interview questions
At LobsterPot Solutions one of the things we often do for our clients is participate in job interviews, to help get a feel for the technical ability of the people…
AI and SQL
Pinal Dave (@pinaldave), who might always exist in my mind as the person who took me to a KFC in Bengaluru, asks us about how AI has helped our roles…
Hekaton – the bad and the good, and a misconception
The SQL Server platform is a robust system, designed to handle data in a relational system through the “ACID” properties of transactions. That is, to ensure that any piece of…
My last ticket
There are a bunch of different things I do for clients, so it’s a bit strange to try to think what to write about in response to a question about…
