SQL Server Agent is not available in Azure SQL DB. So how do we manage tasks for which we currently use SQL Server Agent? During last week's free webinar, our Senior Business Intelligence Consultant Bob Rubocki explained why the absence of SQL Server Agent may not be the end of the world when working with Azure SQL DB. He also discussed Azure Automation as an alternative for some tasks previously managed with SQL Server Agent.
A feature of Azure SQL Data Warehouse is the ability to scale (and pay for) compute resources as needed. This is particularly useful when loading data to a data warehouse. ETL operations typically put heavy load on the data warehouse, and could benefit from increased computing power. When the load process completes, however, that extra power may no longer be necessary.