560 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
An explanation of how to set up and use the MAM database used by this tutorial
Part two of a two-part series of blogs
Our tutorial on using tabular model (Analysis Services) is based on our Make-a-Mammal database. This blog shows how to install this database, and how to understand the tables and relationships that it contains.
This pages gives instructions on how to install the MAM database on your computer.
This database was created by Wise Owl for private use. Neither the database nor any part of this tutorial can be redistributed in any form whatsoever, or for any purpose, without the prior written permission of the author.
Begin by downloading the database by clicking on this link. This will give you a zipped file. When you double-click on this, you should see what it contains:
Choose to extract all of the files (there is only one!) from this zipped file. This screen dump is for Windows 7, but other Windows versions will be similar.
You'll then probably need to repeat this process to get at the actual SQL file:
Eventually you'll be able to extract the SQL script.
To generate the Make-a-Mammal database, you'll need to run the script you've downloaded. In SQL Server Management Studio, choose to open a file:
You can also press CTRL + O to do this.
Double-click on the script file you've downloaded and extracted:
Choose to open this file.
Management Studio displays the script:
The start of the (long) script to generate the database and its tables.
You can now execute the script:
Either click on this tool or press the F5 key.
The script will now generate the database and its tables, although this takes a while:
On my laptop this took 13 seconds, but yours may take quite a bit longer.
At first sight it may seem that nothing has been created, but this may be because you haven't refreshed your databases:
Right-click on Databases and choose to refresh the list.
You can now expand the MAM database to see its contents:
The tables in the MAM database.
You're now in a position to continue with the rest of this tutorial!
|Parts of this blog|
25 Aytoun Street