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 11
Pat Wright in Cloud How to ensure successful deployment of a cloud migration Practical cloud migration go-live tips: planning, team readiness, rollback strategy, testing, and post-migration checks for a smooth deployment.… 06 May 2026 3 min read 1
Greg Low in SQL Server What are managed identities in SQL Server 2025? A complete guide Learn how managed identities in SQL Server 2025 enhance security by eliminating passwords and enabling seamless Microsoft Entra authentication for... 05 May 2026 6 min read 1
Greg Low in SQL Server What is chunking, and how does it apply to vectors in SQL Server 2025? Learn what chunking is, why it matters for embeddings, and how SQL Server 2025 enables efficient AI-powered vector search.… 01 May 2026 7 min read 22
Abhishek Goyal in AI How to get 80% of GPT-4’s value for 20% of the cost (5 tips for reducing AI spend) AI model costs can explode fast - and overpaying is common. The reality is, you don’t need GPT-4 for most... 30 April 2026 15 min read 123
Lee Asher in PostgreSQL What is fillfactor in PostgreSQL – and when should you adjust it? Learn how to optimize PostgreSQL performance with fillfactor - including how it affects HOT updates, indexing, and update-heavy workloads.… 29 April 2026 7 min read 41
Simple Talk Editor in Databases What are the top database platforms in 2026? A look at the latest data Explore 2026 database market trends: AWS, Microsoft, Oracle, and Google Cloud Platform remain dominant as MongoDB, Snowflake, and Databricks steadily... 28 April 2026 6 min read 4
Chisom Kanu in AI Vibe coding and databases: the hidden risks of AI-generated database code Explore how Andrej Karpathy’s “vibe coding” trend reached databases. Uncover risks, real incidents, and 5 critical failure patterns in AI-generated... 27 April 2026 15 min read 2
Pat Wright in Databases What should you move first in a cloud migration? 5 key guidelines Learn how to choose which application to move first in a cloud migration with five practical guidelines covering risk, impact,... 24 April 2026 3 min read 2
Greg Low in AI Local vs remote MCP servers – which should you choose? MCP (Model Context Protocol) servers let AI apps access real-time data and external tools, improving accuracy beyond static model knowledge.... 20 April 2026 6 min read 32
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
Fabiano Amorim in SQL Server Cross-database ownership chaining in SQL Server: security risks, behavior, and privilege escalation explained Learn how cross-database ownership chaining works in SQL Server, how permissions are evaluated, and why it can introduce security risks... 13 April 2026 12 min read 2
Lukas Vileikis in Security and Compliance Everything you need to know about MongoBleed (CVE-2025-14847) Learn what MongoBleed (CVE-2025-14847) is, how the vulnerability leaks MongoDB server memory, which versions are affected, and how to protect... 08 April 2026 6 min read 11
Chisom Kanu in Development Syntax and data structures in esProc SPL – a complete guide Explore esProc SPL's syntax and data structures. Learn how it compares to Python and discover its scripting capabilities for efficient... 06 April 2026 29 min read 1
Lee Asher in Databases First Normal Form (1NF): Breaking the ‘unbreakable rule’ in database design Learn what First Normal Form (1NF) means in database design, why repeating groups are discouraged, and why it can be... 31 March 2026 9 min read 711
Chisom Kanu in Development How to set up a data analysis environment in esProc SPL (compared to Python) Learn how to install and set up esProc SPL for data analysis. Compare esProc with Python and its unique features... 30 March 2026 23 min read 1
Grant Fritchey in PostgreSQL How User-Defined Types work in PostgreSQL: a complete guide Learn PostgreSQL User-Defined Types (UDTs) with clear examples of DOMAIN, COMPOSITE, ENUM, and RANGE types, plus practical SQL code for... 27 March 2026 14 min read 2
Greg Low in SQL Server Everything you should know about the SQL Server Resource database Learn what the SQL Server Resource database is, why it exists, how it affects patching/ upgrades, and what to do... 25 March 2026 5 min read 22
Animesh Goyal in AI Why most enterprise AI projects fail – and how to fix them Discover why many enterprise AI projects fail and learn how to build reliable, cost-effective LLM workflows.… 23 March 2026 6 min read 93
Greg Low in SQL Server How to determine the last value used by a sequence in SQL Server Learn how SQL Server sequences work, how they differ from IDENTITY columns, and how to track the last value with... 17 March 2026 6 min read 111
4
