|
Programming SQL Server 2005 |  | Author: Bill Hamilton
Publisher: O'Reilly Media
Category: Book
List Price: $54.99
Buy Used: $0.48
as of 9/8/2010 12:21 CDT details
You Save: $54.51 (99%)
New (14) Used (17) from $0.48
Seller: gr8lakesbooks1
Rating:  13 reviews
Sales Rank: 263065
Media: Paperback
Edition: 1
Pages: 600
Number Of Items: 1
Shipping Weight (lbs): 1.8
Dimensions (in): 9 x 7 x 1.4
ISBN: 0596004796
Dewey Decimal Number: 005.2768
EAN: 9780596004798
ASIN: 0596004796
Publication Date: February 21, 2006
Availability: Usually ships in 1-2 business days
| |
| Similar Items:
| |
| Editorial Reviews:
Product Description
SQL Server 2005, Microsoft's next-generation data management and analysis solution, represents a huge leap forward. It comes with a myriad of changes that deliver increased security, scalability, and power--making it the complete data package. Used properly, SQL Server 2005 can help organizations of all sizes meet their data challenges head on. Programming SQL Server 2005 from O'Reilly provides a practical look at this updated version of Microsoft's premier database product. It guides you through all the new features, explaining how they work and how to use them. The first half of the book examines the changes and new features of the SQL Server Engine itself. The second addresses the enhanced features and tools of the platform, including the new services blended into this popular version. Each chapter contains numerous code samples-written in C# and compiled using the Visual Studio 2005 development environment-that show you exactly how to program SQL Server 2005. Programming SQL Server 2005 can help you: - Build, deploy, and manage enterprise applications that are more secure, scalable, and reliable
- Maximize IT productivity by reducing the complexity of building, deploying, and managing database applications
- Share data across multiple platforms, applications, and devices to make it easier to connect internal and external systems
Because the goal of Programming SQL Server 2005 is to introduce all facets of Programming SQL Server 2005, it's beneficial to programmers of all levels. The book can be used as a primer by developers with little experience with SQL Server, as a ramp up to the new programming models for SQL Server 2005 for more experienced programmers, or as background and primer to specific concepts. Any IT professional who wants to learn about SQL Server 2005's comprehensive feature set, interoperability with existing systems, and automation of routine tasks will find the answers in this authoritative guide.
|
| Customer Reviews:
Showing reviews 1-5 of 13
 Very Informative and Easy to Read May 6, 2006
Jerry Dixon
6 out of 6 found this review helpful
This book is an easy-to-read tutorial on many of the new features of SQL Server 2005. It covers the expected topics, such as T-SQL Enhancements, HTTP Endpoints (Web Services), CLR Integration, and the XML data type. I was pleased to discover, however, that it also does a good job of explaining the often left-out features such as SQL Server Management Objects (SMO), SQL Server Integration Services (SSIS), and Analysis Services. (There are three chapters on SMO alone!) There is even a chapter on using SMO to program the SQL Server Agent service. That's an extra that I haven't seen before.
One of the things that I really liked about this book was the writing style. Reading it didn't feel like a chore. I wound up reading a bit of it each night after work, in order to relax. This is fairly unusual for me, as I typically get more than enough exposure to SQL during the day.
I was quite pleased with this book. I am a Microsoft Certified Trainer, and have been teaching classes on SQL Server 2005 for over a year. Therefore, I've seen numerous books and classes on SQL 2005. In my mind, this book stands out from the pack.
Must-have book! April 15, 2006
M. Strader
5 out of 5 found this review helpful
This book provides a clear, concise walkthrough about programming all aspects of SQL Server 2005. Numerous code samples are included that can be downloaded from the O'Reilly web site. The book contains excellent coverage of programming CLR routines, XML support, native Web services support, and SQL Server Management Objects (SMO) (which replaces DMO). I also found the sections about topics such as Notification Services, replication, Reporting Services, and Integration Services helpful. These topics are new to me and I now both understand them and have been able to program solutions.
As a previous reviewer correctly mentioned, this book only covers new T-SQL features. I actually prefer this since I already know T-SQL (and there are already a lot of good T-SQL books available). The coverage of new T-SQL features is complete and the examples are good.
This book includes an appendix that explains the new features of ADO.NET 2.0. The writing and examples are clear and helped me understand the changes and enhancements. It's great that the author chose to include this since programming ADO.NET 2.0 is related to programming SQL Server 2005 but not the same thing at all.
Finally, I really like that this book does not simply recycle MSDN content, but rather complements it. There is enough reference material in the book to support the discussion and examples. After reading the book, you'll know enough about programming SQL Server 2005 to quickly find any reference material that you need in MSDN.
A very precise book August 23, 2006
SPYRIDON PRANTALOS (Miami, FL USA)
2 out of 2 found this review helpful
This is a very good book. It is quite compact and does not waste time and pages on huge examples that would not make any sense at the end. The only issue, at least for me, is that it includes only the new features of the Sql Server. As a result if you are a beginner with SQL Server you need to buy an introductory book before you read this one.
Very definitive guide to sql server programming. Topics are up-to-date and well covered. November 13, 2007
J. Druin (Kentucky, USA)
1 out of 1 found this review helpful
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.
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.
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.
This book is a must have for SQL Server DBAs, programmers, and professionals.
Very easy to implement SMO from scratch October 7, 2006
P. Davallou
2 out of 3 found this review helpful
Having never written C# or C++ or DMO, I was able to quickly read parts of this book and successfully create a C# program using SMO/RMO to create my transactional / merge replication republishing environment. I had little experience using Visual Studio. I've been focused on T-SQL for SQL development for the past 8 years as a development DBA. When I looked for a book to quickly bring me up to speed in SMO/RMO, I chose this book because it is explicit and gives great examples. I look forward to using it for Reporting and Notifications. It makes learning new SQL 2005 skills exciting!
Showing reviews 1-5 of 13
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. Copyright 2008, SQL Server 2005 Books. All Rights Reserved. In association with Amazon.com | |
