Login

User Email Password Remember Me

Create Account

Title Forename Surname Account Type User Email Password Remember Me

A consultant with 20 years of working in the IT industry, and a unique knowledge of web, database and cloud services that can move your business to the next level

About Claytabase

Claytabase are an Isle of Wight based Web, Database and Graphic Design agency, find out more about us.

Articles on creating a meaningful web presence

A selection of articles that should provide some insight into helping you maintain a meaningful web presence, and don't fall into one of the main areas.

Building Ousia Content Management System

We spent a lot of time thinking about how to make Ousia Content Management System one of the quickest around. Here we explain some of the concepts put into place.

Computer Scam Calls

What to do with the computer scam phone callers - nothing!

Hot Chilli Internet Closure

Hot Chilli Internet closure affects unknown number of sites. What you can do if you are affected.

Many people in business are unsure what exactly to say in their marketing materials.

They may feel they want something new, aiming to improve the business... But what sort of help do you really need to make sure you end up with cost-effective marketing materials? There are two types of professional writing in this area: journalism to report current events, or copy-writing to create a new future that you want to come true: “a salesperson in print”...

Skimmers of the gig economy

The most annoying things about websites on the Internet

A tongue-in-cheek look at the prevalence of lists and general annoyances that we are subjected to on a daily basis.

Team

Chester Copperpot

I'm the dog with the blog, who loves exploring the Isle of Wight and beyond. As I grow up, my exploring will show some of the best local places to go for walks and drinks with your pooch!

2017-10-21 My First Day

My first day with my new family

2017-10-22 Settling in

Settling in to my new surroundings

2017-10-29 My First Week

My first week in Ryde

2017-11-05 First trip to Sandown

2017-12-01 Ticket To Ryde

Portsmouth

I went for my first wonder around Southsea and Old Portsmouth.

The Duver and Seaview

We went for a wonder around the Duver and Seaview

Binstead and Quarr

A walk from Ryde to Fishbourne through Binstead and Quarr

Gavin Clayton

Claytabase Team, About Gavin Clayton

Microsoft Azure

Microsoft Office Management

Office 365 Management and Delegated Admin

Administration Articles

Requesting SSL and Generation of PFX file in OpenSSL Simple Steps

Requesting SSL License and Generation of PFX file in OpenSSL in a few Simple Steps

Task Scheduler Error 2147943645

Task Scheduler Error Number 2147943645, is reported when user is not logged in, but has a task set up to run under their user name.

Database consultancy services in SQL Server, Oracle and the Cloud

Claytabase provide a range of services across various database platforms, and have worked in a number of challenging warehousing, migration and upgrade projects

Database Articles

Over the years we have encountered and solved a number of database related problems. You can browse some of them here and hopefully they may help you to optimise your databases or ETL processes

Get Open Query

This Table and set of Stored Procedures will enable you to automate the transfer of data from Oracle and Progress databases into SQL Server.

Get Open Query Linked Server Table Column Names

This set of Stored Procedures will enable you to view the available columns in a table for Oracle and Progress databases linked to SQL Server.

Get Open Query Linked Server Tables

This set of Stored Procedures will enable you to view the available tables for Oracle and Progress databases linked to SQL Server.