Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
The Red Gate Guide to SQL Server Team-based Development

Buy

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.

While performing this feat of legerdemain, they'll also have to deal with the fact that the different teams may be at different points in the development life cycle, and that each team may have dependencies on another. These various differences and dependencies will lead to conflict as the teams attempt to work on a single shared system.

Before you throw up your hands and declare this a lost cause, understand that you're not alone. Fortunately, these problems are not unique. There are a number of tools and techniques that can help you write clear, well-documented, reusable database code, then manage that code so that multiple versions of it can be deployed cleanly and reliably to any number of systems.

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.
(HTML tags aren't allowed.)

Digital Forensics and Watermarking: 10th International Workshop, IWDW 2011, Atlantic City, NJ, USA
Digital Forensics and Watermarking: 10th International Workshop, IWDW 2011, Atlantic City, NJ, USA

This book constitutes the thoroughly refereed post-conference proceedings of the 10th International Workshop on Digital-forensics and Watermarking (IWDW 2011) held in Atlantic City, NJ, USA, during October 23-26, 2011. The 37 revised full papers presented were carefully selected from 59 submissions. Conference papers are organized in 6...

Learn JavaScript In a Weekend, Second Edition
Learn JavaScript In a Weekend, Second Edition

Learn JavaScript In a Weekend, 2nd Edition is the ultimate guide to integrating JavaScript into Web pages. With step-by-step instructions, readers will learn how to effectively use JavaScript, the most popular scripting language used for Web development today. Setting itself apart from competitors, this is the only beginner-level...

C# Cookbook
C# Cookbook
The C# Cookbook offers a definitive collection of solutions and examples for this new programming language. Recipes range from simple tasks to the more complex, and are organized with respect to the types of problems you'll need to solve as you progress in your experience as a C# programmer. Nearly every recipe...

The Idea Accelerator: How to Solve Problems Faster Using Speed Thinking
The Idea Accelerator: How to Solve Problems Faster Using Speed Thinking
A toolkit of 60 practical ways by which the reader can think faster to reach earlier decisions, without neglecting a conscious, deliberate, and reflective approach

Creating new ideas and growth opportunities is the lifeblood of any organization, but time to come up with new...

Kindle Paperwhite For Dummies
Kindle Paperwhite For Dummies

Rekindle your love of reading with Amazon's new Kindle Paperwhite and this fun and friendly guide

If you're the proud owner of a Kindle Paperwhite, you'll want to know all the best ways to get the very most out of it - and fast. That's where Kindle Paperwhite For Dummies comes in. This easy-to-follow...

Fixed Broadband Wireless System Design
Fixed Broadband Wireless System Design
Fixed broadband wireless systems provide an alternative solution for the "last mile" delivery of high-speed Internet and other data services to businesses and homes.

Two-way wireless connections can be deployed more rapidly and less expensively than traditional optical fiber, coaxial cable, or wired telephone connections. Fixed...

©2020 LearnIT (support@pdfchm.net) - Privacy Policy