Lukas Vileikis in Security Securing Your Databases in 2026: Best Practices for the Evolving Threat Landscape 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
Greg Low in Learning Resources Common Misconceptions About Microsoft Certification Exams An experienced exam writer explains common misconceptions about Microsoft certification exams, question design, preparation, and real-world expectations.… 21 January 2026 6 min read 1
Aaron Bertrand in SQL Server Common SQL Server Problems: Invalid Length Learn why SQL Server throws the invalid length error in functions like LEFT, SUBSTRING, and RIGHT, and discover practical fixes... 12 January 2026 5 min read 32
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
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 Databases 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 Common SQL Server Problems: Invalid Object Name 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
Vivek Varma in PostgreSQL How to Build an AI-Powered Semantic Search in PostgreSQL with pgvector Learn how to build a sleek, AI-powered semantic search engine that lives inside your existing database. We’ll walk through how... 15 December 2025 12 min read 33
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
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 21
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
Rodrigo Ribeiro Gomes in SQL Server How to Build an AI-Powered T-SQL Assistant with Python & SQL Server Discover how to build an AI-powered T-SQL assistant using Python, embeddings, vector search and SQL Server’s new AI features. Step-by-step... 22 October 2025 58 min read 31
Simon Galbraith in Featured Memories of Andrew Clarke, by Simon Galbraith Simon Galbraith, co-founder of Redgate and one of the creators of Simple Talk, remembers Andrew Clarke.… 30 September 2025 7 min read
Tony Davis in Featured A Tribute to Andrew Clarke (a.k.a. Phil Factor) We are deeply saddened to share the news that Andrew Clarke, better known to Simple-Talk readers as Phil Factor, recently... 08 September 2025 3 min read 643
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 21
Edward Pollack in Featured How to Use the New PRODUCT() Function in SQL Server 2025 Learn how the new PRODUCT() function in SQL Server 2025 simplifies multiplicative aggregation. See examples, performance tips, and use cases.… 21 July 2025 8 min read 2
Edward Pollack in Featured Using Regular Expressions (Regex) in SQL Server 2025: A Complete Guide Everything you need to know about Regular Expressions (Regex) in SQL Server 2025 - learn what it is, how to... 14 July 2025 18 min read
Bravin Wasike in DevOps DevOps vs. SRE: Bridging the Gap, Not Building Walls (Part 2 – Putting it into Practice) In Part 1 of this series, we covered the operational overlap between DevOps and Site Reliability Engineering (SRE). While DevOps... 10 July 2025 29 min read
