Lukas Vileikis in Security, Privacy & 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 11
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 331
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 51
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 21
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 11
Edward Pollack in SQL Server How to Find and Monitor Slow/Long-Running Queries in SQL Server Learn how to detect long-running queries in SQL Server using dynamic management views and T-SQL scripts to monitor performance in... 16 February 2026 19 min read 44
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 31
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 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
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
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 42
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
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
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
Robert Sheldon in PostgreSQL How to Use the psql Command-Line Tool with Azure Database for PostgreSQL Flexible Server Learn how to install and use the psql command-line tool to connect to and manage Azure Database for PostgreSQL Flexible... 04 August 2025 20 min read 1
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
