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”…
Details
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…
Details
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 –…
Details
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.…
Details
How are you staying in touch?
If you’re missing your colleagues like us, you’re not alone.
Home working is here to stay
We are now entering week 11 of our new normal and it appears that many of us will be looking at continuing our working from home (WFH) practices for the foreseeable future.
Fusion launch electronic signatures solution
Fusion has launched an online electronic signatures solution.
Tips for working from home
For many of us we are now into week 7 of working from home and how is it going for you?