Professional SQL Server 2005 Programming

Professional SQL Server 2005 Programming

3.5 (6 ratings by Goodreads)
By (author) 

List price: US$49.99

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks


Professional SQL Server 2005 Programming shows experienced developers how to master the substantially revamped 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. This is especially important given the substantial changes to SQL Server with this release. From there, the book quickly moves on to the meat of the title. Beginning-level material has been removed to provide more room for covering new features and more extensive code examples.
show more

Product details

  • Mixed media product | 912 pages
  • 188 x 233.7 x 50.8mm | 1,247.39g
  • John Wiley & Sons Inc
  • Indianapolis, IN, United States
  • English
  • 0764584340
  • 9780764584343
  • 1,410,784

About Robert Vieira

Robert Vieira is one of the leading authorities on Microsoft SQL Server and author of the bestselling title from Wrox Press, Professional SQL Server 2000 Programming, with nearly 40,000 copies in print. Vieira is currently a Software Architect for NetIQ Corporation in Portland, OR, where he performs design work and coaches other developers. He speaks frequently at both public and private conferences nationally, and is perhaps best known for his light-hearted approach to teaching and writing.
show more

Table of contents

Acknowledgments. Introduction. Chapter 1: Being Objective: Re-Examining Objects in SQL Server. Chapter 2: Tool Time. Chapter 3: Basic T-SQL. Chapter 4: Creating and Altering Tables. Chapter 5: Reviewing Keys and Constraints. Chapter 6: Asking a Better Question: Advanced Queries. Chapter 7: Daring to Design. Chapter 8: SQL Server - Storage and Index Structures. Chapter 9: Views. Chapter 10: Scripts and Batches. Script Basics. Chapter 11: Getting Procedural: Stored Procedures and User-Defined. Chapter 12: Transactions and Locks. Chapter 13: Triggers. Chapter 14: Nothing But NET! Chapter 15: SQL Cursors. Chapter 16: XML Integration Chapter 17: Reporting for Duty, Sir! Chapter 18: Buying in Bulk: the Bulk Copy Program (BCP) and Other Basic Bulk Operations. Chapter 19: Getting Integrated. Chapter 20: Replication. Chapter 21: Looking at Things in Full: Full-Text Search. Chapter 22: Security. Security Basics. Chapter 23: Playing a Good Tune: Performance Tuning. Chapter 24: Administrator. Chapter 25: SMO: SQL Management Objects. Appendix A: System Functions. Appendix B: Connectivity. Appendix C: Getting Service. Index.
show more

Rating details

6 ratings
3.5 out of 5 stars
5 0% (0)
4 50% (3)
3 50% (3)
2 0% (0)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X