With a general understanding of programming principles, SQL Server Programming provides a comprehensive overview of the new areas of SQL Server, for programmers. There is an in-depth discussion of T-SQL, the query language of Microsoft SQL Server. From basic database design concepts a tutorial explains more advanced topics and specific areas including Stored Procedures and Advanced Queries. Advanced topics of performance tuning, security and a solid description of OLAP, which is built in with SQL Server, are then introduced. Data Transformation Services are explained in detail and Remote and Linked SQL Server Agents are covered. With over 1,000 pages this book covers the main topics to provide an in-depth understanding of concepts and procedures, so programmers can get the most out of SQL Server 7.0. Online discussion of the topics in this book available at Wrox's P2P site Whether you're coming from another relational database management system, upgrading your existing system, or perhaps want to add programming skills to your DBA knowledge, you'll find what you need in this book to get to grips with SQL Server 7.0 development. There is no particular programming language, so you'll get as much out of the book if you're programming in C++ as you would in Visual Basic.

Table of Contents:
Chapter 1: SQL Server 7.0 - Particulars and History Chapter 2: RDBMS Basics: What Makes Up a SQL Server Database? Chapter 3: Tools of the Trade Chapter 4: The Foundation Statements of T-SQL Chapter 5: Joining Tables Chapter 6: Creating and Altering Tables Chapter 7: Constraints Chapter 8: Normalization and Other Basic Design Issues Chapter 9: Speeding Performance: SQL Server Storage and Index Structures Chapter 10: Views Chapter 11: Writing Scripts and Batches Chapter 12: Code Storage: Stored Procedures Chapter 13: Transactions and Locks Chapter 14: Triggers Chapter 15: Asking a Better Question: Advanced Queries Chapter 16: Spreading Things Out: Distributed Queries and Transactions Chapter 17: SQL Cursors Chapter 18: Making a Change. Bulk Copy Program and Data Transformation Services Chapter 19: Replication Chapter 20: Advanced Design Chapter 21: OLAP Chapter 22: English Query and Full-Text Search Chapter 23: Security Chapter 24: Performance Tuning Chapter 25: Administration Overview Appendix A: Global Variables Appendix B: Function Listing Appendix C: Tools for Our Time Appendix D: Error Listing Appendix E: Access Upsizing