SQL Server 2000 Unleashed
Ray Rankins, Paul Jensen, Paul Bertucci
Résumé
Contents
Introduction
Part I Welcome to Microsoft SQL Server
1. The Microsoft SQL Server Environment
2. SQL Server 2000 Environments and Editions
3. What's New in SQL Server 2000
Part II. Installation and Upgrade
4. Installing a New SQL Server Instance
5. Client Installation and Configuration
Part III. SQL Server Administration Tasks and
Tools
6. SQL Server System and Database Administration
7. SQI, Server Enterprise Manager
8. SQL Server Command-Line Utilities
9. Creating and Managing Databases
10. Creating and Managing Tables in SQL Server
11. Creating and Managing Indexes
12. Data Integrity
13. Creating and Managing Views in SQL Server
14. Creating and Managing Stored Procedures
15. Creating and Managing Triggers
16. User-Defined Funetions
17. Security and User Administration
18. Database Backup and Recovery
19. Database Maintenance
20. SQL Server Scheduling and Notification
21. Managing Linked and Remote Servers
22. Importing and Exporting SQL Server Data Using
BCP
23. Importing and Exporting SQL Server Data Using Data
Transformation Services (DTS)
24. Administering Very Large SQL Server Databases 569 25.
Data Replication
26. Defining SQL Server Environment and Naming
Standards
Part IV. Transact-SQL
27. Usina Transact-SQL in SQL Server 2000
28. Transaction Management and the Transaction Log
29. Distributed Transaction Processing
Part V. SQL Server Internals and Performance
Tuning
30. SQL Server Internals
31 Indexes and Performance
32. Understanding Query Optimization
33. Query Analysis
34. Using the SQL Servet Profiler
35. Using the SQL Debugger in Query Analyzer
36. Monitoring SQL Server Performance
37. Locking and Performance
38. Database Design and Performance
39. Configuring, Tuning, and Optimizing SQL Server
Options
Part VI. Integrating SQL Server into the Microsoft
Architecture
40. SQL Mail
41. Using XML in SQL Server 2000
42. Microsoft SQL Server Analysis Services
43. Microsoft Transaction Server
44. SQL Server Clustering
45. Full Text Search
Index
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 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.
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.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Sams |
| Auteur(s) | Ray Rankins, Paul Jensen, Paul Bertucci |
| Parution | 15/09/2000 |
| Nb. de pages | 1428 |
| Format | 18,6 x 23,1 |
| Couverture | Broché |
| Poids | 2750g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780672319976 |
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
