Mastering Sybase SQL Server II


Book Description

This in-depth guide to extracting top performance from Sybase System 11 SQL Server covers performance-tuning and database design issues making it a must for data architects, developers, and other computing professionals working with Sybase in a Client/Server environment. Includes a detailed case study of a data warehouse system using Sybase SQL Server.




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.




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 SQL Server


Book Description




Mastering SQL Server 2000 Security


Book Description

Learn how to protect corporate information by properly designing, managing, and maintaining security at the database level Security is a primary concern in all aspects of development and IT administration. While locking down networks and erecting firewalls will always be necessary, so much more can be done to protect a corporation's most valuable intangible assets: accounting records, customer lists, and inventories. Microsoft SQL Server 2000 has proven itself to be the fastest and most reliable product available for protecting corporate data. No other book covers as thoroughly the subject of security design and implementation strategies; Mastering SQL Server 2000 Security fills that gap in literature with practical, hands-on advice. Packed with indispensable design information that can make a tightly secured database faster and easier to use, this book is essential reading for both administrators and developers of databases. The authors explain just how much more is possible in the task of protecting corporate information by properly designing, managing, and maintaining security at the database level. From this book you will: Learn the ins and outs of SQL Server 2000 Security design Understand the implementation differences between SQL Server Authentication and Windows Authentication Understand the security options in SQL Server 2000 for Internet applications Integrate the security of Windows 2000 (Kerberos) into your SQL Server deployment Master the security requirements for distributed data environments, such as DTS, replication, linked servers, and data warehousing




Sybase SQL Server 11 Unleashed


Book Description

The most comprehensive book available on th Sybase SQL Server today, this book enables readers to gain a knowledge of the programming and database administration aspects behind this popular RDBMS (relational database management system). The CD-ROM includes the Aurora Desktop, a compact SQL editor with some of the features of the full-size Aurora Script Manager.




Sybase Sql Server 11 Unleashed


Book Description

Configure, Tune, and Exploit the full Power of SYBASE® SQL Server 11 Learn the capabilities and features of Transact-SQL (Part II) Learn how to analyze query plans (Chapter 14) Back up your database and learn efficient data recovery techniques (Chapter 29) Discover how to bypass the optimizer (Chapter 16) Secure your database from data loss and unauthorized access (Chapter 27) Configure and tune your database to conform to your specific needs (Chapters 30 &31) Measure performance and use benchmarks to identify key problems (Chapter 32) The new release of SQL Server11 is packed with power, breaking many previous SYBASE SQL Server benchmarks-achieving over a 100% improvement over both SQL Server 4.9 and 10. With all this new power at your command, you need a comprehensive book to detail the best ways to program, tune, and administer your databases. SYBASE SQL Server 11 Unleashed is that book. Between its covers you'll find information on installation, Transact-SQL programming, performance tuning, measuring performance, transaction management, security, remote server management, and other key SQL Server 11 topics. Put the full potential of SQL Server 11 to work for you with SYBASE SQL Server 11 Unleashed. The companion CD-ROM includes trial software form Northern Lights Software: Northern Lights Aurora Desktop Aurora Cost Retrieval DLL Aurora Script Manager Plus trial software from other leading companies, including: Analytical Solutions, Incorporated Sylvain Faust StarWare Connectivity Software And Visible Analyst Workbench, an I-CASE tool worth $595.00! Ray Rankins currently consults and instructs on topics including SQL Server administration, performance and tuning, and client/server database application design. Since 1989, Jeffrey R. Garbus has taught thousands of programmers, systems administrators, and database designers about SYBASE administration and tuning. David Solomon writes, speaks, teaches, and consults on SYBASE SQL Server design, application, and implementation. Bennett W. McEwan is the Manager of Software Development for Northern lights Software. He has been responsible for the development of the aurora Utilities suite since February 1995.




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.







Sybase and Client/server Computing


Book Description

This comprehensive C/S reference focuses on Sybase, emphasizing the long-awaited, much-improved Sybase System II. All material on Sybase components, features, and usage is completely updated, with the addition of extensive discussions of data warehousing with System II, Sybase SQL Server designing and tuning, and more.