SharePoint datasheet mode crashes Internet Explorer

This content is 12 years old. I don't routinely update old blog posts as they are only intended to represent a view at a particular point in time. Please be warned that the information here may be out of date.

Back in the summer I wrote about creating dashboards in SharePoint using some borrowed JavaScript in a webpart to display calculate columns of HTML.  I needed to create another dashboard recently, so I reused my old technique but then, today, I found that I could no longer edit my list in SharePoint’s Datasheet mode.  Each time I tried, Internet Exploder crashed, blaming the problem on the Data Execution Prevention (DEP) functionality that is meant to prevent malicious code from being executed in memory.

Of course, being SharePoint (well, on 2007 at least), I couldn’t use an alternative browser but I was pretty sure the issue was related to the HTML generated an placed in a calculated column in my list. By creating a new view that excluded the problematic column (i.e. the one containing  the HTML), I was able to edit as normal, without a browser crash.

Short takes: Amazon Web Services 101, Adobe Marketing Cloud and Milton Keynes Geek Night (#MKGN)

This content is 12 years old. I don't routinely update old blog posts as they are only intended to represent a view at a particular point in time. Please be warned that the information here may be out of date.

What a crazy week. On top of a busy work schedule, I’ve also found myself at some tech events that really deserve a full write-up but, for now, will have to make do with a summary…

Amazon Web Services 101

One of the events I attended this week was a “lunch and learn” session to give an introduction/overview of Amazon Web Services – kind of like a breakfast briefing, but at a more sociable hour of the day!

I already blogged about Amazon’s reference architecture for utility computing but I wanted to mention Ryan Shuttleworth’s (@RyanAWS) explaination of how Amazon Web Services (AWS) came about.

Contrary to popular belief, AWS didn’t grow out of spare capacity in the retail business but in building a service-oriented infrastructure for a scalable development environment to initially provide development services to internal teams and then to expose the amazon catalogue as a web service. Over time, Amazon found that developers were hungry for more and they moved towards the AWS mission to:

“Enable business and developers to use web services* to build scalable, sophisticated applications”

*What people now call “the cloud”

In fact, far from being the catalyst for AWS, Amazon’s retail business is just another AWS customer.

Adobe Marketing Cloud

Most people will be familiar with Adobe for their design and print products, whether that’s Photoshop, Lightroom, or a humble PDF reader.  I was invited to attend an event earlier this week to hear about the Adobe Marketing Cloud, which aims to become for marketers what the Creative Suite has for design professionals.  Whilst the use of “cloud” grates with me as a blatant abuse of a buzzword (if I’m generous, I suppose it is a SaaS suite of products…), Adobe has been acquiring companies (I think I heard $3bn mentioned as the total cost) and integrating technology to create a set of analytics, social, advertising, targeting and web experience management solutions and a real-time dashboard.

Milton Keynes Geek Night

MK Geek Night #mkgn

The third event I attended this week was the quarterly Milton Keynes Geek Night (this was the third one) – and this did not disappoint – it was well up to the standard I’ve come to expect from David Hughes (@DavidHughes) and Richard Wiggins (@RichardWiggins).

The evening kicked off with Dave Addey (@DaveAddey) of UK Train Times app fame, talking about what makes a good mobile app. Starting out from a 2010 Sunday Times article about the app gold rush, Dave explained why few people become smartphone app millionaires, but how to see if your idea is:

  • Is your mobile app idea really a good idea? (i.e. is it universal, is it international, and does it have lasting appeal – or, put bluntly, will you sell enough copies to make it worthwhile?)
  • Is it suitable to become a mobile app? (will it fill “dead time”, does it know where you go and use that to add value, is it “always there”, does it have ongoing use)
  • And how should you make it? (cross platform framework, native app, HTML, or hybrid?)

Dave’s talk warrants a blog post of it’s own – and hopefully I’ll return to the subject one day – but, for now, that’s the highlights.

Next up were the 5 minute talks, with Matt Clements (@MattClementsUK) talking about empowering business with APIs to:

  1. Increase sales by driving traffic.
  2. Improve your brand awareness by working with others.
  3. Increase innovation, by allowing others to interface with your platform.
  4. Create partnerships, with symbiotic relationships to develop complimentary products.
  5. Create satisfied customers – by focusing on the part you’re good at, and let others build on it with their expertise.

Then Adam Onishi (@OnishiWeb) gave a personal, and honest, talk about burnout, it’s effects, recognising the problem, and learning to deal with it.

And Jo Lankester (@JoSnow) talked about real-world responsive design and the lessons she has learned:

  1. Improve the process – collaborate from the outset.
  2. Don’t forget who you’re designing for – consider the users, in which context they will use a feature, and how they will use it.
  3. Learn to let go – not everything can be perfect.

Then, there were the usual one-minute slots from sponsors and others with a quick message, before the second keynote – from Aral Balkan (@Aral), talking about the high cost of free.

In an entertaining talk, loaded with sarcasm, profanity (used to good effect) but, most of all, intelligent insight, Aral explained the various business models we follow in the world of consumer technology:

  • Free – with consequential loss of privacy.
  • Paid – with consequential loss of audience (i.e. niche) and user experience.
  • Open – with consequential loss of good user experience, and a propensity to allow OEMs and operators to mess things up.

This was another talk that warrants a blog post of its own (although I’m told the session audio was recorded – so hopefully I’ll be able to put up a link soon) but Aral moved on to talk about a real alternative with mainstream consumer appeal that happens to be open. To achieve this, Aral says we need a revolution in open source culture in that open source and great user experience do not have to be mutually exclusive. We must bring design thinking to open source. Design-led open source.  Without this, Aral says, we don’t have an alternative to Twitter, Facebook, whatever-the-next-big-platform-is doing what they want to with our data. And that alternative needs to be open. Because if it’s just free, the cost is too high.

The next MK Geek Night will be on 21 March, and the date is already in my diary (just waiting for the Eventbrite notice!)

Photo credit: David Hughes, on Flickr. Used with permission.

[Amazon’s] Reference architecture for utility computing

This content is 12 years old. I don't routinely update old blog posts as they are only intended to represent a view at a particular point in time. Please be warned that the information here may be out of date.

Earlier this week, I attended an Amazon Web Services (AWS) 101 briefing, delivered by Amazon UK’s Ryan Shuttleworth (@RyanAWS).  Although I’ve been watching the “Journey into the AWS cloud” series of webcasts too, it was a really worthwhile session and, when the videos are released to the web, well worth watching for an introduction to the AWS cloud.

One thing I particularly appreciate about Ryan’s presentations is that he approaches things from an architectural view. It’s a refreshing change from the evangelists I’ve met at other companies who generally market software by talking about features (maybe even with some design considerations/best practice or coding snippets) but rarely seem to mention reference architectures or architectural patterns.

During his presentation, Ryan presented a reference architecture for utility computing and, even though this version relates to AWS services, it’s a pretty good model for re-use (in fact, the beauty of such a  reference architecture is that the contents of each box could be swapped out for other components, without affecting the overall approach – maybe I should revisit this post and slot in the Windows Azure components!).

So, what’s in each of these boxes?

  • AWS global infrastructure: consists of regions to collate facilities, with availability zones that are physically separated, and edge locations (e.g. for content distribution).
  • Networking: Amazon provides Direct Connect (dedicated connection to AWS cloud) to integrate with existing assets over VPN Connections and Virtual Private Clouds (your own slice of networking inside EC2), together with Route 53 (a highly available and scalable global DNS service).
  • Compute: Amazon’s Elastic Compute Cloud (EC2) allows for the creation of instances (Linux or Windows) to use as you like, based on a range of instance types, with different pricing – to scale up and down, even auto-scalingElastic Load Balancing  allows the distribution of EC2 workloads across instances in multiple availability zones.
  • Storage: Simple Storage Service (S3) is the main storage service (Dropbox, Spotify and others runs in this) – designed for write once read many applications.  Elastic Block Store (EBS) can be used to provide persistent storage behind an EC2 instance (e.g. boot volume) and supports snapshotting, replicated within an availability zone (so no need to RAID). There’s also Glacier for long term archival of data, AWS Import/Export for bulk uploads/downloads to/from AWS and the AWS Storage Gateway to connect on-premises and cloud-based storage.
  • Databases: Amazon’s Relational Database Service (RDS) provides database as a service capabilities (MySQL, Oracle, or Microsoft SQL Server). There’s also DynamoDB – a provisioned throughput NoSQL database for fast, predictable performance (fully distributed and fault tolerant) and SimpleDB for smaller NoSQL datasets.
  • Application services: Simple Queue Service (SQS) for reliable, scalable, messages queuing for application decoupling); Simple Workflow Service (SWF) to coordinate processing steps across applications and to integrate AWS and non-AWS resources, to manage distributed states in complex systems; CloudSearch – an elastic search engine based on Amazon’s A9 technology to provide auto-scaling and a sophisticated feature set (equivalent to SOLR); CloudFront for a worldwide content delivery network (CDN), to easily distribute content to end users with a single DNS CNAME.
  • Deployment and admin: Elastic Beanstalk allows one click deployment from Eclipse, Visual Studio and Git  for rapid deployment of applications with all AWS resources auto-created; CloudFormation is a scripting framework for AWS resource creation that automates stack creation in a repeatable way. There’s also Identity and Access Management (IAM), software development kits, Simple Email Service (SES), Simple Notification Service (SNS), ElastiCache, Elastic MapReduce, and  the CloudWatch monitoring framework.

