Case Studies
SQL Server Upgrade: Three Risks Resolved in a Regulated Environment
SQL Server 2016 at end of support in a regulated SA financial services environment
• Business impact: audit exposure, absent security patches, 1.5TB storage accumulation
→ Upgraded to current SQL version; performance validated; downstream compatibility resolved in 15 minutes; automated weekly storage cleanup established
When the Network Breaks and Nothing Makes Sense: Systematic Troubleshooting
Intermittent network failures during active construction created diagnostic complexity.
• Business impact: extended connectivity outages, manual data processing, operational efficiency loss
→ Systematic hypothesis elimination identified forgotten VoIP phone as broadcast storm source, restoring network stability within ten hours.
International Network Investigation: Resolving Salesforce Authentication Failures
Sporadic Salesforce authentication failures
• Business impact: API timeouts, user lockouts, executive confidence loss
→ 48-hour resolution through international network investigation with carrier-level evidence
Enterprise Security Deployment: Navigating Multi-Vendor Environments
600 endpoints requiring VPN compliance verification across CrowdStrike, Cisco ISE and Fortinet security fabric • Business impact: circular dependencies risked stranding distributed workforce → Architectural analysis resolved integration, 455 endpoints secured with compliance-controlled access
Systematic Client Migration Without Business Disruption
Network provider performance issues affecting 100+ client connections require urgent action
• Business impact: months of field deployments, hardware shipping logistics, coordinated downtime windows, operational disruption
→ Systematic migration using existing routers with remote configuration eliminates hardware costs and field team deployments, achieves 2-5 minute cutover times with zero user complaints
The Desktop Masquerading as a Server That Could Have Derailed an Acquisition
Critical server running on desktop hardware threatens acquisition viability – comprehensive IT infrastructure assessment needed
• Business impact: hidden acquisition costs, security vulnerabilities, operational risks, integration delays
→ Systematic assessment reveals £XXk infrastructure investment requirements, enabling informed acquisition decision-making