AWPL Rings Up Revenue and Future Proofs Systems with WARDY IT Solutions’ Help

AWPL and WARDY IT Solutions SQL Server Case Study

Retailer AWPL rings up revenue and future proofs systems with SQL Server partner WARDY IT Solutions

Executive Summary

It’s likely that frequent air travellers have patronised one of AWPL’s shops located at airports across Australia and New Zealand. Because the business operates across time-zones and around-the-clock, the retailer’s infrastructure comes with an always-on service requirement. As the workloads caused by rapid business expansion increased, greater demands were placed on the finite resources of the technology support team.

WARDY IT Solutions were recommended by AWPL’s hosting company as the right fit to help AWPL realise increased value from their SQL Server database investment. The two organisations collaborated on translating business and engineering goals into successful, completed projects. WARDY IT Solutions provided ad-hoc consultation and engineering expertise and delivered employee training that enabled team managers to capture data and reveal how their retail supply chain could be optimised.

How WARDY IT Solutions Helped:

  • We provided a resilient SQL Server database framework
  • Future proofing AWPL’s SQL Server database investment has delivered an adaptable platform that integrates easily with new processes and technology
  • WARDY IT’s around-the-clock Virtual DBA service instantly alerts AWPL administrators if systems are not operating at peak performance
  • Executive training workshops have enabled one third of AWPL’s savvy management team to model, analyse and deduce solutions to improve underperforming assets and resources
  • The coaching and mentoring provided by WARDY IT Solutions is highly valued by AWPL staff and enables them to manage their digital assets and IP with greater efficacy.

One third of AWPL management are now conversant in using “database queries” and business intelligence tools to analyse structured data and apply this knowledge to improve business productivity and reduce operating costs. This end-to-end re-engineering has delivered operating cost reductions conservatively estimated at 20% and contributed to increasing AWPL’s return on costly airport retail rentals.

Download the full case study here.

Case Study: WARDY IT Solutions’ SQL Server Collaboration with Hema Maps

Hema Maps Collaborates with WARDY IT Solutions

WARDY IT Solutions’ SQL Server Collaboration is a “Perfect Fit” for Publisher Hema Maps

Executive Summary

Hema Maps’ three decades of accumulated knowledge represents the organisation’s valuation of its market value and commercial worth. Protecting this business intellectual property (IP) was of concern to Hema’s executive team and the means to improve how this valuable repository was protected were sought. Technology partner WARDY IT Solutions were asked to help design a new backup and archive structure and to define a security model to oversee which personnel could access, modify, delete or remove data. WARDY IT Solutions key deliverable was to design procedures that adhered with industry-based best practices and to simplify how Hema protected its digital assets. By taking this approach, Hema’s technology and business goals would align more closely and a future-ready framework would be created that could easily integrate with technology upgrades. Hema’s leadership team were concerned about information security, and by clearly defining who could read, modify or remove data, company policies could be rigidly enforced based on the employees’ roles and responsibilities. This would ensure that digital assets could be safeguarded more effectively.

The backup and archive solution deployed by Hema more effectively protected company information from data loss and the security model requires no intervention to protect the integrity of Hema’s intellectual property.

At a glance, the solution delivered:

  • Updated systems protect and secure more than 30 years of Hema’s accrued Intellectual Property
  • Hema’s SQL Server environment is stable, reliable and ready to meet new business demands
  • SQL Server systems and processes are all built using industry best practice guidelines with an eye to future development
  • Resilient backup and archiving guarantees no more than 15 minutes of data loss in the event of an unplanned outage
  • WARDY IT provides mentoring and third-level support to ensure Hema realises the best return from their Microsoft SQL Server investment

The solution helped Hema’s SQL Server production database environment to be stable, resilient and serves as the “Single Point of Truth” – a validated knowledge repository that consolidates all of the organisation’s data into a single location. This agglomeration of knowledge eases the burden of management improving productivity, minimises the risk of data duplication and simplifies lifecycle management of the dynamic data that forms the core of Hema’s IP.

Download the full case study here.