i got that info from here years ago: https://cathydumas.com/2012/04/23/changing-an-analysis-services-instance-to-tabular-mode/

regarding the "is ETL dead?" question:

every time a new shiny dev toy comes out, the silo'd tunnel vision ADD kiddiez are always quick to scream "zomg everything else is obsolete...

Cool - I hadn't considered source control for report builder content.

nice informercial.

Is this process numerically stable?

I've always used expresso http://www.ultrapico.com/Expresso.htm - makes code for a bunch of...

I wasn't familiar with this before - thanks! In general, it sounds like a linked server server. 🙂

Questions:

1) Did you really say you cannot use sql service accounts with CMS?

2)...

It'll go the route every other new shiny thing in tech goes, I would imagine:

1) There'll be a proliferation of home-rolled cobbled together codes to perform big data gathering, storage,...

Oh. I didn't realize people did anything...

I use ssrs for reports that are consumed by web pages.

The bulk of my users use access (ugh) to create their own stuff. As a replacement, I'll be nudging...

When I require live data, I almost always join against OPENQUERY resultsets - much, much, MUCH faster than directly joining to the remote server.

Or else an SSIS job.

-sff

Oh welp there you go then! 🙂

Now back to figuring out how to get the right passwords in my deployed ssis package's connection managers. #@$@#%@

Friend of mine told me to order my joins so that the greatest expected number of rows are eliminated soonest. Unfortunately, I've never been clear on just how to do...

I can't recall the last time I used isnull. I always use coalesce specifically to avoid data type result issues.

I like this thread because it furnishes a nice object lesson in why you don't go reinventing wheels.