SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach (Expert's Voice) [Paperback]

Joseph Sack (Author)

Book Description

Publication Date: December 13, 2005 | ISBN-10: 159059570X | ISBN-13: 978-1590595701 | Edition: 1

Need to brush up on a specific SQL Server task, procedures, or Transact-SQL commands? Not finding what you need from SQL Server books online? Or, perhaps, you just want to familiarize yourself with the new T-SQL-realted features offered in SQL Server 2005, but are more interested in practical application than endless background theory? Then check out SQL Server 2005 T-SQL Recipes. It provides a practical working guide for this powerful relational database management system.

It brings you up-to-date in a flash with the latest SQL Server 2005 T -SQL features. SQL Server 2005 T-SQL Recipes provides a "no fluff" desk reference, allowing you to access the information you need to get the job done, from coverage of basic T-SQL data manipulation to the use of stored procedures, triggers and UDFs to advanced T-SQL techniques for database security and maintenance. It addresses content and topics that are useful to all SQL Server professionals and it provides hundreds of practical recipes that describe and demonstrate the utility of a feature or function with a minimum of background theory. This book provides ‘How To’ answers to common SQL Server T-SQL questions, conceptual overviews, and highlights of new features introduced in SQL Server 2005 as well as useful and concise Transact-SQL syntax examples. You can even use it in preparation for a SQL Server job interview or for a SQL Server certification test.

Editorial Reviews

About the Author

Joseph Sack is a database administration and developer based in Minneapolis, Minnesota since 1997. He has been developing and supporting SQL Server environments for clients in financial services, IT consulting, manufacturing, transportation, and the real estate industry. He is the author of SQL Server 2000 Fast Answers for DBAs and Developers (Apress, ISBN: 1-59059-161-5), the co-author of Beginning SQL Server 2000 DBA: From Novice to Professional (Apress, ISBN: 1-59059-293-X) and is a Microsoft Certified Database Administrator (MCDBA).

Product Details

• Paperback: 768 pages
• Publisher: Apress; 1 edition (December 13, 2005)
• Language: English
• ISBN-10: 159059570X
• ISBN-13: 978-1590595701
• Product Dimensions: 9.2 x 7 x 1.6 inches
• Shipping Weight: 2.6 pounds (View shipping rates and policies)
• Average Customer Review: 4.6 out of 5 stars  See all reviews (21 customer reviews)
• Amazon Best Sellers Rank: #546,952 in Books (See Top 100 in Books)

More About the Author

I've worked as a SQL Server professional since 1997 and I work for Microsoft as a Dedicated Support Engineer in the Premier Field Engineering team, working with retail sector customers in the Twin Cities. I'm the author of 'SQL Server 2000 Fast Answers', 'SQL Server 2005 T-SQL Recipes' and "SQL Server 2008 Transact-SQL Recipes."

Customer Reviews

Most Helpful Customer Reviews

68 of 69 people found the following review helpful:

5.0 out of 5 stars Extensive coverage, lots of 2005 specific coverage, January 20, 2006

By 

William Addington "William Addington" - See all my reviews
(VINE VOICE)    (REAL NAME)   

This review is from: SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach (Expert's Voice) (Paperback)

Sometimes we see books on a new version of software that haven't soaked in the new technology -- you can tell the book was written with a mindset stuck in the old version. Not true here. Joseph Sack goes provides numerous useful examples of how to use the new features of SQL Server 2005. If he missed one I have yet to find it.

Lost in the hoopla of CLR integration for example, is the new feature likely to fundamentally change how we approach SQL application architecture: the Service Broker. Joseph provides 15 separate "how it works" examples of using the service broker including "Enabling Transport Security", "Enabling Dialog Security", "Creating Routes and Remote Service Bindings" and "Event Notifications."

Since Amazon hasn't provided a Table of Contents, I'll give a high level one:
Chapter 1) Select (44 recipes)
Chapter 2) Insert, Update, Delete (14 recipes)
Chapter 3) Transactions, Locking, Blocking and Deadlocking (8 recipes)
Chapter 4) Tables (35 recipes)
Chapter 5) Indexes (16 recipes)
Chapter 6) Full-Text Search (14 recipes)
Chapter 7) Views (11 recipes)
Chapter 8) SQL Server Functions (56 recipes)
Chapter 9) Conditional Processing, Control-of-Flow and Cursors (8 recipes)
Chapter 10) Stored Procedures (12 recipes)
Chapter 11) User-Defined Functions and Types (12 recipes)
Chapter 12) Triggers (14 recipes)
Chapter 13) CLR Integration (10 recipes) (and a section on when and when NOT to use CLR integration assemblies)
Chapter 14) XML (8 recipes)
Chapter 15) Web Services (6 recipes)
Chapter 16) Error Handling (8 recipes)
Chapter 17) Principals (19 recipes - managing users and roles)
Chapter 18) Securables and Permissions (10 recipes)
Chapter 19) Encryption (20 recipes)
Chapter 20) Service Broker (15 recipes)
Chapter 21) Configuring and Viewing SQL Server Options (2 recipes)
Chapter 22) Creating and Configuring Databases (33 recipes)
Chapter 23) Database Integrity and Optimization (8 recipes)
Chapter 24) Maintaining Database Objects and Object Dependencies (4 recipes)
Chapter 25) Database Mirroring (10 recipes)
Chapter 26) Database Snapshots (3 recipes)
Chapter 27) Linked Servers and Distributed Queries (12 recipes)
Chapter 28) Performance Tuning (17 recipes)
Chapter 29) Backup and Recovery (18 recipes)

Highly Recommended.

9 of 9 people found the following review helpful:

5.0 out of 5 stars Great for quickly finding out how to do something, January 23, 2006

By 

Adam Machanic "Data Dude" (Melrose, MA United States) - See all my reviews
(REAL NAME)   

This review is from: SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach (Expert's Voice) (Paperback)

This book's "recipe" format makes it great for quickly figuring out how to do something. The examples are straight to the point--so don't expect really deep insights. Rather, this is the kind of book you'll want to keep on your desk for those times you might get stuck on a task. Flip to the right page and there you have it.

There's also a "how it works" section for every recipe that briefly describes what's going on. If you're in more of a cover-to-cover reading mode, that should help enhance the book's readability.

9 of 9 people found the following review helpful:

4.0 out of 5 stars Excellent Data Manipulation Language Coverage, February 26, 2006

By 

T. Anderson (PA USA) - See all my reviews
(VINE VOICE)    (TOP 1000 REVIEWER)    (REAL NAME)   

This review is from: SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach (Expert's Voice) (Paperback)

See the other review to see what is covered in this book. It is an excellent book and thoroughly covers everything it includes. It covers everything you need to know about the Data Manipulation Language (DML)

The only downside I found was that it doesn't cover the Data Definition Language (DDL) much at all, which was somewhat disappointing.

It's a great book to have by your side.