Sachin Pawar in Cloud

DMS migration failing? How to debug Oracle to Cloud SQL network errors, layer-by-layer (OSI model guide)

Debugging Google DMS failures for Oracle to Cloud SQL migrations? Use the OSI model to pinpoint network errors layer by...

01 July 2026 13 min read

Grant Fritchey in Databases

I let Copilot build my database. Here’s what I learned – and everything I’d do differently next time (part two)

What happens when Microsoft Copilot designs a PostgreSQL schema for Azure? Here's what it got right, what it got wrong,...

29 June 2026 23 min read

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

A stock image showing someone working on a laptop

Aisha Bukar in Databases

The complete guide to XML support in MySQL and PostgreSQL

Discover how MySQL and PostgreSQL differ in XML storage, validation, and querying, and why these differences matter for enterprise apps...

24 June 2026 15 min read

Grant Fritchey in AI

How I built an app just by talking to an AI LLM – the good, the bad, and what I’d do differently next time (part one)

Building a real app end-to-end with an LLM: lessons from week one of dbRosetta. Why scope, prompt templates, and acceptance...

22 June 2026 9 min read

Fabiano Amorim in SQL Server

Exposing a SQL injection vulnerability you’ve never heard of (what it is, how it works, and key takeaways)

How a Unicode lookalike character bypassed REPLACE-based sanitization in a trusted SQL Server system procedure - and what it teaches...

19 June 2026 11 min read

Lukas Vileikis in Career

Why you should still become SQL-certified in 2026 (and how to achieve it)

Is SQL certification still worth it in 2026? Learn how it boosts credibility, career opportunities, and helps you stay competitive...

18 June 2026 10 min read

Greg Low in SQL Server

Vector search in SQL Server: VECTOR_DISTANCE, VECTOR_SEARCH, and index trade-offs

Learn how to use VECTOR_DISTANCE and VECTOR_SEARCH in SQL Server to find semantically similar data. Covers vector indexes, performance trade-offs,...

17 June 2026 7 min read

Simple Talk Editor in Career

From anthropology to analytics: how to build a data career with no prior experience (10 tips from a Microsoft MVP)

No computer science degree, no clear plan - just deliberate moves and the right communities. Here's what Kristyna Ferris learned...

12 June 2026 10 min read

Chisom Kanu in Databases

It’s 2026. Why are databases still failing GDPR compliance audits?

GDPR erasure failures are often database engineering problems, not legal ones. Learn how relational schema design, backup retention, and audit...

11 June 2026 13 min read

Grant Fritchey in Cloud

Why even the best teams struggle with cloud migrations

Cloud migrations fail not from incompetence, but from unknown unknowns. Discover the most common challenges teams face in 2026 —...

10 June 2026 7 min read

Greg Low in SQL Server

How to call an Ollama-based AI text embeddings model from SQL Server 2025

Learn how to call locally hosted Ollama embedding models from SQL Server using sp_invoke_external_rest_endpoint, CREATE EXTERNAL MODEL, and AI_GENERATE_EMBEDDINGS.…

08 June 2026 5 min read

Abhishek Goyal in AI

How to stop AI hallucinations in enterprise RAG systems (a complete guide)

Discover the six biggest causes of AI hallucinations in RAG pipelines - then learn five proven architecture patterns to avoid...

05 June 2026 15 min read

Kellyn Pot'Vin-Gorman in Oracle

Why migrating from Oracle is harder than anyone admits – and what you should do instead

Oracle-to-Postgres migrations routinely go over budget — not because of schemas, but because of DBMS_* packages. Learn what breaks, why...

03 June 2026 19 min read

Greg Low in SQL Server

How to host an AI text embeddings model for SQL Server using Ollama

Learn how to install Ollama locally to generate text embeddings for SQL Server vector search, plus configure a Caddy proxy...

01 June 2026 5 min read

Uzma Younas in PostgreSQL

How data scientists work with PostgreSQL from Python (and how to write queries that don’t break at scale)

In this article, learn how PostgreSQL powers data science workflows, including query execution, performance optimization, indexing, data retrieval, and more.…

29 May 2026 10 min read

Mercy Bassey in PostgreSQL

How to automate vector embeddings with pgai Vectorizer in PostgreSQL

Automate PostgreSQL vector embeddings with pgai Vectorizer. Learn how to sync pgvector embeddings automatically using Timescale’s AI-powered workflow.…

25 May 2026 12 min read

Edward Pollack in T-SQL Programming

Demystifying PIVOT and UNPIVOT in T-SQL

Learn how to use T-SQL PIVOT and UNPIVOT operators with clear examples — from basic row-to-column transforms to dynamic SQL...

20 May 2026 12 min read

Lukas Vileikis in Databases

4 CVEs are affecting Valkey databases. Here’s everything you need to know (and what you should do, right now, to protect yours)

4 CVEs currently affect Valkey databases. Learn what they are, which Valkey versions are vulnerable, and what you should do...

19 May 2026 7 min read

Fabiano Amorim in SQL Server

SQL Server security vulnerabilities you weren’t aware of: how tampered indexed-view metadata can break cross-database isolation

Indexed view tampering in SQL Server backups can expose cross-database data after restore. Learn how restore-boundary attacks work and how...

18 May 2026 18 min read