SQL Server 2005 Assemblies Revealed
1st Edition
Published on 15. October 2005
Book
Paperback/Softback
300 pages
978-1-59059-412-4 (ISBN)
Description
This book is a preview of Microsoft's SQL Server 2005 database. SQL Server 2005 is completely.NET integrated, allowing developers to program in any.NET language, conveniently inside the database. This book is a first look at and illustrates the new.NET capabilities of the database. This book has strong appeal to three core audiences: SQL Server developers,.NET developers, and database administrators. After reading this book, developers will be able to build robust, useful and intelligent assemblies that are safe to execute and secure for the organization. TOC:Introduction.- Building.NET Assemblies: Best Practices.- Security and Execution Contexts.- Error Handling.- Stored procedures.- User Defined Functions.- User Defined Data Types.- User Defined Aggregations.- Extending Triggers.- Using XML.- Appendix A:.NET Primer.- Appendix B: C# Code Examples.
More details
Edition
1., Ed.
Language
English
Place of publication
New York
United States
Target group
Professional and scholarly
College/higher education
Beginner-intermediate-advanced, audience: SQL Server developers and DBAs
Dimensions
Height: 235 mm
Width: 178 mm
Thickness: 15 mm
ISBN-13
978-1-59059-412-4 (9781590594124)
Schweitzer Classification
Persons
Robin Dewson has been hooked on programming since he bought his first computer in 1980, a Sinclair ZX80. Dewson's first creation was a Visual FoxPro application that could run a Fantasy League system, and realized the importance of being both GUI- and database-conscious. Dewson started working closely with Visual Basic, versions 5 to.NET, and worked simultaneously with SQL Server 6.5, through the current SQL Server Yukon, participating in several SQL Server betas along the way. Dewson authored Beginning SQL-Server 2000 Programming, and has co-authored and contributed to numerous other books. Dewson is a consultant mainly in London, and has been there for nearly 8 years. He has also been developing a rugby related website, as well as his own personal site at, www.fat-belly.com.
Content
1. Introduction2. Building .NET Assemblies: Best Practices3. Security and Execution Contexts4. Error Handling.5. Stored procedures6. User Defined Functions7. User Defined Data Types8. User Defined Aggregations9. Extending Triggers10. Using XMLAppendix A: .NET PrimerAppendix B: C# Code Examples