Pro T-SQL 2008 Programmer's Guide (Expert's Voice in SQL Server) [Paperback]

Michael Coles (Author)

Book Description

ISBN-10: 143021001X | ISBN-13: 978-1430210016 | Publication Date: August 21, 2008 | Edition: 1

Skill with the Transact-SQL language is key to any developer making use of Microsoft SQL Server. Written especially for developers, the Pro T-SQL 2008 Programmer’s Guide shows developers the full range of what’s possible using the language. Readers become fully-grounded in the language, in the key features that SQL Server has to offer, and they are introduced to best-practices that will help ensure their success.

Editorial Reviews

About the Author

Michael Coles has over a decade’s experience designing and administering SQL Server databases. A prolific writer of articles on all aspects of SQL Server, particularly on the expert use of T-SQL, he holds MCDBA and MCP certifications. He received a bachelor’s of science (magna cum laude) in information technology from American Intercontinental University. A member of the United States Army Reserve, he was activated for two years following 9/11.

Product Details

• Paperback: 688 pages
• Publisher: Apress; 1 edition (August 21, 2008)
• Language: English
• ISBN-10: 143021001X
• ISBN-13: 978-1430210016
• Product Dimensions: 9.1 x 7 x 1.6 inches
• Shipping Weight: 2.3 pounds (View shipping rates and policies)
• Average Customer Review: 4.4 out of 5 stars  See all reviews (5 customer reviews)
• Amazon Best Sellers Rank: #719,637 in Books (See Top 100 in Books)

More About the Author

Michael Coles is a principal database architect and developer working out of New York. He has authored several books, published dozens of articles on SQL Server development topics (both online and in print), and regularly speaks at SQL Server user groups. He has been recognized as a Microsoft MVP for his work with SQL Server and contributions to the development community. He holds multiple Microsoft certifications including MCITP:Database Development 2008 and MCDBA. Michael currently lives in New Jersey. His blog can be found at http://sqlblog.com/blogs/michael_coles/.

Customer Reviews

Most Helpful Customer Reviews

8 of 9 people found the following review helpful:

5.0 out of 5 stars A must-read book for every developer to take full advantage of SQL Server 2008 - Review by SQLAuthority.com, April 18, 2009

By 

Pinalkumar Dave "Pinal Dave" (SQLAuthority) - See all my reviews

This review is from: Pro T-SQL 2008 Programmer's Guide (Expert's Voice in SQL Server) (Paperback)

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)

4 of 5 people found the following review helpful:

3.0 out of 5 stars Pro T-SQL disappointing, May 17, 2009

By 

John Warner (Greenville, SC USA) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Pro T-SQL 2008 Programmer's Guide (Expert's Voice in SQL Server) (Paperback)

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.

6 of 8 people found the following review helpful:

5.0 out of 5 stars A Comprehensive SQL server book, September 23, 2008

By 

Frank Banin (USA) - See all my reviews

This review is from: Pro T-SQL 2008 Programmer's Guide (Expert's Voice in SQL Server) (Paperback)

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.