Join Amazon Prime and ship Two-Day for free and Overnight for $3.99. Already a member? Sign in.
Pro T-SQL 2005 Programmer's Guide (Expert's Voice) and over 300,000 other books are available for Amazon Kindle – Amazon’s new wireless reading device. Learn more

 

or
Sign in to turn on 1-Click ordering.
 
 
More Buying Choices
31 used & new from $14.41

Have one to sell? Sell yours here
 
   
Pro T-SQL 2005 Programmer's Guide (Expert's Voice)
 
 
Start reading Pro T-SQL 2005 Programmer's Guide (Expert's Voice) on your Kindle in under a minute.

Don’t have a Kindle? Get yours here.
 
  

Pro T-SQL 2005 Programmer's Guide (Expert's Voice) (Paperback)

by Michael Coles (Author)
Key Phrases: key encrypting keys, test node, deleted virtual tables, Databasewide Returns, Imports System, Visual Studio (more...)
4.8 out of 5 stars See all reviews (6 customer reviews)

List Price: $49.99
Price: $31.49 & this item ships for FREE with Super Saver Shipping. Details
You Save: $18.50 (37%)
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

Want it delivered Tuesday, July 7? Choose One-Day Shipping at checkout. Details
19 new from $14.41 12 used from $14.45
Also Available in: List Price: Our Price: Other Offers:
Kindle Edition (Kindle Book) $17.32

Frequently Bought Together

Pro T-SQL 2005 Programmer's Guide (Expert's Voice) + Expert SQL Server 2005 Development + SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach (A Problem - Solution Approach)
Price For All Three: $125.93

Show availability and shipping details


Customers Who Bought This Item Also Bought

SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach (A Problem - Solution Approach)

SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach (A Problem - Solution Approach)

by Joseph Sack
4.6 out of 5 stars (22)  $53.99
Pro SQL Server 2005 Database Design and Optimization

Pro SQL Server 2005 Database Design and Optimization

by Louis Davidson
4.4 out of 5 stars (9)  $53.99
Microsoft SQL Server 2005 Unleashed

Microsoft SQL Server 2005 Unleashed

by Ray Rankins
4.4 out of 5 stars (20)  $40.49
Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning)

Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning)

by Itzik Ben-Gan
4.7 out of 5 stars (30)  $29.69
Microsoft SQL Server 2005 Reporting Services 2005

Microsoft SQL Server 2005 Reporting Services 2005

by Brian Larson
4.2 out of 5 stars (48)  $31.49
Explore similar items


Editorial Reviews

Product Description

Pro T-SQL 2005 Programmer's Guide provides comprehensive and detailed coverage of all the major features and facilities of T-SQL for SQL Server 2005. It is designed for all users of T-SQL, database administrators, systems administrators, application developers, and end-users, who want to learn how to exploit the power of T-SQL. Whatever you need to do with T-SQL, you'll find it described clearly here.

Stored procedures, triggers, and user-defined functions are only part of the story. Dynamic SQL, the new XML data type, and SQLCLR programming are also covered, as well as accessing SQL Server with ADO.NET. Exception handling and performance are fully covered, too. This book is truly a complete programmer's guide to T-SQL and SQL Server 2005.



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: 532 pages
  • Publisher: Apress (April 23, 2007)
  • Language: English
  • ISBN-10: 159059794X
  • ISBN-13: 978-1590597941
  • Product Dimensions: 9.1 x 7 x 1.3 inches
  • Shipping Weight: 1.9 pounds (View shipping rates and policies)
  • Average Customer Review: 4.8 out of 5 stars See all reviews (6 customer reviews)
  • Amazon.com Sales Rank: #130,024 in Books (See Bestsellers in Books)

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

    #72 in  Books > Computers & Internet > Microsoft > Development > SQL Server

Inside This Book (learn more)

What Do Customers Ultimately Buy After Viewing This Item?


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
Check the boxes next to the tags you consider relevant or enter your own tags in the field below.
(2)
(2)

Your tags: Add your first tag
 
Help others find this product — tag it for Amazon search
No one has tagged this product for Amazon search yet. Why not be the first to suggest a search for which it should appear?

 

Customer Reviews

6 Reviews
5 star:
 (5)
4 star:
 (1)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
