Straight answers on QA, restores, migrations and cloud bills

Customers send database work, backups and restores to our engineers as tickets. Each guide shows how that work gets done, including when you’re better off staying on a major public cloud.

32 guides

Hotfix stack8.3 build and datasetRegression stack9.0 build and dataset
One approved configuration, nothing shared

Development & QA

Parallel QA environments for two releases in the same week

What two QA stacks have to keep apart when a hotfix and the next release test in the same week: the database, sandbox accounts, sign in callbacks and scheduled jobs.

6 min read
QA stackRebuilt, run, torn downRelease recordKept after the stack is gone
Build, environment, dataset, results, approval

Development & QA

What enterprise buyers ask to see about your regression testing

The five items in a regression record for one release: build, environment, dataset, results and approval, with the public framework that asks for them.

7 min read
8 hour runEnds before the first vacuum60 hour runThree nightly jobs inside it
Memory climbing 50 MiB an hour

Development & QA

How long to run a soak test

Set a soak test's length from the slowest scheduled cycle in the system, hold it at average load, and read memory, connections, disk and latency as slopes.

7 min read
Six repsThree on calls at 2:15Three demo stacksSized to the calendar peak
Each stack reset before its next booking

Operations

One demo environment per rep or one per vertical?

Count overlapping demos on the calendar, check whether one tenant can be reset alone, and multiply stacks by releases before choosing a demo environment pattern.

6 min read
Suite runs12 of 35 working hoursStack work10 of 35 working hours
Triage and manual passes take the other 13

Development & QA

Where the hours go in a slow regression suite

A ledger for one regression cycle: hand rebuilds, dataset loads, fixture setup, triage and reruns, with the commands that show which hours the tests own.

7 min read
Two buildsRun on one environmentBudget lineLast release plus 10 percent
Queries per request over the line: 15 against 12

Development & QA

Performance budgets per release

Set a release's latency budget from the run to run spread, measure the last release and the candidate on one environment, and count queries per request.

8 min read
ProductionStays on AWSQARebuilds from staged data
Image pulls and S3 reads run through the tunnel

Development & QA

When to move QA off AWS ahead of production

Move QA off AWS first when it rebuilds often from data staged once and none of its tests call AWS services. Price the path back before you move.

17 min read
ProductionCuts over laterQAMoves first
Who swaps a failed disk after cutover

Planning

Cloud repatriation for teams under 50 engineers

What cloud repatriation takes for a team under 50 engineers: who replaces a failed disk, how to sort the bill, and why QA moves before production.

13 min read
PaaSHeroku, RenderAWS or AzureWith a consultantPrivate cloudRun by Petrichor
Product teamProvider or consultant

Planning

Choosing a SaaS hosting provider by who runs operations

Replay one outage across a PaaS, AWS or Azure with a consultant, and a managed private cloud to see whose engineer does each operating step.

12 min read
Vendor platform listChecked firstMicrosoft support datesJuly 2026, January 2027
Ready to moveVendor upgrade firstStays where it runs

Operations

Legacy application hosting inside the vendor's support matrix

The vendor's supported platform list decides where a legacy application runs. Three options as SQL Server 2016 and Windows Server 2016 age out.

19 min read
One account$3,000 on $40,000Several accountsTiers restart per accountReservation monthPrepay raises the fee

Planning

What Business Support+ costs on a $40,000 monthly cloud bill

AWS Business Support+ costs $3,000 a month on a $40,000 single-account bill, and more across accounts or with a prepaid reservation.

14 min read
CPU stealLogged for a weekDisk imageBooted on another hypervisorBackupsLocked from the admin login

Operations

Due diligence questions for a managed private cloud provider

Questions for a managed private cloud provider, grouped by the failure each one guards against, with the evidence a strong answer includes.

15 min read
60 physical coresTwo 10-core CPUs in each host96 billed coresA 16-core minimum per CPU

Migration

VMware renewal quote: options for a cluster of three hosts

Recount a Broadcom renewal quote for three ESXi hosts from the cores you run, and price the replacement hosts before choosing a VMware alternative.

16 min read
$912.60Egress at list price+$436.47NAT, cross-AZ, replication$1,349.07Billed for the month

Planning

AWS egress fees for a 10 TB month

Ten TB of AWS internet egress lists at $912.60. With NAT Gateway, cross-zone traffic and replication, one 10 TB month came to $1,349.07.

15 min read
Host firstEvery rebuild needs itSix changesOne per weekendKept spareJanuary 9 and 10

Migration

Before January 12, 2027: triaging Windows Server 2016 by role

Windows Server 2016 end of support lands January 12, 2027. Give each server role its own action and cutover weekend, and know where ESU applies.

18 min read
ProductionSQL Server 2016Full backupTaken before last month's close2022 or 2025Reruns the close at level 130

Migration

Testing SQL Server 2016 upgrades on a restored copy

SQL Server 2016 end of support passed on July 14, 2026. Rerun the heaviest cycle on a restored copy running 2022 or 2025 before the upgrade.

19 min read
GrowthNext year’s budgetDriftThe only wasteRate changeA purchase decision

Planning

Why does my Azure bill keep going up?

Sort an Azure bill increase into added work, leftover resources and rate changes in about an hour in Cost Management, then act on each one.

17 min read
Configuration v14Approved by QA leadFive layersGolden image first
Checked after each layer

Development & QA

Test environment provisioning from approved configurations

What a QA configuration pins above the golden image, who approves each version, and the order Petrichor builds a stack from it, with a check after each layer.

14 min read
PrimaryTakes the writesStandbyReplays every change
Third vote on a separate host

Operations

High availability for a small SaaS backend

Which servers need a backup twin, how the database decides who's in charge, and how to time a failover drill.

18 min read
Release numberWhat the ticket saysExact buildCU, Windows build, collation
Destroyed when the case closes

Development & QA

Reproduce a customer bug on their exact version

Collect the customer's patch levels in the first reply, keep busy releases built, and give each stack a known dataset and a test license.

16 min read
Cloud invoiceResourcesPaid support
Engineering timePatchingIncidentsRestores

Planning

Counting engineer hours and support fees in cloud TCO

Price one application's AWS or Azure cost with its support fee, open commitments and engineer hours, then find the quote a provider must beat.

10 min read
Private cloud
One organization
Exclusive use
Public cloudShared by many customers

Planning

Private vs public cloud once the application is in production

Four checks for an application on AWS or Azure: the managed services it calls, the versions it pins, shared hardware behavior, and ticket owners.

11 min read
BaselineBuild + dataTest runRepeat the checks
Reset both together

Development & QA

Resetting a QA environment between test runs

Choose a reset method by the state it leaves untouched, and check the environment against a written starting state before the next run.

16 min read
Release artifactv1.4
Stagingv1.4
Customer Av1.4
Customer BUpdate pendingv1.3

Operations

Release management when a hosting provider runs production

What a software vendor and its hosting provider write down before a release: who can stop it, the artifact digest, and the schema change.

13 min read
Vendor platform listChecked firstMicrosoft support datesJuly 2026, January 2027
Ready to moveVendor upgrade firstStays where it runs

Planning

Your app works. Is it ready for real customers?

Five questions to answer before real customers use an app you built with AI tools: where it runs, who can get in, backups, patching and cost.

3 min read
One account$3,000 on $40,000Several accountsTiers restart per accountReservation monthPrepay raises the fee

Planning

How to read a cloud bill in ten minutes

A plain walk through a cloud invoice for business owners: the five lines that carry most of the cost, and the cost the invoice leaves out.

3 min read
Talk to a consultant