Microsoft, Think DevOps First

  • Comments posted to this topic are about the item Microsoft, Think DevOps First

  • I could not agree more. People get caught up in what functionality a tool offers but it’s the nonfunctional aspects that can make or break the overall value it can bring to my customers. Thinking about the developer experience and how the produced software fits into my CI/CD pipelines is on the short list of where I start evaluations with vendor tools.

    SSIS is a great example of a very functional tool with an unfortunate output format. Mouse-driven development tools in general do poorly in this area, SSIS and PowerBI included. I mostly give visualization tools like PowerBI a pass on this point because parallel and concurrent development is less of an emphasis (at least in my experience) however data integration tools like SSIS, while Microsoft did a nice job with the ispac concept to support builds and deploys, have posed significant challenges for my teams with the limitations around merging dtsx files. The lack of merge capabilities affected design decisions at times just so we could enable concurrent development and that got frustrating at times.

    After a good 5 year run going deep with SSIS solutions I haven’t touched SSIS in three years and shifted back towards code-based solutions. Getting back to C# has been like meeting up with an old friend and I am also exploring Spark. Code-based solutions have attributes some may view as disadvantages but the CI/CD limitations do not exist and that’s become tool-adoption criteria for me over the last few years.

    There are no special teachers of virtue, because virtue is taught by the whole community.

  • Completely agree with both Steve and Orlando.

    Same experience with SSIS as Orlando.  The fact that both PowerBI and SSIS can not be meaningfully and efficiently version controlled is a major hindrance to adoption.  In the case of SSIS, this fact alone doomed it in several of my projects, and its train has left the station IMO.

    I'm worried that PowerBI can be travelling down that same trajectory eventually.   Microsoft better recognize that, and make an effort to change the representation of a report to some text based solution.  If they do so, it is crucial to separate positioning of elements on the report from the rest of the visual layout (color, sizing, etc.), and especially any embedded logic/DAX expression.  Having it all cramped into a single XML file in the case of SSIS was specifically what made source controlling meaningless.



  • +1 on SSIS, exactly. Some parts of our office do still use it but for our dev operations it's kind of dead.

  • This is not a lost idea in the "Power BI Ideas" forum. We are trying, vote here!

  • Voted and commented.

  • This was removed by the editor as SPAM

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply