|
SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach |  | Author: Joseph Sack
Publisher: Apress
Category: Book
List Price: $59.99
Buy New: $23.04
as of 7/30/2010 03:55 CDT details
You Save: $36.95 (62%)
New (25) Used (16) from $23.03
Seller: BOOKS__UNLIMITED
Rating:  9 reviews
Sales Rank: 202811
Media: Paperback
Edition: 1
Pages: 872
Number Of Items: 1
Shipping Weight (lbs): 3
Dimensions (in): 9.2 x 7 x 1.9
ISBN: 1590599802
Dewey Decimal Number: 005.7585
EAN: 9781590599808
ASIN: 1590599802
Publication Date: July 23, 2008
Availability: Usually ships in 1-2 business days
| |
| Features:
| • | ISBN13: 9781590599808 | | • | Condition: New | | • | Notes: BUY WITH CONFIDENCE, Over one million books sold! 98% Positive feedback. Compare our books, prices and service to the competition. 100% Satisfaction Guaranteed |
|
| Also Available In:
|
| Similar Items:
| |
| Editorial Reviews:
Product Description
SQL Server 2008 Transact–SQL Recipes: A Problem–Solution Approach is an example–based guide to the Transact–SQL language that is at the core of SQL Server 2008. Learn to create databases, insert and update data, generate reports, secure your data, and more. Author Joseph Sack takes common Transact–SQL tasks and breaks them down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on. - Focused on solutions: Look up what you need to do. Learn how to do it. Do it.
- Current: Newly updated for SQL Server 2008.
- Comprehensive: Covers 30 different Transact–SQL problem domains.
What you’ll learn - Create databases, tables, and indexes.
- Query and manipulate data.
- Store and manage XML inside the database.
- Move business logic into the database.
- Encrypt data and capture changes for compliance purposes.
- Implement Full–Text Search.
- Interface with Service Broker.
- And more!
Who is this book for? Developers who use Microsoft SQL Server 2008 as their back–end database. Database administrators who create, manage, and secure those databases.
|
| Customer Reviews:
Showing reviews 1-5 of 9
 A good SQL Server Reference Book June 4, 2010
Sudheer K. Maharana
1 out of 1 found this review helpful
I read and review lot of SQL Server books. Almost every other book on SQL Server has something new or explaining same features in a different way. I ordered this book being drawn to the title of this book. This book is written by one of the SQL Premier Field Support Engineers from Microsoft. It is nicely laid out and definitely different from other books in explaining SQL Server features. The best thing about this book is "How it Works" sections. For most of the part, the author has done a good job for these sections in describing the internals of each of the features. However, I did find the explanation to some extent short for some important features such as Service Broker, Encryption, Database Snapshots and Query Hints. Especially, I was looking for some internal information on Service Broker.
It is definitely worthwhile to spend some time in reading this book. I would rate this book a 4 star.
 Excellent T-SQL book for SQL Server 2008 March 31, 2010
J. Wong (Houston, TX, US)
This is an excellent T-SQL book for SQL Server 2008. You have to have some T-SQL coding experiences to enjoy the use of it.
Buy or steal this book May 17, 2009
John Warner (Greenville, SC USA)
3 out of 5 found this review helpful
I bought this thinking it was the typical recipe type book for T-SQL from this publisher and it is. It also covers a number of things regarding managing SQL Server that a developer should know and understand. This won't make you a dba but after reading this you are on your way. Well organized in presentation explainations of code samples are good. I found the writing itself enjoyable. You should have an understanding of basic SQL to get the full benefit here but I think a beginner to the subject would not be lost here. As I say in the title of my review buy or steal this book if you need a T-SQL guide.
Now This Is What I Call "From Novice To Professional" March 19, 2009
Kurt Heitmeyer
1 out of 2 found this review helpful
I Highly Recommend this book to anyone using Sql Server... Dont let the 2008 fool you, he points out where the T-SQL code differs from previous enviroments...full of great information
Fantastic Addition to the Books Online March 14, 2009
Grant Fritchey (MA)
1 out of 2 found this review helpful
Joseph Sack's book is full of information on how to write T-SQL code. That's all it does and all it is. The name is just about perfect. He focuses on the language and structure of Transact SQL and delivers a great set of examples and explanations that will communicate the concepts, simple and complex, necessary for you to go to work on your own system. It really is a set of recipes for dealing with T-SQL.
The chapters break down into broad concepts like Select or Indexes or Linked Servers. These concepts are then broken down into the component parts so that, for example, in the Backup chapter, you get broad sub-topics on Creating a Backup and Recovery Plan, Making Backups and Restoring a Database. These are then broken down even further into specifics such as Viewing Database Space Usage. These specific topics then show the syntax, similar to Books Online, but laid out a little differently with immediate explanation of the parameters followed by the true strength of the book, examples. He finally sums up the section with a "How It Works" description.
This is not a "learn how to use SQL Server" book. It is exactly what it says, a set of recipes that will help you work with T-SQL. Actually, when you look at all the examples in the book, that's where you're getting your money's worth and then some. These are good examples, original and well thought out. It shows how to use the code, and, more importantly, how to use it right.
I'd recommend this to DBA's for sure, but I think it's a must for developers too. Here's a handy resource to help you get better T-SQL code the first time.
Showing reviews 1-5 of 9
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. Copyright 2009, SQL Server 2008 Books. All Rights Reserved.
In association with Amazon.com | |
