Microsoft at the PHP UK Conference 2009

27th February 2009

It’s great to be here at the conference – I know we’re going to have some great conversations.

Here are some links we think you’ll find useful:

• PHP on Windows Server 2008
• Port25 - Microsoft Open Source blog
• Microsoft Open Source home page
• FastCGI for PHP
• PHP for Windows on php.net
• IRC channel: http://irc.freenode.net/#php-dev-win
• SQL Server driver for PHP (works with SQL Server 2005 & 2008)
• Windows SDK & Windows specific docs for building PHP on Windows
• Windows Azure – Microsoft’s cloud os
• Silverlight - getting started

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

2008-11-19 What's new in Visual Studio 2008 SP1

On Wednesday 19th we delivered this session in Leeds, hosted by our good friends Black Marble. A big thanks to all who showed.

We have previously posted the links for these sessions.

Presentation: What's new for Presentation
Presenter: Mike Taulty http://mtaulty.com

Presentation: What's new in Data
Presenter: Eric Nelson http://blogs.msdn.com/ericnel

2008-11-13 SQL Server 2008 for Access Developers at the Access User Group

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

Thanks to all those who listened to my session. Apologies that we did run out of time (as I suspected – but still sorry)

Some answers to Q&A during the breaks:

• What are the differences between the Express edition and the Compact Edition? Nicely summarised here.
• Does normal backup/restore work with Filestream? Yes (see the article link below)
• How convert from postcode to coordinates? Various services are out there. Try nearby (link below) as a starter.

Links

• Code for my demos is attached.
• SQL Server 2008 http://www.microsoft.com/sqlserver/2008 
• SQL Server 2008 Express – download the free version http://www.microsoft.com/express/sql/ 
• Filestream Article http://msdn.microsoft.com/en-us/library/cc949109.aspx 
• Spatial demo
• Generate INSERT statement (remember – build polygon anti clockwise!)  http://mikeo.co.uk/demo/sqlspatial/
• Plot spatial data on Virtual Earth (as extracted from SQL 2008) http://mikeo.co.uk/demo/sqlspatial/visualise.aspx 
• Find latitude and longitude from postcode. Several free services. Try http://www.nearby.org.uk/api/
• NOTE: We all think latitude and longitude. BUT spatial sw (such as SQL 2008) is longitude then latitude
• 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 

2008-10-24 MSDN Roadshow Re-Run

Session 1 ADO.NEXT – Entity Framework & Data Services

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

Not already signed up to MSDN Flash? Then check out http://msdn.microsoft.com/en-gb/flash/default.aspx
Interested in Visual Basic? Then check out http://blogs.msdn.com/goto100

ADO.NET Entity Framework

• MSDN Library http://msdn.microsoft.com/en-gb/library/bb399572.aspx
• EF Dev Manager http://blogs.msdn.com/dsimmons
• FAQ http://blogs.msdn.com/dsimmons/pages/entity-framework-faq.aspx
• Entity Framework Design http://blogs.msdn.com/efdesign/default.aspx
• Entity Framework sample project to explore ESQL and LINQ to Entities http://code.msdn.microsoft.com/EFQuerySamples
• Using Entity Framework with SQL 2008 types
• A bunch of EF extensions – Lazy Loading, Stored Procedures, Sample provider etc http://code.msdn.microsoft.com/adonetefx
• Code generation using T4

ADO.NET Data Services

• MSDN Library http://msdn.microsoft.com/en-gb/library/cc668792.aspx
• Team blog http://blogs.msdn.com/astoriateam
• How do I use ADO.NET Data Services with LINQ to SQL and enable read/write

Session 2 ASP.NEXT – The ASP.NET 3.5 Extensions

Session 3 Building Rich Internet UI with Silverlight 2

Session 4 Getting the most from the Visual Studio Team Suite Toolbox

2008-10-14 and 2008-10-16 Whats new in Visual Studio 2008 SP1

On Tuesday 14th we delivered this session in Birmingham and on Thursday 16th in Edinburgh. A big thanks to all who showed.

We have previously posted the links for these sessions.

Presentation: What's new for Presentation
Presenter: Mike Taulty http://mtaulty.com

Presentation: What's new in Data
Presenter: Eric Nelson http://blogs.msdn.com/ericnel

Microsoft at London Future of Web Apps 2008

Update... Silverlight 2 is released! 14th Oct 2008

Get free stuff...

