Fabiano Amorim in SQL Server Exploiting SQL Server Date Correlation Optimization: How Tampered Backups Enable Cross‑Database Data Leaks This article reveals a critical SQL Server flaw: attackers can weaponize Date Correlation Optimization (DCO) views in restored backups to... 07 January 2026 19 min read 2
Greg Low in Databases How to Create a SQL Server Linked Server to Oracle 26ai Free Easily move data from SQL Server to Oracle 26ai Free with this step-by-step guide. Learn how to set up a... 05 January 2026 4 min read 2
Ben Johnston in SQL Server SQL Server Regular Expression Performance and Guidelines SQL Server 2025 introduces regular expression (regex) functions to the TSQL language. You could do this in previous versions with... 02 January 2026 15 min read 111
Rodrigo Ribeiro Gomes in SQL Server How to View SQL Server Object Code Easily with sp_showcode Discover how sp_showcode improves SQL Server code viewing compared to sp_helptext, with better formatting, search, and decryption.… 29 December 2025 11 min read 21
Fabiano Amorim in Security, Privacy & Compliance SQL Server Privilege Escalation via Replication Jobs Learn how attackers can exploit SQL Server replication cleanup jobs to escalate privileges from db_owner to sysadmin, and discover practical... 22 December 2025 5 min read 31
Aaron Bertrand in SQL Server How to fix the Invalid Object Name error in SQL Server Learn why SQL Server shows ‘Invalid object name’ errors and how to fix them. Common causes include typos, missing objects... 18 December 2025 6 min read 21
Steve Jones in Editorials Evolving SQL Saturday Steve Jones explains the exciting rebranding of the SQL Saturday events, beginning in 2026 with plans for full integration in... 10 December 2025 4 min read 21
Greg Low in SQL Server 10 Key Concepts Developers Should Know About the SQL Server model Database Learn how SQL Server’s model database serves as a template for new databases, including file settings, recovery model, and deployment... 08 December 2025 5 min read 2
Aisha Bukar in Databases MySQL vs PostgreSQL: JSON Data Types MySQL and PostgreSQL both support JSON, but they handle it in very different ways. This article compares their JSON data... 02 December 2025 22 min read 21
Greg Low in SQL Server 15 Practical Tips for Securing SQL Server 15 practical, high-impact steps for securing your SQL Server environment.… 28 November 2025 5 min read 22
Matt Gantz in Databases How to Monitor and Optimize Batched Deletion Processes in SQL Server Batched deletions are a common strategy in SQL Server to manage large datasets without overloading the system, but poorly tuned... 19 November 2025 9 min read 42
Lee Asher in Databases 5 Strategies to Refactor SQL Code Struggling with messy SQL queries? Discover 5 smart refactoring strategies to clean up your code, boost performance, and simplify maintenance.… 12 November 2025 16 min read 73
Fabiano Amorim in Security, Privacy & Compliance SQL Server security vulnerabilities you weren’t aware of: DBaaS system code decryption & user data exfiltration A SQL Server DBaaS privilege bypass exposed system tables and vendor-protected code on AWS, GCP, and Alibaba. This explains the... 05 November 2025 30 min read 43
Chandan Shukla in SQL Server IoT Meets OLTP: How to Handle Backfilling Challenges in Real-Time Systems Learn how IoT backfilling impacts OLTP systems and discover strategies to optimize performance for real-time data processing.… 23 September 2025 19 min read 32
Lee Asher in SQL Server SQL FULL OUTER JOIN Explained: Use Cases, Examples & Performance A FULL OUTER JOIN returns every row from both tables, filling unmatched rows with NULLs. Learn when to use it... 26 August 2025 13 min read 531
Lukas Vileikis in MySQL MySQL Index Overviews: PRIMARY KEY Indexes Learn how to use PRIMARY KEY indexes in MySQL - a type of B-tree index designed to help a database... 15 August 2025 16 min read
Joe Celko in SQL Server Mastering SQL VIEWs: Syntax, Use Cases, and Best Practices Learn how to use SQL VIEWs effectively with practical examples, syntax breakdowns, and expert tips for recursive, union, and updatable... 05 August 2025 10 min read 11
Edward Pollack in Featured How to Increase SQL Server Column Width Without IO (Input/Output) Overhead One of the most hassle-prone changes that can be made in a SQL Server database is to widen an existing... 28 July 2025 14 min read 211
Matt Gantz in SQL Server Measure Replication Latency in SQL Server AlwaysOn AGs Learn how to measure synchronous replication latency in SQL Server AlwaysOn Availability Groups using performance counters. Track HADR_SYNC_COMMIT waits and... 25 July 2025 9 min read 211
Robert Sheldon in PostgreSQL How to use pgAdmin with Azure Database for PostgreSQL flexible server Learn how to connect and manage Azure PostgreSQL Flexible Server using pgAdmin, a powerful GUI tool for PostgreSQL.… 23 July 2025 17 min read
