|
Pro T-SQL 2008 Programmer’s Guide |  | Author: Michael Coles
Publisher: Apress
Category: Book
List Price: $52.99
Buy New: $31.00
as of 7/30/2010 03:43 CDT details
You Save: $21.99 (41%)
New (24) Used (12) from $30.98
Seller: cyberemail2me
Rating:  5 reviews
Sales Rank: 455291
Media: Paperback
Edition: 1
Pages: 688
Number Of Items: 1
Shipping Weight (lbs): 2.3
Dimensions (in): 9.1 x 7 x 1.6
ISBN: 143021001X
Dewey Decimal Number: 005.756
EAN: 9781430210016
ASIN: 143021001X
Publication Date: August 11, 2008
Availability: Usually ships in 1-2 business days
| |
| Also Available In:
|
| Similar Items:
| |
| Editorial Reviews:
Product Description
Discussing new and existing features, SQL Server designer and administrator Michael Coles takes you on an expert guided tour of Transact–SQL functionality in SQL Server 2008 in his book Pro T–SQL 2008 Programmer’s Guide. Fully functioning examples and downloadable source code bring Coles’ technically accurate and engaging treatment of Transact–SQL into your own hands. Step–by–step explanations ensure clarity, and an advocacy of best–practices will steer you down the road to success. Pro T–SQL 2008 Programmer’s Guide is every developer’s key to making full use of SQL Server 2008’s powerful, built–in Transact–SQL language. Transact–SQL is the language developers and DBAs use to interact with SQL Server. It’s used for everything from querying data, to writing stored procedures, to managing the database. New features in SQL Server 2008 include a spatial data type, SQLCLR integration, the MERGE statement, a dramatically improved and market–leading XML feature set, and support for encryption—all of which are covered in this book What you’ll learn - Write stored procedures, functions, and triggers using Transact–SQL
- Apply best–practices when centralizing procedural logic inside your SQL Server database.
- Seamlessly work with XML data using XQuery, XPath, and the XML type.
- Use SQLCLR to write .NET code that runs inside SQL Server.
- Implement full–text search within your database.
- Load data more efficiently using the new MERGE statement.
- Learn about the new geography type for storing spatial data.
Who is this book for? Pro T–SQL 2008 Programmer’s Guide is written for SQL Server and Transact–SQL developers who want to implement best–practices and take full advantage of all that SQL Server has to offer. .NET programmers will find the book helpful in showing how to run .NET code within SQL Server. Database administrators who need to write triggers and the occasional stored procedure will also benefit from the book. About the Apress Pro Series The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder. You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hard–won solutions to problems you will face in your professional programming career.
|
| Customer Reviews:
 Pro T-SQL disappointing May 17, 2009
John Warner (Greenville, SC USA)
2 out of 3 found this review helpful
This book was poorly organized and left out a lot of details about T-SQL keywords and built in functions. He would use a T-SQL function in an example but there would be no explaination of that bit of code. There are some useful tips which is why I give it at 3 stars. I would recommend you look else where for T-SQL 2008 coverage. Coles knows the subject that is obvious it just doesn't fully make it into print. Not sure if it was the author or the editor but this just did not satisfy.
 A must-read book for every developer to take full advantage of SQL Server 2008 - Review by SQLAuthority.com April 19, 2009
