Grant Fritchey in PostgreSQL How to insert, query, and modify data in PostgreSQL (getting started with PostgreSQL, part three) Learn how to insert, query, update, and delete data in PostgreSQL with real examples covering INSERT, SELECT, JOIN, WHERE, and... 02 November 2026 18 min read 11
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
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
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
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
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
Greg Low in SQL Server What’s missing in T-SQL? My wish list of features that developers actually need in SQL Server A veteran SQL Server expert's wish list for T-SQL: true constants, enumerations, extensibility, better naming consistency, and more. See what's... 08 July 2026 12 min read 11
Edward Pollack in SQL Server 5 T-SQL features that should already exist (2026 SQL Server wish list) 2026 T-SQL wish list covering native Parquet imports, arrays, OVERLAPS, simpler licensing, and cloud storage — features SQL Server still... 26 June 2026 14 min read 42
Lukas Vileikis in Databases Why COALESCE might be the most useful SQL function you’re not using right Learn how the SQL COALESCE function works, with practical examples for handling NULL values, setting defaults, and writing cleaner, more... 07 May 2026 7 min read 31
Greg Low in SQL Server Can SQL Server 2025’s REGEXP_SPLIT_TO_TABLE fix STRING_SPLIT in T-SQL? Learn how to split strings efficiently in T-SQL using STRING_SPLIT and the REGEXP_SPLIT_TO_TABLE function in SQL Server 2025. Discover limitations,... 15 April 2026 5 min read 1
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
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 731
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
Lukas Vileikis in MySQL MySQL PRIMARY KEY Indexes: The Clustered Index How PRIMARY KEY indexes work in MySQL and InnoDB: the rules, why the primary key is the clustered index, strings... 15 August 2025 15 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
Edward Pollack in Featured SQL Server 2025 PRODUCT() Function: Multiply Values in T-SQL Learn the new PRODUCT() aggregate function in SQL Server 2025 - multiply values across rows like SUM() adds them. Covers... 21 July 2025 9 min read 21
1
1
