Now that the Azure SQL Database is more compatible with the latest on-premises version of SQL Server, it's easier for Microsoft to offer more traditional database workloads as services. The latest is setting up a data warehouse, which is already a good match for a cloud service because of the number of servers and amount of storage involved.

You can already set up a data warehouse on Azure using IaaS, and Microsoft even provides PowerShell scripts to simplify the setup. However, there are still plenty of steps you have to go through, including configuring storage pools and filegroups, and the assumption is that you'll already have done the ...

Upgrade now to get the whole story

Start your free trial