We’re walking for Laura
During #SpectacularSeptember The Laura Crane Youth Cancer Trust are asking people to support them in a virtual Great North Run for the charity on the 13 September 2020.
I started my career as most people do – at the bottom. After leaving college I went straight into an IT position at a Huddersfield based Chartered Accountants. It wasn’t long before they expanded overseas, giving me the perfect opportunity to develop my career. Whilst there, I also completed a computing qualification at the University of Leeds and polished my skills in Microsoft, Cisco, Lotus, Checkpoint, Citrix, A+ and Novell.
What are you drinking for charity Jamie?
So it’s week one of Jamie Watson’s ‘I’m a Director…Get me out of here!’ challenge for the Forget Me Not Children’s Hospice.
He’s a director, get him out of there…
Are you brave enough to take on bushtucker trials? Our very own Managing Director is! Jamie Watson is taking on the ‘I’m a Director…. Get me out of here!’ challenge for the Forget Me Not Children’s Hospice throughout August.
Staying alert online during Covid-19
Covid-19 has made businesses reliant on their online networks and remote-working capabilities for the last few months and will continue to do so as our ‘new normal’ evolves.
Electronic signatures in conveyancing
The Land Registry has announced that it is bringing forward proposals to accept electronic signatures.
Covid times call for Covid measures
Anyone notice the WWE star at our latest staff quiz?
Parse JSON Data with OPENJSON in SQL Server
Recently I came across a problem where I had to parse JSON in SQL and retrieve data in a table format. Parsing Simple JSON in SQL Let us take the following JSON as an example: { “employeeCode”:”E1″, “emailAddress”:”[email protected]”, “firstName”:”nathan”, “lastName”:”poole”, “jobTitleName”:”Developer”, “userId”:”npoole” } In SQL you must declare JSON as NVARCHAR(MAX) and select using “OPENJSON”…
Restoring Power BI Server Files
Power BI doesnt really have any version control, I recently overwrote a report with a version that was incorrect. After some research I realiased the only way would be to restore the SQL sever, but instead of restoring the whole database I realised that all the data was effectivly in 3 fields in the CatalogItemExtendedContent…
Working hours between two datetime TSQL
As part of working out SLA’s by using the working hours between two dates we struggled to find a working solution, one of our developers built a nice function that does just that; SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION [dbo].udctGetWorkingMins(@from DATETIME, @to DATETIME,@daystartmins INT NULL,@dayendmins INT=NULL) RETURNS INT AS BEGIN –…
Office 365 Business is getting a new name
Microsoft have just announced new product names for the Office 365 Business plans, which will be coming into effect 21st April 2020. Office 365 is split into three main categories: Personal, Business and Enterprise. Microsoft have just announced important name changes to the Office 365 Business subscriptions to bring them into the Microsoft 365 family.…