Microsoft SQL Server 2000 Unleashed - Softcover

Rankins, Ray; Jensen, Paul; Bertucci, Paul

Softcover

ISBN 10: 0672319977 ISBN 13: 9780672319976

Publisher: Sams, 2001

Synopsis

Microsoft SQL Server 2000 Unleashed offers a variety of topics for system and database administrators to help them learn new features of the product and to solve problems they face on a daily basis. It shows them how to build upon their working knowledge of the product and take their experience and knowledge to a higher level.

This title includes topics such as:

• SQL Server and XML;
• High availability;
• SQL Server architecture, performance and tuning;
• SQL Server and the Web;
• Scalability issues;
• Integration with BackOffice and other Microsoft products;
• Enterprise issues and replication;
• Data Transformation Services (DTS) security and analysis services.

About this title

About the Author

Ray Rankins is currently owner and president of Gotham Consulting Services, Inc. near Saratoga Springs, New York (the summer place to be). Ray has been working with Sybase and Microsoft SQL Server since 1987 as a DBA, application developer, database designer, project manager, consultant, and instructor. He has worked in a variety of industries including financial, manufacturing, health care, retail, insurance, communications, public utilities, and government. His expertise is in database performance and tuning, query analysis, advanced SQL programming and stored procedure development, and database application design and development. Ray's presentations on these topics at past user group conferences have been very well received. Ray is co-author of Sybase SQL Server 11 Unleashed, Microsoft SQL Server 6.5 Unleashed, and Sybase SQL Server 11 DBA Survival Guide, Second Edition, all published by Sams Publishing. He can be reached at rrankins@gothamconsulting.com.

Paul Jensen is an MCDBA, MCT, MCSE, and OCP (Oracle Certified Professional) who has been involved with database and system administration for almost 15 years. His experience has made him a popular trainer, and the past few years have seen him bouncing around North America and Europe in his role as an MCT, bringing new SQL Server converts in to the fold. Paul lives in Ottawa, Canada, and can be contacted through his Web site at http://www.infojen.com.

Paul Bertucci is managing principal and founder of Database Archi-techs (http://www.dbarchitechs.com), a database consulting firm based in San Francisco, California and with European offices in Paris, France. He has more than 20 years of experience doing database design, data architecture, data replication, performance and tuning, distributed data systems, data integration, and systems integration for numerous Fortune 500 companies including Intel, 3COM, Apple Computers, Toshiba, Lockheed, Wells Fargo, Safeway, Texaco, Charles Schwab, Cisco Systems, Sybase, Webgain, and i2 Technologies. He has authored numerous articles, standards, and courses such as Sybase's "Performance and Tuning" course and "Physical Database Design" course. Paul is a frequent conference speaker and regularly teaches database design, performance and tuning, data modeling, OLAP, Supply Chain Management, and SQL courses. He has worked heavily with MS SQL Server, Sybase, DB2, and Oracle, and has architected several commercially available tools in the database, data modeling, performance and tuning, and data integration arena. Paul serves part-time as chief technical advisor for a data integration server software company as well as an advisory board member of a software services company in Silicon Valley. Paul received his formal education in computer science from UC Berkeley. He lives in northern California with his wife, Vilay, and four children (with a fifth on the way). Paul can be reached at pbertucci@dbarchitechs.com and by phone at 925-674-0000.

Bennett McEwan is president of Parry Five Consulting, LLC, in Northern Virginia. Ben consults on SQL Server projects in the Washington, DC area. His top skills are in SQL Server replication, performance tuning, high availability database design, and data warehouse architecture. He is always on the lookout for challenging projects. Contact him at ben@parryfive.com.

Chris Gallelli is a database administrator working for Alltel Corporation in Latham, New York. Chris has more than seven years of experience with SQL Server and more than 15 years of computing experience. His experience is varied and includes work as both a Visual Basic developer and a DBA. He has a Bachelors degree in electrical engineering and a Masters degree in business administration from Union College. Chris currently lives near Albany, New York with his lovely wife Laura and two daughters Rachael and Kayla. Chris can be reached at CGallelli@excite.com.

Alex T. Silverstein is a Client/Server developer for Alltel Information Services in New York's capital region. He specializes in thin-client enterprise software design and programming. His expertise is in Microsoft-powered Internet solutions based on SQL Server 2000 and Internet Information Server (IIS), Extensible Markup Language (XML) and Extensible Stylesheet Language for Transformations (XSLT), Active Server Pages (ASP), Dynamic HTML (DHTML) and scripting languages. He is a graduate of Rutgers University. Alex can be contacted at alexsilverstein@lycos.com.

From the Back Cover

Microsoft SQL Server 2000 Unleashed offers a variety of topics for system and database administrators to help them learn new features of the product and to solve problems they face on a daily basis. It shows them how to build upon their working knowledge of the product and take their experience and knowledge to a higher level. This title includes topics such as: *

SQL Server and XML

*

High availability

*

SQL Server architecture; performance and tuning

*

SQL Server and the Web

*

Scalability issues

*

Integration with BackOffice and other Microsoft products

*

Enterprise issues; replication

*

Data Transformation Services (DTS) security; and analysis services

Edition details

• Publisher: Sams
• Publication date: 2001
• Language: English
• ISBN 10: 0672319977
• ISBN 13: 9780672319976
• Binding: Paperback
• Edition number: 1
• Number of pages: 1512