Pro SQL Server 2005 and over one million other books are available for Amazon Kindle. Learn more

Buy New

or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
Buy Used
Used - Very Good See details
$5.23 & eligible for FREE Super Saver Shipping on orders over $25. Details

or
Sign in to turn on 1-Click ordering.
 
   
More Buying Choices
Have one to sell? Sell yours here
Pro SQL Server 2005
 
 
Start reading Pro SQL Server 2005 on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Pro SQL Server 2005 [Paperback]

Thomas Rizzo (Author), Adam Machanic (Author), Robin Dewson (Author), Rob Walters (Author), Joseph Sack (Author), Julian Skinner (Author), Louis Davidson (Author)
3.8 out of 5 stars  See all reviews (11 customer reviews)

List Price: $49.99
Price: $26.66 & this item ships for FREE with Super Saver Shipping. Details
You Save: $23.33 (47%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
Want it delivered Tuesday, January 31? Choose One-Day Shipping at checkout. Details

Formats

Amazon Price New from Used from
Kindle Edition $23.99  
Paperback $26.66  

Book Description

Pro November 7, 2005

SQL Server 2005 is next generation of SQL Server database and represents a massive leap forward for SQL Server developers in terms of programming options, productivity, database management and analysis. This book will take a deep look at the full range of SQL Server enhancements that will give meaningful and relevant examples that show not just how these new features work, but also how to architect their applications in order to exploit the new features most effectively.

This book is all about getting developers working on their own SQL Server 2005 solutions as quickly and painlessly as possible. Some of the core topics covered in the book are: Enhancements to database programmability features and languages, such as ADO.NET, XML, .NET assemblies, and T-SQL; New Servers, services and tools such as Reporting Services, and the Service Broker and DTS; Enhancements to the BI capabilities such as Analysis Services and Notification services.


Frequently Bought Together

Customers buy this book with Beginning SQL Server 2005 for Developers: From Novice to Professional (Expert's Voice) $49.99

Pro SQL Server 2005 + Beginning SQL Server 2005 for Developers: From Novice to Professional (Expert's Voice)


Editorial Reviews

About the Author

Thomas Rizzo

Tom Rizzo, a director of product management in SQL Server, has been at Microsoft for nine years. Before joining the SQL Server team, Tom worked with e-business servers, including BizTalk Server and Commerce Server, as well as Microsoft Exchange Server. He is also the author of three Microsoft Press books about programming solutions on Microsoft's collaboration platform.

Robin Dewson

Robin Dewson has been hooked on programming ever since he bought his first computer in 1980. His first main application of his own was a Visual FoxPro application that could be used to run a Fantasy League system. From there, realizing that the market place for Visual FoxPro in the United Kingdom was limited, decided to learn Visual Basic and SQL Server. Starting out with SQL Server 6.5 he soon moved to SQL Server 7 and Visual Basic 5 where he became involved in developing several applications for clients both in the UK and the US.

From there he moved to SQL Server 2000 and Visual Basic 6 through to SQL Server Yukon and Visual Basic.Net. Robin is a consultant mainly in the City of London where he has been for nearly 8 years but also has been developing his own rugby related website as well as his own site at www.fat-belly.com

Julian Skinner

Skinner studied Germanic etymology to PhD level before joining Wrox Press as an indexer in 1998 in order to get a real job. He became a technical editor shortly after that, later working as a technical architect and commissioning editor.

Skinner contributed many sections and code samples, and often whole chapters, to the books he worked on at Wrox, mostly hiding behind the relative anonymity of an 'additional material' credit, but he is credited as a co-author of Professional ADO.NET (186100527X), Professional ASP Data Access (1861003927), and Beginning SQL (1861001800). Skinner is also a co-author of A Programmer's Guide to SQL (1590592182) (published by Apress).

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 in Nashville Data Center.

The majority of his experience, with slight deviations into Visual Basic, has been spent with Microsoft SQL Server from version 1.0 to whatever latest version that is in Beta. Davidson’s primary areas of expertise are in database architecture and coding in Transact-SQL, and he has written thousands of numerous stored procedures and triggers throughout the years. Davidson was the sole author on Professional SQL Server 2000 Database Design (1861004761) with Wrox Press, and was a contributor to SQL Server 2000 Stored Procedure Handbook. (1861008252)

Adam Machanic

Adam Machanic is a database-focused software engineer with over six years of professional experience implementing SQL Server in both high availability OLTP and large scale data warehouse environments. Adam is currently Senior Database Engineer for GetConnected Inc. in Boston, MA, where he specializes in .NET data access layer performance optimization. He is a Microsoft MVP for SQL Server and a Brainbench Certified DBA

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 (1590591615), the co-author of Beginning SQL Server 2000 DBA: From Novice to Professional (159059293X) and is a Microsoft Certified Database Administrator (MCDBA).

 


Product Details

  • Paperback: 704 pages
  • Publisher: Apress; 1st ed. 2005, corr. 2nd printing edition (November 7, 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 Best Sellers Rank: #571,630 in Books (See Top 100 in Books)

More About the Authors

Discover books, learn about writers, read author blogs, and more.

 

Customer Reviews

11 Reviews
5 star:
 (3)
4 star:
 (5)
3 star:
 (1)
2 star:
 (2)
1 star:    (0)
 
 
 
 
 
Average Customer Review
3.8 out of 5 stars (11 customer reviews)
 
 
 
 
Share your thoughts with other customers:
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
This review is from: Pro SQL Server 2005 (Paperback)
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
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


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
This review is from: Pro SQL Server 2005 (Paperback)
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.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


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 
This review is from: Pro SQL Server 2005 (Paperback)
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.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews









Only search this product's reviews



Inside This Book (learn more)
Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
database master key, database mirroring, transparent client redirection, input date range, dynamic management views, snapshot isolation level, conversation timer, data source view, destination adapter, xml column, application definition file, common table expressions, dialog security, multivalued parameters, annotated schema, database snapshots, data source wizard, initiator service, source adapter, database mail, automation and monitoring, interactive sorting, proxy account, scheduled subscriptions, principal server
Key Phrases - Capitalized Phrases (CAPs): (learn more)
Reporting Services, Management Studio, Visual Studio, Server Agent, Notification Services, Cancel Figure, Adventure Works, Performance Monitor, Solution Explorer, Sales Represen, Object Explorer, Back Next, Books Online, Query Designer, Report Manager, Conditional Split, Configuration Manager, Cancel Help Figure, Business Intelligence Development Studio, Export Column, Maintenance Plan Designer, Program Files, Fact Internet Sales, Boolean Gets, Multidimensional Expressions
New!
Concordance | Text Stats
Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
Search Inside This Book:

What Other Items Do Customers Buy After Viewing This Item?


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 
(1)
(1)

Your tags: Add your first tag
 

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Listmania!


Create a Listmania! list

So You'd Like to...


Create a guide


Look for Similar Items by Category


Look for Similar Items by Subject