Skip to content

Cloud, Data & Platform

A 1 TB SQL Server migration to the cloud with zero data loss

A mission-critical on-premise SQL Server database had to move to a managed cloud instance without losing a row or overrunning the cutover window.

Client
Enterprise transformation programme
Industry
Enterprise IT
Disclosure
Anonymised under NDA
Migrated to a managed instance
1 TBMigrated to a managed instance
Rows lost
0Rows lost
Schema integrity verified
100%Schema integrity verified

The challenge

1 TB of mission-critical data, a short cutover window and no tolerance for loss.

Stack

  • SQL Server
  • Azure SQL Managed Instance
  • Blob staging
  • Automation

What we did

  1. 01Staged differential backups through cloud object storage
  2. 02Automated restore pipeline, rehearsed end to end
  3. 03Schema integrity verified before cutover
  4. 04Cutover in a minimal window
Generic reference architecture
lagAPPconnection poolPGBOUNCERtransaction modePRIMARYpostgres · auroraREAD REPLICAhot standbyWAL ARCHIVEpitr windowPGROLLzero downtime

A generic representation of the pattern, not the client’s topology.

How you would buy this

Fixed-scope Delivery Sprint

One outcome, one price: a cloud-cost cut, a platform migration, a ClickHouse or IIoT ingestion path, or a production AI-agent pilot.

Compare all engagements →

Fixed fee · 2–6 weeks

Fixed-scope Delivery Sprint

From

$25,000

fixed fee

One outcome, one price: a cloud-cost cut, a platform migration, a ClickHouse or IIoT ingestion path, or a production AI-agent pilot.

  • Written acceptance criteria per milestone
  • Demo at every milestone
  • Source, runbooks and handover included
  • Milestone billing 30 / 40 / 30
Ask about this engagement

More cloud, data & platform work

Cloud, Data & PlatformNDA · AI & analytics SaaS

85% infrastructure cost cut with a hybrid bare-metal platform

High-growth AI and analytics SaaS

Managed databases, vector search and LLM API tokens had grown into a six-figure monthly bill. We moved the heavy paths onto owned infrastructure without giving up the cloud where it earns its keep.

Lower recurring infrastructure spend
85%Lower recurring infrastructure spend
Query latency, down from 350 ms
<45 msQuery latency, down from 350 ms
Unencrypted network paths
0Unencrypted network paths
Cloud, Data & PlatformNDA · Financial services

Zero-trust multi-account landing zone that passed SOC 2 first time

Regulated financial services provider

A monolithic cloud estate with shared credentials and flat networking had an audit date. We rebuilt it as modular, policy-bounded accounts with every change in code.

Type II passed with zero findings on first evaluation
SOC 2Type II passed with zero findings on first evaluation
Infrastructure provisioned from code
100%Infrastructure provisioned from code
Public IP exposures left
0Public IP exposures left
Cloud, Data & PlatformNDA · Logistics

From kickoff to paying customers in 14 weeks

Series A logistics SaaS

A greenfield dispatch platform. We owned the architecture, the infrastructure and the first three service surfaces, then hired the team that took it over.

Kickoff to first paying customer
14 wksKickoff to first paying customer
Uptime from day one
99.95%Uptime from day one
Engineers hired and onboarded
3 → 11Engineers hired and onboarded

Start with a scoping call.

Thirty minutes with the founder. Bring your architecture diagram, your cloud bill or your plant drawings, and leave with what is realistic — including when the answer is that you do not need us yet.

Mutual NDA before any detail is shared. First response within 24 hours.