Kigtek Solutions
We are very happy to be working with Kigtek Solutions, a leading Systems Integrator and Electrical Installation Services company based in the central belt of Scotland
Blog
ISBN13 to ISBN10 Converter for SQL Server
ISBN13 -> ISBN10 Here’s a handy function for converting a 13-digit ISBN to its 10-digit equivalent in SQL Server T-SQL. CREATE FUNCTION TO_ISBN10 ( @isbn varchar(13) ) RETURNS VARCHAR(10) AS BEGIN DECLARE @isbn10 varchar(10); DECLARE @forwards int; DECLARE @backwards int; DECLARE @check int; DECLARE @thisval int; SET @isbn10 =substring(@isbn,4,9); SET @forwards = 1; SET @backwards […]
Listing Outlook mailbox rules for all users
Use this PowerShell script to list all the server-side mailbox rules for Outlook users in an organisation.
Oracle Function-based Index
We give an example to show how a function-based index in Oracle can increase the speed of a query where null and not null values are being compared.
Photos from the London Book Fair
Maria visited the London Book Fair on Tuesday this week. Buzzing with activity and enthusiasm, it’s great to see our thriving book industry in action. Lots of familiar faces too, and chocolate frogs!
Backups affecting system performance – our LVM2 solution
Our customer’s database backup was locking the data for over an hour each night. We reduced this to a small number of seconds.
LBF14 – London Book Fair 2014
Maria will be visiting the London Book Fair on Tuesday 8th April. If you would like to meet up for a chat, please get in touch.
User Testing with Real Users – the Icing on the Cake
The importance of testing new software with real users who are going to be using the system. Users like Chris.