Jim Czuprynski in Oracle

How to implement Deep Data Security (DeepSec) in Oracle 26ai: complete step-by-step guide (part one)

Learn how Oracle 26ai Deep Data Security (DeepSec) simplifies row- and column-level access control for structured and vector data. A...

17 August 2026 18 min read

Greg Low in SQL Server

How to avoid nested REPLACE functions with TRANSLATE in SQL Server

Learn how SQL Server's TRANSLATE function replaces messy nested REPLACE statements. Simplify multi-character string replacements in T-SQL with one clean...

14 August 2026 4 min read

Simple Talk Editor in Resources

The full story of PASS Data Community Summit: 25 years of connect, share, and learn

PASS Data Community Summit turns 25: from a 1999 Microsoft-backed user group to a global, multi-platform data community. Here's the...

11 August 2026 5 min read

Fabiano Amorim in SQL Server

msdb attack paths: how to secure SQL Server Agent, triggers, and restores

Learn how msdb, SQL Server Agent jobs, triggers, and untrusted restores create privilege escalation paths - plus T-SQL scripts to...

10 August 2026 28 min read

Lukas Vileikis in PostgreSQL

How to ensure replication stability in PostgreSQL (fix/prevent lag, bloat, and bottlenecks)

PostgreSQL replication stability depends on more than just configuration. Learn how replication lag, network bottlenecks, and VACUUM-related issues can silently...

07 August 2026 8 min read

Aisha Bukar in Databases

MySQL vs PostgreSQL: spatial data types, functions, and migration pitfalls explained

MySQL and PostgreSQL both support spatial data, but work very differently. This guide breaks down types, indexing, functions, and key...

05 August 2026 15 min read

Kellyn Pot'Vin-Gorman in Databases

How to build an Oracle AWR-equivalent diagnostics stack in PostgreSQL (step-by-step guide with code)

Miss Oracle's AWR in PostgreSQL? This guide maps every AWR feature - snapshots, ASH, wait events, Top SQL - to...

03 August 2026 27 min read

Fabiano Amorim in SQL Server

How a SQL Server backup can execute attacker code during restore – and how to prevent it (CVE-2026-47295 vulnerability)

CVE-2026-47295: a truncation bug in SQL Server's replication cleanup lets a malicious backup execute attacker code as sysadmin during RESTORE...

31 July 2026 22 min read

Simple Talk Editor in Career

What does a modern DBA actually do? 6 key points from a senior DBA

The DBA role has changed. Senior DBA Lee Brownhill shares 6 honest insights on what database professionals are focused on...

29 July 2026 7 min read

Edward Pollack in SQL Server

SQL Server index tuning: common mistakes and how to fix them

Learn the most common SQL Server index tuning mistakes -over-indexing, wide indexes, fill factor misuse, heaps - and how to...

27 July 2026 33 min read

Uzma Younas in SQL Server

How to get clean, usable data out of SQL Server into Python

Build scalable data pipelines by pushing transformations into SQL and keeping Python focused on analysis. Learn about views, CTEs, pruning,...

24 July 2026 11 min read

Lukas Vileikis in MySQL

Comparing MySQL Enterprise Monitor with Oracle Enterprise Manager for MySQL – which is best?

Comparing MySQL Enterprise Monitor and Oracle Enterprise Manager for MySQL to determine which is best for you. Covers features, scalability,...

23 July 2026 6 min read

Grant Fritchey in AI

AI built my WordPress plugin. Here’s what worked – and what went wrong (building an app with AI, part five)

Learn what happens when you try building a working WordPress plugin for your app with AI - featuring plugin creation,...

20 July 2026 9 min read

Fabiano Amorim in SQL Server

How SQL Server maintenance becomes an attack path – and what to do about it

How trigger hijacking, msdb exposure, and over-privileged database users create SQL Server attack paths — plus how to detect and...

17 July 2026 25 min read

Joydip Kanjilal in Big Data

Big data: what it is, why projects fail, and how to get value from it

Big data projects fail not because of technology, but strategy. Learn the 6 Vs, 5 reasons initiatives fail, and key...

14 July 2026 9 min read

Grant Fritchey in AI

I let AI build my API. Here’s what happened (building an app with an AI LLM, part four)

Learn how to use Microsoft CoPilot and GitHub Copilot to build a secure REST API— covering Azure deployment, PostgreSQL integration,...

13 July 2026 8 min read

Greg Low in SQL Server

What’s missing in T-SQL? My wish list of features that developers actually need in SQL Server

A veteran SQL Server expert's wish list for T-SQL: true constants, enumerations, extensibility, better naming consistency, and more. See what's...

08 July 2026 12 min read

Sachin Pawar in Cloud

DMS migration failing? How to debug Oracle to Cloud SQL network errors, layer-by-layer (OSI model guide)

Debugging Google DMS failures for Oracle to Cloud SQL migrations? Use the OSI model to pinpoint network errors layer by...

01 July 2026 13 min read

Grant Fritchey in Databases

I let Copilot build my database. Here’s what I learned – and everything I’d do differently next time (part two)

What happens when Microsoft Copilot designs a PostgreSQL schema for Azure? Here's what it got right, what it got wrong,...

29 June 2026 23 min read

Edward Pollack in SQL Server

5 T-SQL features that should already exist (2026 SQL Server wish list)

2026 T-SQL wish list covering native Parquet imports, arrays, OVERLAPS, simpler licensing, and cloud storage — features SQL Server still...

26 June 2026 14 min read