Table of Content

for RuBoard

Guru's Guide to SQL Server Stored Procedures, XML, and HTML, The
By Ken  Henderson
Publisher	: Addison Wesley
Pub Date	: December 28, 2001
ISBN	: 0-201-70046-8
Pages	: 800
Slots	: 1			Copyright
		Foreword
		Preface
		Introduction
			About the Sample Databases
			Acknowledgments
			About the Author
		Part I:   The Basics
			Chapter  1.   Stored Procedure Primer
				What Is a Stored Procedure?
				Stored Procedure Advantages
				Creating a Stored Procedure
				Altering Stored Procedures
				Executing Stored Procedures
				Extended Stored Procedures
				Environmental Issues
				Parameters
				Flow Control Language
				Errors
				Nesting
				Recursion
				Summary
			Chapter  2.   Suggested Conventions
				Source Formatting
				Coding Conventions
				Summary
			Chapter  3.   Common Design Patterns
				The Law of Parsimony
				Idioms
				Design Patterns
				Summary
			Chapter  4.   Source Code Management
				The Benefits of Source Code Management
				The dt Procedures
				Best Practices
				Version Control from Query Analyzer
				Automating Script Generation with Version Control
				Summary
			Chapter  5.   Database Design
				General Approach
				Modeling Tools
				The Sample Project
				The Five Processes
				The Five Phases Examined
				Modeling Business Processes
				Entity-Relationship Modeling
				Relational Data Modeling
				Summary
			Chapter  6.   Data Volumes
				Approaches to Generating Data
				Speed
				Summary
		Part II:   Objects
			Chapter  7.   Error Handling
				Error Reporting
				Handling Errors
				Summary
			Chapter  8.   Triggers
				Determining What Has Changed
				Managing Sequential Values
				Trigger Restrictions
				INSTEAD OF Triggers
				Triggers and Auditing
				Transactions
				Execution
				Calling Stored Procedures
				Nested Triggers
				Disabling Triggers
				Best Practices
				Summary
			Chapter  9.   Views
				Meta-data
				Restrictions
				ANSI SQL Schema Views
				Updatable Views
				The WITH CHECK OPTION Clause
				Derived Tables
				Parameterized Views
				Dynamic Views
				Partitioned Views
				Indexed Views
				Designing Modular Indexed Views
				Summary
			Chapter  10.   User-Defined Functions
				Scalar Functions
				Table-Valued Functions
				Inline Functions
				Limitations
				Meta-data
				Creating Your Own System Functions
				UDF Cookbook
				Summary
		Part III:   HTML, XML, and NET
			Chapter  11.   HTML
				Origins
				Producing HTML from Transact-SQL
				Producing HTML from sp_makewebtask
				Summary
			Chapter  12.   Introduction to XML
				Wooden Nickels
				XML: An Overview
				HTML: Simplicity Comes at a Price
				XML: A Brief History
				XML versus HTML: An Example
				Document Type Definitions
				XML Schemas
				Extensible Stylesheet Language Transformation (XSLT)
				Document Object Model
				Further Reading
				Tools
				Summary
			Chapter  13.   XML and SQL Server: HTTP Queries
				Accessing SQL Server over HTTP
				URL Queries
				Template Queries
				Summary
			Chapter  14.   XML and SQL Server: Retrieving Data
				SELECT FOR XML
				RAW Mode
				AUTO Mode
				ELEMENTS
				EXPLICIT Mode
				Mapping Schemas
				Summary
			Chapter  15.   XML and SQL Server: OPENXML
				The Flags Parameter
				Edge Table Format
				Inserting Data with OPENXML()
				Web Release 1
				Limitations
				Summary
			Chapter  16.   .NET and the Coming Revolution
				.NET: The Future of Applications Development
				What Is .NET?
				On Microsoft Bashing
				Microsoft Bigotry?
				Summary
		Part IV:   Advanced Topics
			Chapter  17.   Performance Considerations
				Indexing
				Statistics
				Query Optimization
				Summary
			Chapter  18.   Debugging and Profiling
				Debugging
				Profiling
				Stress Testing
				Summary
			Chapter  19.   Automation
				A Brief Overview of COM
				SQL Server and COM Automation
				Summary
			Chapter  20.   Extended Stored Procedures
				Open Data Services
				A Simple Example
				A Better Example
				Making Extended Procedures Easier to Use
				Debugging Extended Procedures
				Isolating Extended Procedures
				xp_setpriority
				Summary
			Chapter  21.   Administrative Stored Procedures
				sp_readtextfile
				sp_diff
				sp_generate_script
				Sp_start_trace
				sp_stop_trace
				sp_list_trace
				sp_proc_runner
				sp_create_backup_job
				sp_diffdb
				Summary
			Chapter  22.   Undocumented Transact-SQL
				What Defines Undocumented?
				Undocumented Procedures
				Creating INFORMATION_SCHEMA Views
				Creating System Functions
				Undocumented DBCC Commands
				Undocumented Trace Flags
				Summary
			Chapter  23.   Arrays
				xp_array.dll
				Array System Functions
				The Pi ce de R sistance
				Multidimensional Arrays
				Summary
		Part V:   Essays on Software Engineering
			Chapter  24.   Creating a Workable Environment
				Get Rid of Distractions
				Close the Door
				Internal Distractions
				Form Over Function
				Silence Is Golden; Communication Divine
				Conclusion
				Epilogue
			Chapter  25.   Evolutionary Development
				Kaizen
				The Benefits of Small Changes
				Software
				Software Entropy
				Refactoring
				Selling Management (or Yourself) on Refactoring
				When Not to Refactor
				Databases
				Can You Refactor Instead of Design?
				Code Extinction
				Extreme Programming
				Conclusion
				Epilogue
			Chapter  26.   The Gestalt of Testing
				Where to Begin
				The Futility of Testing
				Types of Tests
				When to Test
				Testing Can Save Time
				Testing in the Extreme
				Other Types of Testing
				Conclusion
				Epilogue
			References

for RuBoard