Creating the database
The SQL Server database used in the prior recipes is available as a backup from the online content for this book on the Packt Publishing website. This backup can be restored to the SQL server instance (running SQL Server 2012).
We do not specify details for the installation of SQL Server (since they are outside the scope of this book). However, a brief overview of the database restore is discussed in this section.
An evaluation version of SQL Server is available for download at the following URL. This license will expire after 180 days. Alternatively, a free edition of SQL Server (SQL Server Express) is also available (with reduced features and no license expiry limit).
http://www.microsoft.com/betaexperience/pd/SQL2012EvalCTA/enus/default.aspx
The online resources contain two files. Firstly, a file named tabular_modelling.bak
, which is the database backup. The second is the file that contains the restore script. It is also reproduced as follows:
USE [master] RESTORE DATABASE...