THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Jamie Thomson

This is the blog of Jamie Thomson, a freelance data mangler in London

Big AdventureWorks2012

Last week I launched AdventureWorks on Azure, an initiative to make SQL Azure accessible to anyone, in my blog post AdventureWorks2012 now available for all on SQL Azure. Since then I think its fair to say that the reaction has been lukewarm with 31 insertions into the [dbo].[SqlFamily] table and only 8 donations via PayPal to support it; on the other hand those 8 donators have been incredibly generous and we nearly have enough in the bank to cover a full year’s worth of availability.

It was always my intention to try and make this offering more appealing and to that end I have used an adapted version of Adam Machanic’s make_big_adventure.sql script to massively increase the amount of data in the database and give the community more scope to really push SQL Azure and see what it is capable of. There are now two new tables in the database:

  • [dbo].[bigProduct] with 25200 rows
  • [dbo].[bigTransactionHistory] with 7827579 rows

The credentials to login and use AdventureWorks on Azure are as they were before:

  • Server mhknbn2kdz.database.windows.net
  • Database AdventureWorks2012
  • User sqlfamily
  • Password sqlf@m1ly

Remember, if you want to support AdventureWorks on Azure simply click here to launch a pre-populated PayPal Send Money form - all you have to do is login, fill in an amount, and click Send. We need more donations to keep this up and running so if you think this is useful and worth supporting, please please donate.

I mentioned that I had to adapt Adam’s script, the main reasons being:

  • Cross-database queries are not yet supported in SQL Azure so I had to create a local copy of [dbo].[spt_values] rather than reference that in [master]
  • SELECT…INTO is not supported in SQL Azure
  • The 1GB limit of SQLAzure web edition meant that there would not be enough space to store all the data generated by Adam’s script so I had to decrease the total number of rows.

The amended script is available on my SkyDrive at https://skydrive.live.com/redir.aspx?cid=550f681dad532637&resid=550F681DAD532637!16756&parid=550F681DAD532637!16755

@Jamiet

AdventureWorks on Azure - Provided by the SQL Server community, for the SQL Server community!

Published Tuesday, April 03, 2012 12:19 AM by jamiet

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Paul White said:

Excellent idea Jamie, and just the prompt I needed to connect to Azure for the first time!

April 2, 2012 6:56 PM
 

Jason Thomas said:

I hope it stays for more than a year! :)

And is there any way that we can implement Chris' idea of getting this hosted in Azure Data Market also?

April 3, 2012 7:26 AM
 

jamiet said:

Hi Jason,

I need to look into that. Its on my ToDo list (a long list).

April 3, 2012 8:17 AM
 

jamiet said:

P.S. Jason, the best way to help it stay for more than a year is to donate :)

April 3, 2012 8:17 AM
 

SSIS Junkie said:

Two weeks ago I made available a copy of [AdventureWorks2012] on SQL Azure and published credentials

April 10, 2012 5:08 PM
 

Bill said:

I found your SQL Server while googling SSRS.  I did not contribute any money yet, as I wanted to see if I could successfully use your databases.  I am doing a SSRS tutorial, and have spent the last hour trying to run a query provided.  It seems that for whatever reason, I cannot join the Sales.SalesOrderHeader to the Sales.SalesOrderDetail tables.  Upon further examination, it seems there are not matching SalesOrderID records.  I am not complaining, just wondering why this  happened, and if I am correct, or just having a bad day.

April 27, 2012 3:05 PM
 

jamiet said:

Hello Bill,

What query are you running?

April 28, 2012 3:30 AM
 

SSIS Junkie said:

In March 2013 I launched an initiative called AdventureWorks on Azure in which I hosted the AdventureWorks2012

May 20, 2013 5:48 PM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement