Microsoft SQL Server - Customer Samples

Winning Solutions, Inc. (WSI) has worked with a number of clients during the past few years to help develop a SQL Server Database, Setup a SQL Server, fine tune a SQL Server and whole wide variety of additional uses.  Below is a  sampling of some of the types of services and databases that we've built for our customers using MS SQL.

At WSI we realize that no two clients are exactly the same and therefore we listen to your needs and wants and deliver to you the solution you desire with the specs you want.

Customer Samples

• Ames Convention & Visitors Bureau - Ames Iowa
  In coordination with the Iowa Games, the ACVB was responsible for lining up volunteers for the Iowa Games. WSI was contacted to create an Access Database that would take the registrations that the volunteers made on the ACVB website and allow ACVB to assign or re-assign volunteers as needed. A complex reporting system was then developed that alerted ACVB to areas where more volunteers were needed and also allowed them to send out letters to the volunteers with instructions on what to do in a very timely and efficient manner that pulled data from the Iowa Games SQL Server Database.
  
  
• Iowa State University Stat Lab - Ames Iowa
  The ISU Stab Lab came to WSI with a need to simplify the tracking of their grants, projects and hours associated with those projects along with the budget for the project. WSI developed an intensive data entry process for keeping track of this information and then developed a very complex reporting system that allowed the user to see where a particular project was sitting at any point in time. As the system was expanded over time, it was ported into a SQL Server Database
  
  
  
• Marion County Title Services - Knoxville Iowa
  Marion County Abstract contacted WSI to convert a DOS based system into an Access/Visual Basic/SQL Server application. They needed a system that would allow them to quickly and efficiently work with Title Information and a Custom Access Database was developed that pulls data from a SQL Server Database to help deliver on this need.
  
  
• First National Bank - Ames Iowa
  First National Bank contacted WSI to help them create run-time versions of a number of databases that they had created internally. WSI worked with the developers at First National Bank to help teach the creation process as well as installation. In addition, WSI enhanced an Officer Call, Trust Officer Call and Stock Tracking databases to allow them to be more user-friendly and robust by creating standardized forms, reports, tables and queries. In addition, each branch of the bank was setup with it's own SQL Server Database for storing this data.
  
  
• Iowa Games - Ames Iowa
  As the technology provider for the Iowa Games, WSI created an application to keep track of all athlete and event registrations. The entire system was built using a MS SQL Server database. The database contains a number of years of history which allows the Iowa Games staff to go in and query the database for various types of results. This power at their fingertips has allowed the Iowa Games to be more effecient and effective as they put on sporting events throughout the state of Iowa.
  
  
• Bilbrey Insurance Services - Johnston Iowa
  Bilbrey Insurance and WSI have had a very beneficial 10 year relationship. Bilbrey initially came to WSI with the desire to get their member information into an Access Database. After that initial setup and customization, Bilbrey has continually pushed the envelope forward and over time has developed a complete custom Insurance Underwriting System for the Iowa Communities Assurance Pool. This required that the database be converted from Access to SQL Server and this conversion/upsizing of data was completed in a timely and effecient manner for Bilbrey. This system has allowed Bilbrey to expand many times over while keeping costs and employees stable. For a more detailed look at our history with Bilbrey, be sure and view the case study located here.
  
  
• FitSense Technologies - Boston Massachusetts
  FitSense and WSI have had a long and valuable relationship and during that relationship, WSI has developed a number of MS SQL databases for Fitsense. One of the largest SQL databases that WSI has worked with is one that was developed for Fitsense to keep track of all runs/walks that users at the Fitsense website log using the device that Fitsense sells. The volume of data logged on just a single entry from the device is quite vast and SQL Server has proven to be more than up to the challenge for this large amount of data. This has allowed the users of the Fitsense device to have a complete history of all their logged entries without any archival process. For a more detailed look at our history with Fitsense, be sure and view the case study located here.