When cubes came out column store technology was no where near where it is now and wasn't available in SQL Server.

Dimensional modelling and Data Vault 2.0 modelling remain relevant...

Exactly!!!

Cubes are a legacy technology.  I would also consider SSRS to be somewhat legacy.  If dealing with a greenfield situation, I would go Azure.  And ironically, In-Memory OLTP can help...

Okay, that makes sense.

If you are trying to build a data warehouse "from scratch" (also known as "greenfield"), I would definitely do cloud first.  Also, I would start small, perhaps...

Are you creating a data LAKE or a data WAREHOUSE?  They are two vastly different things.

Considering that:

1. Microsoft has been touting the SSAS tabular model over the multidimensional model
2. There haven't been any real upgrades to the multidimensional model in quite some time
3. Azure Analysis...

I read the article.  Does this also work for Azure Analysis Services?  Also, what if the PBX is hosted on PowerBI.com?

I meant the model, not the data.

I want to import a Power BI PBIX file into Azure Analysis Services. I don't see any recent information on how to do that. Is it possible? If so, how?

All I know is our firm begged, pleaded and debated with the client over this issue for weeks before asking me.  I do not know the technical reason why, it...

The client does have this odd requirement to use package, not project deployment.

Also, the client does NOT allow environment variables.  Strange, I know...

The dev environment is the developer's local machine. ...

So, what automated tests should QA have for SQL?

This is good information.  Thank you very much!

In 20 years of using SQL Server, I've never dealt with a QA team just for T-SQL code.  What exactly should that team be testing and how?

And I don't think...

Thank you all.

Thank you all for your responses. Now that I've reviewed, I think I need to add more information.

1. The SQL developers build their code. These are usually, but...