Administrator's Guide to Sybase ASE 15


Book Description

Administrator's Guide to Sybase ASE 15 is a practical systems administration guide for the newest release of the ASE product. Designed to provide all administrators with an authoritative guide, topics include installation, defining physical and Sybase-mirrored devices, transaction logging and modes, security, auditing, database backup and restoration, troubleshooting, maintenance, and more. After reading this book, you should be able to perform any task that encompasses the creation or maintenance of a server. With this book any administrator will understand the responsibilities of a system administrator; find out how to set limits on server resources using the Resource Governor; learn how to prioritize tasks with the Logical Process Manager; use data partitioning to enable finer control over data placement, maintenance, and management.




The Official New Features Guide to Sybase ASE 15


Book Description

Sybase Adaptive Server Enterprise 15 is a high-performance, mission-critical database management system designed to meet the increasing demands of large databases and high-transaction volumes, while providing a cost-effective database management system. The Official New Features Guide to Sybase ASE 15 focuses on the many enhancements in Sybase ASE 15 including semantic partitions, computed columns, functional indexes, and scrollable cursors. With this book learn about the enhancements to ASE 15, how the new features can increase your efficiency and productivity, and how these features integrate with existing systems; understand how semantic partitions decrease the complexities of data management; find out how scrollable cursors and computed columns can ease the development process; learn how the optimizer toolset and QP Metrics improve monitoring and diagnostic efforts; provide the ability to ensure customer compliance through the use of Sybase Software Asset Management; test your knowledge with the included Sybase certification practice exam.




Sybase 15.0 Replication Server Administration


Book Description

Sybase 15 Replication Server Administration addresses the needs of a wide range of database professionals, explaining to both beginners and experts how to administer Sybase’s newest Replication Server release. This book examines all the knowledge, background information, and conceptual frameworks needed in order to get started on installing and administering Sybase Replication Server, and explores the world of contemporary cross-platform compatible Sybase Replication Server administration. Learn how to replicate business-critical data; configure database connections and routes; manage replicated tables, stored procedures, and subscriptions; set up a warm standby system; monitor replication performance and tune the database system; provide up-to-the-minute high availability of data; recover from failures and prevent data loss; troubleshoot the replication system.




Sybase 15.0 Replication Server Administration


Book Description

Sybase 15 Replication Server Administration addresses the needs of a wide range of database professionals, explaining to both beginners and experts how to administer Sybase’s newest Replication Server release. This book examines all the knowledge, background information, and conceptual frameworks needed in order to get started on installing and administering Sybase Replication Server, and explores the world of contemporary cross-platform compatible Sybase Replication Server administration. Learn how to replicate business-critical data; configure database connections and routes; manage replicated tables, stored procedures, and subscriptions; set up a warm standby system; monitor replication performance and tune the database system; provide up-to-the-minute high availability of data; recover from failures and prevent data loss; troubleshoot the replication system.







Database Administration


Book Description

Database Administration, Second Edition, is the definitive, technology-independent guide to the modern discipline of database administration. Packed with best practices and proven solutions for any database platform or environment, this text fully reflects the field’s latest realities and challenges. Drawing on more than thirty years of database experience, Mullins focuses on problems that today’s DBAs actually face, and skills and knowledge they simply must have. Mullins presents realistic, thorough, and up-to-date coverage of every DBA task, including creating database environments, data modeling, normalization, design, performance, data integrity, compliance, governance, security, backup/recovery, disaster planning, data and storage management, data movement/distribution, data warehousing, connectivity, metadata, tools, and more. This edition adds new coverage of “Big Data,” database appliances, cloud computing, and NoSQL. Mullins includes an entirely new chapter on the DBA’s role in regulatory compliance, with substantial new material on data breaches, auditing, encryption, retention, and metadata management. You’ll also find an all-new glossary, plus up-to-the-minute DBA rules of thumb.




Adobe Captivate 3


Book Description

Adobe Captivate 3: The Definitive Guide, the follow-up to Wordware’s popular Macromedia Captivate: The Definitive Guide, steps you through all the procedures needed to create Flash movies based on any software on your desktop. You’ll learn how to create Flash movies, edit individual screens, add and edit sound, even add interactivity (with or without grading) for complete customization. The expanded e-learning chapter in this edition discusses a variety of ways to build quizzing functions with individual questions and question pools. A chapter on branching shows how to move slide elements on a visual display, and how to create paths through a movie that give each viewer a unique experience. This book covers everything from getting the software installed and activated, manipulating the movie files, adding and editing audio, and building quizzes, all the way to delivery mechanisms of the final output and integrating your movies with other applications. With this book, learn to install and configure Captivate; create and edit movies; add, delete, edit, and rearrange slides; incorporate audio and interactivity in your movies; create e-learning content through the use of question slides and branching functions; use a variety of Captivate tools including templates and MenuBuilder.




Sybase ASE 12.5 Performance and Tuning


Book Description

Once your database system is up and running, you need to keep it functioning smoothly. Designed for the DBA working to maximize the performance of a Sybase server, Sybase ASE 12.5 Performance and Tuning provides a guide to this important process. From benchmarking your system and optimizing stored procedures to indexing and using sp_sysmon to monitor your system, the authors thoroughly explain how to tune your server for maximum performance. Topics include defining performance, understanding the I/O system, using the query optimizer, managing memory, processing queries, application design, deadlocks and locking schemes, performance metrics, auditing features, tips for solving problems that can bog down a system.




SQL for Microsoft Access


Book Description

SQL for Microsoft Access (2nd Edition) provides a guide to getting the most out of Microsoft Access through the use of Structured Query Language. Step-by-step examples demonstrate how to use SQL script to create tables, add records to tables, and retrieve and manage records. Readers will also learn about calculated fields, Access projects, and the integration of SQL script in VBA and ASP code. Explore the relational database structure and the basics of SQL. Understand how table joins, unions, and subqueries are used to retrieve records from multiple tables simultaneously. Learn how to filter records and group data. Discover how to create parameter queries that prompt users for data. Test your knowledge and comprehension with the end-of-chapter quizzes and projects.




Sybase Developer (ASE 15) Survival Guide


Book Description

SYBASE Developer (ASE 15) Survival Guide is an all - embracing guide which though aiming to help both beginners and advanced level professionals gain a thorough understanding of Sybase, will also be useful for aspirants of Sybase ASE SQL Developer Professional certification exam. Topics for beginners include Logical and Physical design, normalization, primary key, constraints, DDL and DML; whereas for intermediate and advanced level professionals, key areas covered are Stored procedure, Triggers, Performance and Tuning Basics, Query optimization process, Index, Query optimization engine, Partition, locking, and many more. Whats new in ASE 15: In addition to the topics covered in previous version of Sybase ASE, this book includes details on new features of the ASE 15 version, including: -Local and global index -Scrollable cursor -New join types -ASE 15 optimization goals and -New commands for getting optimizer information.