Tag Archives: Microsoft

Compatibility issue in SSIS

Just discovered a difference in the way SSIS parent-child package variable values interact in the newest version of SSIS. This can seriously impact SSIS-projects’ upgrade. If packages exchange information not using parameter binding but using configuration mechanism then upgraded project … Continue reading

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

5 questions for time limited interview for BI developer position that touch almost all areas related to modern Microsoft BI

1. For example it’s necessary to allow user to input worker’s salary but ensure that it’s in range related to the worker’s category. Ranges for categories are stored in a separate table. Data inserted by using T-SQL. Where is the … Continue reading

Posted in Business Capability, Data to Knowledge, programming, Uncategorized | Tagged , , , , , , | Leave a comment

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