What you need for this book

This book will explain the features of Microsoft SQL Server 2014 Enterprise Edition. However, you can also download and install MS SQL Server 2014 Evaluation Edition, which has the same functionalities but is free for the first 180 days, from the following link:

http://technet.microsoft.com/en-US/evalcenter/dn205290.aspx

There are many examples in this book and all of the examples use the following databases as a source:

You can download the database files from the following link:

http://msftdbprodsamples.codeplex.com/releases/view/55330

After downloading the database files, open SQL Server Management Studio and enter the following scripts to create databases from their data files:

CREATE DATABASE AdventureWorks2012 ON (FILENAME = '{drive}:\{file path}\AdventureWorks2012_Data.mdf') FOR ATTACH_REBUILD_LOG;
CREATE DATABASE AdventureWorksDW2012 ON (FILENAME = '<drive>:\<file path>\AdventureWorksDW2012_Data.mdf') FOR ATTACH_REBUILD_LOG ;
CREATE DATABASE AdventureWorksLT2012 ON (FILENAME = '<drive>:\<file path>\AdventureWorksLT2012_Data.mdf') FOR ATTACH_REBUILD_LOG ;