Back to Tech landscape

Snowflake

Databases

Snowflake with SQL Server as the Factory default

Official documentation (opens in a new tab)

Overview

Snowflake hosts analytics workloads fed from operational stores via ADF and batch pipelines.

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:

  • Role-based access
  • Warehouse sizing
  • Stage from Azure Storage
  • PII handling policies
  • 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