4.8 out of 5 stars (6 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
8 of 10 people found the following review helpful:
5.0 out of 5 stars A book for every developer working with T-SQL - Review of Database Administrator SQLAuthority.com, September 14, 2007
Short Summary:
Pro T-SQL 2005 Programmer's Guide book examines SQL Server 2005 T-SQL from a developer's perspective. It covers a wide range of developer-specific topics in SQL Server 2005. This book covers many newly introduced topics in depth. This book is written as a practical and useful guide to help database developers who mainly deals with T-SQL. This book is really hit the spot with appropriate .NET code at few places where needed. This book assumes a basic knowledge of SQL but it is really easy for new beginners developers to understand and advanced developers to enjoy further reading.

Detailed Summary:
One thing I really liked about this book is that it can be either read cover to cover, or it can be used as a reference guide for one particular topic. Index of this book is extremely well organized and aids to find the right topic very quickly. Books is structure is many chapters and each chapter justifies the chapters with good details and proper amount of examples.

Each chapter has excellent advice and knowledge and filled with sample code (available online). The book is targeted specifically at SQL Server 2005 and the innovative ways to code T-SQL, new functions and commands. If is very easy to get started with this book and it immerses in comprehensive reading in no time. This book addresses many details and comparisons with T-SQL in very organized way. The examples are in very accurate and useful as well sufficient to targeted topics. This book addresses many of the real world issues with examples, discussions and solutions.

This book start with providing a brief history of T-SQL and the ANSI SQL standards. SQLCMD and SQL Server Management Studio are new tools to explore SQL Server 2005 and are covered in depth in beginning of the book. Chapters which covers Common Table Expressions (CTEs), new datatypes, operators, keywords, functions, and control of flows are really interesting and with 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 that. The regular T-SQL concepts which I write a lot about Stored Procedure, Triggers and Dynamic SQL each have their own chapter. One thing many T-SQL book does not cover in depth is XML, XQuery and XPath which are properly discussed and their importance is explained properly. Last three chapter of the book which covers SQLCLR, .NET Client Programming and HTTP Endpoints requires the Microsoft .NET FrameWork 2.0, as it contains some code which are written in VB and C#.

One thing which I always liked in any database book is, use of sample database AdventureWorks. I strongly believe that all the example should be independent from 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 script of examples are available to download online. No book is free from the errors and website for this book have errata list, which is surprisingly very small.

I will list few tips from book which interested me. This will give brief idea how good this book is.

"TABLESAMPLE always returns an approximate number of rows because of the way it samples data. The required percentage is the number of data pages SQL Server retreves in full to fulfill your TABLESAMPLE request. The number of rows returned by TABLESAMPLE will often be slightly less, or greater, than the specified amount."

"Anytime you use dynamic SQL, make sure that you take precautions against SQL injection, that is, malicious SQL Code being inserted into your SQL statements. In this instance we're using the QUOTENAME function to quote the column names being dynamically generated to help avoid SQL injection problems."

Following one example really caught my eyes while reading the book. It seems Author accurately described the situation and put his suggestion regarding syntax.
"The ANSI SQL:2003 standard includes a MERGE statement that performs the same function as the upsert type of SP. The prerelease versions of SQL Server 2005 included the MERGE statement. Though it was well-publicized during the prerelease period, the MERGE statement was unceremoniously dropped from the production version. We can only hope that Microsoft brings it back sometime in the near future."
Good news is Microsoft have included the Authors request in future version of SQL Server. SQL Server 2008 CTP 4 has included MERGE Keyword.

Rating: 4 and 1/2 stars

In Summary, A book for every developer who want to take full advantage of the power of T-SQL on SQL Server 2005.

Pinal Dave
Principal Database Administrator
(blog.sqlauthority.com)
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
3 of 5 people found the following review helpful:
4.0 out of 5 stars Excellent Introduction to T-SQL, June 9, 2007
I found this book a wonderful introduction to T-SQL on SQL Server 2005. The author's writing style is authoritative but easy to understand. The dozens of samples help to make the concepts presented even more concrete. In particular I found the chapters on the new SQL Server XML features, XQuery, and encryption functionality particularly enlightening. These new features are especially useful to me in integrating applications and ensuring HIPAA compliance. These tools are now an indispensable part of my tool set, and this book is the best introduction I've found yet.
Comment Comment (1) | Permalink | Was this review helpful to you? Yes No (Report this)



 
1 of 2 people found the following review helpful:
5.0 out of 5 stars Essential Tool for SQL Developers and Administators, June 23, 2007
By Reginald Tyler "Reggie Tyler" (Springfield Gardens, NY United States) - See all my reviews
(REAL NAME)   
Pro T SQL Programmers Guide is an excellent resource to jump start your SQL Server 2005 development efforts. Michael Coles presents clear, concise examples that will guide the reader from T-SQL fundamentals to the use of the new xml data type,http endpoints, sqlclr programming, encryption and more. A clear read with great practical examples.



I would highly recommend this book as a reference and guide book for t-sql developers, dba's and development professionals

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews

5.0 out of 5 stars An excellent T-SQL guide...
This book is is easy to read and does an excellent job of introducing the new features and tools in T-SQL 2005. Read more
Published on June 19, 2007 by Charles Richardson

5.0 out of 5 stars Indispensable book for T-SQL Programmers
This book is well written with clear examples and excellent coverage of T-SQL. Great to read cover to cover but also very useful as a reference source. I highly recommend it.
Published on June 15, 2007 by Carol Cox

5.0 out of 5 stars a great book!
I really enjoyed this book. It presents the essential new features of SQL 2005 in a well written easy to read manner. Read more
Published on June 11, 2007 by Hilary Cotter

Only search this product's reviews



Customer Discussions

 Beta (What's this?)
New! See all customer communities, and bookmark your communities to keep track of them.
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]


Active discussions in related forums
   


Product Information from the Amapedia Community

Beta (What's this?)



Look for Similar Items by Category


Everything to Maintain Your Landscape

Shop for gardening tools
From pruners and saws to shovels and rakes, we have the gardening tools you need to keep your landscape looking its best.

Shop all gardening tools

 

Big Savings in Books

Bargain Books
Find great titles at fantastic prices in our Bargain Books Store.
 

Buy Three Books, Get a Fourth Free

4-for-3 Books
Order any four eligible books under $10 and get the lowest-price book free in our 4-for-3 Books Store. See more details.
 

Best Books

Best of the Month
See our editors' picks and more of the best new books on our Best of the Month page.
 
Ad

 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info or give feedback on images?
Is there any other feedback you would like to provide?

Your comments can help make our site better for everyone.


Where's My Stuff?

Shipping & Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.

Continue shopping: Top Sellers
Paranoia
Paranoia by Joseph Finder
Glenn Beck's Common Sense
Glenn Beck's Common Sense
Darkfever
Darkfever by Karen Marie Moning

Conditions of Use | Privacy Notice © 1996-2009, Amazon.com, Inc. or its affiliates