Announcing the AdventureWorks OData Feed Sample


Derrick VanArnam (MSFT) has put together a great blog post on consuming an OData feed based on the AdventureWorks 2012 database.

The AdventureWorks OData service exposes resources based on specific SQL views. The SQL views are a limited subset of the AdventureWorks database that results in several consuming scenarios:

  • CompanySales
  • Documents
  • ManufacturingInstructions
  • ProductCatalog
  • TerritorySalesDrilldown
  • WorkOrderRouting

Well worth the read Smile

Source: http://blogs.msdn.com/b/derrick_vanarnams_blog/archive/2012/09/06/announcing-the-adventureworks-odata-feed-sample.aspx

Microsoft Virtual Academy


The Microsoft Virtual Academy (MVA) is a free cloud-based learning environment focusing on Microsoft Technologies (Although the site states that it focuses on cloud-based technologies, I have found content in some countries not specific to the cloud).

The concept behind the MVA is similar to that of a “Virtual University”; students select a course(s) to study and then do a self-assessment exam to gauge how well they’ve understood the study material. Students also accrue points for material studied and courses completed which are used to promote them through a recognition system (Bronze, Silver, Gold or Platinum Level) and provide them with a comparison on how they rank against other students in their country and around the world.

As it currently stands, there is only 1 SQL Server related course (Introduction To SQL Azure) currently available in Australia (and the United States and United Kingdom) however I have been advised by the Dean that new material will become available in the near future. I also mentioned earlier that there is additional content (SQL 2008/R2/Azure, .Net, Sharepoint, Silverlight, Windows Phone) available in other countries (mainly Spain and Colombia) with some of this content being in English and some in the native language of the selected country (the Microsoft study links are good as all you need to do is change the language setting of the site to a language of your choice and the content is translated. You can also use Google Translate on some of the content).

More information about the MVA can be found in the FAQ.

Tech.Ed Australia 2011 – HOL/ILL Additional Resources


Re-post for Tech.Ed Australia attendees

Visual Studio 2010 and .NET Framework 4 Training Kit – http://www.microsoft.com/download/en/details.aspx?id=23507

Microsoft® Visual Studio® 2010 and Team Foundation Server® 2010 RTM virtual machine for Microsoft® Virtual PC 2007 SP1 – http://www.microsoft.com/download/en/details.aspx?id=18867

SQL Server 2008 Developer Training Kit – http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=10662

SQL Server 2008 R2 Business Intelligence Training Course – http://msdn.microsoft.com/en-us/gg618026

Microsoft® SQL Server® code name ‘Denali’, Community Technology Preview 3 (CTP 3) Product Guide – http://www.microsoft.com/download/en/details.aspx?id=27069

SQL Azure – http://sqlazuretutorials.com/

Windows Azure and SQL Azure Tutorials – http://social.technet.microsoft.com/wiki/contents/articles/windows-azure-and-sql-azure-tutorials.aspx

SharePoint 2010 Developer Training Kit – http://msdn.microsoft.com/en-us/gg620703

%d bloggers like this: