I may be misunderstanding what you are doing here, but can you not build a single query from the source system that has all of these attributes/fields in the output...

There is a great deal of benefits from an operational and optimization standpoint for sure. I went to a tech conference last month where someone gave a presentation on their...

I handle it by placing a place holder so the business knows it's late and incomplete. Then separate it so it can be processed separately. As the data in the...

You could likely make an argument that the machine learning piece is bundled in the SSAS product as "Data Mining".

I played lead guitar in a band for 5 years prior to working in data myself.

That works too. Not to distort the issue as being tied specifically to stored procs. That's actually semantics. But, it's often communicated as stored procs being the issue because everyone...

I didn't know him personally, but I do follow him on Twitter and have interacted with him many times. I'm sadden by the news. My condolences to his family and...

I would say it's morphing rather than dying. Operational wise, the DBA is not becoming a needed position due to the fact of automation. With the rise of "the cloud",...

This is just me I suppose, but I do use data stores to store data first before transforming it. This is not any different than downloading it to disk and...

What keeps me from using it? Linux and Python.

I use a lot of Python for my ETL as opposed to SSIS in Azure. Even before I moved to...