DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: SQL server administrative knowledge

  1. #1
    Becky Guest

    SQL server administrative knowledge

    Hi, I'm a beginner of dealing with SQL server 7. I'm looking for ways to catch
    up with the skill and knowledge efficiently. What do you think is the most
    efficient way to learn up SQL server 7 and to be a good SQL server 7 administrator?
    I have the will and the goal but I dun know the best way to reach the goal.
    can anybody help?
    thank you.


  2. #2
    Neil Pike Guest

    Re: SQL server administrative knowledge

    Becky - experience and reading!

    Q. What are good SQL Server books and other sources of reference.

    A. SQL Books Online is a good source, as is Technet with 100's of techie
    articles/whitepapers on SQL as well as the Knowledgebase. The SQL 7.0
    books-online can be downloaded at

    An un-official "FAQ" is held at :-
    (download from library 7 (SQL Public))

    The most up to date copy (apart from the one on my hard-drive) is the one in
    the Compuserve library - you don't need to be a Compuserve member to download
    it. The other sites all take the info and put it into their own format.

    On-line resources (Microsoft):-

    On-line resources :-

    SQL Server newsgroups : microsoft.public.sqlserver.* and
    GO MSDEVAPP on Compuserve for SQL forums (Copy of SQL FAQ, Code samples, other stuff) (Copy of SQL FAQ, reviews, lots of other
    resources) (SQL News) (Updates to Kalen Delaney's Inside SQL Server
    7.0 book, Q&A and lots of other info is held here) (Copy of SQL FAQ) (SQL Server Mailing List and other resources) (Code samples) (Bill Vaughn's WebSite)

    Magazines :-

    SQL Server Magazine, (
    SQL Server Professional, Pinnacle publications, (
    NT Magazine has monthly articles on SQL plus the odd one-off article

    Books (a few good ones, but this doesn't mean anything not listed isn't good!
    Many of these go through various revisions, so check you're getting the latest
    and greatest version) :-

    Microsoft SQL Server 6.5/7.0 Programming Unleashed : Sams/various : Good for

    Microsoft SQL Server 6.5/7.0 Unleashed : Sams/various : Good for DBA's, admin,
    performance, general stuff.

    SQL for Smarties : Morgan-K/Joe Celko : Advanced SQL programming techniques,
    tricks and tips. Not SQL Server specific but highly recommended.

    Hitchhikers Guide to VB and SQL Server : MSPress/Bill Vaughn : ISBN: 1572318481
    : If you're coding VB to access SQL and you're not sure whether (or how) to use
    DB-Library, ODBC, ADO, RDO, OLE-DB, RDS, RDO, DMO (I think that's all of them)
    then this is the bible.

    BackOffice Resource Kit Part II : MSPress : Good stuff on SQL 6.5 connectivity
    and some internals, plus some nice utilities and whitepapers.

    BackOffice 4.5 Resource Kit : MSPress : As above but for SQL 7.

    Teach yourself Microsoft SQL Server 7.0 in 21 days : Sams/Richard Waymire :
    ISBN 0-672-31290-5 : A good overall guide to SQL Server 7.0.

    Inside Microsoft SQL Server 6.5 : MSPress/Ron Soukup : SQL Server Internals,
    how it works, why the history. Plenty of good undocumented stuff.

    Inside Microsoft SQL Server 7.0 : MSPress/Kalen Delaney : ISBN: 0735605173 :
    The bible for SQL 7 internals.

    SQL Server 7 Database Administration. Prima Press/Ron Talmage : Probably the
    best SQL 7 administrator/dba book.

    The Guru's Guide to Transact-SQL : Ken Henderson : ISBN: 0-201-61576-2 : Great
    SQL 7.0 Transact SQL book

    Microsoft OLAP Solutions. Microsoft Press/George Spofford and Erik Thomsen.
    ISBN: 0471332585. The definitive Microsoft Olap book.

    Database Modelling and Design. Morgan Kaufmann/Toby Teory.

    Transact-SQL Programming. O'Reilly/Kline, Gould and Zanevsky. What the title
    says - specific to SQL Server 6.5/Sybase 4.x. Nothing on later Sybase/SQL
    Server additions/changes to syntax.

    Unlocking OLAP with SQL Server 7 and Excel 2000 : Wayne Freeze : ISBN

    Microsoft SQL Server 7 OLAP Developer's Guide : Bill Amo : ISBN 0764546430

    OLAP Solutions, Building Multidimensional INformation systems with CDROM : Erik
    Thomsen : ISBN 0471149314

    OLAP Services Fundamentals, Online Analytical Processing Technology for
    Microsoft SQL Server with CDROM : OLAP Train : ISBN 0735609047

    Microsoft OLAP Unleashed with CDROM : Tim Peterson, Bob Pfeiff, Jim Pinkelman :
    ISBN 07672316714

    Anything by Ralph Kimball will be good for Data Warehousing.


    v1.25 2000.07.11
    Applies to SQL Server versions : All
    FAQ Categories : Miscellaneous
    Related FAQ articles : n/a
    Related Microsoft Kb articles : n/a
    Other related information : n/a
    Authors : Neil Pike

    Neil Pike MVP/MCSE. Protech Computing Ltd
    Reply here - no email
    SQL FAQ (484 entries) see ( - L7
    - SQL Public)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center