Inside Microsoft Sql Server 2008

( 5 )

Overview

Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of this programming language—solving complex problems with real-world solutions.

Discover how to:

  • Work with T-SQL and CLR user-defined functions, ...
See more details below
Paperback
$34.69
BN.com price
(Save 30%)$49.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (22) from $19.72   
  • New (15) from $30.12   
  • Used (7) from $16.01   
Inside Microsoft SQL Server 2008: T-SQL Programming

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$22.99
BN.com price
(Save 42%)$39.99 List Price

Overview

Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of this programming language—solving complex problems with real-world solutions.

Discover how to:

  • Work with T-SQL and CLR user-defined functions, stored procedures, and triggers.
  • Handle transactions, concurrency, and error handling.
  • Efficiently use temporary objects, including temporary tables, table variables, and table expressions.
  • Evaluate when to use set-based programming techniques and when to use cursors.
  • Work with dynamic SQL in an efficient and secure manner.
  • Treat date- and time-related data in a robust manner.
  • Develop CLR user-defined types and learn about temporal support in the relational model.
  • Use XML and XQuery and implement a dynamic schema solution.
  • Work with spatial data using the new geometry and geography types and spatial indexes.
  • Track access and changes to data using extended events, SQL Server Audit, change tracking, and change data capture.
  • Use Service Broker for controlled asynchronous processing in database applications.

All the book’s code samples will be available for download from the companion Web site.

Read More Show Less

Product Details

  • ISBN-13: 9780735626027
  • Publisher: Microsoft Press
  • Publication date: 9/30/2009
  • Pages: 834
  • Sales rank: 685,726
  • Product dimensions: 7.50 (w) x 9.00 (h) x 2.00 (d)

Meet the Author

Itzik Ben-Gan is a mentor and cofounder of Solid Quality Mentors. A Microsoft MVP for SQL Server since 1999, Ben-Gan teaches and consults internationally on T-SQL querying, programming, and query tuning. He is the coauthor of Inside Microsoft SQL Server: T-SQL Querying and Inside Microsoft SQL Server:T-SQL Programming. He has written numerous articles for SQL Server Magazine and MSDN®, and speaks at industry events such as Microsoft Tech*Ed, DevWeek, PASS, and SQL Server Connections.

Dejan Sarka is MCT and MCDBA certified and a Microsoft® MVP for SQL Server®. He teaches and consults for Solid Quality Mentors, speaks at TechEd and PASS, and develops OLTP, OLAP, and data mining solutions.

Greg Low is a SQL Server MVP and Microsoft Regional Director. He is based in Melbourne, Australia and is the CEO and Principal Mentor for SQL Down Under. Greg is probably best known for his SQL Down Under podcast.

Roger Wolter is an architect on the Microsoft IT MDM (Master Data Management) project team. He has 30 years of experience in various aspects of the computer industry and has spent the past 10 years as a program manager at Microsoft. His projects at Microsoft include SQLXML, the Soap Toolkit, the SQL Server Service Broker, SQL Server Express, and Master Data Services.Dr.

Ed Katibah is a principal program manager on the Microsoft SQL Server Security team.

Isaac Kunen is a senior program manager on the Microsoft SQL Server Storage Engine team.

Read More Show Less

Table of Contents

