Database Consulting

Microsoft SQL Server and Microsoft Access Database Administration in Chicago

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 outgrow 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, or 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 also are 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 me there when you need it
  • Performance tuning
  • Views, stored procedures, 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)

Don’t hesitate to contact us with your database needs.

MS SQL Server
MS Access