Services
What we design, build and integrate.
Each practice uses the same rules: tests before release, a written way back for every change, and a handover you can keep.
01 · SQL Server and data
Data systems that must be right.
SQL Server is our core. We design data models, write and tune T-SQL, and put databases under version control with tests.
- Schema design and data modelling, from first draft to hundreds of tables.
- T-SQL development: procedures, functions, triggers and constraints.
- Performance work: query plans, indexing, plan forcing and maintenance.
- Versioned migrations, automated tests (tSQLt) and schema drift checks.
- SQL Server 2022 and 2025. PostgreSQL alongside, when one model must run on both.
- Safe automation: gated scripts with policy checks and a kill switch.
Typical jobs
- Health check of a slow or fragile database
- New data model for a line-of-business system
- Migration path from scripts to versioned releases
- Integration of data from several sources
02 · Software and integration
Services that connect what you already own.
We build the glue between systems: services, APIs, consoles and workflows that run unattended and report their health.
- .NET and C#, Blazor web apps, Python, TypeScript and Node.
- APIs, background services and Windows scheduled services.
- Workflow engines and message buses (RabbitMQ, Camunda).
- Single sign-in portals with two-factor authentication.
- Monitoring and maintenance consoles for PCs and servers.
- Encrypted data stores for sensitive records.
Typical jobs
- Connect two systems that do not talk today
- Replace a manual spreadsheet process with a service
- Secure remote access to internal tools
- A dashboard that shows what is running and what failed
03 · Home automation
Home Assistant, done safely.
We design and build Home Assistant systems for homes and estates in Gauteng. Safety-critical devices never switch without a person confirming the action.
- Home Assistant design, build, migration and audit.
- Lights, pumps, gates, garage doors, geysers and climate.
- Local-first control: the house keeps working when the internet is down.
- Cloud and local device reconciliation (Sonoff eWeLink and others).
- Node-RED flows, automations and dashboards for phone and tablet.
- Energy and solar monitoring.
- Daily backups and a written restore runbook.
Typical jobs
- Audit of an existing Home Assistant system
- New installation for a home or estate
- Clean-up of automations that misfire
- Safe control rules for gates, geysers and pumps
04 · Media systems
Cameras, music and streaming.
We integrate camera, music and streaming systems so they are reliable and easy to use.
- IP cameras and network video recorders with Blue Iris.
- Camera inventory and stream health checks (RTSP).
- Motion and AI alert tuning to cut false alarms.
- Self-hosted music servers over HTTPS.
- Casting to TVs and speakers.
- Generative music and audio tools.
Typical jobs
- Make an existing camera system record and alert reliably
- Remote viewing that stays secure
- A private music library for the whole house
How an engagement runs
Three ways to work with us.
| Engagement | What you get | Best for |
|---|---|---|
| Health check | A fixed-scope review with a written report and a ranked fix list. | A database, Home Assistant system or camera system that is slow, fragile or unclear. |
| Build | Design, build, tests, documentation and handover. | A new system, or a rebuild with a clear goal. |
| Support | Agreed hours each month for changes, checks and fixes. | Systems that must keep running after handover. |