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.)

ABAP Basics
ABAP Basics

ABAP Basics is an ideal companion on your journey towards your first working SAP applications. Whether you’re already familiar with another programming language or ABAP is your first, this introduction to ABAP provides you with comprehensive and structured basics on programming business-critical software. Get to know all relevant...

Business Intelligence Tools for Small Companies: A Guide to Free and Low-Cost Solutions
Business Intelligence Tools for Small Companies: A Guide to Free and Low-Cost Solutions

Learn how to transition from Excel-based business intelligence (BI) analysis to enterprise stacks of open-source BI tools. Select and implement the best free and freemium open-source BI tools for your company’s needs and design, implement, and integrate BI automation across the full stack using agile methodologies.

...

Foundations of Corneal Disease: Past, Present and Future
Foundations of Corneal Disease: Past, Present and Future

The field of cornea has seen tremendous advances over the last 40 years?this uniquely comprehensive book will discuss the history of these advances, current best practices in important diseases of the cornea and ocular surface, and examine future directions in diagnosis and management. Written by leading experts, many of whom trained...


Building Websites with ExpressionEngine 2
Building Websites with ExpressionEngine 2

ExpressionEngine is a flexible, feature-rich content management system used by top designers and web professionals across the world to build and manage their websites. It is written in the world's most popular web scripting language, PHP, and built on the MySQL database server. Are you eager to start creating websites with...

Knapsack Problems: Algorithms and Computer Implementations (Wiley Series in Discrete Mathematics and Optimization)
Knapsack Problems: Algorithms and Computer Implementations (Wiley Series in Discrete Mathematics and Optimization)
Here is a state of art examination on exact and approximate algorithms for a number of important NP-hard problems in the field of integer linear programming, which the authors refer to as ``knapsack.'' Includes not only the classical knapsack problems such as binary, bounded, unbounded or binary multiple, but also less familiar problems...
Taylor's 10-Minute Diagnosis Manual: Symptoms and Signs in the Time-Limited Encounter (Spiral Manual Series)
Taylor's 10-Minute Diagnosis Manual: Symptoms and Signs in the Time-Limited Encounter (Spiral Manual Series)
Primary care physicians and other healthcare providers, residents, and students often face the challenge of diagnosing conditions for patients on the basis of undifferentiated presenting complaints or concerns. Pressures from payers of medical care to increase clinical efficiency while maintaining high-quality care has made the...
©2019 LearnIT (support@pdfchm.net) - Privacy Policy