Microsoft's Azure SQL Warehouse Innovates with Elastic Pooling
Azure SQL Data Lake & PoolingManaging both structured and unstructured data across the enterprise is a challenge. Leveraging 100s even 1000s of databases generally requires maintaining many resources to support dynamic front-end technologies. Software as a Service (SaaS) developers in particular are tasked with creating a unified user experience from many databases while maintaining performance. Until Microsoft’s recent announcement of Azure SQL elastic pools as part of the new SQL Data Warehouse, maintaining many databases was inefficient and cumbersome. Now, isolated databases can be maintained with one resource layer to run and administer the databases making for more efficient database builds.
Another big advantage of the new Data Warehouse is the ability to grow and shrink elastic database pools within seconds, a major innovation considering elasticity on Redshift can take hours to days to resize. Azure SQL Warehouse is the first elastic database platform that provides dynamic elasticity.
Many SaaS systems must overprovision databases to accommodate peak demand on resources. Now, by deploying an elastic pool functionality within Azure SQL, unused database space can be utilized by other databases that are experiencing heavy demand. Elastic pool is part of the “Azure Data Lake” offering released at Microsoft’s Build 2015 Developer Conference held in San Francisco. Azure Data Lake is designed for organizations storing vast amounts of data and can be processed using Hadoop and other big data analysis platforms.
Another advantage of Azure database pooling vs. a service like Amazon’s Redshift is true SQL support. Converting data files to Redshift adds another layer to the data migration process and simply takes more time.