Schedule for LinuxFest NW is up

Hey all – if you were planning on attending LinuxFest NW my presentation is on Saturday afternoon. The whole two days are free and there looks to be some great talks. If you are in the area you should come on by.

Oh yeah and I will be giving one of the 4 hour workshops on the first day of GeoWeb 2009. I am bummed that Mansour will be giving his workshop at the same time as me since I now expect 2 of the original 5 people to show up for my workshop. The other reason it bums me out is because I really wanted to go to his session.

I know James will be there but who else from the GIS posse is planning on attending?

I am not going to where but I am going to WhereCamp. Are there any other events people are really looking forward to attending?

VSLive09 – SQL Server 2008 for developers

Leonard Lobel is the presenter – He is a doing a good job showing demos and covering  just the right amount of details in slides. Striking a good balance between new features and basic understanding. Talks a bit fast, so sometimes I fall behind.

Got in late. SQL Server 2008 studio has some very nice features

Table defined types, table valued paramter (TVP) gives you the ability to define a variable which is actual a whole table (like a temp table) with a schema defined.  They are stored tempdb (so a bit slower than CTE or table variable) but it can be indexed. Use case is something like an order table because you can flatten the schema for the header and order items. Instead of going round trip for each piece you can create a table with one call. Demo time

Very very nice! Quick and easy to get results and much less chat across the wire with a client.

Once you pass it – it is read only once you pass it down the stack. THere is no ALTER TABLE… AS TYPE so you need to drop it as well as the stored procedures

Next Topic – MERGE

Four statements in one

• select
• insert
• update
• delete

Operates on a join but you didn’t need to know about it

Start using it now – 100% compat with existing business logic, such as triggers

OUTPUT is for getting psuedo-tables after an operation
OUTPUT $action, inserted.*, deleted.*;

Demo time – he is showing how to do replication and it is really tight and interesting to watch.  Give me more kool-aid

He does a nice demo for updating data and it looks really good – just too much to follow and he is talking a bit too fast.

Next – GROUP BY

Look at with Roll up and CUBE – frickin awesome great for summarization – produces sum for all possible combinations

new is GROUPING SETS – basically does it just for the category you ask for

SQL Server does Cubes right out of the box.

GROUPING helps to deal with distinguising between Nulls and All possible values rolled up

To get this from ORM you would need to use a view or something like that. We then had a short detour on when you might use TSQL vs ORM. He says doing reporting like this might be a place where you might want to use TSQL but he understands the conlict there.

BIG BENEFIT TO VSLive – IT IS NOT MS Conference so the presenters are not as kool-aid driven, much more frank conversation and discussion of pitfalls

New Date and Time variable

• Date
• Time
• datetime2
• datetimeoffset

use these instead of

• datetime
• smalldatetime

Some more about writing code and insulation between layer

He likes DataSets unless you need to serialize them. He thinks they are good for most people and don’t think you really need ORM. DataSets are not slower than DataReaders

He believes developers should only query against stored procedures – no access directly to the tables.  For numerous reasons he then delimits the reasons – wow that is bit harsh but interesting to think about. He argues that with a where clause in LINQ, is that you pull back all the data and then filter on the client and why would you want to do that.

On to LINQ

LINQ is really a way to deal with collections to datasource and vice versa in a standard language. Trying to get rid of all these For loops where you process something to get a Collection of data objects.

On to LINQ to DataSet – look in System.Data.DataSetExtensions assembly

He says if you are starting new he says go to Entity framework – it is much more of an ORM mapper

Watching him decorate a Plain Old C# Object (POCO) with LINQ attributes and then doing really cool things. This is actually pretty neat stuff. As a person who doesn’t usually get into performance issues because of low transaction numbers, I am going to mostly go down this route.

He concludes morning session on stating – LINQ is going to be with us for a while and you better dig in. Some providers are better than other but you better learn it.

More to come after lunch!!! THis is a great session

VSLive – Building RESTful services using WCF 3.5

Jon Flanders found at www.rest-ful.net or www.pluralsight.com – vibrant speaker. He wrote RESTful.NET for O’reilly. He actually is a great speaker.