I suppose if I were to re-draw Ryan’s reference architecture, I’d include support (AWS Support) as well some payment/billing services (after all, this doesn’t come for free) and the AWS Marketplace to find and start using software applications on the AWS cloud.

One more point: security and compliance (security and service management are not shown as they are effectively layers that run through all of the components in the architecture) – if you implement this model in the cloud, who is responsible? Well, if you contract with Amazon, they are responsible for the AWS global infrastructure and foundation services (compute, storage, database, networking). Everything on top of that (the customisable parts) are up to the customer to secure.  Other providers may take a different approach.

Useful links: November 2012

This content is 12 years old. I don't routinely update old blog posts as they are only intended to represent a view at a particular point in time. Please be warned that the information here may be out of date.

A list of items I’ve come across recently that I found potentially useful, interesting, or just plain funny:

Website moving to a new server…

This content is 12 years old. I don't routinely update old blog posts as they are only intended to represent a view at a particular point in time. Please be warned that the information here may be out of date.

My hosting provider has told me that they are moving this website to a new server over the weekend.

All being well, the move will be transparent but I will also need to point the domain names at new DNS servers, so, if I disappear offline for a while on Sunday night, please bear with me and I should be back again once the interwebs have updated…

HomePlug Ethernet, part 1

This content is 12 years old. I don't routinely update old blog posts as they are only intended to represent a view at a particular point in time. Please be warned that the information here may be out of date.

