Tag Archives: Development

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

Restoring objects in SQL Server

This is a code googled in panic after occasional deletion of a stored procedure. Does real magic saving hours of work that could be spent on re-writing:  

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

Querying Tabular model XML/A with XPath

There can be various reasons to extract metadata from Tabular model, for example to compose documentation or logical model diagram. The next collections are useful from architectural point of view: list of dimensions, list of measure groups and measures, list … Continue reading

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

Concatenating Row Values in Transact-SQL

A useful trick for logging subsystem based on T-SQL: Found here among a number of similar solutions realised various ways.

Posted in programming | Tagged , | Leave a comment

Information Asymmetry In IT Projects

A pretty good article about information asymmetry in IT Projects and way of it’s reduction by Polish researcher Bartosz Wachnik (Linkedin): Information Asymmetry In IT Projects (pdf) On the basis of his conclusions, the author has designed the following recommendations … Continue reading

Posted in Business Capability, Business Delivery, Uncategorized | 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