Pro SQL Server 2005 (Paperback)

~ Thomas Rizzo (Author), (Author), (Author), Rob Walters (Author), (Author), Julian Skinner (Author), Louis Davidson (Author)
Key Phrases: database master key, database mirroring, transparent client redirection, Reporting Services, Management Studio, Visual Studio (more...)

Editorial Reviews

Product Description

SQL Server 2005 is a landmark release of Microsoft's powerful relational database management system for the Windows platform, and one that will change the way you architect your data systems and develop your data-driven applications. Pro SQL Server 2005 takes a deep look at the full range of SQL Server enhancements, and includes meaningful and relevant examples showing how these new features work and how you can build applications effectively. This book provides a critical examination of all of the major new functionality in SQL Server 2005, covering topics that are essential for DBAs and developers alike, including:

* T-SQL programming

* CLR integration and assembly programming

* Using SQL Server Integration Services for data extraction, transformation, and loading

* The new native XML datatype and how to use it

* Security enhancements and Service Broker SQL Server 2005 is a vast new release and each author provides practical, in-depth coverage of the core topics in their specialist areas – always illustrated with realistic examples. As a result, you'll be able to work on your own SQL Server 2005 solutions quickly and painlessly. Ultimately, this book provides you with a starting point, a roadmap, and then the tools and knowledge to exploit this powerful new database to its fullest extent. So, sit back, fire up your computer and your brain and get ready to learn SQL Server 2005.

About the Author

Thomas Rizzo

Tom Rizzo, the lead author, is a director in the SQL Server group at Microsoft. Being an eleven year veteran at Microsoft, Tom has worked on a number of the different Microsoft server technologies such as BizTalk, SharePoint and Exchange Server before joining the SQL Server group. Tom is a published author on topics ranging from SQL Server to developing collaborative applications using Microsoft’s collaboration servers.

Adam Machanic

Adam Machanic is a database-focused software engineer, writer, and speaker based in Boston, Massachusetts. He has implemented SQL Server for a variety of high-availability OLTP and large-scale data warehouse applications, and also specializes in .NET data access layer performance optimization. He is a Microsoft Most Valuable Professional (MVP) for SQL Server and a Microsoft Certified Professional (MCP).

Julian Skinner

Julian Skinner studied Germanic etymology to PhD level before becoming a technical editor, first at Wrox Press, then at Apress. Recently he has focusing on development and writing in Microsoft technologies and, in particular, on C# and the .NET Framework. He is co-author of Professional ADO.NET, Professional ASP Data Access, and A Programmer's Guide to SQL.

Louis Davidson

Louis Davidson has been in the information technology industry for ten years, as a corporate database developer and architect. Currently, he is serving as a Database Administrator for Compass Technology Management, supporting the Christian Broadcasting Network and NorthStar Studios in Nashville, TN. Louis' primary areas of expertise are in database architecture and coding in Transact-SQL, and he is currently writing Pro SQL Server 2005 Database Design and Optimization.

Robin Dewson

Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years.Jan D. Narkiewicz

Jan D. Narkiewicz is chief technical officer of Software Pronto, Inc. His areas of expertise include Microsoft technologies, Oracle, and DB2. Jan also write books for Apress and serves as academic coordinator for U.C. Berkeley Extension’s .NET/Windows program. His clients include E*Trade, Visa, eBay, and Oracle.

Joseph Sack

Joseph Sack is a database administration and developer based in Minneapolis, Minnesota. Since 1997, he has been developing and supporting SQL Server environments for clients in financial services, IT consulting, manufacturing, and the real estate industry. Joseph received his bachelor's degree in psychology from the University of Minnesota. He is the author of "SQL Server 2000 Fast Answers for DBAs and Developers", the co-author of "Beginning SQL Server 2000 DBA: From Novice to Professional" and is a Microsoft Certified Database Administrator (MCDBA).

Rob Walters

Rob Walters is a program manager in the SQL Server group of Microsoft. He has seven years of experience in software development and relational databases.

Product Details

• Paperback: 704 pages
• Publisher: Apress (November 2, 2005)
• Language: English
• ISBN-10: 1590594770
• ISBN-13: 978-1590594773
• Product Dimensions: 9.2 x 7 x 1.5 inches
• Shipping Weight: 2.4 pounds (View shipping rates and policies)
• Average Customer Review: 3.8 out of 5 stars  See all reviews (11 customer reviews)
• Amazon.com Sales Rank: #371,027 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #5 in

  Books > Teens > Authors, A-Z > ( T ) > Thomas, Rob

Customer Reviews

Most Helpful Customer Reviews

36 of 38 people found the following review helpful:

4.0 out of 5 stars New features for sql server 2005 but not pro, December 3, 2005

By	.Net learner ".Net learner" (USA) - See all my reviews

This books seems to be a list and quick summary of new features of sql server 2005. I like the fact that the authors do make an attempt to explain why the new features are present and how to use them. However I would not call it a professional book since it does not dive into depth in any one particular feature on how to take advantage of these features and how to implement something like it in a production environment. All we have is short demo samples which is good for explaining but not really helping the dba/developer integerate it with their existing systems and applications as seen in more advanced/architecture books.

I fell asleep a few times whilst going thru this book. It could do with alot more pictures too to keep the motivation going

A very good intro to sql server 2005 but you still going to need to buy a book for each topic/chapter on this book to be competent user since there simply isn't enough information/examples in it

22 of 23 people found the following review helpful:

3.0 out of 5 stars A medium-value overview of SqlServer 2005, December 2, 2005

By	Pagliei Carlo "paco" (Italy) - See all my reviews (REAL NAME)

This book is a medium-value overview of the SqlServer 2005 new features. The overview is complete but the book does not goes in depth as I expected. I also don't like the writing style that is not very clear (for instance the APPLY Statement explanation is really poor) and the exposition that mixes DBAs related topics with Developers-Related topics.
If you're searching for a quick overview of all new topics this is a good starting point, but don't expect to became a SQL new features expert.

24 of 30 people found the following review helpful:

2.0 out of 5 stars Not what I was looking for, March 8, 2006

By	Farquar McGuillicuddy (Minneapolis, MN USA) - See all my reviews

If you're looking for a "what's new in SQL Server 2005" this book covers that. If you're looking for a reference book on the product, that goes into how to configure or upgrade from an earlier version--Keep Looking.

The book explains new features in some detail. But, I want to know how to place the databases in a specific directory, how to set up replication--not mirroring; and how to install the software remotely. The book does not discuss any of that.