Table Of ContentWe would like to acknowledge the following people for their kindness and support
in making this book possible.
Richard Kristof, Duncan Anderson, Jennifer Gould, Robert Woodruff, Kevin
Murray, Dale Leatherwood, Rhonda Harmon, and Robert Sanregret of Global
Knowledge, for their generous access to the IT industry's best courses, instructors
and training facilities.
Ralph Troupe, Rhonda St. John, and the team at Callisma for their invaluable
insight into the challenges of designing, deploying and supporting world-class
enterprise networks.
Karen Cross, Lance Tilford, Meaghan Cunningham, Kim Wylie, Harry Kirchner,
Bill Richter, Kevin Votel, Brittin Clark, and Sarah MacLachlan of Publishers Group
West for sharing their incredible marketing experience and expertise.
Mary Ging, Caroline Hird, Simon Beale, Caroline Wheeler, Victoria Fuller,
Jona than Bunkell, and Klaus Beran of Harcourt International for making certain
that our vision remains worldwide in scope.
Anneke Baeten, Annabel Dent, and Laurie Giles of Harcourt Australia for all their
help.
David Buckland, Wendi Wong, Daniel Loh, Marie Chieng, Lucy Chong, Leslie Lim,
Audrey Gan, and Joseph Chan of Transquest Publishers for the enthusiasm with
which they receive our books.
Kwon Sung June at Acorn Publishing for his support.
Ethan Atkin at Cranbury International for his help in expanding the Syngress
program.
Joe Pisco, Helen Moyer, and the great folks at InterCity Press for all their help.
From Global Knowledge
At Global Knowledge we strive to suppor t the multiplicity of learning styles
required by our s tuden t s to achieve success as technical professionals. As
the world's largest IT training company, Global Knowledge is uniquely
positioned to offer these books. The expertise gained each year from pro-
viding inst ructor- led training to h u n d r e d s of t h ousan d s of s tuden t s world-
wide has been captured in book form to enhance your learning experience.
We hope tha t the quality of these books demons t ra tes our commi tment to
your lifelong learning success. Whether you choose to learn th rough the
writ ten word, computer based training, Web delivery, or ins t ructor- led
training, Global Knowledge is committed to providing you with the very
best in each of these categories. For those of you who know Global
Knowledge, or those of you who have jus t found us for the first time, our
goal is to be your lifelong competency partner.
T han k your for the opportuni ty to serve you. We look forward to serving
your needs again in the future.
Warmes t regards,
D u n c a n Anderson
President and Chief Executive Officer, Global Knowledge
vi
Robert A. Pat ton (MCDBA, MCSD, MCSE+I, MCP+I) is a Software
Engineer specializing in Microsoft Windows DNA applications using
Interdev and Visual Basic with Windows 2000 and SQL Server. He is cur-
rently a Senior Applications Developer at PurchasingFirs t .com in Dublin,
OH and, in his position there, has done work for First Union National
Bank, Corporate Strategic Services, the Midland Life Insurance Company,
and Sykes Enterprises. Robert a t tended the University of Chicago, where
he studied Public Policy. He earned his Bachelor of Science degree in
Software Engineering from The Ohio State University. He lives in Dublin,
OH with his wife J e n n y and their sons Michael and Alex.
Jenni fer Ogle (MCSE, MCP+I, MCNE, Oracle DBA) is Owner and President
of Radioactive Frog Web Designs, Inc. (www.radfrog.com), which specializes
in contract Web site design and development and da tabase administrat ion.
Jennifer has over 20 years of experience in the IT industry, specializing in
government, scientific, and manufac tu r ing applications. Her recent assign-
ments include SQL and Oracle development for Hoover Materials Handling
Group and Lockheed Martin. In addition to her extensive software and
hardware experience, she has programmed with Java, Visual Basic, and
Visual InterDev, among many others. Jennifer lives with her h u s b a n d Kent
in Knoxville, TN.
Sean Campbell (MCSE, MCDBA, MCSD, MCT) is an Owner of 3 Leaf
Solutions, LLC. He has worked in the educat ion field for 7 years, with 5
years focused on IT training and consulting. Sean has worked with SQL
Server since version 6. He has developed cus tom training and delivered
MOC training for a n u m b e r of years on SQL Server and other development
technologies and has au thored n u m e r o u s Microsoft TechNet sessions on
topics such as support ing SQL and upgrading to SQL Server 2000.
Sean 's consult ing experiences have run the gamut from da tabase
adminis t ra t ion and application upgrades to .NET development. Sean has
been working on projects with Microsoft since early Beta releases of SQL
Server 2000 and has focused on SQL Server 2000's adminis t ra t ion and
implementat ion enhancements .
vii
Mark Horninger (A+, MCSE+I, MCSD, MCDBA) is President and Founder
of Haverford Consul tants , Inc. {www.haverford-consultants.com}, located in
the subu rbs of Philadelphia, PA. He develops cus tom applications and
sys tem engineering solutions, specializing primarily in Microsoft operat ing
sys tems and Microsoft BackOffice solutions. Mark has over 12 years of
computer consul t ing experience and has passed 26 Microsoft certified
exams. During his career, Mark has worked on many extensive projects
including da tabase development using SQL 6.5, SQL 7, and SQL 2000;
application development; training; embedded sys tems development; and
Windows NT and 2000 project rollout planning and implementat ions . Mark
lives with his wife Debbie and two children in Havertown, PA.
Steve Maier (MCSD) is a Senior Software Engineer for Heidelberg Digital
L.L.C. {www.us.heidelberg.com}, located in Rochester, NY. He develops
cus tom PostScript drivers for Microsoft operating systems. Steve has 10
years of compute r programming experience in DOS, Windows, and UNIX.
During his career, Steve has done da tabase development, manufac tu r ing
application development, driver development, and game development. He
has also worked on FDA-approved medical software and has t augh t a
variety of college classes including programming, sys tem analysis, and PC
repair. Steve lives with his wife Lisa and two children in Rochester, NY.
Henk-Evert Sonder (CCNA) has over 15 years of experience as an Infor-
mat ion and Communica t ion Technologies (ICT} professional, building and
main ta in ing ICT infras t ructures . In recent years, he has specialized in inte-
grat ing ICT inf ras t ruc tures with bus iness applications and the security
tha t comes with it. Currently, Henk works as a Senior Consul tan t for a
large Dutch ICT solutions provider. His company, IT Selective, helps
retailers get e-connected. Henk has also contr ibuted to other Syngress
books, including the E-mail Virus Protection H a n d b o o k {ISBN: 1-928994-
23-7}.
Scot t Delaney (MCSD, MCDBA, MCSE) is a Senior Consul tan t with
TurnAround Solutions {www.turnaroundsolutions.com}, a leading e-com-
merce consul t ing and product development firm based in Australia.
TurnAround has a core client list including blue chips and mul t ina t ionals
and is known for its well-trained staff, processes, and quality development.
In addit ion to his da tabase work with SQL Server and Oracle, Scott also
develops cus tom C++ and Java solutions. His cur ren t pet project is the
viii
development of SayIT, a full-featured speech synthes is package for use by
people who have lost the ability to speak due to il lnesses such as ALS or
stroke. Scott lives in Tasmania , Austral ia with his wife Paula.
J o h n I w a s z (MCSD) has over 5 years consult ing experience developing
cus tom applications. He specializes in n-tier and Web development using
Microsoft technologies. J o h n recently wrote an article on the IIS Metabase
for ASP Today. During his career, J o h n has worked on enterprise-wide pro-
jects as well as commercial development. His has designed and developed
Web site front ends, middle tier components , and determined da tabase
archi tecture. J o h n lives in Philadelphia, PA.
M e l i s s a Craft (CCNA, MCSE, Network+, MCNE, Citrix CCA) is Director of
e-Business Offering Development for MicroAge Technology Services.
MicroAge is a global sys tems integrator headquar te red in Tempe, AZ.
MicroAge provides IT design, project management , and suppor t for dis-
t r ibuted comput ing systems. Melissa is a key contr ibutor to the bus iness
development and implementa t ion of e -bus iness services. As such, she
develops enterprise-wide technology solutions and methodologies focused
on client organizations. These technology solutions touch every par t of a
system's lifecycle--from network design, testing, and implementa t ion to
operational m a n a g e m e n t and strategic planning.
Melissa holds a bachelor 's degree from the University of Michigan and
is a member of the IEEE, the Society of Women Engineers, and American
MENSA, Ltd. Melissa current ly resides in Glendale, AZ with her family,
Dan, Jus t ine , and Taylor. Melissa is the au thor of Syngress Publishing's
best-sell ing Managing Active Directory for Windows 2000 Server (ISBN:
1-928994-07-5).
C a m e r o n W a k e f i e l d (MCSD, MCP) is a Senior Software Engineer at
Computer Science Innovations, Inc. (www.csihq.com) in Melbourne, FL,
where he develops cus tom software solutions ranging from satellite com-
munica t ions to da ta-mining applications. His development work spans a
broad spec t rum including Visual C++, Visual Basic, COM, ADO, ASP,
Delphi, CORBA, and UNIX. Cameron also develops software for a Brazilian
hematology company as well as bus iness - to -bus iness Web applications. He
also teaches Microsoft certification courses for Herzing College (AATP). He
has passed 10 Microsoft certification exams. Cameron 's formal educat ion
was in compute r science with a minor in m a t h at Rollins College. He lives
in Rockledge, FL with his wife Lorraine and daughte r Rachel.
ix
Bret S t a t e h a m (CNE, MCSE, MCSD, MCDBA, MCT) is the Owner of Net
Connex Technology Training and Consulting, L.L.C. (www.netconnex.com)
in San Diego, CA. Bret 's background includes extensive networking, devel-
opment , and training experience. His most recent projects have involved
cus tom training, da tabase development and administrat ion, XML schema
development and standardizat ion, cus tom application development, and
count less hours developing Active Server Pages-based Web solutions. Bret
and his wife Lori live in San Diego, CA.
Technical Editor and Contributor
Travis Laird (MCSE, MCDBA, A+, Network+, i-Net+, CIW) has extensive
experience in a broad range of technology subjects ranging from network
design and suppor t th rough software design and development. Travis has
worked on n u m e r o u s e-commerce and l ine-of-business solutions based on
Microsoft technologies including Windows 2000, Visual Basic, IIS, and SQL
Server.
Travis current ly works as an Independent Consul tan t in the New York
City area. He recently designed and developed a Web-based e-commerce
solution allowing a client to reach global marke t s with over 30,000 prod-
ucts. He a t tended Syracuse University and gradua ted with a Bachelor of
Science degree in Finance and Management Information Systems. Travis
lives in Westchester, NY and enjoys traveling with his ever-supportive
fianc6e Maria.
Bret S t a t e h a m (CNE, MCSE, MCSD, MCDBA, MCT) is the Owner of Net
Connex Technology Training and Consulting, L.L.C. (www.netconnex.com)
in San Diego, CA. Bret 's background includes extensive networking, devel-
opment , and training experience. His most recent projects have involved
cus tom training, da tabase development and administrat ion, XML schema
development and standardizat ion, cus tom application development, and
count less hours developing Active Server Pages-based Web solutions. Bret
and his wife Lori live in San Diego, CA.
Technical Editor and Contributor
Travis Laird (MCSE, MCDBA, A+, Network+, i-Net+, CIW) has extensive
experience in a broad range of technology subjects ranging from network
design and suppor t th rough software design and development. Travis has
worked on n u m e r o u s e-commerce and l ine-of-business solutions based on
Microsoft technologies including Windows 2000, Visual Basic, IIS, and SQL
Server.
Travis current ly works as an Independent Consul tan t in the New York
City area. He recently designed and developed a Web-based e-commerce
solution allowing a client to reach global marke t s with over 30,000 prod-
ucts. He a t tended Syracuse University and gradua ted with a Bachelor of
Science degree in Finance and Management Information Systems. Travis
lives in Westchester, NY and enjoys traveling with his ever-supportive
fianc6e Maria.
xxviii Introduction
software solut ions at t ha t t ime always looked to Oracle w h e n it came to the ques-
tion of where to store the data. In fact, o ther opt ions were rarely even d iscussed .
The release of SQL Server 7.0 was the resu l t of significant reworking of the SQL
Server product , which b rough t a t ten t ion b a c k to Microsoft in the en terpr i se-c lass
RDBMS marke t .
Wha t was significant abou t SQL Server 7.0 was its b road range of m a r k e t
usabili ty. From small b u s i n e s s e s with no dedicated technical staff to large mult i-
na t iona l corpora t ions with dozens of d a t a b a s e adminis t ra tors , SQL Server 7.0 was
tai lored to meet the demand . SQL Server finally found its way into the r a n k s of
i ndus t ry b e n c h m a r k s for pe r fo rmance and scalabili ty as well as usabili ty. Those
two categories are not typically ment ioned in the s ame sentence; the ability to
claim bo th charac te r i s t i cs is un ique to Microsoft SQL Server.
In addi t ion to this newfound s t a tu s as an enterpr i se-c lass RDBMS, SQL Server
7.0 in t roduced n u m e r o u s appl icat ion fea tures tha t were originally outs ide the
scope of a nat ive d a t a b a s e server. Fea tu res such as Data Trans fo rma t ion Services
(DTS) added native capabil i t ies for import ing and export ing da ta with heteroge-
neous sys tems, a t a sk once left to cus tom-bui l t utilities. An online analyt ical pro-
cess ing (OLAP) server engine opened the doors to da t a analysis capabil i t ies once
reserved for large corpora t ions tha t had the resources to bui ld and per form these
activities. Smal ler organizat ion can use SQL Server 7.0 to take advan tage of
graphica l wizards and a u t o m a t e d m a i n t e n a n c e rou t ines to set up and m a n a g e
their SQL Server solutions. Every organizat ion can take advantage of the self-
t un ing capabil i t ies t ha t allow SQL Server to r u n at optimal levels r ight out of the
box. These fea tures and more opened up the m ar k e t for SQL Server and posi-
t ioned it to compete in the depa r tmen ta l segment , its previous niche, all the way
to the en te rpr i se -c lass RDBMS marke t s .
As with m a n y Microsoft-based solut ion designers, I began working with SQL
Server 7.0 while it was in be ta and was immediate ly impressed with bo th the
improvemen t s to its relat ional d a t ab a s e engine and its solut ion capabilit ies. Most
of my previous SQL Server appl icat ions were migra ted to SQL Server 7.0 within
the first six m o n t h s of its public availability. Under an aggressive schedule by
mos t s t anda rds , the benefi ts of this fea ture-r ich release were well beyond the con-
cern over service packs , someth ing Microsoft u se r s have come to expect, and relia-
bility tes t ing proved its stability. New fea tures such as native operat ing sys tem file
suppor t replaced the "devices" s torage model of previous versions, mak ing
d a t a b as e file m a n a g e m e n t simpler. Data and t r ansac t ion log file au togrow fea tures
r educe the a m o u n t of moni tor ing necessa ry to alleviate potent ial s torage problems.
Simplified se tup of m a i n t e n a n c e and b a c k u p t a sks again minimize the a m o u n t of
admin i s t r a t ion necessary . Fea tu res s u c h as DTS replace and extend m a n y of the
c u s t o m impor t and export rout ines tha t I had developed and cont inued to main-
tain. The list of benefi ts to my SQL Server appl icat ions cont inues on.
Introduction xxix
Although the matur i ty period of SQL Server 7.0 was quick and many benefits
are available from the simple upgrade from SQL Server 6.5 to 7.0, Microsoft's
development of SQL Server 2000 has a strong and interesting list of enhance-
ments. New programming fea tures~user -def ined functions and table type vari-
ables as well as a redesigned Query Analyzer with functioning
debugger~immedia te ly at t ract the attention of any SQL developer. SQL Server
2000 offers a powerful list of feature enhancements both inside and outside. With
nearly twice the amoun t of functional testing that SQL Server 7.0 was subject to,
this latest version is the most scalable and reliable release of SQL Server to date.
Designed with Windows 2000 Server in mind, SQL Server 2000 is scalable up to
four-way clustering with support for up to 32 processors and 64GB of RAM. By
any calculation, tha t is a powerful server configuration. On the more common side
of database applications, enhancements in backup and recovery, DTS, and repli-
cation increase the usability and functionality of what have become common com-
ponents in many database solutions.
This latest release of OLAP services, renamed Analysis Services, is an obvi-
ously mature version of Microsoft's first take at OLAP in SQL Server. Analysis
Services provide greater integration and capabilities than their predecessor and
now add a data-mining component for trend discovery in your data. Data mining
is quickly becoming s tandard practice for organizations of any size as the competi-
tion for customers demands knowing who your customers are, what they pur-
chase, and what they do at your Web site. The focus on Internet applications does
not stop there. SQL Server 2000 is the first release with native support for HTTP
and HTTPS protocols. Accessing and querying your SQL Server and Analysis
Server da tabases is possible using s tandard Web protocols.
Aside from Web protocol support, Extensible Markup Language (XML) is at
home in SQL Server 2000. The growing use of XML for nearly any imaginable
application means that SQL Server 2000 is ready to support this new wave of
solutions. The increasing trend of separat ing content from presentat ion in Web
sites is m u c h simpler with SQL Server's support for storing, delivering, and
manipula t ing XML data. Other common practices of using XML to exchange data
with heterogeneous systems, which once required complex conversion routines, is
again natively possible with SQL Server 2000. This list of new and enhanced fea-
tures is of t remendous interest and importance to the SQL Server application
communi ty and will surely continue to position SQL Server as an indust ry leader.
This book walks you through the SQL Server 2000 product so tha t you can
take advantage of all tha t SQL Server has to offer. Building on the successful
delivery of SQL Server 7.0, SQL Server 2000 presents integration and matur i ty of
many features tha t were announced with and after SQL Server 7.0. SQL Server's
rich integration with Internet technologies and native support for XML make it an
exciting part of the next generation of solutions tha t many organizations are
beginning to design in a growing global community. Enhancemen t s in scalability
www.syngress.com
