AdventureWorks 2014 download (link)

Microsoft released the new AdventureWorks for SQL Server 2014.

By default, sample databases and sample code are not installed during the installation of SQL Server and you have to search, find and download the sample databases.

Sample databases

On Codeplex you can download the AdventureWorks databases for SQL Server.

Relational Databases (OLTP):
AdventureWorks2012 Data File
AdventureWorks 2012 OLTP Script
AdventureWorks2012-Full Database
AdventureWorks2012 CS Data File
AdventureWorks 2012 CS OLTP Script
AdventureWorks 2012 LT Script

Databases (DW)
AdventureWorksDW2012 Data File

AdventureWorks Multidimensional Models SQL Server 2012
Analysis Services Tutorial SQL Server 2012

SSAS Tabular
AdventureWorks Tabular Model SQL Server 2012
AdventureWorks Internet Sales Tabular Model SQL Server 201

Here are some other samples for SQL Server (thanks to Hennie de Nooijer):
SQL Server 2014 RTM In-Memory OLTP Sample. Samples of the new features of SQL Server : esource Governor IO, Online Operations, and the Columnstore Index.
Adventure Works for SQL Server 2012
SQLSkills databases
Arcane Code. Upgrade for SQL Server 2014
AdventureWorks for SQL Azure

Join us at LinkedIn!
Don’t forget to join the SQL Server 2014 group on LinkedIn and stay updated!:

New SQL Server 2012-RTM fully integrated Demo (Hyper-V!)

***Updated: See below***

Demo Image XII: SQL 2012

Brief Description
The Base ImageX Server is a virtual machine that allows a user to test out the latest Business Intelligence features of SQL Server 2012; including PowerView reports and PowerPivot Excel Documents.

The Base ImageX Server is a virtual machine that can be hosted in Hyper-V that allows a user to test out the latest Business Intelligence features of SQL Server 2012. The virtual machine has been configured to support the use of PowerView reports, PowerPivot Excel documents and various content packs allowing the user to explore the capabilities of SQL Server 2012. Working with the demos that can be installed on the ImageX server the user will have a clear picture of how the SQL Server 2012, Office and SharePoint tools support and enhance the self-service business intelligence environment.

The new SQL Server 2012-RTM demo is fully integrated with SQL Server 2012, SharePoint 2010 and Office 2010 including:
– PowerPivot and MDS Excel integration
– Reporting Services integration with SharePoint
– Power View integrated with SharePoint
– Data Quality Services
– Master Data Services
– Multidimensional and Tabular instances of SQL Server 2012 Analysis Services
– Visual Studio 2010
– Silverlight 5
– Picnic Power View sample loaded

This image also includes demos of the RTM version of AutoSales, TailspinToys, Contoso Energy, Telco (PowerPivot and Power View), Contoso Schools and the Telco demo.

Download it here!

Quick Details
File Name: SQL Image
Version: 1.0
Date Published: 5/11/2012
Language: English
Download Size: 21.6GB

Don’t forget to read the installation notes:

Credentials (thanks to Dan English):
The password for the image is the typical pass@word1 for the contoso\Administrator user. The name of the server is SQLIMAGE2012.

Thank you Microsoft!


***Update: 3 hours later, same day, a lot of disk space shortage…***

Is Microsoft serious?
Finally I downloaded the 21.6 gig and then I stumbled upon this ridiculous issue:
(My previous ridiculous issue/error: SQL Server – Rare Event error)

While browsing inside the ZIP-file:

SQL Server 2012 Samples by Microsoft

Microsoft posted a great overview of all samples for SQL Server 2012 on TechNet, you’ll find it here.

A few highlights:
– AdventureWorks2012 / AdventureWorksLT2012 / AdventureWorksDW2012
– Adventure Works Tabular Model Projects SQL Server 2012
– Power View and PowerPivot Samples for SQL Server 2012
– Power View Sample Images
– Adventure Works Internet Sales Tabular Model SQL Server 2012

Don’t forget the latest ones:
Power View Overview
Power View and PowerPivot HelloWorldPicnic Samples for SQL Server 2012

Playing around with SQL Azure

I’ve started playing with SQL Azure on my ’30 days free SQL Azure trial’ and already got a few tips:

Login on SQL Azure’s Developer Portal and create a database.

Don’t forget to modify your Firewall settings of SQL Azure in order to connect to it (Tutorial):
A simple statement does the trick (execute on Master DB):

exec sp_set_firewall_rule N'Allow Project Houston','',''

An overview of security in SQL Azure

Project ‘Houston’ is very handy! 🙂

I’ve uploaded AdventureWorksDW2008R2 partially (28,2 MB) with Create-scripts and a small SSIS package:

An overview of my tables within SQL Azure:

I can’t find any traffic stats though.

Next on my to-do-list:
Start using SQL Azure within a PowerPivot workbook (performance check).

I’ll keep you guys posted!

AdventureWorks for SQL Server Denali CTP1

Microsoft released the new AdventureWorks for SQL Server Denali (CTP1, aka SQL Server 2011) yesterday!

The release notes:

This release is dedicated to the Adventureworks sample databases that ship for Microsoft SQL Server code-named “Denali”, Community Technical Preview 1 (CTP1). This release uses the AdventureWorks2008R2 and AdventureWorksDW2008R2 sample databases. They have been upgraded to the “Denali” CTP1 version and the FILESTREAM properties have been removed from the Production.Document table. No additional schema or data changes have been made.

Note: These databases cannot be installed on any version of SQL Server other than SQL Server code-named “Denali” CTP1.

Get it here.

Recursive Stored Procedure query

I stumbled upon a great stored procedure for Recursive Queries (here), but I wanted to recreate it for AdventureWorks.

Note: This one only works on the previous AdventureWorks database (not 2008R2, the Employee table has changed). Soon I’ll be posting a modified version of this based upon the AdventureWorks2008R2 database.

Basicly the Employee-table is self referencing table with levels (also known as ‘Tree Walking‘) has an EmployeeId and ManagerId I’m going to use.

The code:

How to execute:

And ofcourse, the results are shown here:

A really nice thing about this SP is that it uses a parameter Root, which can be used to ‘climb’ the tree. For example, if I set @Root to be 12:

Want the SQL sourcecode? Click here