Lukas Vileikis in AI

What really happens when you let AI design your database schema (everything you should know)

AI can write SQL, but can it design your database schema? Learn why LLMs get databases wrong — and how...

02 October 2026 12 min read

Pat Wright in PostgreSQL

Why PostgreSQL shouldn’t be your app’s answer to everything

A DBA explains why using PostgreSQL for queuing, caching, or document storage creates ownership gaps, security risks, and higher cloud...

01 October 2026 6 min read

Fabiano Amorim in SQL Server

How to close SQL Server operational blind spots (linked servers, DMVs, and KILL command security risks & fixes)

Learn how attackers exploit SQL Server linked servers, traces, DMVs, and the KILL command - plus the monitoring queries and...

25 September 2026 14 min read

Grant Fritchey in PostgreSQL

How to run PostgreSQL in Docker (getting started with PostgreSQL, part one)

Get PostgreSQL running in Docker in minutes with this step-by-step setup guide. Learn to pull the image, run a container,...

23 September 2026 13 min read

Lukas Vileikis in Databases

The one big difference between MySQL and MariaDB you may have overlooked

What's the one big difference between MySQL and MariaDB? Learn what the difference is, why it's important, and what's best...

22 September 2026 9 min read

Tony Davis in Security, Privacy & Compliance

How test data management helps meet DORA’s resilience testing requirements

Learn how test data management helps financial institutions meet DORA's resilience testing and ICT risk requirements without exposing sensitive data.…

21 September 2026 11 min read

Grant Fritchey in AI

What happens when your AI coding agent starts a database on its own (building an app with AI, part six)

How to build an app through an LLM: switching from CoPilot to Claude, a directional term-lookup feature, and an AI...

18 September 2026 16 min read

Greg Low in SQL Server

Should your SQL Server database use foreign key constraints?

Should SQL Server databases enforce foreign key constraints? A veteran DBA breaks down the real arguments for transactional and analytic...

16 September 2026 8 min read

Fabiano Amorim in SQL Server

How a Microsoft-signed SQL Server stored procedure lets sysadmins bypass disabled xp_cmdshell

Discover how a Microsoft-signed system procedure bypasses SQL Server's disabled xp_cmdshell setting - plus detection and mitigation steps for defenders.…

14 September 2026 11 min read

Dejan Lukić in Security, Privacy & Compliance

How to delete personal data for GDPR & CCPA compliance

Learn how to fully erase a customer's data for GDPR and CCPA requests — across backups, replicas, caches, and third-party...

11 September 2026 8 min read

Lukas Vileikis in Databases

Bi-directional logical replication in PostgreSQL: a practical guide

Learn how bi-directional logical replication works in PostgreSQL 16+, including setup steps, key pros and cons, and whether it's the...

09 September 2026 6 min read

Greg Low in SQL Server

How to mirror data from SQL Server to Microsoft Fabric: complete guide

Learn all about Microsoft Fabric mirroring for SQL Server: how it works, what's new in 2025, setup, limitations, and troubleshooting.…

07 September 2026 9 min read

Grant Fritchey in PostgreSQL

Learning PostgreSQL with Grant: Preparing for the PostgreSQL certification

I don't believe in certifications, so why am I taking PostgreSQL's brand-new exam? Here's my honest study plan using AI,...

04 September 2026 7 min read

Edward Pollack in SQL Server

SQL Server login failures: how to monitor, report, and alert on them (complete guide)

Learn how to detect and report SQL Server login failures using T-SQL and xp_readerrorlog. Includes ready-to-use scripts for filtering, aggregating,...

02 September 2026 17 min read

Greg Low in AI

Is AI already learning from our old, poor-quality code?

Why do AI models get hard questions correct, but fail easy ones? A look at how LLMs weigh popularity, quality,...

31 August 2026 8 min read

Fabiano Amorim in SQL Server

Why SQL Server’s default trigger execution model is a security flaw – and what Microsoft should do about it

SQL Server triggers execute under the caller's privileges by default - not the creator's. Learn why this design enables privilege...

28 August 2026 12 min read

Chisom Kanu in Cloud

What is cloud database vendor lock-in? The 3 types explained (and how to audit yours)

Cloud database lock-in takes three forms: engine, feature, and operational. Learn which type you're accumulating, and what it would actually...

27 August 2026 12 min read

Simple Talk Editor in AI

What your AI strategy is missing (according to the people who know your data best)

Our AI panel of database experts shared 10 sharp, practical insights on how to adopt AI responsibly. Top strategies with...

26 August 2026 14 min read

Louis Davidson in SQL Server

9 things I wish SQL Server had (and why they’d matter)

A T-SQL veteran's wish list: 9 missing SQL Server features that would simplify auditing, data validation, graph queries, and error...

24 August 2026 21 min read

Fabiano Amorim in Security, Privacy & Compliance

How Azure Arc allows a DB admin to become SQL Server sysadmin – the vulnerability explained

Learn how db_ddladmin permissions plus Azure Arc's SQL extension create a confused-deputy attack path to sysadmin — and how to...

21 August 2026 27 min read