KB & Posts

Z-Score Trace 3 Month Gap

Welcome 2018! New focus on Analytics

Goodbye 2017! 2017 was a busy year running BI projects and big (messy) data, and it’s consolidated a better focus going forward – on data analytics rather than just systems. After all, nobody simply needs a database system anymore – we need solutions and business improvements. Although they need to be built on sound and Read More

SSAS 2014 No Tabular Instance Installable

SSAS Tabular available in SQL Server Standard Edition?

There’s a lot of confusion on the web with people asking if or why they can’t install SSAS (SQL Server Analysis Services) Tabular data model on their server, thinking you can’t install both Multidimensional (SSAS MD) and Tabular on the same server etc. Especially as only MD is offered by default on new installations and already Read More

SharePoint Online 250x150

SharePoint Online – overlooked but very handy

SharePoint was pretty clunky in the noughties, but now it’s racing ahead and the premier Document Management System integrated with Office – about time too. Critically, Microsoft are pushing it out via Office 365 as SharePoint Online so they’re really eating their own dogfood – and that has influenced the hybrid-friendly version of SP2016, so Read More

Background from  british pound banknotes in perspective view

Microsoft Licence Sales

Licence sales are not a big part of our business anymore (we focus on database and BI system design and implementation), as you can often get them cheaper from retailers via the EU, and Microsoft don’t think that’s a problem worth bothering about – although customers miss out on experienced system solution providers like us, Read More

Where’s that Darned Licence Server?

So you added the Role for Licencing Server (on same or preferably another more dedicated server) and even the additional Remote Desktop Session Host role on the one users are accessing. But they still get that pesky “You have 119 days” message. Embarrasing. Where on earth do you tell this server where to contact the Read More

Big Microsoft Price Increases in Jan 2017

You may have heard Microsoft are raising prices to “rebalance” the US to UK/EU exchange rate (especially after Brexit impact), ie putting our prices up! They did similar to the Swiss Franc and Norwegian Krone in April this year. We have now had confirmation from our distribution network together with further details: The increases will apply Read More

Windows Server 2016 out now!

Windows Server 2016 is finally released to the public after development testing releases – is it worth it? Well, the big shock was that Microsoft moved it to Core based licencing, rather than the previous CPU based. So more like SQL Server – and we know how expensive that can get if unfettered! So plenty Read More

OneDrive For Business / Personal – Confusion & Fit For Purpose?

Previously, OneDrive and OneDrive For Business (ODFB) were hardly worth wasting time on, unless you had the patience of a saint and didn’t mind performing basic QA and bug-verification for Microsoft. Now, they have moved on… at last! XXX It obviously took a lot to catch up with DropBox et al, even though the method of Read More

SharePoint 2016 – On-Prem is not dead!

Contrary to rumour, on-premises SharePoint is not disappearing just because Microsoft want to bring in new functionality on Office 365 Sharepoint first. In fact, on-prem will always be the way forward for businesses who want to keep control of their data and keep it backed up properly. We still haven’t heard of a replacement for Read More

Open Value – Surprisingly good for spread payments

There are 2 things which hit us hard with perpertual ownership licencing: Big upfront cost; Stuck to Version, eg 2013/2014, (no upgrade to 2016) especially these days of quicker releases. This is especially true with SQL, SharePoint and Windows Server – these systems need to keep up with a more connected landscape. Frankly, it’s rare for customers to Read More