Claus on Code

A data dudes random musings about code, bugs, products, life etc.


Unboxing MS SQL Server 2012 – Installing the database server and the Adventure works databases

The new MS SQL server version 2012 was released not so long ago. With this article series, I will log my first experiences with it, regarding installation and setup, new features, look and feel etc.

First things first. Let’s install it. If you don’t have a developer edition in you company, download a trial version from MS’s website.

Just download the ISO, and install it from there.

Figure 1 – download it
Figure 1 – download it

 

Figure 2 - Double click setup.exe
Figure 2 – Double click setup.exe

 

Figure 3 – installation process looks the same as previous version -> Clik New SQL server stand alone installation
Figure 3 – installation process looks the same as previous version -> Clik New SQL server stand alone installation

 

Figure 4 – If you downloaded the Trial version as me, select the evaluation version
Figure 4 – If you downloaded the Trial version as me, select the evaluation version

 

Figure 5 – Let’s just select SQL server feature installation
Figure 5 – Let’s just select SQL server feature installation

 

After this, just click through with the default setting and start the installation.

After the installation, you can log on to the database server with SQL Server Management Studio (SSMS). Not much to see now, except from a more pretty interface, that looks as though it is part of Visual Studio 2010.

All development is now done visual studio 2010, and there are a lot of improvements, but more of that in a later article. Let’s first get some databases to work with. Let’s Install the adventureworks databases.

Apparently in 2012, there is no install file to install the databases. Instead you can download the mdf files separately from codeplex, and attach them. Do It here: http://msftdbprodsamples.codeplex.com/

Let’s just start with the two relational databases.

Figure 6 – Right click on databases->Select attach database, and select the downloaded mdf files. The OLTP  and the DWH databases.
Figure 6 – Right click on databases->Select attach database, and select the downloaded mdf files. The OLTP and the DWH databases.

 

We are now ready to explore the new SQL features. We’ll start with that in the next blog post.



Leave a Reply

Your email address will not be published. Required fields are marked *