Table of Contents

Hitchhiker's Guide to Visual Studio and SQL Server, 7th Edition: Best Practice Architectures and Examples
By R. Vaughn William, Peter Blackburn
...............................................
Publisher: Addison Wesley Professional
Pub Date: November 02, 2006
Print ISBN-10: 0-321-24362-5
Print ISBN-13: 978-0-321-24362-1
Pages: 1128

Table of Contents  | Index

		Copyright
		Microsoft Windows Server System Series
		Foreword
		Acknowledgments
		About the Authors
		Introduction
			How Did I Get to This Point?
			The 7th Edition's Scope
			Keeping Current
			Is This Book Written For You?
			Getting Help and Support
		Chapter 1.  Exploring Application Architectures
			Introduction
			Choosing the "Right" Architecture
			Understanding Your Toolset
			Recognizing Application Design Constraints
			Choosing the Right Data Access Interface
			Choosing the Right Database Management System
			Understanding Basic Data Access Architectures
			Summary
		Chapter 2.  How Does SQL Server Work?
			Introduction
			Servers and Versions
			Installing SQL Server
			Running SQL Server Services
			Touring the SQL Server System Databases
			Understanding the SQL Server Security System
			Managing SQL Server Connections
			Using the SQL Query Tools
			Creating SELECT Queries
			Creating and Querying Views
			Implementing Business Rules
			User-Defined (Aliased) Types
			Implementing Constraints
			Managing Databases and Queries with Batches and Scripts
			The Query Optimizer and the Query Plan
			Understanding the Buffer Cache
			Executing Action Commands
			Introducing Stored Procedures
			Introducing Triggers
			Using Transactions to Protect Data Integrity
			Administrative Functions
			Working with the Transaction Log
			Summary
		Chapter 3.  Relational Databases 101
			Introduction
			Getting Started with Solid Database Design
			Understanding Relational Database Normalization
			Creating Tables, Rows, and Columns
			Summary
		Chapter 4.  Getting Started with Visual Studio
			Introduction
			How I Got Here
			Installing the "Right" Version of Visual Studio
			Launching Visual Studio
			Customizing Visual Studio 2005
			Configuring Server (or Database) Explorers
			Creating and Managing Database Connections
			Managing Database Objects with the Server Explorer
			Managing Queries with the Query Designer
			Using the Server Explorer to View Synonyms
			Using the Server Explorer to Manage Types
			Using the Server Explorer to Manage Assemblies
			Using the Server Explorer to Manage Servers
			Summary
		Chapter 5.  Managing Executables with the Server Explorer
			Introduction
			Creating and Editing Stored Procedures
			Creating New Stored Procedures
			Executing T-SQL with Run Selection
			Debugging Stored Procedures
			Debugging Stored Procedures on Remote Instances
			Debugging Stored Procedures from Code
			Using the Server Explorer to Manage Functions
			Summary
		Chapter 6.  Building Data Sources, DataSets, and TableAdapters
			Why Create YADAI?
			Is Strongly Typed Data Important?
			What Is a Data Source?
			What Is a TableAdapter?
			What's Missing in the TableAdapter?
			Creating Database-Based Data Sources
			Configuring a TableAdapter
			Binding to the TableAdapter Using Drag and Drop
			Using a TableAdapter DirectlyWithout Drag-and-Drop?
			Managing DataTable Classes in the Data Source Designer
			Moving Data Sources Between Applications
			Creating Web Service Data Sources
			Summary
		Chapter 7.  Managing Data Tools and Data Binding
			Introduction
			Touring the Visual Studio Toolbox
			Using the DataSet Toolbox Element
			Introduction to Data Binding
			Using the BindingSource Class
			Using the BindingNavigator Control
			Using the DataGridView Control
			Using the ProgressBar Control
			Summary
		Chapter 8.  Getting Started with ADO.NET
			Introduction
			Approaching Data Access Challenges
			ADO.NET from 50,000 Feet
			Using the Visual Studio Object Browser to Explore ADO.NET
			Instantiating ADO.NET Objects
			Exploring the System.Data.SqlClient Namespace
			Exploring the SqlClient Namespace
			Exploring the System.Data Namespace
			Summary
		Chapter 9.  Getting Connected
			Introduction
			Connectivity StrategiesThat Include Security
			Configuring the Server and Firewall
			Connection Strategies
			Establishing a Connection
			Writing Code to Create Connections
			Understanding and Managing the Connection Pool
			Building a ConnectionString for Other Providers
			Getting Visual Studio to Build Your ConnectionString
			Opening and Closing Connections (Semi-) Automatically
			Understanding the Connection Properties
			Using the Connection Methods
			Handling Connection Events
			Managing Connection Exceptions
			Summary
		Chapter 10.  Managing SqlCommand Objects
			Introduction
			Creating SqlCommand Objects
			Integrating Ad Hoc Queries into Your Application
			Coding Parameter Queries
			Validating the Value
			Executing Stored Procedures
			Summary
		Chapter 11.  Executing SqlCommand Objects
			Introduction
			Executing SqlCommand Objects Synchronously
			Understanding the SqlDataReader
			Populating Data Structures
			Fetching Rows Asynchronously
			Executing Commands Asynchronously
			Summary
		Chapter 12.  Managing Updates
			Introduction
			Using Wizards to Generate Update Action Commands
			Update Alternatives: Using the TableAdapter Configuration Wizard
			Complex Updates with Server-Side Logic
			Managing Concurrency by Design or Collision
			Summary
		Chapter 13.  Managing SQL Server CLR Executables
			Introduction
			Evolving CLR Executables Technology
			Where Do CLR Executables Make Sense?
			Designing a CLR Executable
			Building Your First CLR Executable
			Building and Deploying a CLR Executable
			Setting Up a Test Environment
			Working with ADO.NET from Within CLR Executables
			Coding CLR Stored Procedures
			Implementing Basic User-Defined Type (UDT) CLR Executables
			Implementing Advanced CLR User Defined Types
			Accessing CLR UDTs Elsewhere
			Implementing CLR Aggregate Executables
			Implementing CLR Triggers
			Advanced Debugging
			UDT Safety and IP Security
			Summary
		Chapter 14.  Creating and Managing Reports
			Introduction
			Understanding Reporting Services and RDL
			Visual Studio 2005 Reporting
			What Are the Visual Studio 2005 Report Tools?
			Building Your First Report
			Exploring the ReportViewer Class in Depth
			Managing Server Reports
			Managing Parameters
			Advanced Reporting Techniques
			Implementing the Matrix Report
			Summary
		Chapter 15.  Summary and Wintry: Where We Are Now
		Appendix I.  Installing the Examples and Test Databases
			Installing the Examples
			Installing the Example Databases
			Chapter-Specific Configuration Issues
			Summary
		Appendix II.  Reinstalling the DACW and Other Missing Functionality in Visual Studio
		Appendix III.  Monitoring SQL Server
			Monitoring SQL Server with the SQL Profiler
			Monitoring SQL Server and ADO.NET with Performance Counters
			Summary
		Appendix IV.  Creating and Managing Server-Side Cursors
			Why Are Server-side Cursors Important?
			How Does ADO.NET Implement Cursors?
			How Are Server-Side Cursors Managed?
			How Can ADO.NET Create a Server-Side Cursor?
			Fetching Data from the Cursor
			Updating with a Server-Side Cursor
			Summary
		Index