SQL Web Database

[fisaacs]

I'm a complete beginner here and haven't even touched a SQL database. I'm actually researching the feasibility of doing a web-based SQL database with a FrontPage front end.
My question:
1. How secure would such a database be
2. What kind of development time / skill requirements would be needed
3. How easy/difficult would it be to maintain such a database and make modifications after first production.

 

[tlbroadbent]

Here are some opinions.[ol][li]How secure would such a database be?

SQL Server can be made very secure if you follow guidelines.

[li]What kind of development time / skill requirements would be needed?

Database development is not trivial but SQL Server development is relatively easy. You would certainly want to get some training, read a good book or two and have documentation nearby.

[li]How easy/difficult would it be to maintain such a database and make modifications after first production?

SQL Server databases are fairly easy to maintain. Of course there are myriad factors that impact maintenance - complexity of the databases, complexity of the applications, size of the databases, availability requirement (24x7, only 9-5 on workdays, etc.), experience of the DBA and application developers, etc.

One big problem I see and others have written about is the apparent ease of administration of SQL Server leads some to forego training. Some organizations try to get by with no DBA or a very inexperienced DBA. That may work in a small shop or with non-critical applications. However if performance, availability, security, and data integrity are important, the company should invest in a DBA or train someone.[/ol]As I said these are just my opinions. I'm sure others will have differing points of view. Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost

 

[dbmsguy]

I would tend to agree with Terry above.... SQL is a very easy dbms to implement and manage with only a little knowledge. a little knowledge however can be very dangerous thing sometimes. If it is a small app in a small db you will probably be very happy until the unthinkable happens and you find yourself totally unprepared due to poor planning and an overall lack of knowledge.

Definitely a course or two at least will prepare you so at least the basics of maintanability and recoverability are followed.... Paul

http://www.dbmsguy.com