Greg Low in Editorials

My thoughts on Redgate’s 2026 State of the Database Landscape report

Greg Low shares his thoughts on Redgate’s 2026 State of the Database Landscape report, covering cloud adoption, database security, AI,...

05 March 2026 9 min read

Lukas Vileikis in Security and Compliance

How to secure MySQL and PostgreSQL in the world of AI

Learn how AI is transforming database security and discover best practices to secure MySQL and PostgreSQL against AI-driven threats, faster...

04 March 2026 11 min read

Lee Asher in Databases

What are database keys? A practical guide

A practical guide to database keys: natural vs surrogate, UUIDs, performance tradeoffs, and best practices for scalable schema design.…

02 March 2026 12 min read

Greg Low in SQL Server

Why disabling the SQL Server sa account still matters in 2026

Disabling the SQL Server sa account isn’t outdated advice. Learn why attackers still target sa and what modern SQL Server...

26 February 2026 5 min read

Aaron Bertrand in SQL Server

How to optimize planned availability group failovers in SQL Server

Learn how to perform fast and predictable SQL Server planned Availability Group (AG) failovers. Discover tips to reduce downtime, optimize...

20 February 2026 15 min read

Lukas Vileikis in MySQL

How to safely use MySQL 8.0 post end-of-life (and alternatives to consider)

MySQL 8.0 reaches End of Life in April 2026. Learn the risks, upgrade paths, migration options, and how to stay...

18 February 2026 5 min read

Rodrigo Ribeiro Gomes in SQL Server

SQL Server 2025 CREATE EXTERNAL MODEL and AI_GENERATE_EMBEDDINGS Commands Explained

Learn about the new CREATE EXTERNAL MODEL and AI_GENERATE_EMBEDDINGS commands in SQL Server 2025.…

09 February 2026 29 min read

Lukas Vileikis in Security

How to keep your databases secure in 2026: a complete guide

Learn top strategies for securing your databases against emerging security threats. Discover best practices for access control, encryption, monitoring and...

27 January 2026 10 min read

Lukas Vileikis in Databases

Making AI Talk to Your Database: AI-Powered Database Queries Made Simple

Learn how AI-driven tools bridge the gap between human language and databases, making data access faster, easier, and more intuitive.…

04 December 2025 9 min read

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

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

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

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

An image showing columns increasing in size from 10% to 100%.

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

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