Dedication;
Foreword;
Acknowledgments;
Introduction;
Hardware and Software Requirements;
Companion Content and Sample Database;
Find Additional Content Online;
Support for These Books;
Chapter 1: Views;
1.1 What Are Views?;
1.2 ORDER BY in a View;
1.3 Refreshing Views;
1.4 Modular Approach;
1.5 Updating Views;
1.6 View Options;
1.7 Indexed Views;
1.8 Conclusion;
Chapter 2: User-Defined Functions;
2.1 Some Facts About UDFs;
2.2 Scalar UDFs;
2.3 Table-Valued UDFs;
2.4 Per-Row UDFs;
2.5 Conclusion;
Chapter 3: Stored Procedures;
3.1 Types of Stored Procedures;
3.2 The Stored Procedure Interface;
3.3 Resolution;
3.4 Dependency Information;
3.5 Compilations, Recompilations, and Reuse of Execution Plans;
3.6 EXECUTE AS;
3.7 Parameterizing Sort Order;
3.8 CLR Stored Procedures;
3.9 Conclusion;
Chapter 4: Triggers;
4.1 AFTER Triggers;
4.2 DDL Triggers;
4.3 Logon Triggers;
4.4 CLR Triggers;
4.5 Conclusion;
Chapter 5: Transactions and Concurrency;
5.1 What Are Transactions?;
5.2 Locking and Blocking;
5.3 Lock Escalation;
5.4 Isolation Levels;
5.5 Savepoints;
5.6 Deadlocks;
5.7 Conclusion;
Chapter 6: Error Handling;
6.1 Error Handling without the TRY/CATCH Construct;
6.2 Error Handling with the TRY/CATCH Construct;
6.3 Conclusion;
Chapter 7: Temporary Tables and Table Variables;
7.1 Temporary Tables;
7.2 Table Variables;
7.3 tempdb Considerations;
7.4 Table Expressions;
7.5 Comparison Summary;
7.6 Summary Exercises;
7.7 Conclusion;
Chapter 8: Cursors;
8.1 Using Cursors;
8.2 Cursor Overhead;
8.3 Dealing with Each Row Individually;
8.4 Order-Based Access;
8.5 Conclusion;
Chapter 9: Dynamic SQL;
9.1 EXEC;
9.2 sp_executesql;
9.3 Environmental Settings;
9.4 Uses of Dynamic SQL;
9.5 SQL Injection;
9.6 Conclusion;
Chapter 10: Working with Date and Time;
10.1 Date and Time Data Types;
10.2 Date and Time Manipulation;
10.3 Date- and Time-Related Querying Problems;
10.4 Conclusion;
Chapter 11: CLR User-Defined Types;
11.1 Theoretical Introduction to UDTs;
11.2 Programming a UDT;
11.3 Conclusion;
Chapter 12: Temporal Support in the Relational Model;
12.1 Timestamped Predicates and Propositions;
12.2 Semitemporal Problems;
12.3 Tables with Full Temporal Support;
12.4 Unpack and Pack;
12.5 Sixth Normal Form in Use;
12.6 Conclusion;
Chapter 13: XML and XQuery;
13.1 Converting Relational Data to XML and Vice Versa;
13.2 The XQuery Language in SQL Server 2008;
13.3 XML Data Type;
13.4 Dynamic Relational Schema;
13.5 Conclusion;
Chapter 14: Spatial Data;
14.1 Introduction to Spatial Data;
14.2 Basic Spatial Data Concepts;
14.3 Data;
14.4 Getting Started with Spatial Data;
14.5 Spatial Data Validity;
14.6 Measuring Length and Area;
14.7 Indexing Spatial Data;
14.8 Using Spatial Data to Solve Problems;
14.9 Extending Spatial Support with CLR Routines;
14.10 Conclusion;
Chapter 15: Tracking Access and Changes to Data;
15.1 Which Technology Do I Use?;
15.2 Extended Events Implementation;
15.3 SQL Server Audit Implementation;
15.4 Change Tracking Implementation;
15.5 Change Data Capture Implementation;
15.6 Conclusion;
Chapter 16: Service Broker;
16.1 Dialog Conversations;
16.2 Activation;
16.3 Conversation Priority;
16.4 Sample Dialog;
16.5 Poison Messages;
16.6 Dialog Security;
16.7 Routing and Distribution;
16.8 Troubleshooting;
16.9 Scenarios;
16.10 Where Does Service Broker Fit?;
16.11 Conclusion;
Companion to CLR Routines;
Create the CLRUtilities Database: SQL Server;
Development: Visual Studio;
Deployment and Testing: Visual Studio and SQL Server;
About the Authors;

Read More Show Less

Customer Reviews

Average Rating 4.5
( 5 )
Rating Distribution

5 Star

(3)

4 Star

(1)

3 Star

(1)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Posted October 27, 2010

    more from this reviewer

    Highly Recommended! Inside Microsoft SQL Server 2008-T-SQL Programming

    I have used SQL Server since the 6.5/7.0 days and thought I knew enough to get by. I had various experiences with SQL Server 2000/2005, and then did not immediately use SQL Server 2008 until the Spring of 2010; I took a T-SQL CLASS using SQL Server 2008 at Mt. San Antonio College in Walnut, California. I learned a great deal that I did not previously know from Professor Shui-lien Huang, a very excellent teacher.

    You can work with SQL Server, and unless you have the opportunity to have many challenges to stretch your skills, you may seemingly work in a silo and never learn all of it, which is a good reason to buy this book: "Inside Microsoft SQL Server 2008: T-SQL Programming". I am glad I had the T-SQL class before reading this book.

    This book contains the typical coverage for a standard T-SQL statement, and then User-Defined Functions (UDFs), Triggers, Stored Procedures, Views, etc., but also some new things. For example, extending SQL Server by using CLR (Common Language Runtime) user defined types, the use of XML, dynamic SQL, and Service Broker for reliable, asynchronous processing, and Spatial Data (i.e. geodata).
    On the subject of Spatial Data in Chapter 14, Microsoft has brought forth new data types, operators, and indexes to the database. Microsoft introduces the core spatial concepts and provides key programming constructs to successfully navigate this new feature in SQL Server 2008. There are 70 pages covering Spatial Data. Obviously, this is a heavy topic.

    Because of auditing and compliance requirements, the issue of tracking access and changes to data has become much more important. This book shows how previous versions of SQL Server did take care of this to some degree, but in SQL Server 2008, Microsoft has added the following: change tracking, change data capture, Extended Events, and SQL Server Audit. The book shows provides guidance on where each of these new technologies is best used, and then goes on to show how to implement each technology.

    This is not a beginner's T-SQL book, but it does cover beginner topics, as mentioned above. In addition, it covers some of the new aspects of SL Server 2008 that are more complex. This is most assuredly a valuable reference book that all T-SQL and .NET developers and database administrators should have nearby. It will give you excellent instruction and answers to your T-SQL questions.

    2 out of 2 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted February 13, 2011

    No text was provided for this review.

Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)