Creation of database in SQL Server is pretty, specially using SQL Server Management Studio. We create a database easily by performing following steps.
Open SQL Server Management Studio.
In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.
Right-click Databases, and then click New Database.
In New Database, enter a database name.
To create the database by accepting all default values, click OK;
SQL Server Denali : Running a package using SQL Server Management Studio (SSMS)
For More Details, check http://sqlserver-training.com/category/sql-denali
SQL Server Denali : Configure an Integration Services project using SQL Server Management Studio (SSMS)
SQL Server 2011 : How to Configure an Integration Services project using SQL Server Management Studio (SSMS)
Sitecore's web content management system gives developers unprecedented freedom and powerful tools to deliver truly amazing applications and site capabilities. From day one, Sitecore has been totally committed to the .NET framework, and we've been the leader in Microsoft compatibility for web CMS, rapidly staying current with the latest releases of .NET, Visual Studio, SQL Server and Windows Server. Sitecore provides the capabilities you expect in a leading CMS, including: strict separation of content from presentation, component based content architecture based on XML, caching and performance optimization tools, data abstraction and integration tools to connect to enterprise legacy systems, strong configurable workflow management system, and rich security tools based on the .NET security provider architecture.