Microsoft SQL Server 2000 Unleashed
Ray Rankins, Paul Bertucci, Paul Jensen
Résumé
Microsoft SQL Server 2000 Unleashed provides comprehensive coverage of SQL Server 2000 that goes beyond the basic syntax and information you'll find in the product manuals. This book addresses the most important features of SQL Server 2000, including new features such as the .NET Framework, SQL XML 3.0, and SQL Server Notification Services. Authors Ray Rankins, Paul Bertucci, and Paul Jensen offer insights based on years of SQL Server experience.
Detailed Information on...- Installing and administering SQL Server 2000
- Database maintenance, backup, and recovery
- Creating and managing tables, views, stored procedures, triggers, and user-defined functions
- Database and index design and performance
- SQL Server internals, query optimization, and performance monitoring and tuning
- Transactions, transaction management, and distributed transactions
- Importing and exporting data using BCP and Data Transformation Services
- SQL Server and the .NET Framework - NEW!
- SQL Server and SQL XML 3.0 - NEW!
- SQL Server Notification Services - NEW!
- High availability and SQL Server clustering
- SQL Server Analysis Services
- Enterprise issues and data replication " SQL Server tools and utilities
- A searchable electronic version of the book
- Transact-SQL code listings
- Data replication scripts
- ADO.NET sample code
- Performance monitoring and XML examples
- Distributed transaction Samples
- Helpful BCP and system stored procedures
- Sample databases
- Evaluation versions of database utilities from FMS, Embarcadero Technologies, and Red Gate Software
Contents
I. Welcome to Microsoft SQL Server- The Microsoft SQL Server Environment
- SQL Server 2000 Environments and Editions
- What's New in SQL Server 2000
- SQL Server Enterprise Manager
- SQL Server Command-Line Utilities
- SQL Server Query Analyser and SQL Debugger
- Using the SQL Profiler
- Installing and Upgrading SQL Server
- Client Installation and Configuration
- SQL Server System and Database Administration
- Creating and Managing Databases
- Creating and Managing Tables in SQL Server
- Creating and Managing Indexes
- Implementing Data Integrity
- Security and User Administration
- Database Backup and Restore
- Database Maintenance
- SQL Server Scheduling and Notification
- Managing Linked and Remote Servers
- Importing and Exporting SQL Server Data Using BCP and DTS
- Administering Very Large SQL Server Databases
- Data Replication
- SQL Mail
- SQL Server Clustering
- Defining SQL Server Environment and Naming Standards
- Using Transact-SQL in SQL Server 2000
- Creating and Managing Views in SQL Server
- Creating and Managing Stored Procedures in SQL Server
- Creating and Managing Triggers
- User-Defined Functions
- Transaction Management and the Transaction Log
- Distributed Transaction Processing
- SQL Server Internals
- Indexes and Performance
- Understanding Query Optimization
- Query Analysis
- Monitoring SQL Server Performance
- Locking and Performance
- Database Design and Performance
- Configuring, Tuning, and Optimizing SQL Server Options
- Using XML in SQL Server 2000
- Microsoft SQL Server Analysis Services
- Microsoft Transaction Server
- SQL Server Full-Text Search Services
- SQL Server Notification Services
- SQL Server and the Microsoft .NET Framework
- English Query
L'auteur - Ray Rankins
Ray Rankins is owner and president of Gotham Consulting Services, Inc. Ray has more than 15 years of database experience and has been working with Microsoft SQL Server from its beginning. Ray is a popular instructor and speaker at database conferences. He has also authored a number of database-related courses and was co-author of SQL Server 6.5 Unleashed.
L'auteur - Paul Bertucci
Paul Bertucci heads the technology practices for the San Francisco offices of Collaborative Consulting, I.LC. He has more than 22 years of experience in database technologies including distributed data systems, data integration, and systems integration. He has authored many courses such as Sybase's "Performance and Tuning" and "Physical Database Design," and books such as Sams Teach Yourself ADO.NET in 24 Hours, and he holds numerous certifications.
L'auteur - Paul Jensen
Paul Jensen is an MCUBA, MCT, MCSE, and OCP who has been involved with database and system administration for 15 years. His experience has made him a popular trainer, and he has spent the past few years bouncing around North America and Europe in his role as an MCT, bringing new SQL Server converts into the fold.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Sams |
| Auteur(s) | Ray Rankins, Paul Bertucci, Paul Jensen |
| Parution | 22/01/2003 |
| Édition | 2eme édition |
| Nb. de pages | 1556 |
| Format | 18,7 x 22,8 |
| Couverture | Broché |
| Poids | 2005g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780672324673 |
| ISBN13 | 978-0-672-32467-3 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
