Database Consulting

Microsoft SQL Server and Microsoft Access Database Administration

Our database consulting experience varies from small Microsoft Access applications to robust Microsoft SQL client server applications with millions of records, stored procedures, functions, user-defined types, and other complex features.

Many small businesses rely on a ‘home built’ Microsoft Access application that often outgrows the abilities of the original designer, or becomes slow and corrupt. We have experience stepping in to existing projects and getting things back on track, as well as building applications from scratch. Common requests include:

  • Speed issues and slow running forms and reports
  • Adding or editing reports
  • Splitting or upsizing to SQL server
  • New forms, queries, or tables
  • Migrating Excel data to a Microsoft Access format

We are also well experienced in Microsoft SQL server on either client server applications or database driven websites. Typical engagements involve:

  • Configuration changes for speed tuning or stability
  • Maintenance planning to ensure that your data will be there when you need it
  • Performance tuning
  • Views, stored procedures, and triggers

And if you need help with MySQL server we can do that too:

  • Install and configure (on Windows, Ubuntu, Debian...)
  • Optimize for better speed
  • Analyze existing database for issues
  • Migrate data between engines (ex: MyISAM to InnoDB)

Contact us now to set up a database consultation.

MS SQL Server
MS Access
MySQL

See also: