Beginning SQL Server 2005 Programming (Programmer to Programmer)

Beginning SQL Server 2005 Programming (Programmer to Programmer)
by Robert Vieira

Beginning SQL Server 2005 Programming (Programmer to Programmer)
List Price: $39.99
Our Price: $3.43
You Save: $36.56 (91%)
Availability: Usually ships in 24 hours
Buy Used: from $0.76 (click here)
Category: Book
See more book details and other editions


(Click here)
Buy this book at online book store in your country
Canada | UK | Germany | France

Book Summary Information

Author: Robert Vieira
Edition: Paperback
Audio: English (Unknown); English (Original Language); English (Published)
Published: 2006-02-27
ISBN: 0764584332
Number of pages: 720
Publisher: Wrox

Book Reviews of Beginning SQL Server 2005 Programming (Programmer to Programmer)

Book Review: Great SQL Server Book -- Balanced, Practical, Comprehensive
Summary: 5 Stars

I purchased this book for 2 reasons. First, I'm in IT and my organization uses quite a few professionally created small/medium SQL Server databases. While I'm familiar with the essentials of SQL Server administration, I wanted to know more about the data side to help me think through problems that arise as well has to help me leverage the data by using it as a source for other applications and custom build databases. I also just started creating small ASP sites and want to use SQL Server 2005 as the back end.

This book is fantastic. Because of the nature of my job I've read a large technical book (500+ pages) every couple of months for years now and this is the best written book I can remember since reading Mark Minasi's "Master Windows 2000 Server" 5 years ago.

This is a beginning book and thus if you have programming and/or SQL Server experience you will probably find more detail than you need--I'd rather have more than less! However, I think it is misleading to think of it merely as a beginning book. After reading it there was little I found in my organization's professionally developed small to medium databases that I do not now understand. I'm sure there is much more to learn when dealing with highly distributed massive databases, but if you're at that level you're certainly not reading this review! After reading this book, I'm now able to create my own custom built databases which read data from our professionally developed databases. For example, I've created custom databases which use our SQL Server based personnel database as the source for basic employee info, thus my custom database does not have to deal with replicating employee information as this information is pulled directly from the source database. I also now know everything I need on the SQL Server side for the small ASP applications I'm creating.

It's hard to put my finger on what I most like about the book. The best term I can come up with is balance. It provides a great balance between background theory and discussion of practical examples. Vieira has a great sense for knowing when discussing theory is the best way to explain something versus knowing when to jump right into an example. The other thing I really like about the book is that his real-world experience is apparent on every page. This book is not just a dry "this is how this function works" book. The book is filled with best practices and small gray boxes which warn of possible pitfalls. He is also not afraid to give his own opinion about possibly controversial issues, but he does so in italics to make it clear he is giving his opinion and he also very clearly states his reasons for his opinion.

In one sentence, I like this book because reading it felt like I was having a private tutoring session with an experienced SQL programmer.

Summary of Beginning SQL Server 2005 Programming (Programmer to Programmer)

  • After a quick primer on database design basics and the SQL query language (for those programmers who may be building their first database application), this book provides an overview of SQL Server itself, which has been dramatically redesigned with the 2005 release
  • Once readers have grasped the fundamentals of database design and SQL concepts, they will then learn how to implement those concepts with Microsoft SQL Server 2005
  • Addresses creating and changing tables, managing keys, database normalization, writing scripts, working with stored procedures, programming with XML, and using SQL Server reporting and data transformation services
  • The companion Web site provides all of the code found in the book

Databases Books

Book Subjects
Most talked about in Databases Books
Mining for Gold on The Internet: How to Find Investment and Financial Information on the Internet ImageMining for Gold on The Internet: How to Find Investment and Financial Information on the Internet
by Mary Ellen Bates
McGraw-Hill Companies; Published: 2000-05-30; Paperback; Book
Best price: $20.47
Price in other shops: $26.95
Building XML Applications ImageBuilding XML Applications
by Simon St.; Cerami, Ethan Laurent
McGraw-Hill Companies; Published: 1999; Paperback; Book
Introduction to Data Communications and Local Area Networking Technology ImageIntroduction to Data Communications and Local Area Networking Technology
by Eduardo da Silva
HarperCollins Publishers Ltd; Published: 1986-08-28; Paperback; Book
Data Analysis Using SQL and Excel ImageData Analysis Using SQL and Excel
by Gordon S. Linoff
Wiley; Published: 2007-10-01; Paperback; Book
Best price: $27.16
Price in other shops: $45.00
Fundamentals of Database Systems (5th Edition) ImageFundamentals of Database Systems (5th Edition)
by Ramez Elmasri, Shamkant B. Navathe
Addison Wesley; Published: 2006-03-17; Hardcover; Book
Best price: $66.00
Price in other shops: $138.00
An Introduction to Database Systems (8th Edition) ImageAn Introduction to Database Systems (8th Edition)
by C.J. Date
Addison Wesley; Published: 2003-08-01; Paperback; Book
Best price: $99.93
Price in other shops: $169.00
Pragmatic ADO.NET: Data Access for the Internet World ImagePragmatic ADO.NET: Data Access for the Internet World
by Shawn Wildermuth
Addison-Wesley Professional; Published: 2002-11-15; Paperback; Book
Best price: $5.20
Price in other shops: $54.99
SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL ImageSQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL
by Michael J. Hernandez, John L. Viescas
Addison-Wesley Professional; Published: 2000-08-31; Paperback; Book
Best price: $57.61
Price in other shops: $59.99
Microsoft Office Access 2003 QuickSteps ImageMicrosoft Office Access 2003 QuickSteps
by John Cronan, Virginia Anderson, Brenda Bryant Anderson
McGraw-Hill Osborne Media; Published: 2004-03-01; Paperback; Book
Best price: $2.70
Price in other shops: $19.99
Database Systems Concepts ImageDatabase Systems Concepts
by Henry F. Korth, Abraham Silberschatz, S. Sudarshan
Osborne/McGraw-Hill,U.S.; Published: 2001-08; Hardcover; Book
Similar Books and other products
Beginning T-SQL with Microsoft SQL Server 2005 and 2008 (Wrox Programmer to Programmer) ImageBeginning T-SQL with Microsoft SQL Server 2005 and 2008 (Wrox Programmer to Programmer)
by Paul Turley, Dan Wood
Wrox; Published: 2008-12-10; Paperback; Book
Best price: $22.39
Price in other shops: $39.99
Professional SQL Server 2005 Integration Services (Programmer to Programmer) ImageProfessional SQL Server 2005 Integration Services (Programmer to Programmer)
by Brian Knight, Allan Mitchell, Darren Green, Douglas Hinson, Kathi Kellenberger, Andy Leonard, Erik Veerman, Jason Gerard, Haidong Ji, Mike Murphy
Wrox; Published: 2006-01-31; Paperback; Book
Best price: $7.49
Price in other shops: $49.99
Inside Microsoft SQL Server 2005: T-SQL Programming (Solid Quality Learning) ImageInside Microsoft SQL Server 2005: T-SQL Programming (Solid Quality Learning)
by Itzik Ben-gan, Dejan Sarka, Roger Wolter
Microsoft Press; Published: 2006-06-14; Paperback; Book
Best price: $10.44
Price in other shops: $44.99
Microsoft SQL Server 2005 Reporting Services ImageMicrosoft SQL Server 2005 Reporting Services
by Brian Larson
McGraw-Hill Osborne Media; Published: 2005-12-12; Paperback; Book
Best price: $22.34
Price in other shops: $49.99
Professional SQL Server 2005 Reporting Services ImageProfessional SQL Server 2005 Reporting Services
by Paul Turley, Todd Bryant, James Counihan, Dave DuVarney
Wrox; Published: 2006-03-06; Paperback; Book
Best price: $9.98
Price in other shops: $39.99
Beginning SQL Server 2005 for Developers: From Novice to Professional (Expert's Voice) ImageBeginning SQL Server 2005 for Developers: From Novice to Professional (Expert's Voice)
by Robin Dewson
Apress; Published: 2006-02-02; Paperback; Book
Best price: $37.33
Price in other shops: $49.99
Microsoft SQL Server 2005 Unleashed ImageMicrosoft SQL Server 2005 Unleashed
by Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein
Sams; Published: 2006-12-31; Paperback; Book
Best price: $34.99
Price in other shops: $64.99
Beginning SQL Server 2005 Administration ImageBeginning SQL Server 2005 Administration
by Dan Wood, Chris Leiter, Paul Turley
Wrox; Published: 2006-11-29; Paperback; Book
Best price: $13.36
Price in other shops: $39.99
Professional SQL Server 2005 Programming (Programmer to Programmer) ImageProfessional SQL Server 2005 Programming (Programmer to Programmer)
by Robert Vieira
Wrox; Published: 2006-12-01; Paperback; Book
Best price: $7.45
Price in other shops: $49.99
Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning) ImageInside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning)
by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka
Microsoft Press; Published: 2006-04-26; Paperback; Book
Best price: $11.68
Price in other shops: $44.99
Book store. Illustrated catalog of books on different categories