Visual Web Developer 2008 Express Edition is a free version of Visual Studio for building all kinds of web applications - you'll also get the free version of SQL Server 2008 from the same place.

Everything you need to get started building Silverlight 2 applications - including download links and information.

Codeplex.com is one of the open source repositories where you’ll find loads of ASP.NET and Silverlight projects – download code for your own use, contribute to existing projects or create your own. Microsoft contributes much of its open source to Codeplex.com including extensions to ASP.NET such as the model-view-controller support in ASP.NET MVC.

Code Chronicles: It's often easy to forget how much commonality there is between our coding worlds - and as programmers and designers we can get pretty passionate about the tools, languages and approaches we use to create software... and every one has its advantages and its quirks... take a look at Code Chronicles to see where you're favourite programming language comes from.

The Microsoft Web Platform site includes link to the Web Platform Installer which auto configures a machine for building and running web applications on Windows in ASP.NET or PHP.

University session links...

Useful links...

Silverlight Streaming	Silverlight showcase
Silverlight community	Microsoft Expression product information
ASP.NET Community	Microsoft Expression community
Live.com - online services for developers	Get the Designer newsletter (Expression)
Get the UK Developer newsletter (MSDN Flash)	World Wide Telescope
Live Mesh	Photosynth
Microsoft Surface
Free access to video recordings from Remix UK 08

Blogs for some of the people you may have met at FOWA...

• Paul Foster
• Mike Taulty
• Mike Ormond
• Eric Nelson
• David Gristwood
• Paolo Barone
• UK ISV Team

2008-10-07 Whats new in Visual Studio 2008 SP1

Presentation: What's new for Presentation

Presenter: Mike Taulty http://mtaulty.com

ASP.NET

• ASP.NET website http://www.asp.net
• ASP.NET Videos http://www.asp.net/learn/3.5-SP1 
• jQuery Intellisense helper http://blogs.ipona.com/james/archive/2008/02/15/JQuery-IntelliSense-in-Visual-Studio-2008.aspx
• ASP.NET AJAX ScriptReferenceProfiler control http://www.codeplex.com/aspnet/Release/ProjectReleases.aspx?ReleaseId=13356
• ASP.NET Rotuing http://blogs.msdn.com/mikeormond/archive/2008/05/14/using-asp-net-routing-independent-of-mvc.aspx
• Dynamic Data @ Mix08 http://sessions.visitmix.com/?selectedSearch=T24
• Dynamic Data Futures on CodePlex http://www.codeplex.com/aspnet/Release/ProjectReleases.aspx?ReleaseId=14475

Windows Presentation Foundation

• WPF Site http://windowsclient.net
• Channel 9 "WPF Week" videos http://beta.channel9.msdn.com/tags/WPFWeek
• Tim Sneath's blog post on the new features http://blogs.msdn.com/tims/archive/2008/05/12/introducing-the-third-major-release-of-windows-presentation-foundation.aspx
• Greg Schechter's series on GPU based effects for WPF http://blogs.msdn.com/greg_schechter/archive/2008/05/12/a-series-on-gpu-based-effects-for-wpf.aspx
• WPF Toolkit Release on CodePlex (DataGrid) http://www.codeplex.com/wpf/Release/ProjectReleases.aspx?ReleaseId=14963
• Shader Effects and SplashScreen project templates on CodePlex http://www.codeplex.com/wpf/Release/ProjectReleases.aspx?ReleaseId=14962
• Client Profile http://windowsclient.net/wpf/wpf35/wpf-intro-client-profile.aspx 

Presentation: What's new in Data

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

Not already signed up to MSDN Flash? Then check out http://msdn.microsoft.com/en-gb/flash/default.aspx 
Interested in Visual Basic? Then check out http://blogs.msdn.com/goto100

ADO.NET Entity Framework

• MSDN Library http://msdn.microsoft.com/en-gb/library/bb399572.aspx  
• EF Dev Manager http://blogs.msdn.com/dsimmons
• FAQ http://blogs.msdn.com/dsimmons/pages/entity-framework-faq.aspx 
• Entity Framework Design http://blogs.msdn.com/efdesign/default.aspx
• Entity Framework sample project to explore ESQL and LINQ to Entities http://code.msdn.microsoft.com/EFQuerySamples   
• This tool allows you to play around with Entity SQL eSQLblast 

ADO.NET Data Services

• MSDN Library http://msdn.microsoft.com/en-gb/library/cc668792.aspx  
• Team blog http://blogs.msdn.com/astoriateam  

