Monday, November 29, 2010

Free eBook, “The Red Gate Guide to SQL Server Team based Development”

I want some Moore - The Red Gate Guide to SQL Server Team based Development Free e-book

“After about 6 months of work, the new book I've coauthored with Grant Fritchey (Blog|Twitter), Phil Factor (Blog|Twitter) and Alex Kuznetsov (Blog|Twitter) is out. They're all smart folks I talk to online and this book is packed with good ideas backed by years of experience.

The book contains a good deal of information about things you need to think of when doing any kind of multi person database development. Although it's meant for SQL Server, the principles can be applied to any database platform out there. In the book you will find information on: writing readable code, documenting code, source control and change management, deploying code between environments, unit testing, reusing code, searching and refactoring your code base. I've written chapter 5 about Database testing and chapter 11 about SQL Refactoring.

…”

SQL Books  -  The Red Gate Guide to SQL Server Team-based Development

“The Red Gate Guide to SQL Server Team-based Development
Phil Factor, Grant Fritchey, Alex Kuznetsov, and Mladen Prajdić

Download the free eBook here.

This book shows how to use a mixture of home-grown scripts, native SQL Server tools, and tools from the Red Gate SQL Toolbelt, to successfully develop database applications in a team environment, and make database development as similar as possible to "normal" development.

Why read this book?

Only small projects, relevant to very few people, are built by the sweat and toil of a lone developer. Larger projects, affecting whole organizations, will invariably require a team of people to design and develop the application and its storage layer, or database.

In some cases, this will mean some developers and one or two DBAs, but larger organizations can afford a higher degree of specialization, so there will be developers who work exclusively within the data access layer of an application, database developers who specialize in writing T-SQL, architects who design databases from scratch based on business requirements, and so on. Stepping up the scale even further, some projects require multiple development teams, each working on a different aspect of the application and database, and each team performing of a collection of these specialized tasks. All these people will have to work together, mixing and matching their bits and pieces of work, to arrive at a unified delivery: an application and its database.

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 all the areas below.

  • Writing readable code.
  • Documenting code.
  • Source control and change management.
  • Deploying code between environments.
  • Unit testing.
  • Reusing code.
  • Searching and refactoring your code base

…”

If you read any of the popular link bloggers you’ve probably already seen this, but just in case not…

Note that this is a special campaign and so the book might not be available for forever (so get it now).

Here’s a snap of it;

image

No comments: