Muutke küpsiste eelistusi

Sybase Systems Management [Pehme köide]

  • Formaat: Paperback / softback, 704 pages, laius x paksus: 234x47 mm, kaal: 1317 g
  • Ilmumisaeg: 26-Sep-1996
  • Kirjastus: Prentice Hall
  • ISBN-10: 0134553535
  • ISBN-13: 9780134553535
  • Pehme köide
  • Hind: 50,49 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
Sybase Systems Management
  • Formaat: Paperback / softback, 704 pages, laius x paksus: 234x47 mm, kaal: 1317 g
  • Ilmumisaeg: 26-Sep-1996
  • Kirjastus: Prentice Hall
  • ISBN-10: 0134553535
  • ISBN-13: 9780134553535
45535-2 The first complete guide to managing Sybase SQL Server. To succeed as a Sybase systems professional, you need to understand your system from both a technical and managerial standpoint. Sybase Systems Management is the first book that helps with both. It's the right book for you, if ...*You don't have time to read all of the Sybase documentation. *You need to understand how Sybase SQL Server fits into your computing infrastructure-and how it can help your organization achieve its goals. As a former Sybase AnswerBase implementor and technical support engineer, Karen Hogoboom is singularly well-qualified to present this detailed, inside view of Sybase SQL Server. This book shows you exactly how Sybase SQL Server works-and how it interacts with disks, memory, CPUs, external software and networks. There is extensive coverage of configuration issues, including System 11 configuration. There's also exclusive, never-before-published information about SQL Server internals. In short, you'll learn enough to troubleshoot nearly any Sybase technical or performance problem, and to optimize new database systems. But technical detail is only half the story.Sybase Systems Management also focuses on the real-world management issues that face Sybase developers and administrators every day. Here, you'll get the big picture that's so often missing in computer manuals. How can you make sure Sybase SQL Server actually solves the business problems it's intended to solve? How can you analyze costs and benefits associated with specific projects, and set appropriate priorities? How can you avoid common project implementation problems, and establish procedures that ensure maximum efficiency? Sybase Systems Management covers Sybase SQL Server with unprecedented depth and insight. It's essential reading for every Sybase developer, manager or administrator.
Preface. Why Sybase Systems Management? What's An Information System?
What's a Systems Manager? How Do You Become a SQL Server Expert? How is
Sybase Systems Management Structured? Conventions. Acknowledgments. PART
I. Sybase SQL Server.
1. An External View of SQL Server Structure. The
Client/Server Architecture. Relational Database Management Systems.
Databases * Tables * Rows * Columns * Indexes * Schemas. Managing
User-Defined Datatypes.
2. An External View of SQL Server Processing.
Data Protection. Integrity Features. Transactions. Locking * DBCC *
Backing Up and Loading Databases * Security. The Transact-SQL Language.
SQL Server Utilities. SQL Server Limits. Starting and Stopping SQL Server.
Managing Database Objects. Backup and Recovery * Avoiding Hard-coded Limits.
Managing Stored Procedures. Managing Roles. Managing Object Permissions.
3. An Internal View of SQL Server Structure. Terminology. Device Types
and Features. Device Performance. SQL Server Devices. Configuring Disk
Devices. Disk Mirroring. System Databases. User Databases. Database
Objects. Segments * Partitions * Allocation Units * Extents * Pages * Rows.
Managing the Model Database. Managing The Sybsecurity Database. Making
Backups of System Databases. Disk Partition Use. Managing Space With
Segments and Thresholds.
4. An Internal View of SQL Server Processing.
SQL Server Files. CPU Usage. Memory Usage. Network Usage.
Internationalization. Localization.
5. The Sybase SQL Server System
Catalogs. Server Management Tables. Object Management Tables. Security and
User Management Tables. Direct Updates of System Tables. Bit Mapped Status
Values. Managing User-Defined Messages.
6. SQL Server System-Wide
Configuration. The Configuration Block * The sp_configure Command * Server
Management Configuration Values * Object and Data Management Configuration
Values * Language and Localization Configuration Values * Connection and
Process Mana gement Configuration Values * Security Management Configuration
Values. Documenting a Standard Configuration. Managing Server
Configuration.
7. Database and User Environment Configuration. Database
Options. User Environment Configuration. Managing Database Configuration.
8. Performance Analysis and Tuning. SQL Server Performance Factors.
Setting Performance Goals and Measuring Results. Understanding the SQL
Server Query Process. Optimizing Indexes. Optimizing Queries. Optimizing
Stored Procedures. Optimizing Operating Environment. Optimizing Design.
Minimizing Locking. SQL Server Performance-Related Commands.
9.
Enterprise Data Strategies. Determining A Storage Management Strategy.
System Migration. Data Conversion. Data Replication. Data Warehouses.
Decision Support Systems and On-Line Analytical Processing. Distributed,
Interoperable Systems. The Standards Strategy. Beyond Organizational
Systems. Archiving Data. Managing Communication Between Servers.
10.
Preventing and Resolving Problems. Backup and Recovery. Improving
Maintainability. Automating Logins. Managing Connections. Increasing
Security. Upgrading SQL Server. Troubleshooting. The SQL Server Errorlog.
Notifying Users About Down Time * Reporting errors * Disaster Recovery.
Contacting Vendors. Passwords. Upgrades. PART II. Systems Management.
11. Establishing System Goals. The Information System. The Systems
Manager's Job. The System Vision. Organizational Goals. Technology-Driven
Goals. Personal Goals. The Right System For The Organization. Document
System Goals. Information System Solutions. Organizational Structure.
12.
Implementing the Right Projects. Choosing What To Change * Choosing What
Not To Change * Choosing When to Make Changes. Initiating Projects.
Design. Validation and Verification. Implementation. Technical Support.
Just Do It. Requests for Information Systems Changes * System Timing
Considerations * Creating Proposals * Information System Project Standards *
Consultant Arrangements * Programming Standards * Naming conventions.
13.
Project Leadership. Leadership, Management and Coordination. Selecting a
Project Leader * Communication * Team Building * Motivation * Successful
Meetings. Time Management. A Quick Time Management Lesson * Preventing and
Recovering from Delays. Managing Expectations. Managing Resistance to
Change. Communication. Notifying Users Of System Changes * Recommended
Communication Methods. Project Document Storage.
14. Identifying the
Costs, Benefits and Functions of System Components. Techniques of
Cost/Benefit Analysis * Evaluating Current And Future System Elements *
Format for Cost/Benefit Analysis * Evaluating Proposals. Hardware And
Software Acquisition And Support. Appendix A. Sybase Products and Services
Overview. Server and Server Administration Products. Tools. Middleware
(Enterprise CONNECT, Connectivity). Services. Bibliography. Favorites.
Becoming a An Expert. Sybase.