Hey Sean, he called it an architectural style – does he get correctness points for that.

Gives a short history of REST vs SOAP/WS* and now an introduction so I am tuning out again until he comes to how to do this with WCF. He is doing a good job talking about why REST is better.

VS2008 .NET3.5 SP1

Much fewer attributes to define the service. Just create a service and then create methods to respond to messages.  Since there probably no needs for multiple implementations of the service you don’t need to use IService -> Service, just do the service. You need a WebGet annotation – with a UriTemplate = to the uri that you want to use to get this method called.

You do need a SVC file – a text file with the service definition for IIS to see the service,  also needs a factory that is in his demo.

Fiddler is a good tool for doing REST debugging if you don’t want to use Firebug – made by MS.

Caching is a huge benefit for REST – especially with static data.  Glad to hear Silverlight support JSON/ WCF has support for JSON – AJAX enabled WCF service from new file.

Easy to do with feeds with as well – showing how to create an Atom feed -built in helper methods.

There is a REST starter kit on codeplex.

GREAT SESSION – highly reccomend as a speaker and does a good job talking to .NET developers about why use REST.

VSLive – WCF a whirl wind introductio

Rob Green is the presenter

Available at www.mcwtech.com/2009/vslive/sf

WCF allows you to expose the same service through many protocols – not just SOAP over HTTP (did he just say SOAP, I am about to have listen to WS* stuff)

Looks like from this talk it only knows how to talk using XML as the data type and that you might have to define XSD. I think there is a REST using WCF in a later session. That might be more appropriate for what I want…

So while most of his talk is generic it looks to be focused mostly on WS* stuff. I may skip out and go to the LINQ session though it sounds like Entity Framework is the way to go. Nah stay here for now…

Interesting, Attributed Code seems to be the .NET equivalent to Java  @ annotations.

The WCF test client shows you the XML payloads and the bound data – not bad

If the web service to front your service – delete the generated files and point it instead to the service you make first. Need the slides or demo to figure this stuff out and now I see what Dave B was talking about. There is a lot to remember to get this up and going – then again he is showing WS*.

Alright tuning out and doing work work – pop back in if he stops talking about WS*.

Ok, wacky pack but kinda cool is that you could host one of these services inside excel where one person has the master spreadsheet and everyone else looks to get updates interactively while the spreadsheet is open.

Interesting

VSLive – using sharepoint and VSTO to deliver apps

You can use WPF in VSTO

Advantage for sharepoint is that it reduces risk and so does office

Allows you to integrate data from the desktop in excel with central data sources. You probably/may not to make this outward facing to the rest of the world and instead use it just internally.

Help to bring some structure from unstructured business flows – gives example using Excel spreadsheet being set around in email. Work in excel but it is really talking to back-end data services (VSTO helps with this – no more VBA – another source for 3 cheers). He is a big fan of Office 2007.  VSTO can also integrate with VBA in your current documents.

UH OH – VB6 troll in the room and sidetracks the conversation.

Demo of sharepoint with an excel worksheet with customization with VSTO rather than VBA. Has some web service calls and some DB stuff and save the results back to the DB, trigger the workflow, then trigger an email.

Ruh roh – network connection not working during a demo – I don’t want to be on the end of these kind of support calls.

VSTO

Action Pane and Custom task pane – a Window Form pane in excel to work with and the wpf interop control allows you to put some WPF controls there. Same for Ribbon bar

Outlook form regions – set up custom capabilities inside of outlook. Put a WPF control in outlook email message – hhhmmmm that first hit is free – are you in and if so you are in for a long long time to come

VSTO adds two sharepoint specific worklows – sharepoint is such a sense of gobleygook to me. I wish someone built some nice sharepoint site so I could feel good about spending time trying to make it work. Right now I am so not sold on sharepoint, and certainly not something mere mortals can do.  These demos are doing nothing for making me feel any better about sharepoint. Does anyone out there have good stories about sharepoint – other than propoganda.

Too much demo problems making it hard to stay focused – hello twitter, whats up on FB….

