Tag Archives: Microsoft

Problem unsolvable for Data Lake Analytics

One of the tasks of Database Forensics is to detect events (or categories of events) that began too frequent. From programming perspective, this means that for each date there should be searches categories appearing more than certain number of times … Continue reading

Posted in Big Data, Business Capability, R&D, Uncategorized | Tagged , , , , , , | Leave a comment

Lake and Blob – how far from each other?

Two competing cloud storage products by Microsoft are defined the next way: Azure Blob Storage is a general purpose, scalable object store that is designed for a wide variety of storage scenarios. Azure Data Lake Store is a hyper-scale repository that … Continue reading

Posted in Big Data, Business Capability, R&D | Tagged , , , , | Leave a comment

Data Lake Store vs Blob Storage

Why might company consider using Azure Data Lake Store over Azure Blob Storage? There are several options for data storage in Azure, each with a specific goal. In particular Data Lake Store is design specifically for Azure Data Lake Analytics. While Blob Storage can … Continue reading

Posted in Big Data, Business Capability, R&D | Tagged , , , , , , | Leave a comment

SHARK on SPARK – business capability increment or just another ICT extension?

The media provides generous buzz in regards to every particular emerging technology. No surprise the promising technology Spark contributes a lot to this stream. However it’s not always easy to separate out technical features descriptions and get pure understanding of how the technology can contribute … Continue reading

Posted in Big Data, Business Capability, Data to Knowledge, R&D | Tagged , , , , , , , , , , , , , | Leave a comment

Big Data ad-hoc querying with Power BI?

It has been a long time since Coudera introduced Impala as an alternative to slow MapReduce-based Hive. And has positioned new product as ad-hoc querying supporting tool (I recall Mr Isotov expressed interest in this – now I can state that only … Continue reading

Posted in Big Data, Data to Knowledge, R&D | Tagged , , , , , , , , , | Leave a comment

R capability in SQL Server 2016

After the recent news that SQL Server 2016 will support R and old news that Microsoft acquired RevolutionR I was interested if SQL Server is planned to use parallel computing (map-reduce based realisation R) or existing open-source version. Attending seninars … Continue reading

Posted in Data to Knowledge | Tagged , , , , , , | Leave a comment

Hidden functionality of LOOKUPVALUE function

Despite described was not noticed a useful trick in functionality of the LOOKUPVALUE function – in contrast to LOOKUP in SSRS (and in probably many other systems) it returns a distinct selection of found values if there is only one value. From … Continue reading

Posted in programming | Tagged , , , , | Leave a comment