Customer Reviews

12
4.0 out of 5 stars
Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET
Format: PaperbackChange
Price:$40.88 + Free shipping with Amazon Prime
Your rating(Clear)Rate this item


There was a problem filtering reviews right now. Please try again later.

11 of 12 people found the following review helpful
on June 13, 2006
Format: Paperback
This book contains much useful information on SQL Server 2005 T-SQL enhancements, but it regularly employs functions and constructs in its examples that are only explained in later passages. Specifically, when attempting to absorb a new concept by examining a code example, you must also contend with looking up items which have not yet been covered. This is a mild stumbling block but it hurts the flow of the book.

Also, the practice database (Asset5) did not attach properly (on my SQL Server 2005 STD edition install regarding appropriate permissions to modify objects) and the most direct workaround was: (1) To use the included, but unreferenced script to initialize the database and all its objects using a "new name" for the database (2) Attach the original database - Asset5 (3) Use the data import feature to populate the "new name" database tables (4) Drop the attached database Asset5 (5) Rename the "new name" database to Asset5. I did first attempt to modify the permissions associated with the login I was using - unsuccessfully...

By way of comparison I am using Oracle Press' "Oracle 9i The Complete Reference" by Koch and Loney as a standard of clarity and conceptual organization for PL-SQL. It is on this basis that I assign this book 3 stars, but admit that I have yet to discover a better book for advanced T-SQL topics. Please feel free to forward me better titles.

As an aside, Murach's SQL for SQL Server is the best introductory text I have found for T-SQL.
11 commentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
7 of 8 people found the following review helpful
Format: Paperback
In SQL Server 2005 Stored Procedure Programming, Dejan Šunderic describes practical uses of T-SQL stored procedures well beyond the level of coverage reached by most other books dealing with SQL Server 2005, including the book on T_SQL programming by Itzik Ben-Gan, et al. Microsoft's documentation, while thorough, is useful mainly to provide reminders when one already knows the the structure.

Šunderic describes some of the interactions between SQL Server 2005 and Visual Studio languages, including of course the SQL Server 2005 techniques for using these languages to write stored procedures, but also showing how to use Visual Studio 2005 as a debugger for stored procedures written in T-SQL.

It would probably have been helpful for many readers had Šunderic described the main access classes that the Visual Studio languages provide to reach SQL Server, that is, the SqlConnection, SqlCommand, SqlParameter and SqlDataReader classes. This topic is missing or barely mentioned in every current book on SQL Server and the .NET and Visual Studio technologies.

It would also been of use to many readers had Šunderic shown examples utilizing some of the key improvements in SQL Server 2005, for example generating lightweight cursors on table variables and implementing messaging. Both are likely to involve stored procedures. A messaging discussion almost starts in the final chapter, where Šunderic seems to be running out of steam.

Overall, Šunderic has written an informative and helpful book that substantially augments information available from other books and from Microsoft documentation.
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
2 of 2 people found the following review helpful
on June 10, 2006
Format: Paperback
This book is a great help for beginners or those transferring from the SQL 2000 to SQL 2005. Well-written and comprehensive with detailed guidelines for DBAs and developers, it helps answer any questions one might have in their day to day work with SQL server. You will find great tips and useful examples; a great way to expand your knowledge of stored procedures, new functions used in SQL 2005, and offers a means of combatting common errors. Highly recommended!
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
1 of 1 people found the following review helpful
on September 5, 2008
Format: PaperbackVerified Purchase
Like many IT and programming books, this one is no exception in that it seems to be riddled with small errors - things like showing a database schema and then referring to a table by an incorrect name. The most problematic issue with errors like this is that details really matter in these technical fields and it results in a "not ready for prime time" feel to the work. However, if the writer's teaching style appeals to your learning style, then go ahead, because at the end of the day that's what's most important.
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
2 of 3 people found the following review helpful
Format: Paperback
I got this book as a present and started reading it immediately upon receiving it. I read it from cover to cover in about 2 nights. It lays next to my computer at work for constant reference. [...]

It is very informative and very well laid-out. I never once was lost and wondered what the author was talking about. It's vocabulary and grammer are just right for the advanced programmer to the programming newb.