Alright it is kinda late in the day and I am not all the interested in breakpoints in the worklflow but looks kinda cool.

LINQ to SQL in an excel spreadsheet FTW!

Load Events when working VSTO form has to be called on the document load otherwise it doesn’t work.

VSLive – ASP.NET MVC (or MS discovers Struts)

Stephen Walther is the presenter and I like his style. Easy going, minimal slides, and good examples with explanations

It is a new technology for web developers and not to replace WebForms. I usually had a hard time with this with .NET devs in the past. I am glad there is something there now that I can show with the MS stamp of approval.

MVC = Model – View – Controller

It was built on codeplex in an agile pattern and is open source. He is now going to show a CRUD application. It is good to see how people use VS.

Sweet – it prompts you to create unit test from the start. Nice little lecture on why testing is important especially when you need to touch other peoples code. Hallelujah he says to delete the sample files since they just end up confusing you.

Invest the ADO.NET Entity data model  framework (“the way forward”) rather than LINQ -but they are very similar

He is going to talk about Model Binding which is the new concept for MS. You can register your own model binders.

Holy cow this is so much better than web forms but still not good enough – I am really going to focus on the WCF and REST sessions. I was done with this style of development quite some time ago.

FOSS to the rescue

What to do when a client sends you multiple 500Meg DBF files and you want to move them into PostgreSQL? Why you find a FOSS solution of course.

http://www.tv.com.pl/stepbystep/dbasepsql/

Seems to be a problem for us in the program seeing all the DBF files in the dbf folder but it works if you list them in the properties file. Pretty darn quick, runs in Java so multiplatform, source code included in case you want to change it, and it gives you both a DDL and a data file.

Life is good…

Haven’t posted in a while

1. Been extremely busy traveling and talking to customers
Webinars with Nokia
Classes with Nokia
Customers and partners in Columbia, Brazil, the Pacific Northwest
Talk at LinuxWorld

2. Find myself using my blogging energy to post shorter snippets on Twitter (@TheSteve0)
3. Life changes that I will blog about soon.

In the mean time you need to watch this video (it is an hour long but mind expanding and well done)
It is Michael Wesch the anthro professor talking to the library of congress – sounds boring but then you are WRONG because it is great.

Here is the money shot – on the left what we have – on the right what we want

Would love to hear your thoughts about what he said. There is interesting cross fertilization happening everywhere – O’Reilly Radar points out this post which talks about OS style-community interaction becoming more popular in the workplace in general. Which I think ties directly into the post above…

Mashup Camp Day 1

Well here we go at mashup camp. It is nice to catch up people from last year, such as Ted from Bungee Labs. I really like the way David runs these events, he is funny and is flexible about how things go and they always seems to be fun. I am not sure if I want to try lead a session today or tomorrow but it should be fun to hear the discussion.

Some ideas:

• What you want in a mashup API provider (other than free)
• Moving beyond pushpins with location stuff
• The dark side of mashup – authentication and relying on services not your own

I don’t think I am going to live blog this one – more of just a thoughts either during the day or sometime on friday. I am also thinking about entering the contest now that I grok our API. This could be a fun way to make a demo.

Wireless is grinding to a crawl – we’ll see how it holds up…

If you care about my schedule

If you want to meet up with me here is some of the things I will be going to in the near future:

1. The web 2.0 mapping and social network meetup in Menlo Park – This should be fun with Mapfacture, remapper, and mashed life giving presentations

2. Mashup Camp at the Computer History Museum -  had a great time last year and lookin forward to going again. Love the lightning round when you get to see all the cool apps people are making but it is also nice to hear the big boys talk about where they will push the enterprise.

3.  CTIA in Vegas – I am going to Mobile Jam beforehand. I really don’t like Vegas but it will be fun to be floor for this extravaganza. I will be working the booth so stop by.

4. Web 2.0 Expo – I will be there in the Tele Atlas booth looks to be a great floor as well. Come on over for a chat. I will be showing some of the demos I put together.

Farther out I am planning on attending Where and  for sure going to be at WhereCamp, perhaps Location Intelligence and Extend08.

Have I mentioned that I love living in the Valley…