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 21
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 31
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 22
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 31
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 33
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 1
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 1
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 1
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 2
Dejan Lukić in AI The best AI developer tools in 2026: from coding agents to code review A developer's honest take on the best AI tools for research, day-to-day coding, and code review in 2026 — covering... 15 July 2026 9 min read 11
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
John Kerski in Microsoft Fabric How to automate Fabric data agent testing with promptfoo and GitHub Actions Learn how to automate Fabric Data Agent testing using promptfoo, service principals, and GitHub Actions - step-by-step guide. No more... 10 July 2026 13 min read 1
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 11
Grant Fritchey in AI AI can build the pipeline, but don’t trust it for security (building an app with an AI LLM, part three) Learn what happens when you let GitHub Copilot and VSCode set up database migrations and a GitHub Actions pipeline on... 06 July 2026 8 min read 1
Abhishek Goyal in Development How I built a startup with no web development background: lessons from launching Unibridge The story of how I built Unibridge - a platform helping new arrivals navigate housing, banking, and SIM cards -... 03 July 2026 17 min read 2
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 21
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 1
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 41
Aisha Bukar in Databases The complete guide to XML support in MySQL and PostgreSQL Discover how MySQL and PostgreSQL differ in XML storage, validation, and querying, and why these differences matter for enterprise apps... 24 June 2026 15 min read
Grant Fritchey in AI How I built an app just by talking to an AI LLM – the good, the bad, and what I’d do differently next time (part one) Building a real app end-to-end with an LLM: lessons from week one of dbRosetta. Why scope, prompt templates, and acceptance... 22 June 2026 9 min read 211
