How to Download SQL Server 2012 AnandWednesday, February 4, 2015 0 comments

Download SQL Server 2012

Please download SQL Server 2012 from the below link:
http://www.microsoft.com/en-in/download/details.aspx?id=35575
Steps to download SQL Server
From the above link, click on "Download" button.

For 64 bit Windows OS, please download:
SQLServer2012SP1-FullSlipstream-x64-ENU.box
SQLServer2012SP1-FullSlipstream-x64-ENU.exe
SQLServer2012SP1-KB2674319-x64-ENU.exe

For 32 bit Windows OS, please download:
SQLServer2012SP1-FullSlipstream-x86-ENU.box
SQLServer2012SP1-FullSlipstream-x86-ENU.exe
SQLServer2012SP1-KB2674319-x86-ENU.exe

Once you download the above specified THREE files (as applicable) just double click on  file marked in bold so that respective .box file contents will be extracted. 

Read More

Session 1 : SQL SERVER – Samples Database Adventure Works for SQL Server 2012 AnandTuesday, January 27, 2015 0 comments

SQL SERVER –  Samples Database Adventure Works for SQL Server 2012

AdventureWorks is a Sample Database shipped with SQL Server and it can be downloaded from CodePlex site. AdventureWorks has replaced Northwind and Pubs from the sample database in SQL Server 2005.The Microsoft team keeps updating the sample database as they release new versions.

For SQL Server 2012 RTM Samples AdventureWorks Database is released:

• AdventureWorks2012 Data File
• AdventureWorks2012 Case Sensitive Data File

You can download either of the datafile and create database using the same. Here is the script which demonstrates how to create sample database in SQL Server 2012.

CREATE DATABASE AdventureWorks2012ON (FILENAME = 'D:\AdventureWorks2012_Data.mdf')FOR ATTACH_REBUILD_LOG ;

Please specify your filepath in the filename variable. Here is the link for additional downloads.

Read More