Transforming an outdated database landscape into a scalable, high-performance platform for business growth

UK Housing Association accelerates data processing

Read how a UK Housing Association works with Northdoor to transform its SQL Server landscape, enhancing performance and boosting availability.

“Like every other organisation, we face increasingly challenging timelines and budgets, and external skills of course come at a premium. But with Northdoor we feel that it has definitely paid to get the experts in.”

Spokesperson for a large UK housing association

What Northdoor did to help modernise the Housing Association 

1. Database Modernisation:
   • Migrated outdated SQL Server instances to a unified, updated platform on new hardware.
   • Modernised legacy DTS packages to advanced ETL processes.
   • Optimised stored procedures and SQL agent jobs for better performance.
   • Consolidated databases onto VMware virtual machines to balance workloads and reduce bottlenecks.
2. Agile Development Support:
   • Introduced Azure DevOps and formalised source control to modernise development processes.
   • Provided training for staff and built CI/CD pipelines to accelerate functionality delivery.
3. Managed Support:
   • Delivered ongoing database maintenance, monitoring, and issue resolution.
   • Provided strategic consultancy for continuous improvement.
4. Project Execution:
   • Conducted rehearsals to ensure a smooth go-live, achieving immediate improvements without disruption.

Outcome and Results

• Performance Gains:
  • CRM updates accelerated by 10x.
  • Processing times reduced from 2.5 hours to 40 minutes.
• Operational Benefits:
  • Eliminated time-outs and reduced technical team stress.
  • Boosted application reliability and speed for employees and residents.
• Scalability and Confidence:
  • Created a high-performance platform that supports business growth.
  • Enabled the internal team to focus on innovation rather than problem-solving.

The housing association praised Northdoor’s professionalism, technical expertise, and ability to deliver impactful results efficiently, noting immediate performance improvements and a collaborative working relationship. They highlighted that investing in Northdoor’s expertise was invaluable for achieving business goal.