March 27, 2008 at 11:09 am
Hi all,
I am a web developer with ~6 years experience building data driven sites in mysql and MSSQL (only 2yrs experience) and I'm starting to see a hole in my (and my collegues) knowlage.
Now, I'm looking for a couple of book recomendations to help me (us) do things better.
Ideally I would like 2 recomendations, one book that teaches good Database design theory (which could be applied to any RDBMS) and another one that is focused on MSSQL and it's features.
I'm going to explain how we do things at pressent and I'm sure that some of you will cringe at the amature nature of the work but it's got us by for years without many problems so please don't flame me of my lack of databaseness, I'm a web developer not a DBA. That said, your words of wisdom are recieved most gratefully!
The way I build databases is to so that there is as little as possible redundancy accross tables. I use Stored prodedures some times (when time permits ).
I have never used a trigger.
I have used some SQL Server Agent jobs to do basic data proccessing.
Now, most of our stuff is for website CMS's & eCommerce order taking/tracking/product catalogues but we also do some data collection for a large client which takes ~5million registrations per year.
This is where the trouble arises, when the database gets near 3mill rows it starts to chugg. The box it runs on is a quad xeon 3ghz with 4GB ram and SCUSI RAID array of disks so I doubt it's down to hardware, I'm almost certain the problems with it lie with us and our design of the database and quieries.
So folks, your recomendations for a DataBase Amature
Thanks
March 27, 2008 at 11:40 am
Database design theory, I'll leave to someone else. I'm using an ancient text called "Handbook of Relational Database Design" by Fleming & von Halle. It's too basic for most of today's issues.
As to MSSQL, not one book, but four, the "Inside SQL Server 2005" series, edited by Kalen Delaney (and partly written by her as well). Fantastic set of books.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 27, 2008 at 12:27 pm
Recommend this as a necessity:
The Data Modeling Handbook : A Best-Practice Approach to Building Quality Data Models by Michael Reingruber, William W. Gregory (Contributor)
Publisher: John Wiley & Sons; ISBN: 0471052906; (December 1994)
For theory, either of these books
HANDBOOK OF RELATIONAL DATABASE DESIGN
by C. C. Fleming and Barbara von Halle
Addison-Wesley; ISBN 0-201-11434-8.
http://www.amazon.com/exec/obidos/search-handle-form/104-9318903-3039129
CONCEPTUAL SCHEMA AND RELATIONAL DATABASE DESIGN
by T. A. Halpin;
Morgan-Kaufmann. ISBN 0-133-55702-2
SQL = Scarcely Qualifies as a Language
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply