..........The Hightower Group

...is comprised of a team of seasoned professional consultants that not only know how to create software, we also know how business works.

We are experts in knowing how to apply modern software technology to move your business to the next level.

You will find when you talk to us that we will be able to understand your business in a matter of minutes not days or weeks.

This is because we have been developing easy to use software for so long and with so many different industries we are able to quickly understand and apply our past experience to your unique business as well. ....

Call us to today for a fun, friendly experience as we help you make more money in your business...
 

717-560-4002

 
415 Larkspur Loop
Lancaster, PA 17602
717-560-4002

SQL Databases

A SQL Databases is the place that one or more programs holds your data. That is all. It is were you save it and it is where your reports or other process get the data. Almost every programming language available today can use a SQL database. This include both Web based on Windows based systems.

For the most part only the programmer needs to know about the SQL database. There are many ways to look at databases, but the most important thing to ask, what you are using it for?

If it is stand alone or being used by one or two people and the amount of data is not large, then MS Access has a nice SQL database what will work fine.

But if you plan to grow or you have lots of data or you want to have reliable and fast remote access to your data, then you want to use one of the many client server SQL database.

Once you cross into the Client Server database world there are many many choices. Some very costly, some free. (One thing to remember is that a free database is not completely free, you still need to pay for the time to set it up and program it.) You want to constantly ask, what do I need this for? The purpose of the database is ultimately to help provide a safe, reliable place to store your data. It is suppose to save you time and money.

Will there be millions or rows of data? Or just a few thousand?

How many users will there be? Hundreds of thousands, or just a dozen or two? How critical is the data? Can you afford to lose a days worth? An hours worth or none?

The more you want the more it will cost. It is that simple.

So what does The Hightower Group do with SQL databases?

  •  We work with you to determine the correct database for you
  •  We install the database and set it up
  •  We design the data model that will live in the database
  •  We program the stored procedures and triggers that are needed to provide reliable results
  •  We tune the database
  •  We write the SQL code to interact with our programs that we write
  •  We setup security

We can do all or some of these things for you.

The databases that we are most familiar with, although we can work with other are:

  •  Microsoft SQL Server
  •  MySQL
  •  PostreSQL
  •  Firebird
  •  Oracle

see more...