Microsoft UK Developer & Designer Events - Post Event Resources

2008-11-27 SQL Server 2008 Overview for Developers (NxtGenUG Southampton)

Speaker: Eric Nelson http://blogs.msdn.com/ericnel

Location: NxtGenUG Southampton

Thanks to all those who listened to my session.

Staying in touch:

• Email me at eric.nelson
• http://blogs.msdn.com/ericnel - tends to be about .NET and data
• http://blogs.msdn.com/goto100 - all about Visual Basic
• http://twitter.com/ericnel - pot luck :-)

Links:

• SQL Server 2008 http://www.microsoft.com/sqlserver/2008
• SQL Server 2008 Express – download the free version http://www.microsoft.com/express/sql/
• Recent recordings at Sqlbits http://www.sqlbits.com/#sessions 
• Filestream Article http://msdn.microsoft.com/en-us/library/cc949109.aspx
• Spatial demo
  • 9 parts on learning spatial http://blogs.msdn.com/davidlean/archive/2008/11/01/sql-2008-spatial-samples-part-1-of-9-how-to-learn-sql-spatial.aspx 
  • World map World Polygons from Geocommons
  • Find overlays (e.g. football venues) finder site at Geocommons 
  • Generate SQL tables from shapefiles Shape2SQL from Morten Nielsen  
• Microsofts Strategic ORM (Object Relational Mapping) technology is ADO.NET Entity Framework.
  • Released August 2008 as part of Visual Studio 2008 SP1
  • Works with SQL Server, Oracle, MySql etc to expose relational tables as Objects and simplify db development
  • MSDN Library http://msdn.microsoft.com/en-gb/library/bb399572.aspx
• Microsoft SQL Data Services, part of the recently announced Azure Services Platform
  • Stores data in “the cloud” – a Microsoft managed database service accessible via SOAP or simple HTTP (REST). Move all/some of your data off premise.
  • On MSDN (SDK etc to download) http://msdn.microsoft.com/en-us/sqlserver/dataservices/default.aspx