As more an more computing devices are being allowed into my living room (Xbox, Smart TV, etc.) I’m starting to find that the Wi-Fi in our house, which seems fine for basic surfing, email, social media, etc. is struggling more and more when it comes to streaming video content.

It could be a problem with my Wi-Fi setup but I have a pretty good access point, located in a reasonably central position (albeit upstairs) and an Apple Airport Express acting as a repeater, connected to some speakers in our garden room.  I have a feeling that the TV and Xbox are picking up the Airport Express, rather than the main access point (no way to tell on the Airport Express as its diagnostics are almost non-existent) and the lengthy Wi-Fi journey between access points may be the cause of my problems.  I could redesign the network but it works for streaming Spotify to the garden room/kitchen so I started to consider alternatives.

Creating CAT5E/6 cable runs around the house is just too disruptive (I did consider it when we extended a few years ago, but it was quite expensive too), so I started to look at running Ethernet over the household electrical system with HomePlug devices.

A bit of crowdsourcing (asking around on Twitter) turned up quite a bit of advice:

  • Develo dLAN devices seemed to be well-regarded and I nearly bought a dLAN 500 AVtriple+ starter kit.
  • A few people mentioned the TP link Powerline products too.
  • Some people told me to go for faster connections (500Mbps) and that slower devices may be limited by 10/100Mbps Ethernet connections.
  • Others suggested higher speeds are more vulnerable to overheating and interference (that was another common theme – depending on the household wiring it seems you might not get very close to the stated maximum).

Ultimately, whatever I use will mostly be streaming content from the Internet (BBC iPlayer, etc.) over my ADSL connection (which runs at about 6Mbps downstream) so the home network shouldn’t be the bottleneck, once I get off Wi-Fi and onto some copper.

