Edward Pollack in Databases Why disaster recovery takes longer than your RTO (9 hidden causes) Recovery Time Objective (RTO) is the maximum downtime you'll accept. Learn why real recovery runs longer, and the nine gaps... 11 November 2026 16 min read 1
Sergey Gigoyan in SQL Server 5 common SQL Server transaction problems (and how to solve them) Five practical SQL Server transaction problems — dirty reads, non-repeatable reads, phantom reads, rollback behavior, and nested transactions — with... 06 November 2026 16 min read 3
Dejan Lukić in AI How personal data leaks into AI tools by accident (and how to stop it) Customer data reaches ChatGPT through clean-up pastes, BI assistants and copilots, not attacks. Here’s how to stop it without banning... 28 October 2026 8 min read 111
Aisha Bukar in Databases The key syntax differences between MySQL and PostgreSQL – everything you should know Migrating from MySQL to PostgreSQL? Learn the key SQL syntax differences - identifier quoting, auto-increment, LIMIT vs FETCH FIRST, and... 26 October 2026 19 min read 1
Greg Low SQL Server 2016 end of support: how to choose your upgrade path SQL Server 2016 support has ended. Compare SQL Server 2022 vs 2025, in-place vs side-by-side upgrades, Azure and ESUs, with... 23 October 2026 15 min read 42
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 3
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 4
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
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 2
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 22
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
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
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
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
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 41
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 31
Greg Low in SQL Server JSON indexing in SQL Server 2025: how it works and current limitations SQL Server 2025 introduces native JSON indexing via CREATE JSON INDEX. Learn how it works, when to use it, and... 19 August 2026 8 min read 6
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 311
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 11