Sybase SQL Server 11 Unleashed

Ray Rankins, Jeffrey R. Garbus, David Solomon, Bennett W. McEwan - Collection Unleashed

Parution le 25/04/1996

Ajouter à une liste

Indisponible

Résumé

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!

Table of contents

Introduction
1. Overview of Client/Server
2. Understanding the Sybase Client/Server Architecture
3. Introduction to Transact-SQL
4. Transact-SQL Datatypes
5. Creating and Altering Database Objects
6. Transact-SQL Programming Constructs
7. Transact-SQL Program Structures
8. Transaction Management
9. Defining Performance Expectations and Variables
10. Understanding SQL Server Storage Structures
11. Designing Indexes for Performance
12. Understanding the Query Optimizer
13. Stored Procedure Optimization
14. Analyzing Query Plans
15. Locking and Performance
16. Overriding the SQL Server Optimizer
17. Database Design and Performance
18. Database Object Placement and Performance
19. Application Design for Performance
20. Advanced Transact-SQL Programming
21. Miscellaneous Performance Topics
22. Common Performance and Tuning Problems
23. Overview of System Administration
24. SQL Server Installation and Connectivity
25. Defining Physical and Mirror Devices
26. Defining, Altering, and Maintaining Databases and Logs
27. Security and User Administration
28. Database Logging and Recovery
29. Backing Up and Restoring Databases and Transaction Logs
30. Configuring and Tuning the SQL Server
31. Optimizing SQL Server Configuration Options
32. Measuring Performance
33. Remote Server Management
34. Defining Systems Administration and Naming Standards
35. Administering Very Large SQL Server Databases
36. DB-Library Programming
37. ct-Library Programming
38. ODBC Programming
App. A: Sybase Tools Reference
App. B: The Database Consistency Checker
App. C: Managing the Audit System
App. D: Transact-SQL Quick Reference
App. E: System Administration Quick Reference
App. F: Legal Agreements Pertaining to the CD-ROM
Index

L'auteur - Ray Rankins

Ray Rankins is owner and president of Gotham Consulting Services, Inc. Ray has more than 15 years of database experience and has been working with Microsoft SQL Server from its beginning. Ray is a popular instructor and speaker at database conferences. He has also authored a number of database-related courses and was co-author of SQL Server 6.5 Unleashed.

L'auteur - Jeffrey R. Garbus

Jeffrey Garbus is an experienced SQL Server consultant and the CEO of Soaring Eagle Consulting, Ltd. He has spoken at user conferences, and has written many magazine articles. His books on SQL and databases include Learn SQL Server 7.0 Administration.

L'auteur - David Solomon

David Solomon

writes, speaks, teaches, and consults on SYBASE SQL Server design, application, and implementation.

L'auteur - Bennett W. McEwan

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.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Sams
Auteur(s)	Ray Rankins, Jeffrey R. Garbus, David Solomon, Bennett W. McEwan
Collection	Unleashed
Parution	25/04/1996
Format	18,5 x 23
EAN13	9780672309090