Pro SQL Server 2005 Assemblies (Expert's Voice) and over 2 million other books are available for Amazon Kindle . Learn more

Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Start reading Pro SQL Server 2005 Assemblies (Expert's Voice) on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Pro SQL Server 2005 Assemblies (Expert's Voice) [Paperback]

Robin Dewson , Julian Skinner
5.0 out of 5 stars  See all reviews (1 customer review)
RRP: £39.49
Price: £33.84 & FREE Delivery in the UK. Details
You Save: £5.65 (14%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon. Gift-wrap available.
Want it tomorrow, 12 July? Choose Express delivery at checkout. Details


Amazon Price New from Used from
Kindle Edition £32.15  
Paperback £33.84  

Book Description

1 Oct 2005 Expert's Voice
SQL Server 2005 is the forthcoming release of the Microsoft's SQL Server database. SQL Server is currently the most popular database on the Windows platform. In 2002 it had 45% of the Windows database market, compared to 27% for Oracle, and its market is growing. [Source: Gartner Report, May 2003]. In many people's eyes, the biggest advancement in SQL Server 2005 is the inclusion of the Common Language Runtime, or CLR, within the database. As a result, developers are no longer restricted to use of Transact-SQL to write stored procedures, functions and triggers. They can now create these objects using any of the .NET languages (C#, VB.NET, C++ . . . ) and compile them into .NET assemblies in the database. In theory, assemblies provide the "best of both worlds" The code can be hosted in the secure, environment of the database, delegating memory management, garbage collection and thread support to the robust database engine, while exploiting .NET's computational power, advanced data type support, and rich array of built-in classes. The book provides an in-depth tutorial on building and using assemblies. It will focus on building assemblies in C# code, but will provide the equivalent VB.NET code in the code download. Alongside this tutorial comes a detailed examination of exactly when assemblies should and should not be used. Assemblies are not a complete replacement for T-SQL stored procedures and triggers, but are enhancements, to be used at the right place at the right time. After reading this book, the reader will be able to build robust, useful and intelligent assemblies that are safe to execute and secure to the organization.

Special Offers and Product Promotions

  • Spend £30 and get Norton 360 21.0 - 3 Computers, 1 Year 2014 for £24.99. Here's how (terms and conditions apply)

Product details

  • Paperback: 296 pages
  • Publisher: Springer (1 Oct 2005)
  • Language: English
  • ISBN-10: 1590595661
  • ISBN-13: 978-1590595664
  • Product Dimensions: 23.2 x 18.8 x 1.8 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: 952,420 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description

About the Author

Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. His first main application of his own was a Visual FoxPro application that could be used to run a Fantasy League system. om Visual Foxpro he realized the importance of being not only GUI aware but also database aware and he continued his development quest, working hand-in-hand with Visual Basic from version 5 through to .NET. At the same time he started working with SQL Server 6.5 through to the current SQL Server 2005. He has actively participated in several betas of SQL Server. With this cross knowledge he has seen how well these two technologies will bring great expansion of SQL Server as a database. Robin is a consultant mainly in the City of London where he has been for nearly 8 years but also has been developing a rugby related website as well as his own site at He is also an author and co-author of several books such as Beginning SQL Server 2000 Programming (Wrox, ISBN: 1-86100-523-7), SQL Server 2000 Stored Procedure Handbook (Wrox, ISBN: 1-86100-825-2), Visual Basic .Net Windows Services Handbook (Wrox, ISBN: 1-86100-772-8) Julian Skinner studied Germanic etymology to PhD level before joining Wrox Press as an indexer in 1998 in order to get a real job. He became a technical editor shortly after that, later working as a technical architect and commissioning editor, before moving to Apress in 2003 when Apress bought most of Wrox. He has consequently spent most of the last six years reading books about programming, focusing in particular on Microsoft technologies and, since 2000, on C# and the .NET Framework. He recently left Apress to concentrate on writing code. He contributed many sections and code samples, and often whole chapters

Inside This Book (Learn More)
Explore More
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

4 star
3 star
2 star
1 star
5.0 out of 5 stars
5.0 out of 5 stars
Most Helpful Customer Reviews
5.0 out of 5 stars Pro SQL Server 2005 Assemblies 16 Sep 2011
Very helpful! Using it as a reference. Good examples.
It will help me to write more CLR code, which is needed since TSQL is missing a lot of features.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on (beta) 5.0 out of 5 stars  2 reviews
7 of 8 people found the following review helpful
5.0 out of 5 stars A great book 17 Mar 2006
By North Providence RI - Published on
Do not be mistaken the book is NOT a light read but the knowlege that the author is able to impart is fantastic.

I found the first part of the book really informative especially the parts dealing with User Defined Functions and the User Defined Data types.

One must try out the examples in order to glean the most from the book. The last chapter's examples involve the use of Web Services. This is a must!!

Over all I would really recommend the book to the SQL Server Developer.
3 of 4 people found the following review helpful
5.0 out of 5 stars Packed with examples geared to common business problems and solutions 4 April 2006
By Midwest Book Review - Published on
The ability to run .NET code within the database makes SQL Server even more valuable - and the need for Pro SQL Server 2005 Assemblies even more obvious. Here's a guide to building each type of SQL Server assembly, packed with examples geared to common business problems and solutions, and tips on accessing external data sources and web services. Code projects in C# and Visual Basic are available from the Apress web site, making this expert's guide even more useful.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category