Case Studies

Expertise Derived From Experience

AER: Migrating Legacy Hardware & Software to Azure

Computer in Trash CanThe Challenge:

In late 2016, Ken Hopkins, COO of AER Technologies, the largest automotive electronics warranty service center and distributor on the West Coast had a major problem. The company’s entire IT environment was failing, due to:

  • Aging hardware (circa 2004)
  • Out of support hardware
  • Out of support software including SQL 2005
  • Security issues

Ken explains, “If you go back to when the economy collapsed and 2 of the 3 largest automotive manufactures went bankrupt, we had minimal IT budgets available for hardware and software upgrades. Over the last couple of years, we started having critical failures in our server room that led to outages lasting from a few hours to more than two days. Without a high-availability solution in place, coupled with antiquated hardware and software, it put AER’s entire business in jeopardy.”
Read Now >

Rise Services: Time Slice DBA and Disaster Recovery

With headquarters in Arizona, Rise is a nonprofit organization that specializes in home and community-based support services for children and adults with developmental and other disabilities, children with mental health challenges, aging adults and children and families with foster care and adoption needs. For 25 years their purpose has remained constant. They create opportunities for and with the people they serve, their families and for the men and women providing supports to their clientele.

Time Slice DBA

  • Payroll used to take 4 people a week to process. Now done by one person in 2 hours.
  • Billing has gone from 9 people working about 2 ½ weeks to 7 people compiling it in less than a week.
  • Audits used to take 5 FT employees a week. Now gives the auditor read-only access to the resources they require.

Disaster Recovery

  • Previous DR was onsite, local backups & tape backups.
  • DR now includes real-time replicating between two primary offices.
  • Can meet zero losses on databases and 24 hour recovery on all file servers.

Read Now >

Fast Track: RealtyTrac’s High Availability Solution

RealtyTrac® is the leading provider of comprehensive housing data and analytics for the real estate and financial services industries, Federal, state and local governments, academic institutions, and the media. Their data is aggregated from parcel-level records of more than 130 million U.S. residential and commercial properties and delivered through customizable products including bulk file licensing, APIs and custom reports.

Higlights

  • Migrated to SQL Server 2016 while still in beta
  • Reduced Data Warehouse Load Times by 5x
  • Reduced Data Extract to customers run times by 10.4x
  • AlwaysOn AG allows DR function and offloading read workload
  • Data Warehouse 12.5 TB reduced to 4.5 TB (3X) using CCI

Read Now >

Video

Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.