This chapter is based on the article, “Green IT in Practice: SQL Server Consolidation in Microsoft IT,” that appeared in the Microsoft publication The Architecture Journal (www.architecturejournal.net) written by Mark Pohto. This chapter focuses on all aspects of Microsoft IT to consolidate SQL Server. The chapter covers all the key points of SQL Server consolidation, including the following:
• Opportunities presented by SQL Server consolidation
• Initial SQL Server environment that Microsoft IT managed
• Desired SQL Server environment envisioned by Microsoft IT
• Approach taken by Microsoft IT to achieve the desired environment
• Solution implemented
• Results realized as ...