OCC database expert Julian Fletcher describes how SQL’s ForceSeek can be used to combat database deadlocking and blocking. One particular way of using tables in a SQL database can make them particularly prone to deadlocking (and deadlocking’s sickly cousin, blocking). This is where ‘working data’, generated by and used in a complex set of calculations, is temporarily stored in one or more tables. Whereas any one process will probably access only a very small percentage of the rows in a[...]

The most successful apps and products generally have something in common: as well as meeting a need, they are a pleasure to use. They provide the features a user wants in a clear and intuitive way, and create a satisfying journey that anticipates and focuses on user needs at every step. So how do you get it right? How can you be sure that the interface presenting your innovation to the marketplace is providing great usability?

Software consultant Matthew Clarke shares his experience of moving to version 2.5 of Xamarin.Forms. Despite only being a minor version bump over Xamarin.Forms 2.4, version 2.5 has made some rather radical breaking changes. These are currently only “Obsolete” warnings but I’d advise you to act now before they become build failures. The most disruptive of deprecations affect Android but they touch all parts of your code. The chances are they’ll affect you, as they touch some fundamental areas of Xamarin.Forms.[...]

The TAB is OCC’s Technical Advisory Board, made up of representatives from OCC’s project and product groups. The TAB’s role includes reviewing technology developments and their impact on the company’s software development. Articulate.js Articulate.js is a simple, free (MIT license) jQuery plugin that uses the Web Speech API to speak the content of a web page. This could be useful in a broad range of circumstances, but particularly as an assistive technology for those that have problems reading text on[...]

The TAB is OCC’s Technical Advisory Board, made up of representatives from OCC’s project and product groups. The TAB’s role includes reviewing technology developments and their impact on the company’s software development. Xamarin & .NET Standard (Core) .NET Standard is now supported by Xamarin. The .Net Standard is the specification of which .NET APIs are available on all .NET runtimes – including the full framework, Core and now Xamarin. The upshot is that if you use a library or assembly[...]

My name is Florence. I am an A-Level student from Oxford, studying English, Philosophy and Psychology, but I also have an interest in art and design. I spent the last week at OCC, doing work experience with the design team. I’m still unsure about the career path I will take, but this week has been beneficial in helping me learn about design. With the help of the team, I worked on multiple projects, starting with making a banner for the[...]

The TAB is OCC’s Technical Advisory Board, made up of representatives from OCC’s project and product groups. The TAB’s role includes reviewing technology developments and their impact on the company’s software development. Test your production code Things can go wrong between debug and release builds: conditional compilation linking incorrect project configuration/build dependencies This means we need to test the production build. However, this is not always as simple as it sounds. Apple makes it almost impossible to test release builds[...]

The Government Digital Service (GDS) has begun to work with local government teams on transforming their online services to use some of the new technology developed by GDS for central government. So far, there have been 2 pilot projects across about 15 councils, focusing on parking permit and older person’s concessionary bus pass services. The aim has been to redevelop these services end-to-end using GDS expertise and the new GOV.UK Verify service. The interesting thing is that GDS has documented[...]

The TAB is OCC’s Technical Advisory Board, made up of representatives from OCC’s project and product groups. The TAB’s role includes reviewing technology developments and their impact on the company’s software development. Security in the news Data breaches are on the rise and the media is increasingly publishing news stories on the subject. Some of the breaches happened years ago and are only just coming to light. For example, Yahoo had two hacks three years ago that have only recently[...]

Volunteer-led organisation codebar runs regular, free coding workshops that aim to diversify the tech industry. Local developers volunteer as coaches, and women, minority ethnic groups and members of the LGBT+ community come along to learn whatever takes their tech fancy. Workshops run monthly in Oxford, and on 26th September, Oxford Computer Consultants hosted one at our new St Aldates offices. Attendees mingled over food, then the event kicked off with a welcome presentation, followed by a lightning talk from Reynold,[...]

OCC has donated 8 computers to Oxford’s Rose Hill Community Centre. The computers are being used in the Community Centre’s new beginners’ ICT courses, in a joint project between the Centre and City of Oxford College, with Rose Hill Community Association donating equipment as well as OCC. OCC Project Manager Lois Muddiman said, “We are delighted to be supporting community education by donating these computers. We hope they will be used widely by many different groups.” To find out more,[...]

Hi, I’m Isabel. I’ve always wanted to get into coding and hoped to start at Codebar, Oxford, but was too young. However, through my contact with Codebar I met one of the organisers, Beverley Newing, who’s part of the front-end development team at OCC. Beverley was really helpful and after lots of emails, involving her sending me a lot of resources, and me thanking her a lot, she kindly offered me work experience at OCC. Day 1 I was introduced[...]

The OCC Innovation Delivery teams – Fusion, Trilobites, Puffin and the OCC UX Design Studio – hold regular Technical Chapter meetings to help advance cross-team knowledge sharing. The meetings cover a wide range of topics, usually around technologies used in on-going project work, but also on tools and techniques that benefit the development process. Docker Compose [Fusion]​​ Compose is a tool for defining and running multi-container Docker applications. Operando has lots of modules, each one being a Docker container and[...]

OCC Innovation Delivery hold fortnightly Technical Chapter meetings to help advance cross-team knowledge sharing. The meetings cover a wide range of topics, usually around technologies used in on-going project work, but also on tools and techniques that benefit the development process. IIS ​ARR (Application Request Routing)​​ Greg told us about his experience with ARR. This IIS component is required when you want to forward requests to another machine on a port that isn’t port 80. One of the settings is[...]