Back to Tech landscape

pgvector

Databases

pgvector with SQL Server as the Factory default

Official documentation (opens in a new tab)

Overview

pgvector adds vector similarity to PostgreSQL when teams want one database for relational and embedding data.

Relational SQL Server on Azure remains the default for Factory and SaaS templates—paired with NHibernate or EF Core, migrations in CI, and backup policies that match enterprise SLAs.

Polyglot and client-mandated stores are supported with clear boundaries: integration schemas, migration tooling, and capacity planning so operational data never becomes an undocumented side channel.

Need search, cache, or warehouse tiers alongside transactional SQL? We design data paths that stay observable, recoverable, and aligned with your Azure landing zone.

Why we use it:

  • Index tuning for recall
  • Migration of embedding schema
  • Connection pooling
  • Capacity planning
  • Migration and rollback discipline in Azure Pipelines
  • Encryption, redundancy, and residency matched to SLA
  • Clear ownership between platform SQL and integration stores

Ready to work with us?

Let's discuss how our team can help achieve your digital goals