Many businesses and home owners have discovered the benefits of using databases to store information.  Two of the more popular database packages are Microsoft SQL Server and Microsoft Access.  While it is possible to use these tools without a lot of in-depth training, there are times when an expert in database administration needs to be brought in to build databases, solve problems or give advice.  Whether you are building a personal database to hold information about a favorite hobby, or a large company trying to put a backup/recovery plan in place, Innavoy can help.

Databases We Service
We are pleased to offer database consulting/administration services for several database systems including:

• Microsoft SQL Server (version 7.0, 2000, 2005, 2008)
• Microsoft Access (MS Access - all versions)

Consultants
Our lead Database Administrator (DBA) has over 25 years of experience with databases of all shapes and sizes, and is available to travel as needed.  Our services can be used to fill temporary, full-time or part-time positions on either a short-term or long-term basis.

Customers
Our past and present client list features such prominent companies as Dow Chemical, Accenture, Golfnet, & The Net Results Group.

Related Software Areas
Our consultants have experience with many different kinds of database support, reporting & interface software, including:

• SQL Server Analysis Server (SSAS - for Data Warehouse use)
• SQL Server Reporting Services (SSRS)
• SQL Server Reporting Services Report Builder 2.0
• Oracle (interfacing via SQL Servers Linked Server function)
• Embarcadero ER/Studio (database design tool)
• Excel (SQL queries & pivot tables)

What Innavoy Can Do

Performance and Tuning
Whether your problem is with slow queries or bogged down servers, we can help you analyze and fix them.  Dramatic improvements can often be observed in a matter of hours after we get started!

Table Design
We can gather your data requirements, map them into entities, define the relationship between the entities and enforce them with database rules.  Indexes (keys) will be set up based on how you want to access the data.

Security
Together we can determine what your security needs are, create a plan and implement it.

Import/Export of Data
We can help you import or export your data from flat files, spreadsheets, other databases, etc.  We can also convert data values on the fly.  Upsizing databases from Access to SQL Server is our specialty.

Backup/Recovery
The most important job of database administration staff is to protect data and make it available to those who need it.  It's vital that a competent plan for normal onsite recovery be put in place and monitored regularly to ensure data availability.  A disaster recovery plan is also essential, and Innavoy can help you put one in place.

Training
We can provide basic SQL training for programmers and database administration staff using tables and examples from your own company's database to reinforce concepts.  Advanced DBA training is also available and can be customized to meet your needs.
 

Service area - North Carolina and the United States
We are headquartered in Southern Pines, North Carolina (NC), situated in the center of an arc where we can easily travel to most of North Carolina's larger cities for onsite visits, including  Charlotte, Concord, Kannapolis, Salisbury, Winston-Salem, Greensboro, Burlington, Chapel Hill, Durham, Raleigh, Cary, Apex, Asheboro, Sanford & Fayetteville.  Of course we also service our local towns, including Pinehurst, Aberdeen, Whispering Pines, Seven Lakes, Carthage, Vass and the surrounding Moore county area

Innavoy staff is available to travel for short-term and long-term onsite assignments.  We often use the Internet and secure Virtual Private Networks (VPN) to connect to our customers networks so we can work remotely, 24 hours a day.