Date Added: May 2010
This paper describes how SQL Server 2008 consolidation can solve problems associated with multiple SQL servers in an organization. The paper offers several methods for consolidating applications using Microsoft SQL Server 2008, and compares those methods by linking key decision points to business requirements. Microsoft SQL Server has rapidly become the database of choice for a large number of prepackaged and custom-built business applications due to its robust feature set, ease of use, and highly competitive pricing. In some cases, these applications are introduced to small groups within a company, and are not given the infrastructure support that is provided to larger projects. These applications that are initially small and non-business-critical can gradually grow into business-critical resources that require proper support.