SQL SERVER – Installing AdventureWorks Sample Database – SQL in Sixty Seconds #010 – Video

SQL Server has so many enhancements and features that quite often I feel like playing with various features and try out new things. I often come across situation where I want to try something new but I do not have sample data to experiment with. Also just like any sane developer I do not try any of my new experiments on production server. Additionally, when it is about new version of the SQL Server, there are cases when there is no relevant sample data even available on development server. In this kind of scenario sample database can be very much handy. Additionally, in many SQL Books and online blogs and articles there are scripts written by using AdventureWork database. The often receive request that where people can get sample database as well how to restore sample database.

In this sixty seconds video we have discussed the same. You can get various resources used in this video from http://bit.ly/adw2012.

More on Errors:
SQL SERVER – Install Samples Database Adventure Works for SQL Server 2012
SQL SERVER – 2012 – All Download Links in Single Page – SQL Server 2012
SQLAuthority News – SQL Server 2012 – Microsoft Learning Training and Certification
SQLAuthority News – Download Microsoft SQL Server 2012 RTM Now

I encourage you to submit your ideas for SQL in Sixty Seconds. We will try to accommodate as many as we can.

If we like your idea we promise to share with you educational material.

Reference: Pinal Dave (http://blog.sqlauthority.com)

10 thoughts on “SQL SERVER – Installing AdventureWorks Sample Database – SQL in Sixty Seconds #010 – Video

  1. Hi pinal,

    When i try to view the Video, it’s showing “The video is currently Unavailable”.

    Can you please suggest me from where can i see the videos’s?

    Regards
    Sreeram

    Like

  2. Msg 5133, Level 16, State 1, Line 1
    Directory lookup for the file “C:\Users\gowdes\Downloads\AdventureWorks2012_Data.mdf” failed with the operating system error 5(Access is denied.).

    Like

  3. Pingback: SQL SERVER – Video – Step by Step Installation of SQL Server 2012 « SQL Server Journey with SQL Authority

  4. Hi Pinal, when i tried to install AdventureWorks sample database its giving me an error regarding the DatabaseInstaller and secondly, I couldnt get the default instance in the Installation Instance dropdown list. I have SQL Server 2008. Thanks for reply in advance.

    Like

  5. Hi Pinal,

    I tried installing AdventureWorks_SR4 but I couldn’t succeed. Everytime i try and it gives me an error page as “DatabaseInstaller has encountered a problem and needs to close”. What should I do?? Please help me out in fixing this issue. Thanks for the help in advance.

    Like

  6. Thanks i installed it successfully on my win7 laptop. At first it said Access denied. When i copied the MDF to the DATA directory i clicked Yes when it said make directory available. works. you were much clearer than the MS pseudo-Help.

    Like

  7. Pingback: SQL SERVER – Weekly Series – Memory Lane – #024 | SQL Server Journey with SQL Authority

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s