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

Northwind now available on SQL Azure

Two weeks ago I made available a copy of [AdventureWorks2012] on SQL Azure and published credentials so that anyone from the SQL community could connect up and experience SQL Azure, probably for the first time. One of the (somewhat) popular requests thereafter was to make the venerable Northwind database available too so I am pleased to say that as of right now, Northwind is up there too.

image

You will notice immediately that all of the Northwind tables (and the stored procedures and views too) have been moved into a schema called [Northwind] – this was so that they could be easily differentiated from the existing [AdventureWorks2012] objects.

I used an SQL Server Data Tools (SSDT) project to publish the schema and data up to this SQL Azure database; if you are at all interested in poking around that SSDT project then I have made it available on Codeplex for your convenience under the MS-PL license – go and get it from https://northwindssdt.codeplex.com/.

Using SSDT proved particularly useful as it alerted me to some aspects of Northwind that were not compatible with SQL Azure, namely that five of the tables did not have clustered indexes:

image

The beauty of using SSDT is that I am alerted to these issues before I even attempt a connection to SQL Azure. Pretty cool, no? Fixing this situation was of course very easy, I simply changed the following primary keys from being nonclustered to clustered:

  • [PK_Region]
  • [PK_CustomerDemographics]
  • [PK_EmployeeTerritories]
  • [PK_Territories]
  • [PK_CustomerCustomerDemo]

 

If you want to connect up then here are the credentials that you will need:

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

You will need SQL Server Management Studio (SSMS) 2008R2 installed in order to connect or alternatively simply use this handy website: https://mhknbn2kdz.database.windows.net which provides a web interface to a SQL Azure server.

Do remember that hosting this database is not free so if you find that you are making use of it please help to keep it available by visiting Paypal and donating any amount at all to adventureworksazure@hotmail.co.uk. To make this easy you can simply hit this link and the details will be completed for you – all you have to do is login and hit the “Send” button. If you are already a PayPal member then it should take you all of about 20 seconds!

I hope this is useful to some of you folks out there. Don’t forget that we also have more data up there than in the conventional [AdventureWorks2012], read more at Big AdventureWorks2012.

@Jamiet 

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

Published Tuesday, April 10, 2012 11:08 PM 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

 

Davy said:

At first, it was a bit confusing for me to get the connectionstring working in c# and how to get data from a tabel where it goes by the name e.g. Employees (Northwind), but then when i make a query i saw my fault doing it wrong.

My first query: "select * from Employees (Northwind)" should be

"Select * from Northwind.Employees"

Basically it's the same as of any other sql database to work with something like Azure, but i find it rather intriguing to learn something new.

I also noticed there is a database AdventureWorks 2012 in there, but do u have like any script files to deploy that database on a local machine with sql server management studio 2008?

Also if I would enter the number 3 in amount for Paypal donation, is that number then in pounds sterling or dollars or euro's?

I would like to donate a small amount for getting a azure connection to test with, but i would like to know the foreign exchange course that your paypal is using ...

How much is it anyway for this database hosting on azure?  do you have to pay more for giving access to the public ?

July 14, 2012 2:09 PM
 

Davy said:

How do you register here on this blog, i only see "sign in" :s

July 14, 2012 2:17 PM
 

jamiet said:

Hi Davy,

Regarding registering on SQLBlog.com ...I have just realised that I have no idea - I don't see a register link anywhere. I have tweeted the site owner about it so hopefully he'll have a look.

"do u have like any script files to deploy [AdventureWorks2012] on a local machine with sql server management studio 2008"

They're all up here: http://msftdbprodsamples.codeplex.com/releases/view/55330

"Also if I would enter the number 3 in amount for Paypal donation, is that number then in pounds sterling or dollars or euro's?"

I have received donations in both dollars and sterling so I would suspect that its either (a) driven by your preferred currency or (b) you get to choose at some point.

"How much is it anyway for this database hosting on azure?  do you have to pay more for giving access to the public ?"

It is $9.99 a month (see pricing calculator here: https://www.windowsazure.com/en-us/pricing/calculator/ and note that since I wrote this blog post the name has changed from "SQL Azure" to "Windows Azure SQL Database"). No, it doesn't cost more to make it available to the public.

Thanks for the comments Davy.

Regards

Jamie

July 16, 2012 4:41 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
 

Steven Fan said:

the adventureworks2012 looks like adventureworks2008 as the window function is missing.

Also when I run the below query:

SELECT compatibility_level

FROM sys.databases WHERE name = 'AdventureWorks2012';

GO

It returned 100, which is sql server 2008.

May 23, 2013 1:12 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

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