Azure has many built-in features that you can use by creating an Azure SQL data warehouse.
- Ability to improve performance and globalize.
- A low-cost solution with the ability to expand and calculate storage. You can pause or resume the database in minutes.
- Use massive parallelism behind the architecture. This allows you to run up to 128 simultaneous requests at a time and improves performance over traditional on-premises SQL Server.
- Seamlessly create analytical tasks and hubs in addition to native connectivity with data integration and visualization services.
- Guarantees 99.9% uptime and built-in regulatory compliance. So, the DBA does not have to take care of all that, it takes care of everything.
- Integrated advanced security such as connection security, authentication, authorization and encryption.
- Data sovereignty in more than 30 regions of the world.
- Adapt to the workload. If your workload is large, you can take advantage of the power of the cloud, but you can control the cost by reducing the cloud for smaller workloads. You can also reduce costs by suspending or stopping workloads when you are not using them.
- Built-in Smart Cache speeds up data access and query performance.
There are also new hardware innovations and new software breakthroughs that can be found on the Microsoft site. With all these technologies, you can benefit from streamlined and fast services and cost management capabilities.
What are the advantages to using SQL Azure, as opposed to setting up your own SQL Server instance? Here are some of the most crucial, especially for those who are already running SQL Server on their own premises.
No Physical Administration
No physical administration. For people who are sick and tired of dealing with the hassle of setting up SQL Server, apportioning databases and mucking about with physical machines in general, having your database hosted in such a way where all of that becomes someone else’s job is a big plus. This is doubly so if you’re starting fresh and don’t have an existing store of data to pipe up into the cloud somewhere.
High availability out of the box. Azure generally obviates the need for building high availability architectures. This applies to SQL Azure as well; any databases built within it are automatically highly available.
Scalable service plans for multiple needs and budgets. The industrial-strength features of SQL Azure may seem like overkill to folks with relatively modest needs, but Microsoft has taken steps to make SQL Azure appealing to both big and small business users.
A much-abused buzzword, but in SQL Azure’s case, it applies. Applications written for multiple databases (via sharding, for example) can be scaled out with Azure by adding instances as needed. That said, the best benefits of SQL Azure don’t just consist of being able to spin nodes up or down on demand. Microsoft also provides an infrastructure of federations to make scaling out easier and less impactful, as well as tools like the SQL Azure Federation Data Migration Wizard to further