Azure SQL Database

What do you like best?

The feature I like more about SQL servers is JSON parsing to parse complex data. you can easily parse complex level attributes with a simple select query.

easy to scale based on the load to consider the basic feature of cloud provider Pay-as-you-Go.

full support of collation and integration with Azure AD helps to provide hand-in-hand security measures. Transparent data encryption helps to secure data over the network.

Self-performance tuning advises end-user to add an index to provide better query performance.

SQL pool enables the database to share compute power helps us critical application functionality more smoothly.

easy option to provide access to on-prem users helps application developers to keep more focus on development rather than infrastructure.

What do you dislike?

not support of SSIS, which typically blocks more of the traditional developer to proceed with ease of re-using existing SSIS packages.

polybase support is not with Azure SQL, we can't leverage to use massive data that resides on a Storage account.

rest of all features are aligning and make developer's life easy.

What problems are you solving with the product? What benefits have you realized?

reducing Deployment time for customer on-boarding.

Elasticity in terms of space management, as per the customer demands and CPU utilization whenever there is a load on the database.

easy to automate database backup and recovery for critical databases.