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.
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Für höhere Schule und Studium
Maße
Breite: 234 mm
Dicke: 47 mm
Gewicht
ISBN-13
978-0-13-455353-5 (9780134553535)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
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.
