• Include row numbers in your SQL SELECT results

    Luke Canvin Blog Post

    The first of a series of posts introducing handy functions built into SQL Server (2005 and above) to help you include interesting metadata about your SELECT statement’s results. Row_Number() If you’d like to include the row number of the items as they appear in your SELECT result set then the Row_Number function does exactly that. For example: Select SortName, Row_Number() Over (Order By Forename) As Row From T_Person Where Surname = 'Lawson' Would result in: SortName Row ------------------------- ------ Lawson,[...]

  • Stop serving insecure files over a secure connection

    Luke Canvin Blog Post

    I’m sure you’ve come across IE7’s warning “This page contains both secure and nonsecure items. Do you want to display the nonsecure items?” Or IE’s more recent warning “Do you want to view only the page content that was delivered securely?” Other browsers have similar messages, which will rightly unnerve cautious internet users. These warnings are the result of the page being secured, delivered over HTTPS, but some of the page’s resources being delivered using HTTP. It’s a simple thing[...]

  • Foreign keys and deletion performance

    Luke Canvin Blog Post

    Relational databases tend to be furnished with many foreign key constraints. These prevent some types of invalid data from being added to tables – you can think of them as an ASSERT if you’re more familiar with C# and the like. Normally, the performance impact is minimal, based on the following arrangement: The column being referenced by the foreign key will almost always be the primary key of its table. As such it will be indexed so that, when adding[...]

  • Improve WordPress page speed without plugins

    Luke Canvin Blog Post

    There are plenty of WordPress plugins out there that promise to improve your page speed in various ways, but the truth is you can do a great deal without resorting to them and just making a few simple but effective changes to your Apache configuration. In fact, this article applies equally to any Apache website, not just WordPress. As we know, keeping our page load times nice and snappy is the key to happy visitors and one of the important[...]

  • TortoiseSVN integrated into Windows 7 Libraries

    Luke Canvin Blog Post

    TortoiseSVN 1.7 added some Windows integration goodness in the form of integration with Windows 7’s “Libraries” feature. Windows 7 Libraries are a way of giving a name to a group of related folders. You can then search the library, which will look through all the different folders you added to it. The important thing to remember is that all the folders you add to a library will remain in the same physical location. There are a few special, default libraries[...]

  • Display SQL messages instantly, mid-execution

    Luke Canvin Blog Post

    Sometimes when you are running a long running script or stored procedure it’s nice to know whereabouts it has got to, often we put in print statements for this purpose. The problem is that half the time you won’t see the printed statement until SQL Server decides it can’t buffer anymore and shoves it back to the client (e.g. Management Studio) which may not be until it has finished in some cases. Instead of using print in these situations the[...]

  • International Congress on Telehealth and Telecare

    Laura Walton Blog Post

    OCC represented Cupid for the International Congress on Telehealth and Telecare at the Kings Fund on 7-8 March. There was a lot of interest in the results from the Whole System Demonstrator which has established the benefits of telemedicine for chronic diseases. The European Commission was directly represented by speakers from the European Innovation Partnership on Active and Healthy Ageing. Cupid built links with two other FP7 projects, Chronious and inCasa.

  • OCC loves CuPiD

    Laura Walton Blog Post

    Telemedicine is the use of telecommunication and information technologies in order to provide health care at a distance. Here at OCC we are involved in a number of telemedicine projects around Parkinson’s disease and the latest is CuPiD. Part funded by the European Union (FP7/2007-2013), the CuPiD project is developing and field testing home rehabilitation services for the major motor disabilities caused by Parkinson’s disease. OCC is responsible for transforming these services into telemedicine services; available in the home with[...]

  • OCC donates PCs to homeless charity for internet cafe

    Laura Walton Blog Post

    OCC have donated some of our old PCs to help Shepherd’s View set up an internet café to help support their residents. First Housing is the Shepherd’s View service that focuses on helping young parents by providing a supportive environment, helping them develop their skills and self-confidence as parents and as individuals. Shepherds View work in partnership with parents and children, developing supportive relationships based on mutual respect and openness and offering a range of support to young parents so[...]

  • New look PSOCC being rolled out to service providers

    Laura Walton Blog Post

    PSOCC V2.2  is now rolling out to OCC’s PSOCC users. The new look PSOCC improves the way support providers can securely share information and workloads. New reports let users more clearly see the support that’s needed and the outcomes achieved. The improved screen layouts provide the adaptability needed by new commissioners whilst retaining the integrated SP reporting still required by some LAs. PSOCC is one product in OCC’s range of software solutions designed for the Support Providers, enabling them to[...]

  • PERFORM – software to model a tremor

    Janine Smith Blog Post

    The PERFORM project is one of 50 projects selected from 450 applications to be displayed at the Innovation Convention 2011 exhibition to be held in Brussels on 5th and 6th December 2011. A working version of the system will be on show. OCC’s software engineers are developing, testing and integrating software to model a person’s tremor for a wearable home monitoring device for people with neurogenerative diseases. OCC has a long standing involvement with research into virtual reality related healthcare[...]

  • Predictive Asset Management Conference

    Laura Walton Blog Post

    OCC is sponsoring the Predictive Asset Management conference at the Mayfair Conference Centre, London, on the 19th and 20th October. OCC’s Reynold Greenlaw is one of the speakers at a panel discussion on the 2nd day: “Strategies and predictive applications to minimise CAPEX and OPEX”. Kaz Librowski, Technical Director,  and Reynold Greenlaw, Account manager  are look forward to meeting other attendees  from Utilities, National Grid  and CapGemini, and explaining about the software OCC have developed for managing the assets for[...]

  • Offline web apps with HTML5

    Luke Canvin Blog Post

    One of our primary goals for Dev Camp was to create a web application that works perfectly offline, especially on laptops and tablets, which are more likely to be used in a situation without internet access. To support this, we turned to the HTML5 Offline Web applications specification, which should enable us to store a copy of the application in a modern web browser’s application cache, allowing it to be accessed correctly whether the browser is online or offline. One[...]

  • Handling JavaScript touch events in HTML5 Canvas

    Luke Canvin Blog Post

    Right from the start, we wanted to make our application as usable on a tablet as it was on a laptop or desktop computer, which means offering top-notch support for touch as well as mouse-clicks. The only area where this presented a challenge was in allowing a user to use touch to drag and drop in our HTML5 Canvas controls. It was clear how to do this with mouse-clicks; you would bind your mousedown, mousemove and mouseup events to the[...]