2008-10-02 Whats new in Visual Studio 2008 SP1

Presentation: What's new for Presentation

Presenter: Mike Ormond (http://mikeo.co.uk)

ASP.NET

• ASP.NET website http://www.asp.net
• ASP.NET Videos http://www.asp.net/learn/3.5-SP1 
• jQuery Intellisense helper http://blogs.ipona.com/james/archive/2008/02/15/JQuery-IntelliSense-in-Visual-Studio-2008.aspx
• ASP.NET AJAX ScriptReferenceProfiler control http://www.codeplex.com/aspnet/Release/ProjectReleases.aspx?ReleaseId=13356
• ASP.NET Rotuing http://blogs.msdn.com/mikeormond/archive/2008/05/14/using-asp-net-routing-independent-of-mvc.aspx
• Dynamic Data @ Mix08 http://sessions.visitmix.com/?selectedSearch=T24
• Dynamic Data Futures on CodePlex http://www.codeplex.com/aspnet/Release/ProjectReleases.aspx?ReleaseId=14475

Windows Presentation Foundation

• WPF Site http://windowsclient.net
• Channel 9 "WPF Week" videos http://beta.channel9.msdn.com/tags/WPFWeek
• Tim Sneath's blog post on the new features http://blogs.msdn.com/tims/archive/2008/05/12/introducing-the-third-major-release-of-windows-presentation-foundation.aspx
• Greg Schechter's series on GPU based effects for WPF http://blogs.msdn.com/greg_schechter/archive/2008/05/12/a-series-on-gpu-based-effects-for-wpf.aspx
• WPF Toolkit Release on CodePlex (DataGrid) http://www.codeplex.com/wpf/Release/ProjectReleases.aspx?ReleaseId=14963
• Shader Effects and SplashScreen project templates on CodePlex http://www.codeplex.com/wpf/Release/ProjectReleases.aspx?ReleaseId=14962
• Client Profile http://windowsclient.net/wpf/wpf35/wpf-intro-client-profile.aspx 

Presentation: What's new in Data

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

Not already signed up to MSDN Flash? Then check out http://msdn.microsoft.com/en-gb/flash/default.aspx 
Interested in Visual Basic? Then check out http://blogs.msdn.com/goto100

ADO.NET Entity Framework

• MSDN Library http://msdn.microsoft.com/en-gb/library/bb399572.aspx  
• EF Dev Manager http://blogs.msdn.com/dsimmons
• FAQ http://blogs.msdn.com/dsimmons/pages/entity-framework-faq.aspx
• Entity Framework Design http://blogs.msdn.com/efdesign/default.aspx
• Entity Framework sample project to explore ESQL and LINQ to Entities http://code.msdn.microsoft.com/EFQuerySamples  
• This tool allows you to play around with Entity SQL eSQLblast

ADO.NET Data Services

• MSDN Library http://msdn.microsoft.com/en-gb/library/cc668792.aspx  
• Team blog http://blogs.msdn.com/astoriateam

2008-09-24 Visual Studio 2008 Seminar

Presentation: Data and Data Access - State of the Nation
Presenter: Eric Nelson http://blogs.msdn.com/ericnel

General

• ADO.NET Team Blog http://blogs.msdn.com/adonet
• Mike in our team http://www.miketaulty.com ( search Entity or LINQ )
• Data Platform Developer Centre http://msdn.microsoft.com/en-gb/data/default.aspx
• Datasets http://blogs.msdn.com/bethmassi/archive/2008/04/12/linq-to-sql-n-tier-smart-client.aspx 

LINQ

• LINQPad http://www.linqpad.net/

ADO.NET Entity Framework

• EF Dev Manager http://blogs.msdn.com/dsimmons
• FAQ http://blogs.msdn.com/dsimmons/pages/entity-framework-faq.aspx
• Entity Framework Design http://blogs.msdn.com/efdesign/default.aspx

ADO.NET Data Services

• Team blog http://blogs.msdn.com/astoriateam

ADO.NET Sync Services http://msdn.microsoft.com/en-us/library/bb726002.aspx

Microsoft Sync Framework

• Team blog http://blogs.msdn.com/sync/

SQL Server Compact

• Team blog http://blogs.msdn.com/SQLServerCompact/

SQL server Data Services http://www.microsoft.com/sql/dataservices/default.mspx

Project Velocity http://msdn.microsoft.com/en-gb/data/cc655792.aspx