Professional Microsoft SQL Server 2008 Programming [NOOK Book]

Overview

Master the increasingly complex feature set of the latest release of Microsoft SQL Server with the information in Professional Microsoft SQL Server 2008 Programming. Review the new features of SQL Server that will be of interest to you as an experienced developer and move on to more detailed, practical code examples. Learn how to write complex queries, build different types of data structures, improve application speed and performance, manage advanced scripting and errors, and design advanced databases the latest...

See more details below
Professional Microsoft SQL Server 2008 Programming

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • 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)
$28.49
BN.com price
(Save 43%)$49.99 List Price
Note: This NOOK Book can be purchased in bulk. Please email us for more information.

Overview

Master the increasingly complex feature set of the latest release of Microsoft SQL Server with the information in Professional Microsoft SQL Server 2008 Programming. Review the new features of SQL Server that will be of interest to you as an experienced developer and move on to more detailed, practical code examples. Learn how to write complex queries, build different types of data structures, improve application speed and performance, manage advanced scripting and errors, and design advanced databases the latest edition of this valuable programming guide.

Read More Show Less

Product Details

  • ISBN-13: 9780470632093
  • Publisher: Wiley
  • Publication date: 9/29/2010
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 936
  • File size: 22 MB
  • Note: This product may take a few minutes to download.

Meet the Author

Experiencing his first infection with computing fever in 1978,Rob Vieira knew right away that this was something‘‘really cool.’’ In 1980 he began immersinghimself into the computing world more fully — splitting timebetween building and repairing computer kits, and programming inBASIC as well as Z80 and 6502 assembly. In 1983, he began studiesfor a degree in Computer Information Systems, but found theprofessional mainframe environment too rigid for his tastes anddropped out in 1985 to pursue other interests. Later that year, hecaught the "PC bug" and began the long road of programming indatabase languages from dBase to SQL Server. Rob completed a degreein business administration in 1990 and since has typically workedin roles that allow him to combine his unique knowledge of businessand computing. Beyond his bachelor’s degree, he has beencertified as a Certified Management Accountant (CMA); MicrosoftCertified as a Solutions Developer (MCSD), Trainer (MCT), andDatabase Administrator (MCDBA); and even had a brief stintcertified as an EmergencyMedical Technician (EMT).
Rob is currently the Database Team Lead for Stockamp, a HuronConsulting Group practice. He has published six books on SQL Serverdevelopment

Read More Show Less

Table of Contents

Introduction.

Chapter 1: Being Objective: Re-Examining Objects in SQLServer.

Chapter 2: Tool Time.

Chapter 3: Asking a Better Question: Advanced Queries.

Chapter 4: XML Integration.

Chapter 5: Daring to Design.

Chapter 6: Core Storage and Index Structure.

Chapter 7: More Advanced Index Structures.

Chapter 8: Views.

Chapter 9: Scripts and Batches.

Chapter 10: Advanced Programmability.

Chapter 11: Transactions and Locks.

Chapter 12: Triggers.

Chapter 13: SQL Cursors.

Chapter 14: Reporting Services.

Chapter 15: Buying in Bulk: The Bulk Copy Program (BCP) andOther BasicBulkOperations.

Chapter 16: Getting Integrated.

Chapter 17: Replication.

Chapter 18: Looking at Things in Full: Full-Text Search.

Chapter 19: Feeling Security.

Chapter 20: A Grand Performance: Designing a Database ThatPerforms Well.

Chapter 21: What Comes After: Forensic Performance Tuning.

Chapter 22: Administration.

Chapter 23: SMO: SQLManagement Objects.

Chapter 24: Data Warehousing.

Chapter 25: BeingWell Connected.

Appendix A: System Functions.

Appendix B: Going Meta: Getting Data About Your Data.

Appendix C: The Basics.

Index.

Read More Show Less

Customer Reviews

Average Rating 5
( 1 )
Rating Distribution

5 Star

(1)

4 Star

(0)

3 Star

(0)

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 1 Customer Reviews
  • Anonymous

    Posted June 16, 2011

    No text was provided for this review.

Sort by: Showing 1 Customer Reviews

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