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

Simple Talk Editor in Data Security, Privacy, and Compliance

In 2026, engineering teams are quietly accepting more risk. Here’s why

11 takeaways from the Simple Talk podcast on security vs speed in databases: why teams misjudge risk, how AI amplifies...

17 May 2026 4 min read

Lukas Vileikis in PostgreSQL

PostgreSQL is removing MD5 authentication for passwords. Here’s what it means for your databases

PostgreSQL is phasing out MD5 authentication across versions 18–21, replacing it with SCRAM-SHA-256. Here's what it means for your database...

15 May 2026 7 min read

Dejan Lukić in Data Security, Privacy, and Compliance

How to build a privacy-aware analytics layer with SQL (4 top techniques)

Learn how to build privacy-aware analytics with SQL using masking, aggregation, and pseudonymization. Stay GDPR-compliant without exposing PII.…

13 May 2026 11 min read

Grant Fritchey in Databases

Why database ownership is so fragmented in 2026 – and what you can do about it

Learn why database ownership is so fragmented in 2026 - and how best to overcome this challenge, with proven methods...

12 May 2026 7 min read

Pat Wright in Cloud

How to ensure success following a cloud migration

Learn how to optimize performance, reduce costs, improve security, and ensure long-term success after moving from on-prem to the cloud.…

11 May 2026 5 min read

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

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

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

Pat Wright in Databases

How to utilize testing to ensure a successful cloud migration

Learn how to ensure successful migrations by testing applications, tracking bandwidth, and fixing issues before going live.…

04 May 2026 3 min read