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?
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 sqlfaq.zip 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
http://www.sql-server.co.uk (Copy of SQL FAQ, Code samples, other stuff)
http://www.mssqlserver.com (Copy of SQL FAQ, reviews, lots of other
http://www.sqlwire.com (SQL News)
http://www.insidesqlserver.com (Updates to Kalen Delaney's Inside SQL Server
7.0 book, Q&A and lots of other info is held here)
http://www.ntfaq.com/sql.htm (Copy of SQL FAQ)
http://www.swynk.com (SQL Server Mailing List and other resources)
http://www.dbmaint.com (Code samples)
http://www.betav.com/ (Bill Vaughn's WebSite)
SQL Server Magazine, (http://www.sqlmag.com)
SQL Server Professional, Pinnacle publications, (http://www.pinpub.com)
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 :
Anything by Ralph Kimball will be good for Data Warehousing.
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
forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (faqrtf.zip - L7
- SQL Public)
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL