A technical journal and community hub from Redgate
Live Last read · last published · next check
SQL Server 2025 introduces native JSON indexing via CREATE JSON INDEX. Learn how it works, when to use it, and its current preview-stage limitations.… The post JSON indexing in SQL Server 2025: how it works and current limitations appeared first on Simple Talk .
Learn how Oracle 26ai Deep Data Security (DeepSec) simplifies row- and column-level access control for structured and vector data. A hands-on guide with real SQL examples.… The post How to implement Deep Data Security (DeepSec) in Oracle 26ai: complete step-by-step guide (part one) appeared first on Simple Talk .
Learn how SQL Server's TRANSLATE function replaces messy nested REPLACE statements. Simplify multi-character string replacements in T-SQL with one clean call.… The post How to avoid nested REPLACE functions with TRANSLATE in SQL Server appeared first on Simple Talk .
Learn how Microsoft's Power BI Desktop Bridge and Fabric AI Skills let GitHub Copilot edit and hot-reload Power BI reports. No restart needed!… The post How to use the Power BI Desktop Bridge to automate tasks in Power BI Desktop and GitHub Copilot appeared first on Simple Talk .
PASS Data Community Summit turns 25: from a 1999 Microsoft-backed user group to a global, multi-platform data community. Here's the full story.… The post The full story of PASS Data Community Summit: 25 years of connect, share, and learn appeared first on Simple Talk .
Learn how msdb, SQL Server Agent jobs, triggers, and untrusted restores create privilege escalation paths - plus T-SQL scripts to detect and fix them.… The post msdb attack paths: how to secure SQL Server Agent, triggers, and restores appeared first on Simple Talk .
PostgreSQL replication stability depends on more than just configuration. Learn how replication lag, network bottlenecks, and VACUUM-related issues can silently undermine your database, and what to do about each.… The post How to ensure replication stability in PostgreSQL (fix/prevent lag, bloat, and bottlenecks) appeared first on Simple Talk .
MySQL and PostgreSQL both support spatial data, but work very differently. This guide breaks down types, indexing, functions, and key migration gotchas.… The post MySQL vs PostgreSQL: spatial data types, functions, and migration pitfalls explained appeared first on Simple Talk .
Miss Oracle's AWR in PostgreSQL? This guide maps every AWR feature - snapshots, ASH, wait events, Top SQL - to its PostgreSQL extension equivalent, with ready-to-run SQL.… The post How to build an Oracle AWR-equivalent diagnostics stack in PostgreSQL (step-by-step guide with code) appeared first on Simple Talk .
CVE-2026-47295: a truncation bug in SQL Server's replication cleanup lets a malicious backup execute attacker code as sysadmin during RESTORE DATABASE. Learn more, including how to prevent it.… The post How a SQL Server backup can execute attacker code during restore – and how to prevent it (CVE-2026-47295 vulnerability) appeared first on Simple Talk .
