Microsoft SQL Server on Private Cloud

While trying to identify a solution for an internal private cloud for a client and deploy SQL Server as a service on it, came across following articles which can provide some useful insight and references,

 

Microsoft provides certain case studies and articles at following link on private cloud,

http://www.microsoft.com/en-us/sqlserver/solutions-technologies/hybrid-it/private-cloud.aspx

 

Microsoft with HP and Dell has provided Database consolidation and private cloud appliances as well, details at following link,

http://www.microsoft.com/sqlserver/en/us/solutions-technologies/Appliances/HP-dca.aspx

http://h71028.www7.hp.com/enterprise/us/en/partners/microsoft-database-consolidation-solution.html

http://blogs.technet.com/b/dataplatforminsider/archive/2011/10/13/announcing-the-first-database-consolidation-amp-private-cloud-appliance.aspx

 

If you are planning to deploy SQL Server on Microsoft managed private cloud then this article will prove useful to you, it discusses on how to deploy Reporting and DB engine service using sysprep image,

http://www.techrepublic.com/blog/networking/how-to-deploy-sql-server-as-a-service-to-your-private-cloud/5612

 

There are some articles from industry experts which provides insight on whether Private cloud for SQL Server is useful/possible or not?

http://www.sqlmag.com/article/sql-server/microsoft-sql-server-private-cloud-142280

 

A video based case study to “Design a private cloud infrastructure for SQL Server” is available at following link,

http://sqlbits.com/Sessions/event10/Designing_a_Private_Cloud_Infrastructure_for_SQL_Server

 

==========External Tools for MSSQL Private Cloud Solution=============

Scalegrid SQLDirector (http://www.scalegrid.net/sqldirector.htm) is a tool which allows enterprises to run Database as a Service (DBaaS) in their private cloud

 

A visual overview of test case using SQLDirector is available at: http://marlonribunal.com/getting-started-with-sql-server-on-private-cloud/

 

 

===========Only Virtulization===============

If you are interested in just virtualizing and not actually deploying sql as a service then VMWare and Microsoft Hyper-V provides some industry standard solutions which can help you building SQL server using standard copies and within minutes, please find related references below,

 

Useful resources for virtualizing your SQL Servers on VMWare ESX,

 

http://www.vmware.com/solutions/business-critical-apps/sql-virtualization/microsoft-support.html

 

• DBA Guide to Databases on VMware – White Paper
  
• Availability and Recovery Options for Microsoft SQL® on vSphere
  
• Best Practices Guide for Virtualizing SQL Server
  
• SQL Server on vSphere FAQ
  
• Support and Licensing Guide – SQL Server on vSphere
  
• SQL Server on vSphere – Use Cases
  
• VMware Performance Benchmarks and Resources
  
• Reference Architecture: EMC Business Continuity for SQL Server 2008
  
• Reference Architecture: EMC Solutions for Tiered Storage for SQL Server 2008
  
• Reference Architecture: SQL Server on Dell PowerEdge R810 Servers and EqualLogic Storage
  

 

 

Microsoft guide for virtualization,

http://www.google.ca/url?sa=t&rct=j&q=build%20sql%20database%20private%20cloud&source=web&cd=29&cad=rja&ved=0CH4QFjAIOBQ&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2FB%2FE%2F1%2FBE1AABB3-6ED8-4C3C-AF91-448AB733B1AF%2FConsolidating%2520Databases%2520Using%2520Virtualization%2520Planning%2520Guide.docx&ei=SxceUZD_BZTlyAHO1YHoCw&usg=AFQjCNHRziDCgvYjk932_rC-vOvLHUM-ag&bvm=bv.42553238,d.aWc

 

 

==========================

Some useful presentations on Private cloud can be found at,

http://www.google.ca/url?sa=t&rct=j&q=build%20sql%20database%20private%20cloud&source=web&cd=18&cad=rja&ved=0CHEQFjAHOAo&url=http%3A%2F%2Fvideo.ch9.ms%2Fteched%2F2012%2Fna%2FDBI318.pptx&ei=LRYeUfK_Auaw2QX42oHoAQ&usg=AFQjCNGg57hZl6_fAhnIaENlULyHy7J42g&bvm=bv.42553238,d.aWc