Sybase SQL Server 11 Unleashed
Ray Rankins, Jeffrey R. Garbus, David Solomon, Bennett W. McEwan - Collection Unleashed
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.
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
writes, speaks, teaches, and consults on SYBASE SQL Server design, application, and implementation.
L'auteur - 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 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
