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
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
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
Jim Czuprynski in Databases How to Create Uber-Fast Maps With Oracle 23ai Vector Tiles and H3 Indexes (Part 2) Discover how to build ultra-fast mapping applications using Oracle Database 23ai’s new vector tile and H3 hexagonal indexing features. Part... 17 November 2025 15 min read 21
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 53
Fabiano Amorim in Security and Compliance SQL Server DBaaS Vulnerability: Decrypting System Code & Exfiltrating User Data 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
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
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 31
Lee Asher in SQL Server Unlocking the Power of FULL OUTER JOIN in SQL: Performance, Use Cases & Examples Discover how the FULL OUTER JOIN in SQL can simplify queries, improve performance, and solve real-world data problems with practical... 26 August 2025 12 min read 531
Chisom Kanu in MySQL MySQL Shell Basic Configuration Management (Part 6 – Backups and Recovery Procedures) Learn how to automate MySQL performance tuning using MySQL Shell. Discover intelligent backup and recovery strategies, configuration tracking, and optimization... 18 August 2025 18 min read 1
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
Mercy Bassey in PostgreSQL Secure PostgreSQL in Docker: SSL, Certificates & Config Best Practices Learn how to run PostgreSQL in Docker with production-grade SSL encryption, certificate-based authentication, and custom configuration files - perfect for... 13 August 2025 10 min read
Chisom Kanu in MySQL MySQL Shell Basic Configuration Management (Part 5a – Optimizing MySQL Performance) Learn how to optimize MySQL performance using MySQL Shell. This guide covers network tuning, query optimization, and configuration best practices... 08 August 2025 22 min read
