Lukas Vileikis in MySQL How to make database schema changes without downtime in MySQL: complete guide Learn how to make MySQL schema changes without downtime. Compare online DDL, Percona Toolkit, and gh-ost to keep your database... 12 October 2026 6 min read 2
Fabiano Amorim in SQL Server How to secure temporary objects, metadata visibility, and audit assurance in SQL Server (complete guide) Global temp objects, DMVs, and audit gaps can quietly become attack paths in SQL Server. Learn what to review, monitor,... 09 October 2026 23 min read 3
Tony Davis in Security, Privacy & Compliance Why test data management is essential for SOC 2 compliance Struggling with SOC 2 audits? Learn how test data management protects customer data outside production and keeps testing compliant.… 07 October 2026 14 min read 1
Joydip Kanjilal in Data Analytics The future of data leadership: key strategies, challenges, and emerging trends Data leadership drives smarter decisions, stronger governance, and competitive advantage. Discover the key pillars, challenges, and strategies for 2026 and... 06 October 2026 12 min read 1
Dejan Lukić in Security, Privacy & Compliance How to secure MCP (Model Context Protocol) servers connected to your database – a practical guide Learn how to secure MCP database access: stop confused deputy attacks, token passthrough, and prompt injection with proper auth and... 05 October 2026 7 min read 2
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 11
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 1
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 21
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 2
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 2
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 1
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 11
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 3
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 1
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 31
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 21
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 2
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 21
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 11