I mentioned that I nearly bought the Develo kit, so why didn’t I? Well, just as I was getting ready to purchase, PowerEthernet (@PowerEthernet) picked up on my tweet and suggested I take a look at their product, which is really rather neat…

Instead of plugging into a socket (either with or without pass-through power capabilities), the PowerEthernet devices replace a standard UK double socket to provide a single socket and four 200Mbps Ethernet ports. You need a pair (of course) but they work together to create an encrypted (AES128) mesh network that’s compatible with the HomePlug Alliance AV standard.

Professional installation is recommended but, as Paul Ockenden (@PaulOckenden) highlights in his PCPro article:

“Most competent DIYers should be able to replace an existing two-gang socket with a Power Ethernet faceplate, and indeed the IEE Wiring Regulations do allow for a confident consumer to do this. For a new installation, however, or if you lack the confidence, you’ll need to consult a qualified electrician.”

I haven’t installed mine yet – I only collected them from the Royal Mail today – but I intend to report back when I’ve had a chance to play. In the meantime, Jonathan Margolis (@SimplyBestTech) wrote a short but sweet piece for the FT. PC Pro’s full review suggests they are a bit pricey (almost £282 for a pair including VAT) but Girls n Gadgets’ Leila Gregory (@Swannyfound them on Amazon at closer to £80 each (as did I).

I’ll write more when I’ve had a chance to use them for a bit…

How Volkswagen turned an angry customer into a happy one

This content is 12 years old. I don't routinely update old blog posts as they are only intended to represent a view at a particular point in time. Please be warned that the information here may be out of date.

Every now and again, it’s nice to post a “good news” story. This one’s about great customer service. You see, I’ve criticised Volkswagen before because of the problems with water-based paints on their cars, so it’s only right to call them out when they see sense and give great service too. Unfortunately, there is a sting in the tail for one dealer, who will never see my credit card (or any other method of payment) again…

Indeed, one afternoon last week it was a minor miracle that I didn’t tweet my anger and frustration at Volkswagen’s attitude to repairing a known issue on my wife’s low mileage car. The only reason I didn’t was because one of my friends had asked earlier in the week if I needed a “virtual hug” as it seems I’ve been very grumpy on Twitter recently!

A known issue

Our family Golf, which is just over 4 years old (so out of warranty) but has only been driven around 14,000 miles and has a full Volkswagen service history (it’s only just come off a Volkswagen service, maintenance and tyres agreement) was showing a warning lamp for the Electronic Stability Program (ESP). According to the handbook, that means the Anti-lock Braking System (ABS) isn’t working either (normal braking will be fine) and that’s not so great with standing water on the roads and ice to follow later this week.

I booked the car in with a local mechanic, who very kindly, diagnosed the fault and advised me to take it to Volkswagen instead, as the “G201 brake pressure sensor” issue is a known problem on Mk 5 Golfs and Tourans (indeed on a number of other VAG, BMW, and even Citroen cars). Whilst he could take my money, he thought I might be able to get Volkswagen to contribute to the cost on such a low mileage car, as it’s not really a service item and shouldn’t wear out or get damaged.

Furious with the Volkswagen dealer’s response

So I called the local Volkswagen dealer, Wayside Volkswagen in Milton Keynes (Jardine Motors Group), from whom I have purchased the last two (new) cars for my wife and one company car (with a previous employer) as well as placing almost all of my Volkswagen servicing business with them since about 2003. I didn’t even get past the service reception. In fact, I hung up the phone in frustration at the unhelpful, obstructive Service Manager who wanted around £90 for someone to take a look, couldn’t carry out the diagnosis whilst I waited and wasn’t even prepared to discuss the possibility of any goodwill repairs on a car out of warranty*.

Perseverance

After taking a few deep breaths, I tried another dealer, My Volkswagen in Northampton (Parkway Motor Group) who were sympathetic to my problem, explained they would have to charge a diagnostic fee of £69 (including VAT) but that, depending on the outcome, they would speak to Volkswagen UK on my behalf to see if there was any goodwill available. And they could look at the car only a couple of days later (usually I have to wait weeks to get some time with a technician at Wayside).

Good news all-round!

I took the car over today and was delighted to hear a short while later that Volkswagen UK had looked into the circumstances and would carry out the repairs free of charge. Even better, the technician was working on the car and it would be ready the same day. Clearly this won’t happen for everyone – I was really lucky – but this is excellent customer service from a brand I trust, with a car that shouldn’t exhibit this issue (indeed, my Tiguan has been driven more miles in 7 months than my wife’s Golf has in 4 and a half years).

Furthermore, rather than using an independent garage (although I do feel bad because of my local mechanic’s honesty and that might swing things) I’m considering entering into a service contract with Parkway now, which sees the next five years worth of servicing go their way. Oh yes, and my (leased) company car is due for a service in a few thousand miles too, so guess where that will go… and guess where it won’t? So, a part that should cost about £132+VAT, plus labour, and some brake fluid (probably about £400 in total) has cost Wayside Volkswagen a lot of goodwill, together with thousands of pounds worth of servicing and parts over the next few years, maybe even our next family car too.

Customer service matters. Thanks to my local mechanic. Thanks to MyVolkswagen. Thanks to Volkswagen UK. And to anyone reading this blog in the Milton Keynes area, I’d avoid Wayside Volkswagen if I were you…

*I also had cause to complain to Wayside Volkswagen in Milton Keynes when I was choosing my last car, as the pre-sales service I received was so bad – but that’s another story.

Unable to access Barclaycard-powered credit card websites? Try InPrivate browsing

This content is 12 years old. I don't routinely update old blog posts as they are only intended to represent a view at a particular point in time. Please be warned that the information here may be out of date.

Late last night, I was trying to log on to the website for a credit card that I use, that’s branded as belonging to a hotel chain but actually provided by Barclaycard*.  After going through the usual security theatre to log on, the system kept telling me that it was unable to access my account:

Unexpected error
Sorry, an unexpected error has occurred and we can’t continue servicing your account online at this time.

I’ve seen this before so I decided to try another browser, then another PC, then a Mac, then yet another PC – all to no avail.

The fact that I tried so many machines (some of which I wouldn’t have used before to access the site) suggests that the problem is not to do with cookies but I eventually managed to access the site using Internet Explorer’s InPrivate browsing mode (Ctrl+Shift+P – some other browsers have similar functionality).

So, if you’re having problems accessing a Barclaycard-powered site, InPrivate browsing might be the answer.

Strangely, I tried again this morning, from one of the PCs that didn’t work last night and everything worked as it should… bizarre!

*Barclaycard’s own cards appear to use a different system.

5 “stars” to linked open data

This content is 12 years old. I don't routinely update old blog posts as they are only intended to represent a view at a particular point in time. Please be warned that the information here may be out of date.

Every now and again I have a peek into the world of linked and open data. It’s something that generates a lot of excitement for me in that the possibilities are enormous but, as a non-developer and someone whose career has tended to circle around infrastructure architecture rather than application or information architectures, it’s not something I get to do much work with (although I did co-author a paper earlier this year looking at linked data in the context of big data).

Earlier this year (or possibly last), I was at a British Computer Society (BCS) event that aimed to explain linked data to executives, with promises of building a business case. At that event Antonio Acuna, Head of Data at data.gov.uk presented a great overview of linked and open data*. Although I did try, I was unable to get a copy of Antonio’s slides (oh, the irony!) but one of them sprung to mind when I saw a tweet from Dierdre Lee (@deirdrelee) earlier today:

Star rating of #opendata can be improved sequentially. Describe metadata using #RDF even if content isn't yet #dcat #LinkedData #datadrive
@deirdrelee
Deirdre Lee

The star rating that Dierdre is referring to is Sir Tim Berners-Lee’s 5 star model for linked open data. Sir Tim’s post has a lot more detail but, put simply, the star ratings are as follows:

No star web data Available on the web (whatever format) without an open license
One star open web data Available on the web (whatever format) but with an open licence, to be Open Data
Two star open web data Available as machine-readable structured data (e.g. excel instead of image scan of a table)
Three star open web data As for 2 stars, but in a non-proprietary format (e.g. CSV instead of Excel)
Four star open web data All the above plus, use open standards from W3C (RDF and SPARQL) to identify things, so that “people can point at your stuff”
Five star open web data All the above, plus: link your data to other people’s data to provide context

It all sounds remarkable elegant – and is certainly a step-by-step approach that can be followed to opening up and linking data, without trying to “do everything in one go”.

*Linked and open data are not the same but they are closely related. In the context of this post we can say that open data is concerned with publishing data sets (with an open license) and linked data is concerned with creating links between data sets (open or otherwise) to form a semantic web.

Attribution: The data badges used on this post are from Ireland’s Digital Enterprise Research Institute (DERI), licensed under a Creative Commons Attribution 3.0 License.

 

Some thoughts on modern technology: email, gadgets (and how children view them)

This content is 12 years old. I don't routinely update old blog posts as they are only intended to represent a view at a particular point in time. Please be warned that the information here may be out of date.

I haven’t found much time to blog recently, but this post pulls together a few loosely related streams of consciousness on technology – how we use it (or does it use us?), how it’s sold to us, and how the next generation view the current generation’s tech.

on Email…

Driving up to and back from Manchester last Friday night gave me a great opportunity to catch up on my podcast backlog – including listening to an entire series of Aleks Krotoski’s The Digital Human (#digihuman). The “Influence” and “Augment” episodes are particularly interesting but I also found that some parts of “Intent” sparked some thoughts in my mind. That episode featured comments by Douglas Rushkoff (@rushkoff) of Program or be Programmed fame, which I’ve paraphrased here.

Email can be seen as a [broken] game with many unintended consequences coded into it. For many of us, our working life is a game called “empty the inbox” (in the process, filling the inboxes of others). Email has a bias to generate more email – even when we’re away we auto-generate messages. In effect, all problems become a “nail” for which email is the “hammer”.

We’re almost entirely reactive – and we need to understand that it’s a person on the other side, not a computer – someone who is expecting something of some other person. So, standing up to your Blackberry is really standing up to your boss/colleague/whoever, not to the technology. It takes a brave person to send an out of office response that says something to the effect of “I’m deleting your message, if it was urgent, send it again after I’m back”. But that is starting to happen, as people realise that they are the humans here, with finite lifespans, and that a line needs to be drawn “in the digital sand” to show their limits.

I was also fascinated to learn that the average US teenager sends 3000 texts (SMS messages) a month – a stark contrast with ten years ago, when I had to explain to American colleagues what SMS was. At that time, the USA still seemed to be hooked on pagers, whilst SMS was really taking off over here in Europe.

on gadgets…

I spent a chunk of this weekend shopping for a (smart) television and a smart phone [why does everything have to be “smart” – what next, “neat”?].

The experience confirmed to me that a) I’m officially “a grumpy old man” who doesn’t appreciate the ambient noise in John Lewis’ audio visual department (nor, I suspect, do many others in the department store’s target demographic) b) John Lewis’ TV sales guys do not deliver the “well-trained and knowledgeable” confidence I associate with other departments in the store (i.e. they don’t really know their stuff) c) Samsung reps attached to consumer electronics stores are trained to up-sell (no surprise) d) Even John Lewis’ under-trained TV sales guys are better than Carphone Warehouse’s staff (who told my wife that the difference between the iPhone 4, 4S, and 5 starts off with the operating system… at which point I bit my tongue and left the conversation).

Incidentally, Stephen Fry’s new series, Gadget Man, starts tonight on Channel 4 – might be worth a look…

on the way children see gadgets…

Of course, the shopping experience had another angle introduced by my kids, who decided that it would be a good idea to change the channel on as many TVs as possible to show CBeebies (it kept them amused whilst we talked about the merits of different models with the Samsung rep who was in store) but I was fascinated to see how my boys (aged 6 and 8) reacted in Carphone Warehouse:

  • The switch from “oh phone shopping – that will be boooooring” to “oh, look, shiny things with touch screens” was rapid.
  • They liked using a stylus to write on a Galaxy Note.
  • All tablets are “iPads” (in fairness, my wife pointed out that that’s all they’ve ever known in our house).
  • An e-ink Kindle is a “proper Kindle” and the Kindle HD (which they had been happily playing games on – it took my six-year-old about 30 seconds to find “Cut The Rope”) was “the iPad Kindle”.

The irony…

After slating email as a “broken game”, I posted this by email using the new post by email functionality in the WordPress Jetpack plugin. I guess it still has its uses then…