SQL Server 2016 end of support: how to choose your ...
SQL Server 2016 reached the end of extended support in July 2026, which means it no longer […]
Databases
How to fix “too many connections” in PostgreSQL (step-by-step guide)
Getting the “too many connections” error in PostgreSQL? You’ve hit the database’s max_connections limit — and it’s […]
Why your schema shouldn’t mirror your database (and what to ...
Tony’s Pizza looks simple from the outside. A customer orders a pizza, the pizza is prepared, and […]
How to create roles, databases and tables in PostgreSQL (getting ...
Setting up PostgreSQL the right way starts long before your first table exists. In this guide, you’ll […]
How to make database schema changes without downtime in MySQL: ...
Every growing application eventually faces the same challenge: your database schema needs to change, but your users […]
How to secure temporary objects, metadata visibility, and audit assurance in ...
SQL Server environments that are patched, firewalled, and configured to best practice can still carry hidden risk. […]
Why test data management is essential for SOC 2 compliance
Using live data outside production is one of the fastest ways to create compliance risk. It becomes […]
The future of data leadership: key strategies, challenges, and emerging ...
Data is one of the most valuable assets an organisation can hold — but only if it’s […]
How to secure MCP (Model Context Protocol) servers connected to ...
AI agents don’t ask permission before every query. Instead, they themselves decide which tools to call and […]
What really happens when you let AI design your database ...
AI coding assistants have become a fixture in most developers’ workflows, but when it comes to databases, […]
Why PostgreSQL shouldn’t be your app’s answer to everything
PostgreSQL is one of the most capable relational databases available, but capability isn’t the same as suitability. […]
How to close SQL Server operational blind spots (linked servers, ...
The SQL Server attack pattern is consistent: attackers do not always need a spectacular vulnerability. They often […]
How to run PostgreSQL in Docker (getting started with PostgreSQL, ...
The goal of this guide is simple: get PostgreSQL up and running in the fastest, easiest way. […]
The one big difference between MySQL and MariaDB you may ...
The big difference between MySQL and MariaDB largely revolves around database storage engines and anything related to […]
How test data management helps meet DORA’s resilience testing requirements
DORA requires financial institutions to run tests that prove their systems can withstand operational disruption without exposing […]
What happens when your AI coding agent starts a database ...
At the end of the previous article in my series on building an app and database almost […]
Should your SQL Server database use foreign key constraints?
Foreign key constraints exist to stop bad data before it happens, yet plenty of production SQL Server […]
How a Microsoft-signed SQL Server stored procedure lets sysadmins bypass ...
SQL injection inside Microsoft-signed system stored procedures is not supposed to happen. Yet, as I’ve been documenting […]
How to delete personal data for GDPR & CCPA compliance
Deleting a customer’s personal data under GDPR or CCPA means erasing it everywhere it’s stored — not […]
Bi-directional logical replication in PostgreSQL: a practical guide
Logical replication has long been a feature of many database management systems. It’s the simple process of […]
How to mirror data from SQL Server to Microsoft Fabric: ...
Mirroring in Microsoft Fabric is useful when you need to make SQL Server data available in Fabric. […]
Learning PostgreSQL with Grant: Preparing for the PostgreSQL certification
I want to be up front and honest: I suspect I’ll fail this. However, I’m going to […]
SQL Server login failures: how to monitor, report, and alert ...
Failed logins are one of the clearest early-warning signs of trouble on a SQL Server – whether […]
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 […]
Why SQL Server’s default trigger execution model is a security ...
In my previous article, I described a privilege escalation scenario involving Azure Arc-enabled SQL Server and a […]
What is cloud database vendor lock-in? The 3 types explained ...
Cloud database vendor lock-in is one of the most expensive surprises in enterprise infrastructure — not because […]
What your AI strategy is missing (according to the people ...
AI is everywhere, and the pressure to adopt it is relentless. But what does responsible, practical AI […]
9 things I wish SQL Server had (and why they’d ...
Anyone who’s spent years writing T-SQL has a mental list of “why doesn’t SQL Server just do […]
How Azure Arc allows a DB admin to become SQL ...
Azure Arc-enabled SQL Server is designed to bring on-premises and multi-cloud SQL Server instances under centralized Azure […]
JSON indexing in SQL Server 2025: how it works and ...
SQL Server 2025 finally gives developers a native JSON data type and, with it, a purpose-built way […]
How to implement Deep Data Security (DeepSec) in Oracle 26ai: ...
So you’ve been tasked with deploying a Generative AI, RAG (retrieval-augmented generation), or Agentic AI application. Have […]
How to avoid nested REPLACE functions with TRANSLATE in SQL ...
If your T-SQL is buried under layers of nested REPLACE() calls just to swap out a few […]
The full story of PASS Data Community Summit: 25 years ...
PASS Data Community Summit is celebrating a milestone most communities never reach: 25+ years of data professionals […]
MSDB attack paths: how to secure SQL Server Agent, triggers, ...
SQL Server DBAs routinely rely on automation: SQL Server Agent jobs, maintenance plans, refresh processes, restore scripts, replication cleanup, […]
How to ensure replication stability in PostgreSQL (fix/prevent lag, bloat, ...
PostgreSQL replication is one of the most powerful tools available for keeping your database resilient, redundant, and […]
MySQL vs PostgreSQL: spatial data types, functions, and migration pitfalls ...
MySQL and PostgreSQL both store spatial and geometric data, but they take fundamentally different approaches. While MySQL […]
How to build an Oracle AWR-equivalent diagnostics stack in PostgreSQL ...
Moving from Oracle to PostgreSQL means losing one of Oracle’s most-loved diagnostic tools: the Automatic Workload Repository […]
How a SQL Server backup can execute attacker code during ...
CVE-2026-47295 is a SQL Server vulnerability that lets a maliciously crafted database backup execute attacker-controlled code with […]
What does a modern DBA actually do? 6 key points ...
The DBA role has always been misunderstood. But ask a senior database professional what their week looks […]
SQL Server index tuning: common mistakes and how to fix ...
Indexes are supposed to make SQL Server faster – so why do so many databases end up […]
How to get clean, usable data out of SQL Server ...
In the modern data landscape, most of the effort doesn’t go into building models or dashboards. It […]
Comparing MySQL Enterprise Monitor with Oracle Enterprise Manager for MySQL ...
MySQL Enterprise Monitor was a tool many database administrators turned to in times of need – that […]
How SQL Server maintenance becomes an attack path – and what ...
This article takes one practical thread from Fabiano Amorim’s broader SQL Server security research: how apparently normal […]
Big data: what it is, why projects fail, and how ...
Although ‘Big Data’ (and more specifically, the analysis of it) offers several benefits, organizations often fail to […]
What’s missing in T-SQL? My wish list of features that ...
Edward Pollack recently wrote an excellent wish list for T-SQL features he’d like to see in an […]
DMS migration failing? How to debug Oracle to Cloud SQL ...
For database engineers stepping into cloud migrations for the first time, networking is the silent troublemaker. Most […]
I let Copilot build my database. Here’s what I learned ...
I handed Microsoft Copilot the keys to design a PostgreSQL schema for Azure Database for PostgreSQL Flexible […]
5 T-SQL features that should already exist (2026 SQL Server ...
SQL Server is one of the most mature database platforms in the world, but that doesn’t mean […]
The complete guide to XML support in MySQL and PostgreSQL
This article explores how MySQL and PostgreSQL handle XML data differently, including storage behavior, validation, XML querying, […]
How I built an app just by talking to an ...
Like most of you, I’ve been using AI large language models (LLMs) at work and at hobby […]