A Developer's Guide to SQL Server 2005
Bob Beauchemin, Dan Sullivan - Collection Microsoft .Net Development Series
Résumé
Few technologies have been as eagerly anticipated as Microsoft SQL Server 2005. Now, two SQL Server insiders deliver the definitive hands-on guide--accurate, comprehensive, and packed with examples. A Developer's Guide to SQL Server 2005 starts where Microsoft's documentation, white papers, and Web articles leave off, showing developers how to take full advantage of SQL Server 2005's key innovations. It draws on exceptional cooperation from Microsoft's SQL Server developers and the authors' extensive access to SQL Server 2005 since its earliest alpha releases.
You'll find practical explanations of the new SQL Server 2005 data model, built-in .NET hosting, improved programmability, SQL:1999 compliance, and much more. Virtually every key concept is illuminated via sample code that has been fully updated for and tested with the shipping version of the product.
Key coverage includes
- Using SQL Server 2005 as a .NET runtime host: extending the server while enhancing security, reliability, and performance
- Writing procedures, functions, triggers, and types in .NET languages
- Exploiting enhancements to T-SQL for robust error-handling, efficient queries, and improved syntax
- Effectively using the XML data type and XML queries
- Implementing native SQL Server 2005 Web Services
- Writing efficient, robust clients for SQL Server 2005 using ADO.NET, classic ADO, and other APIs
- Taking full advantage of user-defined types (UDTs), query notifications, promotable transactions, and multiple active result sets (MARS)
- Using SQL Management Objects (SMO), SQL Service Broker, and SQL Server Notification Services to build integrated applications
L'auteur - Bob Beauchemin
Bob Beauchemin has more than twenty years' experience in the computer industry as an instructor, course author, software developer, and systems administrator. He currently is a senior staff instructor at DevelopMentor, curriculum liaison for the data access curriculum, and author of courses on ADO.NET, OLE DB, ADO, SQL Server application development, and Java Data Access. He has designed and implemented data-driven Web sites, as well as traditional data access applications for many different clients.
L'auteur - Dan Sullivan
Dan Sullivan, Director of Data Warehousing at Computer Resource Team Inc., designs business intelligence solutions for a variety of industries. He has 15 years of experience in developing natural language processing and database applications and is widely published on data warehousing and text analysis for business intelligence.
Autres livres de Dan Sullivan
Sommaire
- Figures
- Tables
- Foreword by Roger Wolter
- Foreword by Gert E. R. Drapers
- Preface
- Acknowledgments
- About the Authors
- Introduction
- Hosting the Runtime: SQL Server As a Runtime Host
- Procedures and Functions in .NET CLR Languages
- In-Process Data Access
- User-Defined Types and Aggregates
- Security
- SQL Engine Enhancements
- T-SQL Language Enhancements
- XML in the Database: The XML Data Type
- XML Query Languages: XQuery and XPath
- SQL Server Service Broker 481
- SQL Server As a Platform for Web Services
- SQL Server 2005 and Clients
- ADO.NET 2.0 and SqlClient
- SQL Server Management Objects
- Notification Services
- Wrap-Up: Service-Oriented Database Applications
- Appendix A .NET Framework 101
- Appendix B SQL Server Management Studio
- Appendix C Visual Studio 2005 Integration: SQL Server Projects
- References
- Index
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Addison Wesley |
| Auteur(s) | Bob Beauchemin, Dan Sullivan |
| Collection | Microsoft .Net Development Series |
| Parution | 11/05/2006 |
| Nb. de pages | 998 |
| Format | 18 x 23,5 |
| Couverture | Broché |
| Poids | 1550g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780321382184 |
| ISBN13 | 978-0-321-38218-4 |
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
