Everything I Needed to Know Used to be Found in One Book
Books used to be the source of knowledge, but times have changed.
Stop Prompting Your AI Agent. Give It a Playbook.
Learn about how you can better prompt your AI Assistant in solving problems and producing code.
How to run SQL Server on Amazon Elastic Container Service
Learn how to efficiently run SQL Server using Amazon Elastic Container Service for a hassle-free Docker container experience.
Even When You Know What You're Doing, You Can Screw Up
There I was, walking around Amsterdam, radio in hand (OMG! He's talking about radios again!), automatically transmitting Active Packet Report System (APRS) signals every 90 seconds. Same radio I had used in Chicago a couple of weeks ago and in Poland last week. I was on the correct frequency and, as I say, I had […]
Database Mail in SQL Server 2022
This article covers the basics of getting Database Mail setup in SQL Server.
The New Software Team
Software teams are changing with AI and this might be an exciting time for developers if they take advantage of the capabilities available.
Local vs remote MCP servers – which should you choose?
Should you choose a local or remote MCP server? The best option depends on your security needs, performance goals, and deployment model. This guide explains the differences between local and remote Model Context Protocol (MCP) servers, including privacy, scalability, latency, and integration trade-offs.
Limit the Blast Radius
AI can go off the rails, as we see in a recent story about an LLM deleting a production database.
You Can’t Trust “Edit Query Text” in SSMS’s Execution Plans.
When there are IF branches or conditional logic, “Edit Query Text” only shows you the branches that actually executed. It’s easy to miss whole swaths of code that didn’t happen to execute one particular time.
What Can AI Really Do?
Steve asks you what you think AI can do for you today, with a few suggestions of what he sees.
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers