We use the product to extract data and present it for warehouse reporting.
The platform provides valuable scalability, stability, and robustness benefits.
The product's pricing needs improvement.
We have been using SQL Azure for 3 years.
I rate the platform's stability an 8 out of 10.
I rate the platform's scalability as 10 out of 10.
The initial setup can be straightforward if you properly configure the product and utilize scripts effectively. Once the script is ready for cloud deployment, executing it is next. The solutions architect sets up the basic infrastructure using infrastructure as code principles. It involves carefully selecting resources, such as VMs and app services, and configuring them according to your requirements. Additionally, one needs to manage security aspects like opening and closing firewalls, which can introduce complexities to the setup process.
I recommend considering a pay-as-you-go pricing model initially.
The automated scalability feature of SQL Azure has proven to be highly beneficial, particularly when deployed in the cloud. It can be done remotely, eliminating the need for manual intervention. However, it may become more challenging if the infrastructure reaches its limits, especially in vertical scaling scenarios.
Whether opting for AWS or Azure, the service offers guaranteed uptime, often around 99.9%. Additionally, it supports deployment across multiple zones and regions.
The transition from on-premises to SQL Azure can impact operational costs depending on the setup. It offers options like pay-as-you-use or dedicated services running 24/7. However, it's essential to evaluate your business case thoroughly before deciding.
I rate it an 8 out of 10.