1. Red Gate Sql Toolbelt Essentials
2. Sql Toolbelt Essentials Download

Download a 14-day free trial of SQL Toolbelt, all of Redgate's SQL Server tools in one installer.

Red Gate Sql Toolbelt Essentials

Sql Toolbelt Essentials Download

Table of Contents

1. About the Authors
2. Introduction
3. 1. Writing Readable SQL
   1. Object Naming Conventions
   2. Code Layout
4. 2. Documenting your Database
   1. What Standards Exist?
   2. How Headers are Stored in the Database
5. 3. Change Management and Source Control
   1. Environments
      1. Development environments
      2. Testing, staging and production environments
   2. Source Control
      1. Source control features
      2. Getting your database objects into source control
      3. Managing data in source control
         1. Data movement tools
6. 4. Managing Deployments
   1. Deployment Schemes
      1. Visual Studio 2010 Premium tools
      2. Red Gate SQL Source Control
   2. Automating Builds for Continuous Integration
      1. Automation with MSBuild, NAnt, and PowerShell
7. 5. Testing Databases
   1. Essential Types of Database Testing
   2. Essentials for Successful Database Testing
   3. How to Test Databases
      1. Reverting the database state
   4. Unit Testing Examples: Testing Data and Schema Validity
8. 6. Reusing T-SQL Code
   1. Reusing Business Logic: Stored Procedure, Trigger, Constraint or Index?
9. 7. Maintaining a Code Library
   1. Coding for Reuse
   2. Storing Script Libraries
   3. Tools for Creating and Managing Code Libraries
10. 8. Exploring your Database Schema
    1. Searching Structural Metadata in Schema-scoped Objects within a Database
    2. Interrogating Object Dependencies
11. 9. Searching DDL and Build Scripts
    1. Searching Within the DDL
       1. So how do you do it?
    2. Using SSMS to Explore Table Metadata
12. 10. Automating CRUD
13. 11. SQL Refactoring
    1. Requirements for Successful SQL Refactoring
    2. SQL Refactoring in Action: Tackling Common Anti-Patterns
       1. The 'SELECT *' anti-pattern