Databases Archives

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 Security, Privacy & 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 Security, Privacy & 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

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

Pat Wright in Cloud

Why over-communication is critical to the success of a cloud migration

Cloud migration success depends on clear, consistent communication. Learn how dashboards, targeted updates, and regular check-ins keep teams aligned and...

30 April 2026 3 min read

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

Simple Talk Editor in Databases

What are the top database platforms in 2026? A look at the latest data

The top database platforms in 2026 by revenue and popularity - AWS, Microsoft, Oracle and Google leading; MongoDB, Snowflake, Databricks...

28 April 2026 6 min read

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