Résumé
Build and manage highly available distributed database
applications using SQL Server 2000 and the comprehensive
information in this volume. You'll get full details on SQL
Server 2000 system and platform architecture,
administration, application development, and enterprise
services. Learn to program SQL Server with Transact-SQL,
handle multi-dimensional data processing with the Analysis
Services, use Data Transformation Services, implement data
mining and data warehousing techniques, back up and restore
databases, and manage security, performance, and more.
Complete with real-world examples, SQL Server 2000: The
Complete Reference is an invaluable tool for DBAs,
operators, developers, and network administrators of all
skill levels.
- Install, configure, and administer SQL Server
2000
- Build and deploy Web-enabled, scalable, e-commerce
database solutions with XML support
- Use permissions, logins, user accounts, and roles to
secure databases and servers
- Write and deploy T-SQL scripts, stored procedures,
triggers, and queries
- Take full advantage of the new English Query platform
Populate, maintain, and analyze data warehouses and data
marts
- Plan and set up replication and distributed
transactions with Data Transformation Services (DTS)
- Build and manage OLAP cubes and systems
- Manage multiple, isolated installations of SQL Server
from a single machine
- Configure fail-over clustering and implement sound
disaster recovery procedures
Contents
Part I: SQL Server 2000 System and platform
architecture
- Chapter 1: Getting to know SQSL Server 2000
- Chapter 2: Database architecture
- Chapter 3: SQL Server 2000 client/server
architecture
- Chapter 4: DBMS architecture
- Chapter 5: Meta data services
- Chapter 6: Installing SQL Server 2000
Part II: SQL Server 2000 platform administration
- Chapter 7: Administration architectiture
- Chapter 8: SQL Server security and access control
- Chapter 9: SQL Server disaster recovery
- Chapter 10: SQL Server replication
- Chapter 11: SQL Server 2000 databases
- Chapter 12: Administrating SQL Server 2000
- Chapter 13: SQL Server 2000 high availibility
Part III: Programminng SQL Server 2000
- Chapter 14: SQL Server 2000 programming concepts,
strategies and models
- Chapter 15: Getting started with SQL queru
analyser
- Chapter 16: Transact-SQL Primer
- Chapter 17: SQL Server integrity programming and
management
- Chapter 18: Stored procedures and triggers
- Chapter 19: Query fundamentals and strategy
- Chapter 20: Working with operational data
- Chapter 21: SQL Server 2000 advanced concepts
- Chapter 22: English query
- Chapter 23: SQL Server and the Internet
- Chapter 24: Data mining and data warehousing
- Chapter 25: Getting started: analysis services and OLAP
- Chapter A: T-SQL reference
- Index
L'auteur - Jeffrey R. Shapiro
Jeffrey R. Shapiro has specialized in Microsoft technologies since 1989, and has published eleven books on network administration and software development. He is technical lead and chief architect for ZLB Plasma Services, a firm with 50 locations throughout the U.S. As leader of ZLB's NetWare-to-Windows migration team, he architected its nationwide Active Directory, SQL Server, and Exchange network. Previously, he led Broward County, Florida's NetWare-to-Windows 2000 migration project, architecting three mission-critical high performance data centers supporting 6,000 users.
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Mc Graw Hill |
Auteur(s) | Jeffrey R. Shapiro |
Parution | 01/12/2000 |
Nb. de pages | 931 |
Format | 18,8 x 23,2 |
Couverture | Broché |
Poids | 1851g |
Intérieur | Noir et Blanc |
EAN13 | 9780072125887 |
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