Print Book $49.99
Safari Books Online
Print Book £35.50
Looking to Reprint this content?
By Bill Hamilton
First Edition
February 2006
Pages: 586
ISBN 10: 0-596-00479-6 |
ISBN 13: 9780596004798
(Average of 2 Customer Reviews)
Ideal for IT professionals of all stripes, this authoritative guide introduces all facets of SQL Server 2005, Microsoft's next-generation data management and analysis solution. The book explains all of its new features, and shows you how they can help conquer a variety of data challenges. Learn how to reduce the complexity of building, deploying and managing database applications, and much more.
Full Description
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.
Cover | Table of Contents | Colophon
Featured customer reviews
it's great book - also would like the VB, May 28 2008
Submitted by jruder [Respond | View]
Thank you! I agree, to not have both examples now days is really unacceptable. Yes, I can convert it on my own - but I should not have to. I am not a C# programmer - at least give me the code on the website (like nearly every other book out there does)
Excellent reference on programming SQL Server. Very broad coverage., November 13 2007
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.
it's great book, July 09 2006
Programming SQL SERVER 2005 book is very excellent book , but i hope from o'reilly to publish book about sql server 2005 put the examples with visual basic 2005 , not c# 2005 .
Media reviews
"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."
-- Jerry Dixon, JerBear's Lair
"The goal of Programming SQL Server 2005 is to provide you the resource that you need to learn the ins and outs of programming SQL Server 2005. Its premise is that you do not need to know programming in SQL 2000 — which is so radically different than the new version — in fact, just a basic understanding of SQL is required...What it does do well, very well in fact, is to introduce all of the things new to 2005. Obviously, to go into detail of all the topics here would require five volumes. I think that this book is a perfect volume for the person who has worked with and is comfortable with SQL Server 2000 and now wants to learn 2005. While it will be good for those with SQL knowledge and no experience with any Microsoft SQL Sever platform, they may want to also get Learning SQL on SQL Server 2005 also by O'Reilly to fill in some of the gaps."
-- T. Michael Testi, Blogcritics Magazine
Read all reviews
About O'Reilly | Contact | Jobs | Press Room | How to Advertise | Privacy Policy
|
© 2008, O'Reilly Media, Inc. | (707) 827-7000 / (800) 998-9938
All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners.