PROFESSIONAL MICROSOFT SQL SERVER 2008 PROGRAMMING by ROBERT VIEIRA details from flipkart

This book shows experienced developers how to master the increasingly complex feature set of the latest release of Microsoft SQL Server.

The book begins with a concise overview of the new features of SQL Server that is of interest to experienced developers. From there, the book quickly moves on to the meat of the title, with extensive code examples.

The new edition is substantially revised---about 40% revised, plus 75 more pages---to cover the extensive and pervasive changes that come with the 2008 release. SQL Server 2008 brings with it: new data types, new indexing structures, new manageability features, and advanced time zone handling -- it is expected that later CTPs will reveal additional changes.

The book's companion site provides all of the source code, so readers can quickly implement the soluitons described in the book.

About the Author
Robert Vieira is one of the leading authorities on Microsoft SQL Server and author of Professional SQL Server Programming, with more than 46,000 copies in its 2000 and 2005 editions. Vieira is currently an independent consultant in Vancouver, WA. He speaks frequently at both public and private conferences nationally, and is perhaps best known for his unique tutorial approach both in teaching and writing. He plans to aggressively promote the book via speaking engagements at the PASS 2008 Conference, a new SQL Server programming blog, and in articles in SQL Server Magazine.

Table of Contents

• Introduction.
• Chapter 1: Being Objective: Re-Examining Objects in SQL Server.
• 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) and Other 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 That Performs 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.