Pinalkumar Dave (SQLAuthority)
6 out of 7 found this review helpful
Short Summary:
Pro T-SQL 2008 Programmer's Guide examines SQL Server 2008 T-SQL from a developer's perspective. This information-rich book covers a wide array of developer-specific topics in SQL Server 2008. In addition, it provides in-depth knowledge of various newly introduced topics. This book is written as a practical guide to help database developers who mainly deal with T-SQL. It has really hit the spot with appropriate .NET code at a few places where required. The book assumes a basic knowledge of SQL, but it is very easy to understand for novice developers, while for advanced developers it is a great source to enhance their knowledge.
Detailed Summary:
Pro T-SQL 2008 Programmer's Guide is a well-written and well-structured book with a good depth and breadth of quality content presented in a reader friendly way. The book is structured into chapters where latest and comprehensive information have been backed with numerous examples to facilitate understanding of all levels of developers. What I really liked about this book is that it can either be read from cover to cover, or can be used as a reference guide for finding information topic-wise. A well-organized index aids in finding the topics very quickly.
Apart from valuable knowledge, each chapter of the book contains excellent advice and is filled with sample code (available online). It primarily revolves around SQL Server 2008 and innovative ways to code T-SQL, new functions and commands. It addresses many details and comparisons with T-SQL in a very organized manner. All the examples have been carefully selected and are accurate, useful and sufficient for the targeted topics. In addition, this book addresses a number of real-world issues with examples, discussions and solutions.
SQLCMD and SQL Server Management Studio are advanced tools to explore SQL Server 2008 that have been covered in depth in the beginning of the book. I would like to discuss Chapter 2 in detail. This chapter dives right into the new features of T-SQL on SQL Server 2008, with discussion on productivity-enhancing features, the new MERGE statement, new data types like geometry and hierarchyid, and grouping sets. Chapter 13 introduces SQL Server 2008 catalog views, which are the preferred tools for retrieving database and database object metadata. This chapter also hashes out dynamic management views and functions, which provide access to server and database state information.
Chapters that cover Common Table Expressions (CTEs), new data types, operators, keywords, functions, and control of flows are very interesting and contain necessary explanation. Readers of my blog are very well aware of my interests in Error handling and Debugging. Interesting enough for me, there is one whole chapter dedicated to these areas. Some of the regular T-SQL concepts such as Stored Procedure, Triggers and Dynamic SQL, which I write a lot about, have also been covered in this book and each have a chapter dedicated to them. The last three chapters of the book on SQLCLR, .NET Client Programming and HTTP Endpoints necessitate Microsoft .NET FrameWork 2.0, as they contain some codes that are written in VB and C#.
One demerit with other run-of-the-mill T-SQL books is that they do not include in-depth information on XML, XQuery and XPath, while these topic have been discussed in good detail in this book, and their importance has been appropriately explained. Yet another attractive feature of this book is that all the chapters contain exercise with Appendix A having answers to all the questions asked. Appendix D comprises quick reference to SQLCMD command-line tool, which I have been using myself.
Some excerpts from the book that demonstrate how complex subjects have been explained in a lucid way and present the visionary attitude of the author.
"How do you pass parameters to triggers? The short answer is you can't. Because they are automatically fired in response to events, SQL Server triggers provide no means to pass in parameters."
"When used with an aggregate function like SUM, COUNT, or AVG, or a user-defined aggregate, the OVER clause can only take a PARTITION BY clause-not an ORDER BY clause. This is a serious shortcoming in the SQL Server implementation of OVER for aggregate functions. ORDER BY in the OVER clause for aggregate functions allows you to easily perform single-statement running sum-type calculations. Running sum calculations without this feature require extensive joins, causing many people to fall back on cursors. ORDER BY for the aggregate OVER clause, and other features related to windowing functions, has been submitted as a feature request to Microsoft. Hopefully, we'll see it implemented at some point in the near future."
One thing that I have always liked in any database book is the use of sample database AdventureWorks. I strongly believe that the all the examples should be independent of the previous examples and should use default database. If you have not installed default database AdventureWorks, you can get its latest location by searching in my blog SQLAuthority.com. All the scripts of examples are easily available and can be downloaded online. No book is free from errors and the website for this book has errata list, which is surprisingly very small.
Rating: 5 Stars
To sum up, Pro T-SQL 2008 Programmer's Guide is a must-read book for every developer who wants to take full advantage of the power of T-SQL on SQL Server 2008. This book by Author Michel Coles it meant to facilitate developers - they can now spend less time worrying about how things get done and instead think about what they actually want to get done.
Pinal Dave
Founder - (blog.SQLAuthority.com)
 T-SQL 2008 REview April 7, 2009
Farid H. Nia (Columbus, GA)
1 out of 3 found this review helpful
This is a great book. Michael Coles does a great job providing down to earth real world examples. The information in this book is presented in a practical manner with really nice examples. Really nice book for learning T-SQL from a programming perspective. You can tell a DBA wrote this book...
Terrific resouce for every DBA's shelf February 3, 2009
Ron Davis (Plano, TX USA)
3 out of 4 found this review helpful
This is a terrific resource for advanced T-SQL with SQL 2008. I have a good knowledge of the subject and my son has a better one managing over 30,000 customer databases in his job. We saw this and each purchased a copy and each of us has gained insights into the language and important concepts to make our use of T-SQL better.
A Comprehensive SQL server book September 24, 2008
Frank Banin (USA)
6 out of 8 found this review helpful
After finishing this book and following the practical examples you can definitely call yourself a Pro. The book covers every topic you need to know as a SQL server professional with practical and straight-forward examples. Read a chapter and you are up to speed on a topic; a mark of a true companion book.
We all know how we tend to browse or even skip a few topics every now and then due to personal dislikes. Mike's writing style makes every topic straight forward and easy to really complete.
Coming from a GIS background, I liked his break-down of the new spatial Engine feature; his illustrations are perfect for us with that background and a good ice-breaker for those who are new to spatial data and analytics. He did an excellent job on the new features in SQL Server 2008 and T-SQL. If you value your time, this is a book to have.
|
|
|
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 | |
