Free Webcast: You Shouldn’t Use SQL Agent for Batch Processes.
SQL Server Agent is a solid scheduler for database administration and simple, database-local automation. In a small to midsize shop, it is the right tool for backing up databases, checking for corruption, and maintaining statistics. But as a shop grows …
Is AI already learning from our old, poor-quality code?
In this Simple Talk opinion piece, Greg Low unpacks how AI models actually filter and weigh training data, why the most common answer isn’t always the best one, and why truth itself can depend on timing and context — not just quality. A while back, I w …
Why SQL Server’s default trigger execution model is a security flaw – and what Microsoft should do about it
In my previous article, I described a privilege escalation scenario involving Azure Arc-enabled SQL Server and a database-level DDL trigger created by a database-scoped principal. This database-level DDL trigger was later fired by a highly-privileged A …
What is cloud database vendor lock-in? The 3 types explained (and how to audit yours)
Cloud database vendor lock-in is one of the most expensive surprises in enterprise infrastructure — not because the dependency is hidden, but because most teams never quantify it before committing to a platform. Each distinct type – engine lock-in, fea …
How to Download the Stack Overflow Database for Postgres
You wanna learn PostgreSQL, and you wanna use a sample database with big real-world data, the same kinds of issues that pop up with real-life data distribution skew, and fun query challenges. StackOverflow.com provides a free data dump in XML format wi …
What your AI strategy is missing (according to the people who know your data best)
AI is everywhere, and the pressure to adopt it is relentless. But what does responsible, practical AI adoption actually look like for database and software professionals – the people who live closest to the data? Redgate brought together three experts …
It’s Been 10 Years. Has Microsoft Built What You Voted For?
Ten years ago, I published a blog post with the top 10 most highly upvoted requests for Microsoft SQL Server as shown on their feedback site at the time, Connect.Microsoft.com. That site has gone out to a nice farm upstate, but let’s revisit that top 1 …
9 things I wish SQL Server had (and why they’d matter)
Anyone who’s spent years writing T-SQL has a mental list of “why doesn’t SQL Server just do this already?” moments. Here are 9 of those from Louis Davidson’s perspective – a wish list of practical, coding-oriented feature requests drawn from real-world …
How Azure Arc allows a DB admin to become SQL Server sysadmin – the vulnerability explained
Azure Arc-enabled SQL Server is designed to bring on-premises and multi-cloud SQL Server instances under centralized Azure management, but a newly documented privilege escalation technique shows how that same management workflow can be turned against t …
sp_TexasHoldEm: Multi-Player Poker in T-SQL
Wanna play some Texas Hold ‘Em style poker and make a pile of Query Bucks? Wanna watch other database people playing? Fire up SSMS and connect to: Server: firstresponderkit.database.windows.net Database: StackOverflow2010 Username: LadyGaga Password: p …
Database Animations: The Difference Between Row Compression and Page Compression
What’s the difference between SQL Server’s row compression and page compression, and when does each one make sense? Row compression turns every fixed-length datatype into a variable-length datatype, using as little space as possible to store it Page co …
JSON indexing in SQL Server 2025: how it works and current limitations
SQL Server 2025 finally gives developers a native JSON data type and, with it, a purpose-built way to index JSON documents with the new CREATE JSON INDEX statement. Before this, indexing JSON meant exposing individual properties through computed column …
How to implement Deep Data Security (DeepSec) in Oracle 26ai: complete step-by-step guide (part one)
So you’ve been tasked with deploying a Generative AI, RAG (retrieval-augmented generation), or Agentic AI application. Have you thought about how to secure your most sensitive structured data – as well as your vectorized unstructured data? The good new …
How to avoid nested REPLACE functions with TRANSLATE in SQL Server
If your T-SQL is buried under layers of nested REPLACE() calls just to swap out a few characters, there’s a simpler way. SQL Server’s TRANSLATE() function — introduced in 2017 but still rarely used — lets you replace multiple characters in a single str …
Testing AI with an Office Hours Question
When the new MiniMax H3 image-to-video model dropped this month, I was really impressed with how quickly and easily it was able to make 5-10 second videos from a starting image – not in the cloud, mind you, but on my own home computer gear: View this p …