Free eBook “The Red Gate Guide to SQL Server Team-based Development” from Red Gate.
This book shows how to use of mixture of home-grown scripts, native SQL Server tools, and tools from the Red Gate SQL toolbelt (such as SQL Compare, SQL Source Control, SQL Prompt, and so on), to successfully develop database applications in a team environment, and make database development as similar as possible to “normal” development.
It shows how to solve many of the problems that the team will face when writing, documenting, and testing database code in a team environment, including: writing readable code, documenting code, source control and change management, deploying code between environments, unit testing, reusing code, searching and refactoring your code base.
Table of Contents
- Writing Readable SQL
- Documenting your Database
- Change Management and Source Control
- Managing Deployments
- Testing Databases
- Reusing T-SQL Code
- Maintaining a Code Library.
- Exploring your Database Schema
- Searching DDL and Build Scripts
- Automating CRUD
- SQL Refactoring
File size: 8.12 MB
Number of pages: 359