I was able to excel my sql server skills very quickly with the help of this book. I suggest buying this book to all sql programmers new and old.
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
Dejan Sunderic, Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL and .NET (McGraw-Hill, 2006)

Not a bad little book, this, though if you've had to dig into SQL2005 for work you're likely to have picked up on a good deal of this already. Still, Sunderic digs down into a number of places where most developers either don't normally have a reason to go or simply fear to tread. You're sure to find things in here you've overlooked (or never thought to look for) unless you're a guru, and even then there might be a [...]bit or two. For someone who just got thrust into "we're upgrading!", it's been great. *** ½
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
on January 30, 2008
Format: Paperback
First off I know the author personally. In spite of that, the book definitely stands solidly on its own merits. This book is shock full of tips, tricks, angles and perspectives to maximize the use of stored procs in your SQL databases. Dejan really goes under the covers to the many aspects of SQL and the reader is the richer for it. This is a very important how to and reference for any serious SQL developer. You will go back to this book again and again. Highly recommended!
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
on August 12, 2006
Format: Paperback
The best SQL 2005 book for developers that I've seen so far!

Very clear content and easy to upgrade your knowledge from SQL 2000. While the book is focused on the new Features of SQL Server 2005 it addresses also non-new features.

I especially like the tips and samples which are tailored for "real life"

The .Net samples are part in C# and part in VB. I wish they were all in C#.

Highly recommended for any SQL 2005 developer!
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
3 of 5 people found the following review helpful
on May 3, 2007
Format: Paperback
If you are looking for a good review of exisiting as well as new features available for T-sql and stored procedures in SQL Server 2005 , then this book will start you in the right direction. The author has many examples and useful insights peppered throughout the book. I do wish though that he used the AdventureWorks database instead of his own since Adventureworks is the new demo database provided by Microsoft.
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
2 of 4 people found the following review helpful
on January 22, 2009
Format: Paperback
Be advised that in this book, the author is in a hurry to get to advanced concepts. Only the first three chapters could be called basic. After that, it quickly climbs to advanced material before (in my opinion) sufficiently covering basic and intermediate material. By Chapter 14, the subject is, "Advanced Stored Procedure Programming". But I still can't find what I need in 1-3. Then, as if it is even more advanced, the next subject (Chap 15) is "Debugging". Please, when will we have an author who sees that debugging is a progressively learned process? Perhaps there should be a section in a chapter early on covering debugging of basic stuff.

My background as a programmer of relational databases and writing SQL statements goes back over fifteen years. As my reports and SQL statements have gotten more complex to please the customer, I have had to move into writing stored stored procedures to meet the need for speed. My intent was to get a book that would help me get my SQL statements to work as Stored Procedures. This book appeared to match my customer's software make-up (MS SQL Server, Stored Procedures, .Net, T-SQL, etc) as well as being written in a fairly straightforward and easy to understand manner (it does get a big plus on that!). But if you haven't been writing stored procedures for a year or more, and you have little staff assistance where you are, I would not recommend this book. If on the other hand, you have been doing SP's for a few years or have lots of staff help and want to go the next step, this book may be for you. I'm going to get another one that will help get the basics to work.
11 commentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
     
 
Customers who viewed this also viewed
The Guru's Guide to SQL Server Stored Procedures, XML, and HTML
The Guru's Guide to SQL Server Stored Procedures, XML, and HTML by Ken Henderson (Paperback - January 6, 2002)
$41.14

Pro T-SQL 2012 Programmer's Guide (Expert's Voice in SQL Server)
Pro T-SQL 2012 Programmer's Guide (Expert's Voice in SQL Server) by Rudi Bruchez (Paperback - September 24, 2012)
$47.49

Beginning Microsoft SQL Server 2012 Programming
Beginning Microsoft SQL Server 2012 Programming by (Software engineer) Paul Atkinson (Paperback - April 16, 2012)
$27.70
 
     

Send us feedback

How can we make Amazon Customer Reviews better for you?
Let us know here.

Your Recently Viewed Items and Featured Recommendations 
 

After viewing product detail pages, look here to find an easy way to navigate back to pages you are interested in.