No two SQL Server environments are alike. A fix that resolves a performance issue in one environment may not work in another because every SQL Server instance has different...
2026-08-21 (first published: 2026-08-04)
719 reads
I got a notification from a question I’d posted at SQL Server Central: Getting the Average. A user had posted their repro didn’t work, with no real comment. As...
2026-08-21 (first published: 2026-08-05)
426 reads
SQL Server sa Account Security: Rename, Disable & Best Practices
In the Windows administration world, it's pretty much a standard practice to rename the local administrator...
2026-08-19 (first published: 2026-08-05)
733 reads
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most of the tech news. However, the Stanford Emerging Technology Review tries to include any relevant...
2026-08-19 (first published: 2026-08-04)
406 reads
Pinal Dave wrote up his methodology for what to do when you discover bad data in production. If you’ve never been in this situation, having a plan beforehand is...
2026-08-17 (first published: 2026-07-30)
450 reads
Programmatic Tool Calling with the Claude SDK
Every morning somebody on the team runs the same check. Thirty tables in the staging schema, and the only thing anyone wants to...
2026-08-17 (first published: 2026-07-31)
456 reads
Aside from spinning up a SQL Server instance container, the free Azure SQL Database is another great tool for learning SQL. You can even use it for low-traffic or...
2026-08-14 (first published: 2026-07-30)
431 reads
I have been experimenting with MCP servers in a few ways, and pressing on our Redgate Monitor team to add one to their system. They did, started adding tools,...
2026-08-14 (first published: 2026-08-03)
526 reads