Tag Archives: Architecture

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

BIModal IT: Unheeded Silver Bullet?

Gartner gives the next definition for it’s new Bimodal approach: The essence of an enterprise bimodal capability is marrying more predictable evolution of products and technologies (Mode 1) with the new and innovative (Mode 2): Mode 1 is optimized for … Continue reading

Posted in Business Capability, Business Delivery | Tagged , , | Leave a comment

Governed Data Discovery vs BI

Governed Data Discovery vs BI: Is there the best strategy? Governed Data Discovery is one of the trending buzzword since 2014. The term made its debut in Gartner’s 2014 Magic Quadrant Report. Gartner first popularized the term data discovery and … Continue reading

Posted in Big Data, Business Capability, Business Delivery, Data to Knowledge | Tagged , , , , , , | Leave a comment

Smart Data – Extracting Quality From Quantity

Amit Sheth defined “Smart Data” as “realising productivity, efficiency, and effectiveness gains by using semantics to transform raw data into Smart Data.” Clarifying “Smart Data” concept can be understood as automation of the process represented by the arrow linking “Information” and … Continue reading

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

From SQL to NoSQL to NewSQL

History of RDBMS Every time new technology emerged it’s evolution ended up in realisation as relational system (RDBMS). In other words, the business before adopting the stuff always demanded atomicity, consistency, isolation, and durability (ACID).

Posted in Big Data, Business Capability, Business Delivery, R&D, Uncategorized | Tagged , , , , , , , , | 1 Comment

SQL or NoSQL: that is the question.

Relational database management system (RDBMS) have been a primary data storage mechanism for decades. NoSQL databases have existed since the 1960s, but have been recently gaining traction and the business faces a challenge of their efficient adoption. There are many tutorials … Continue reading

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