| Welcome to vBulletin FAQ |
vBulletin FAQ Navigation
Getting Started
Customizing your vBulletin
Search Engines & SEO
Making Money with a Forum
Promoting your Community
|
| Get your own vBulletin Today |
|
| Webmaster Help |
|
|
|
Programming SQL Server 2005
vBulletin Book Store > vBulletin books beginning with P
|
Programming SQL Server 2005 |
Author: Bill Hamilton
Published: 2006-02-21 |
List price: $54.99
Our price: $34.64
|
Usually ships in 1 to 2 months
As of: November 20th, 2008 01:01:52 PM
|
|
|
Customer comments on this selection.
 Very definitive guide to sql server programming. Topics are up-to-date and well covered.
This book covers nearly all topics on SQL Server programming. It begins with the differences between the SQL Server 2000 and 2005. 2005 has new tools (SSMS, Profiler, BIDS, command line), data types, xml support, and .NET integration. Chapters 1-4 go over these topics in turn. The next series shows the reader how to program using the Visual Studio IDE, deal with XML programming, and web services (Chaptes 5-8). Chapters 9-14 are on programming SQL Server management and reporting tools plus interfacing with the objects exposed by SQL Server through .NET. The remaining chapters are on programming services: SS agent, intergrations services, broker, notification services, and analysis services.
br /
br /The book is quite thourough and has a large number of examples, code, and pictures for each topic. The book is generally easy to read and well indexed. Programmers will feel right at home with all the extra help provided by the book.
br /
br /Folks who have no programming experience of any kind will likely struggle with the information in the book. Basic SQL is shown but not explained. It is clear the book is meant for people programming and/or automating SQL Server topics rather than just running basic queries. That being said, the chapter on XML was very helpful even from just a querying point of view. Using XML as a bulk load technique was particuarly useful and turned out to be very fast when loading text based data to the server. Querying XML data was covered by using both FOR XML statements and using XQuery type statements. The chapter sovering SSIS was also very useful as there is not much material on SSIS yet.
br /
br /This book is a must have for SQL Server DBAs, programmers, and professionals.
 Boring and inaccessible
This book is very inaccessible, not because it is too complex, but because it is poorly written. If you'd like to actually learn SQL Server programming I'd recommend Professional SQL Server 2005 Programming (Programmer to Programmer).
 A Great Book for Learning New Features - Review of Database Administrator SQLAuthority.com
User does not have to be experience SQL Server 2005 programmer to use this book; as it is designed for users of all levels. This book also suggests that user does not have to be experienced with SQL Server 2000. However, I disagree with that. This book only covers new features of SQL Server 2005. Understanding of fundamental relational database concepts is helpful to digest and accept the concepts introduced in this book.
br /
br /This book covers following perspective of SQL Server 2005 new features.
br /* Tools and utilities
br /* Data types
br /* T-SQL enhancements
br /* Programmability enhancements
br /* XML support
br /* Native XML web services
br /* SQL Management Objects
br /* SQL Server Integration Services
br /* SQL Server Reporting Services
br /* SQL Server Notification Services
br /* SQL Server Service Broker
br /* Replication Management Objects
br /* SQL Server Agent
br /* SQL Server Mobile Edition
br /
br /The code used in the book is available for download on O'Reilly web site. I always like this as I really do not like to retype examples from the book. Most of the examples of this book use C# code and Visual Studio 2005. One good thing about this book is it uses AdventureWorks sample database, I always prefer book which uses samples database which comes along the SQL Server, this makes it easily useable by developer. This book is also Safari enabled.
br /
br /Appendix of this book has in depth explanation of the ADO.NET 2.0, which can be quite useful to users interested in the topic. There are very few good books which covers this topic such in depth.
br /
br /Rating: 4 stars
br /
br /Summary: This book is quite good for new learning; I enjoy reading it and learning new concepts from this book.
br /
br /Pinal Dave
br /Principal Database Administrator
br /(blog.sqlauthority.com)
One of the best SQL Server programming book.
This is definitely one of my best SQL programming books. It covers the newer programming concepts; such as XML storage and handling in SQL 2005, very well.
br /
br /I would definitely recommend this book to anyone who is serious about SQL Server 2005 programming.
br /
br /It also covers CLR programming in SQL Server. Good book.
Not for the faint of heart
As a new student to the field of SQL Server 2005, I was hoping to obtain a book learning the various methods of programming in SQL Server 2005. I was initially hearted by the first paragraph in the preface:
br /
br /"You don't need to be an experienced SQL Server 2005 programmer to use this book..."
br /
br /which is indeed the case if you intend to use it as a paper weight.
br /
br / The book suspiciously looks like the syntax guide found in most MS products: the procedure name and inputs followed by a description of the inputs. It is not for the beginner/intermediate learner and is somewhat of a disappointment comming from the O'Reilly range ("SQL on SQL Server 2005" is an excellent counter point to the book being reviewed from the same publisher). This book serves mainly as a reference (which on page 7, it clearly states that it is not a reference) to new doctrine in the SQL Server evolution.
|
|
Our vBulletin book picks:
|
|
Find more vBulletin related products of interest.
|
