Getting Started with SQL Server 2008 R2 - Microsoft SQL Server 2008 R2 Administration - page 27

Designing and adopting SQL Server 2008 R2
solutions
The design of a solution needs guidance and planning, that has a series of collection
consisting of information such as infrastructure planning, design, and implementation process
which leads the sequence of core decision points. Designing the SQL Server 2008 R2 is no
different to the key steps mentioned preciously. It also provides a means of validation to
design and deploy the key business decisions to ensure that the solution meets the near-to-
clear requirements for both technology and business stakeholders.
The design and adoption program must include technologists, such as Architects, to have
an operational grasp of the technology to make the best use of new features. Also, the
business team involvement is a high-level need to ensure that they understand the technology
decisions being made for development and support. This can affect the business.
Getting ready
SQL Server 2008 R2 contains new features within the Business Intelligence stack such
as PowerPivot, StreamInsight, and Master Data Services. A series of technology adoption
program needs to be designed from an IT and Business perspective. A step beyond the
traditional technology provision and SQL Server 2008 R2, consists of a series of best
practices to implement the real-world BI solutions to leverage the best use of technologies.
The adoption programs should be designed to help users understand how the new SQL Server
features interact with established technologies such as SQL Server Analysis Services, or
SQL Server Integration Services, or SQL Server Reporting Services. In this recipe, we will go
through the required process in designing and adopting the SQL Server 2008 R2 solutions.
The guidance must include the activities of planning a design, understanding new features,
and implementing them effectively. In this case, SQL Server 2008 R2 new features. The
critical design elements of planning are project scope determination, roles of people (such
as dividing the technology and business decision-maker levels and infrastructure adoption
of SQL Server 2008 R2 technologies), core database engine, integration services, analysis
services, reporting services, and master data services.
Each user and stakeholder's needs should be classified taking the following considerations
into account:
F Organizations that are implementing SQL Server for a specific application
F Organizations that are implementing SQL Server to provide a business intelligence
platform for managers and decision makers to conduct data integration, reporting,
and analysis