Cover -- Table of Contents -- Title Page -- Copyright -- Dedication -- About the Author -- Credits -- Acknowledgments -- Introduction -- Who This Book Is For -- What This Book Covers -- How This Book Is Structured -- What You Need to Use This Book -- Conventions -- Source Code -- Errata -- p2p.wrox.com -- www.professionalsql.com -- 1: RDBMS Basics: What Makes Up a SQL Server Database? -- An Overview of Database Objects -- SQL Server Data Types -- SQL Server Identifiers for Objects -- Summary -- 2: Tools of the Trade -- Books Online -- SQL Server Configuration Manager -- SQL Server Management Studio -- SQL Server Integration Services (SSIS) -- Bulk Copy Program (bcp) -- SQL Server Profiler -- sqlcmd -- PowerShell -- Summary -- 3: The Foundation Statements of T-SQL -- Getting Started with a Basic SELECT Statement -- Adding Data with the INSERT Statement -- Changing What You've Got with the UPDATE Statement -- The DELETE Statement -- Summary -- Exercises -- 4: JOINs -- JOINs -- INNER JOINs -- OUTER JOINs -- Seeing Both Sides with FULL JOINs -- CROSS JOINs -- Exploring Alternative Syntax for Joins -- The UNION -- Summary -- Exercises -- 5: Creating and Altering Tables -- Object Names in SQL Server -- The CREATE Statement -- The ALTER Statement -- The DROP Statement -- Using the GUI Tool -- Summary -- Exercises -- 6: Constraints -- Types of Constraints -- Constraint Naming -- Key Constraints -- CHECK Constraints -- DEFAULT Constraints -- Disabling Constraints -- Rules and Defaults - Cousins of Constraints -- Triggers for Data Integrity -- Choosing What to Use -- Summary -- 7: Adding More to Our Queries -- What Is a Subquery? -- Correlated Subqueries -- Derived Tables -- The EXISTS Operator -- Mixing Data Types: CAST and CONVERT -- The MERGE Command -- Performance Considerations -- Summary -- Exercises.

8: Being Normal: Normalization and Other Basic Design Issues -- Tables -- Keeping Your Data "Normal" -- Relationships -- Diagramming -- De-Normalization -- Beyond Normalization -- Drawing Up a Quick Example -- Summary -- Exercises -- 9: SQL Server Storage and Index Structures -- SQL Server Storage -- Understanding Indexes -- Creating, Altering, and Dropping Indexes -- Choosing Wisely: Deciding What Index Goes Where and When -- Maintaining Your Indexes -- Summary -- Exercises -- 10: Views -- Simple Views -- More Complex Views -- Editing Views with T-SQL -- Dropping Views -- Creating and Editing Views in the Management Studio -- Auditing: Displaying Existing Code -- Protecting Code: Encrypting Views -- About Schema Binding -- Making Your View Look Like a Table with VIEW_METADATA -- Indexed (Materialized) Views -- Summary -- Exercises -- 11: Writing Scripts and Batches -- Script Basics -- Batches -- sqlcmd -- Dynamic SQL: Generating Your Code On the Fly with the EXEC Command -- Control-of-Flow Statements -- Summary -- Exercises -- 12: Stored Procedures -- Creating the Sproc: Basic Syntax -- Changing Stored Procedures with ALTER -- Dropping Sprocs -- Parameterization -- Confirming Success or Failure with Return Values -- More On Dealing with Errors -- What a Sproc Offers -- Extended Stored Procedures (XPs) -- A Brief Look at Recursion -- Debugging -- .NET Assemblies -- Summary -- 13: User-Defined Functions -- What a UDF Is -- UDFs Returning a Scalar Value -- UDFs That Return a Table -- Debugging User-Defined Functions -- .NET in a Database World -- Summary -- Exercise -- 14: Transactions and Locks -- Transactions -- How the SQL Server Log Works -- Locks and Concurrency -- Setting the Isolation Level -- Dealing with Deadlocks (aka "a 1205") -- Summary -- 15: Triggers -- What Is a Trigger? -- Using Triggers for Data Integrity Rules.

Other Common Uses for Triggers -- Other Trigger Issues -- INSTEAD OF Triggers -- Performance Considerations -- Dropping Triggers -- Debugging Triggers -- Summary -- 16: A Brief XML Primer -- XML Basics -- What SQL Server Brings to the Party -- A Brief Word on XSLT -- Summary -- 17: Reporting for Duty, Sir! A Look At Reporting Services -- Reporting Services 101 -- Building Simple Report Models -- Report Server Projects -- Summary -- 18: Getting Integrated with Integration Services -- Understanding the Problem -- Using the Import/Export Wizard to Generate Basic Packages -- Examining Package Basics -- Executing Packages -- A Final Word on Packages -- Summary -- 19: Playing Administrator -- Scheduling Jobs -- Backup and Recovery -- Index Maintenance -- Policy Based Management -- Summary -- Exercises -- A: System Functions -- Legacy System Functions (a.k.a. Global Variables) -- Aggregate Functions -- Configuration Functions -- Cryptographic Functions -- Cursor Functions -- Date and Time Functions -- Hierarchy Functions -- Mathematical Functions -- Basic Metadata Functions -- Rowset Functions -- Security Functions -- String Functions -- System Functions -- Text and Image Functions -- B: Very Simple Connectivity Examples -- Some General Concepts -- Connectivity Examples -- A Brief Word on LINQ -- Index -- Advertisement -- End User License Agreement.