The Sybase SQL Server Survival Guide


Book Description

Learn the do's and don'ts of installing Sybase SQL system from two well-known consultants. With their tip-filled guidebook users can avoid the usual stumbling blocks that developers run across. this book focuses on the day-to-day troubles that SQL Server presents to programmers and developers.




Sybase DBA Survival Guide


Book Description

This book takes the reader through job responsibilities and planning to implementation and performance monitoring. Checklists are included to guide the reader through various tasks. The authors provide a hands-on guide to setting up and administrating a network as well as a reference guide that administrators can refer to for troubleshooting tips and techniques.




Sybase SQL Server 11 DBA Survival Guide


Book Description

Going beyond basic database knowledge to understanding the whys and hows behind the administration process, this book takes the reader through job responsibilities and planning to implementation and performance monitoring. Checklists are included to guide the reader through various tasks.




The Sybase IQ Survival Guide


Book Description

The Sybase IQ Survival Guide is a clear and concise roadmap through the wealth of information out there, presented in logical steps and enhanced with the authors considerable hands on experience. All you need to get going with this book is a basic knowledge of SQL and databases. This guide has hundreds of tested methods for executing day to day tasks as well as hints, tips and guidance derived from the authors 10 years experience with the product. The following chapters are included: - - Introduction to IQ - Creating, Running and Stopping a Database/Server - Security - SQL - Loading, Extracting and Moving Data - Tables, Data Types and Views - Indexes - Stored Procedures, Functions and Triggers - Transaction Management - Backups, Restores & DR - Multiplex - Java in the IQ - Remote Objects & Application/Language Connectivity - Tips and Tricks - System Tables and Views - System Procedures - Options - Migration from Other Databases




Microsoft SQL Server 2000 DBA Survival Guide


Book Description

Organized into several parts that comprise the various jobs and tasks the DBA performs, each chapter of this book is presented with the goal of providing knowledge and "know-how" to Database Administrators of a SQL Server database. The chapters also offer real-world insight and experience by passing on tips, tricks, and suggestions.




Microsoft SQL Server


Book Description

Text written in 7 parts: Introduction (including the role of the Database Administator); 2) World of Microsoft's SQL Server; 3) Planning and Installing / Upgrading the SQL server; 4) Database operation; 5) Performance and tuning; 6) Maintaining the Shop; 7) Appendixes.




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.




Sybase SQL Server


Book Description




Microsoft SQL Server 6.5 DBA Survival Guide


Book Description

Step-by-step checklists for everything involved in running a SQL Server database, real-life tips and notes to complement your learning experience, installation and upgrade techniques, guidelines for backing up and restoring data, steps to optimizing and automating routine procedures, ways to correct common database problems as they arise, and procedures for creating Web pages with the Web Assistant.




Developing Client/Server Systems Using Sybase SQL Server System 11


Book Description

A developmental guide, this book covers stored procedures and triggers, query optimization, the APT workbench, and other features that help developers build fast and efficient client/server applications. this book covers the new Sybase SQL Server 11, which has improved administration performance and enhanced networking capabilities.