I've just spent a week in the UK visiting the Redgate HQ with my fellow advocates. I'm really blessed to get to work with such a great bunch of people. A couple of the conversations we had stuck with me and I'd like to share them here. Sitting in the midst of Cambridge, Cambridgeshire, UK, […]
This article looks at one of the killers of performance at scale, SELECT *.
Build scalable data pipelines by pushing transformations into SQL and keeping Python focused on analysis.
Steve notes that building great software isn't easy, and there is a lot of work that goes into this. Even in today's age of AI.
In Part 2 of this series we learn how OUTER APPLY can be used in your queries to return data, even when there are no matches between tables.
SQL Server Availability Groups are great for DR and HA purposes. In this article, we look at how to setup a SQL Server 2025 Availability Group using the features in SQL Server Management Studio.
See how a small local model performs on some SQL tasks. This shows how Ollama can run a model on your laptop.
Today Steve notes that he often compares the work a computer does to what might happen if the same actions occurred in the physical world.
The article covers four connected areas: over-privileged database users, msdb and SQL Server Agent exposure, privileged maintenance jobs, and trigger-based permission hijacking.
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Comments posted to this topic are about the item Learn From History
Comments posted to this topic are about the item The SQL Server MCP Server
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers