|
Expert SQL Server 2005 Development (Expert) | 
 enlarge | Authors: Adam Machanic, Hugo Kornelis, Lara Rubbelke
Publisher: Apress
Category: Book
List Price: $49.99
Buy New: $18.98
You Save: $31.01 (62%)
New (29) Used (12) from $18.98
Avg. Customer Rating:  9 reviews
Sales Rank: 75551
Media: Paperback
Edition: 1
Number Of Items: 1
Pages: 472
Shipping Weight (lbs): 1.6
Dimensions (in): 9.1 x 6.9 x 1
ISBN: 159059729X
Dewey Decimal Number: 005.2768
EAN: 9781590597293
ASIN: 159059729X
Publication Date: May 21, 2007
Availability: Usually ships in 1-2 business days
Shipping: Expedited shipping available
Shipping: International shipping available
Condition: new book, ships in out next bussiness day, 100% satisfaction guaranteed,may have shelf wear,may have remainder mark
|
| Also Available In:
|
| Similar Items:
|
| Editorial Reviews:
Product Description
While building on the skills you already have, Expert SQL Server 2005 Development will help you become an even better developer by focusing on best practices and demonstrating how to design high–performance, maintainable database applications. This book starts by reintroducing the database as a integral part of the software development ecosystem. You’ll learn how to think about SQL Server development as you would any other software development. For example, there's no reason you can’t architect and test database routines just as you would architect and test application code. And nothing should stop you from implementing the types of exception handling and security rules that are considered so important in other tiers, even if they are usually ignored in the database. You’ll learn how to apply development methodologies like these to produce high–quality encryption and SQLCLR solutions. Furthermore, you’ll discover how to exploit a variety of tools that SQL Server offers in order to properly use dynamic SQL and to improve concurrency in your applications. Finally, you’ll become well versed in implementing spatial and temporal database designs, as well as approaching graph and hierarchy problems. Related Titles - Pro T-SQL 2005 Programmer's Guide
- Pro SQL Server 2005 Database Design and Optimization
- Pro SQL Server 2005
|
| Customer Reviews: Read 4 more reviews...
Did you ever think you wouldn't really learn anything new from yet another SQL Server book? January 3, 2008
1 out of 1 found this review helpful
The author imparts a wealth of knowledge on the reader in a mere 445 pages. His style is direct, clear and doesn't waste any pages on trying to get you up to speed. He gives you just what you need and nothing else. I wish they were all like this.
By providing actual performance testing Adam Machanic doesn't just make expert claims for his methods. In fact, my favorite quote from the book: "The hallmark of a truly great developer, and what allows these qualities to shine through, is a thorough understanding of the importance of testing."
Having never worked with spatial data before, I found the coverage of the topic fascinating. Also, entire books have been written on tree's, hierarchies and graphs. Adam provides enough information in a single chapter for the developer to choose a strategy that works.
5 stars - easy
Definitely different...great different...but different October 16, 2007
I have read (well, ok, read through or I would post more reviews) quite a few technical books about SQL Server. Where many books follow a very rigid path through a subject, quite often in a very feature driven manner (Here is this command, and you can do this. Next, this command) or process driven manner (First we do this, then we do this...).
This book is very different from that. The title includes the word "Expert" for good reason. This is a book that doesn't assume you know nothing and start from scratch, nor does it try to teach you every knob and switch on all of the SQL commands. It it more about going to the next level and becoming the expert at programming with SQL Server by covering several deep dive subjects that every person needs to make the transition from "Pro" to "Expert".
It has eleven chapters, each of them about a distinct facet of programming SQL Server, from the common stuff you need to do or use right (testing, errors, privilege, CLR, encryption, dynamic SQL and concurrency) to three chapters on really deep applied stuff (spatial data, temporal data, and graphs/trees). Each chapter has some very deep information, and a lot of code that could make you dizzy if you try to ingest it too fast. It is all explained nicely though, and if you take the time to understand the code you will be far better off for it.
I would not suggest this as a book for the casual "I would like to know a bit more about SQL" reader. It is more for the reader who is already good and wants to become a solid professional/expert SQL programmer who know the right way to do things. For that reader it should be on your required reading list.
Great Book August 23, 2007
This is really a great book. It covers specific topics really extensively and it is very easy to read. I was impressed because I was able to find great information about topics such as Encryption or Hierarchies that cannot be found very easily in other books. The examples are very descriptive but the most important thing is that the author will show you all possible solutions and will prove why the one he selected is the best. It is not a beginner's book but it is a fantastic book for advanced DBAs/Developers.
Stuff I did not know August 20, 2007
3 out of 3 found this review helpful
Frankly, I was expecting a very SQL Server 2005 specific book. Instead, what we have is a good general RDBMS book that happens to be using SQL Server 2005. Encryption, access control, testing, basic software engineering and exception handling are never touched in SQL programming books -- including my own! The spatial chapters were new to me. The little asides were also worth looking up. Good clean style, great job.
Well written and practical book on SQL Server 2005. August 12, 2007
1 out of 1 found this review helpful
The book presents real-life SQL Server problems and shows you how to solve them. It is written in a friendly and story-like fashion. The amount of detail presented is just right - detailed enough to understand the topics yet simple enough not to feel overwhelmed by the amount of information presented.
In the first chapter, the author reviews coupling, cohesion, encapsulation and database role in the application development cycle.
Chapter 2 is extremely useful for testing and tuning queries. It teaches you all you need to know about SQL Profiler. Other topics include unit and functional testing and performance counters. The chapter also introduces the SQLQueryStress Performance Tool which is a free query performance and load testing tool designed by the author.
Chapter 3 covers the different types of errors and exceptions and also shows you how to write error handling code using new error-handling construct added in SQL Server 2005.
The chapter on Dynamic SQL, chapter 7, is a must read for every database developer as it teaches you how and when to use dynamic SQL to make your application both efficient and secure.
Other advanced topics covered in the book are encryption, SQLCLR security and designing systems for application concurrency.
Recommended for SQL Server professionals of all levels.
|
|
|
Copyright 2008 - RailroadBookstore.com
| |
