Award winning IT Support, Solutions and Systems Development
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”:”nathan@none.com”, “firstName”:”nathan”, “lastName”:”poole”, “jobTitleName”:”Developer”, “userId”:”npoole” } In SQL you must declare JSON as NVARCHAR(MAX) and select using “OPENJSON”…
DetailsPower 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…
DetailsAs 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…
DetailsMicrosoft 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.…
DetailsWe 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.
DetailsFusion has launched an online electronic signatures solution.
DetailsFor many of us we are now into week 7 of working from home and how is it going for you?
DetailsThe coronavirus is unfortunately creating an environment for fraudsters to thrive using a range of tactics including coronavirus-themed phishing emails.
Details
