Over the years, SQL Server Expert Help, LLC. has provided its services to many companies, small and large. We offer cost-effective solutions to almost any size of enterprise. Here are some examples of the companies we serve.

Hilton Grand Vacations, Orlando, FL
Hilton Grand Vacations is the vacation time-share division of Hilton Hotels Corporation. Their development team did such an outstanding job developing the SQL Server application used to run the time-share business that the hospitality industry giant decided to expand the application's use to other divisions and to many, many more users.

Wisely, Hilton management decided to seek the advice of SQL Server performance experts regarding the scalability issues they might encounter and to optimize application performance before opening up access to many more users than the application was originally designed to support. SQL Server Expert Help, LLC. was called in and identified many potential problems in hardware, application code, indexing and server configuration. We resolved many of the issues and provided assistance to Hilton's development team in resolving others.

This pro-active and collaborative approach made for a much smoother transition than otherwise might have occurred.

U.S. Auto Parts, Los Angeles, CA
U.S. Auto Parts Network, Inc. is the nation’s leading Internet direct marketer of automotive aftermarket collision replacement parts and accessories. Receiving more than twelve million Web site visitors annually, U.S. Auto Parts carries over 26,000 part numbers, representing over 75,000 unique products in their inventory.

SQL Server Expert Help, LLC. was originally called in to solve performance problems in their ecommerce and warehouse management systems caused by their rapid increase in business volume. In a short time, we had the database systems performing well again. The management team then asked us to help them address longer term issues. These included data security, future scalability and high availability.

We are currently engaged in a collaborative effort with US Auto Parts to insure ongoing performance and stability in their database environment.

USDA, Agricultural Research Services
For years, the US Department of Agriculture used a SQL Server based application to handle contract management for their Agricultural Research Service. Recently they expanded its use to many other offices. When the number of users jumped from a few dozen to several hundred, performance quickly deteriorated. Realizing that the issues were more complex than could be addressed by standard database tuning techniques, agency IT management decided that they needed outside expertise.

The budget for the project was small. Our first task was to identify specific optimizations that would result in the greatest performance benefits at the least cost. Our second was to leverage the expertise in their own IT group to aid in the project.

The results pleased everyone. Users were pleased because, in some critical areas, we were able to reduce application response times from minutes to seconds. In general, application performance was improved dramatically across the board. Managers were pleased because user productivity was improved to a corresponding degree and because all of this was accomplished within tight budget constraints.

In the real world, there is always a budget constraint. Solving a performance problem within the budget requires careful analysis to determine where efforts can be applied in the most cost-effective manner. That, in turn, requires the kind of experience and knowledge we acquired by years of specialization.

Nautilus Group, Vancouver WA
With such labels as Bowflex, Nautilus, Stairmaster, Schwinn Exercise Systems, The Nautilus Group is number one in the manufacture and sale of home exercise equipment. Their business runs on SQL Server. We assisted them with the transition from their legacy database systems on older versions of SQL Server to an entirely new system built on SQL Server 2000.

State of Oregon, Public Employee Retirement System
PERS manages over $41 billion dollars in assets. Faced with a complete reorganization of the retirement system by the state legislature, the agency had to accomplish a wholesale modification of their database infrastructure in a short amount of time. They looked to SQL Server Expert Help for the Microsoft SQL Server expertise they needed to meet the deadlines set for them by the new legislation. Although their database systems are extremely complex, the deadlines were met and, although state legislatures are notoriously difficult to please, they were satisfied with it. SQL Server Expert Help, LLC. was proud to play a small role in a very large and challenging project.

Pearson NCS, Minneapolis, MN
With over 50,000 customers, NCS Pearson is the industry leader in data collection. Leveraging their core expertise in data collection within the areas of testing and survey, they provide assessment software for classroom and formative testing, also survey solutions for patient and customer satisfaction, faculty evaluations, and school climate surveys.

With offices around the world accessing the corporate SQL Server database, they have a large transaction volume around the clock. SQL Server Expert Help, LLC. worked alongside NCS Pearson's own IT staff to tune the data systems to operate at optimum levels.

Aplia.com, San Carlos, CA
Aplia.com provides software and teaching materials that give university professors easy management of online course materials. Aplia's interactive assignments and experiments enhance classrooms and improve student learning.

Under the demands of thousands of students completing on-line assignments and professors analyzing student performance, the SQL Server database supporting Aplia's website is often under heavy load. SQL Server Expert Help works with Aplia's own development team to insure that the database performs at peak efficiency around the clock and that it will scale to meet growing demand.

McKissock LP, Warren PA
McKissock LP is the premier appraisal and real estate continuing education provider in the US. Every year they hold approximately 1,200 classes for tens of thousands of real estate professionals in various locations across North America.

By early 2004, the demands of their rapidly growing business had exceeded the capacity of their legacy data system. The system that had worked well for a small company was simply too slow and unstable for the company they had become. They called on SQL Server Expert Help, LLC. to help them make a rapid transition to a faster and more robust database environment built on SQL Server.

The entire process was completed quickly and the benefits were immediate. Speed and stability were impoved dramatically. No user re-training was necessary because their existing database applications were re-used with very little modification.

XPrime Inc., Poway, CA
Xprime manufactures the highly-acclaimed XDA Database Accelerator. The XDA is a high performance hardware platform with purpose built, in-memory database software to enable SQL Server-based applications to run orders of magnitude faster. SQL Server Expert Help assisted their engineering team in analyzing highly complex queries to fine-tune the performance of the XDA against the most extreme examples of convoluted SQL Code.

LaCie, Ltd, Paris FR
Headquartered in Paris with manufacturing and sales offices around the globe, LaCie is known worldwide for quality and innovation in the field of computer storage devices. In their highly-distributed computing environment we remotely monitor and administer their mission-critical servers and databases. This has allowed them to limit their IT staff to a few key people who concentrate on line of business issues rather than systems and database administration. All systems run smoothly and LaCie's IT costs are lower.

Columbia Ultimate Software, Vancouver WA

eHRMS Consulting, Scottsdale, AZ
eHRMS Consulting provides nationwide support to a number of Fortune 500 companies for ADP's HRizon®/Enterprise product. SQL Server Expert Help, LLC. provides eHRMS with the additional SQL Server expertise needed for their clients who use the SQL Server versions of ADP's high-end payroll and human resources software.

return to top

---

home about us services and support client list contact us email

Copyright © 2005, 2006 SQL Server Expert Help All rights reserved