Technologies
Platforms we know in depth.
We build our expertise on depth in the few platforms where critical workloads run, not on a long list of tools.
01
Database platforms
- Microsoft SQL Server
- Installation, administration, performance, high availability, security and upgrades.
- PostgreSQL
- Administration, performance analysis, backup and migrations from SQL Server.
02
PostgreSQL ecosystem
- Streaming and logical replication
- Synchronous/asynchronous standbys, version migrations and selective data distribution.
- Automatic failover
- Defined, tested failover with a cluster manager; tooling is chosen per environment.
- pg_stat_statements and EXPLAIN
- Query-level workload analysis and plan review.
- Autovacuum and maintenance
- Per-table tuning, bloat monitoring and statistics management.
- WAL archiving and PITR
- Backups with point-in-time recovery and rehearsed restores.
- Connection pooling
- Managing connection load with a pooling layer; tooling is chosen per environment.
03
High availability & disaster recovery
- Always On Availability Groups
- Availability and read scale-out with synchronous and asynchronous replicas.
- Windows Server Failover Cluster
- Cluster infrastructure, quorum design and failover scenarios.
- Log Shipping
- A simple, resilient disaster recovery copy at a remote site.
- Replication
- Data distribution and offloading reporting workloads.
- Backup & Restore
- Backup strategy aligned to recovery targets, with restore verification.
04
Performance & diagnostics
- Query Store
- Query performance history and plan regression analysis.
- Dynamic Management Views
- Live resource usage, waits and session analysis.
- Wait Statistics
- Pinpointing which resource is the bottleneck.
- Extended Events
- Low-overhead, targeted event tracing.
05
Security & audit
- SQL Server Audit
- Recording critical events and access to sensitive data.
- Role-based authorisation
- Role and permission design on least privilege.
- Connection and encryption security
- Encrypted connections and secure configuration.
06
Data & reporting
- ETL and data integration
- Observable, re-runnable load processes.
- Data warehousing
- Analytical data models on shared definitions.
- Power BI
- Enterprise reporting and management dashboards.
- Qlik Sense
- Analytical applications and data discovery.
- SSRS
- Paginated, scheduled enterprise reports.
Product names mentioned are trademarks of their respective owners. This page is not a statement of official partnership or certification with those vendors; it shows the technologies we work with and our scope of service on them.
Let's review your infrastructure together.
Schedule a discovery call or a health assessment for your critical database estate.