Pro T-SQL 2008 Programmer’s Guide (Paperback)

by Michael Coles (Author)
Key Phrases: flat washer, bottom bracket, stored procedure, Visual Studio, Road Frame, Data Services (more...)

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.

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 (August 11, 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.com Sales Rank: #144,982 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #72 in

  Books > Computers & Internet > Microsoft > Development > SQL Server

Customer Reviews

Most Helpful Customer Reviews

6 of 7 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

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.

2 of 2 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.com) - See all my reviews

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)

3 of 4 people found the following review helpful:

5.0 out of 5 stars Terrific resouce for every DBA's shelf, February 3, 2009

By	Ron Davis "USMC 67-71 OOHRAH!" (Plano, TX USA) - See all my reviews (REAL NAME)

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.