Start with the series · SQL Server → PostgreSQL New here? This category's flagship series takes you start to finish An eight-part translation guide for developers who know SQL Server and are moving to PostgreSQL — schemas, data types, T-SQL differences, PL/pgSQL, performance, backup and restore, and the migration itself. Current for PostgreSQL 18. →
Databases & Data PostgreSQL vs SQL Server for .NET Developers: The Real Differences PostgreSQL vs SQL Server, decided by someone who ran both. Licensing, EF Core support, tooling, hosting, JSON, full-text search, and what hurts in a migration. Sep 4, 2026 · 9 min read →
Databases & Data SQL vs NoSQL: Which Database Should You Learn First? Tables or documents? Rows or JSON? What each kind of database is good at, where each struggles, and a clear recommendation for your first one. Jul 30, 2026 · 5 min read →
Databases & Data What Is a Vector Database? (And Why AI Needs One) Vector databases search by meaning, not keywords. How embeddings turn text into numbers, and how similarity search powers RAG and semantic search. Jul 30, 2026 · 4 min read →
Databases & Data Database Indexes: Why Your Queries Are Slow Scan a million rows, or jump straight to one. How indexes work, when to add them, and the trade-offs nobody mentions. Jul 30, 2026 · 5 min read →