Within our organization, there are roughly 15 people using this solution.
A customizable platform for creating various dashboards
Pros and Cons
- "It's a great solution. It's so customizable. Every user can create dashboards to suit their needs. We can create and share them with our teammates easily, too."
- "Due to the pandemic, I haven't been able to utilize their full resources. This has made it complicated to scale up. I hope this will be resolved after the pandemic."
What is our primary use case?
What is most valuable?
It's a great solution. It's so customizable. Every user can create dashboards to suit their needs. We can create and share them with our teammates easily, too.
Microsoft Azure is also very user-friendly.
What needs improvement?
I honestly can't think of anything that needs to be improved.
For how long have I used the solution?
I have been using this solution for five years.
Buyer's Guide
Microsoft Azure
December 2024
Learn what your peers think about Microsoft Azure. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.
What do I think about the scalability of the solution?
Microsoft Azure is both scalable and stable.
How are customer service and support?
The technical support is very responsive.
Which solution did I use previously and why did I switch?
I evaluated Amazon and Google Cloud.
How was the initial setup?
The initial setup was quite straightforward. Deployment depends on your requirements. Typically, I can deploy it within a weeks time.
What's my experience with pricing, setup cost, and licensing?
There are monthly and yearly payment plans. We save more in the long run with the yearly option.
What other advice do I have?
I would absolutely recommend this solution to other users.
Microsoft Azure has all of the latest cloud services with all high availability and scalability. It's also very secure. The cost is more or less the same across all cloud service providers, too.
Overall, on a scale from one to ten, I would give this solution a rating of nine.
Due to the pandemic, I haven't been able to utilize their full resources.This has made it complicated to scale up. I hope this will be resolved after the pandemic.
Which deployment model are you using for this solution?
Hybrid Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Architect/ Project Manager at a computer software company with 1,001-5,000 employees
Provides very good security, scalability, and elasticity
Pros and Cons
- "Good security, scalability, and elasticity."
- "Technical support could be improved."
Buyer's Guide
Microsoft Azure
December 2024
Learn what your peers think about Microsoft Azure. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.
Owner and Senior Technical Architect at a consultancy with 1-10 employees
A secure, vast, and powerful platform that provides many possibilities and reduces the strain on internal IT
Pros and Cons
- "It is so huge and so powerful. The best thing is the possibilities of things that you can actually do with it. If you do it right, you can work or host your stuff a lot cheaper than traditionally. Its security is good, and it also reduces the strain on internal IT."
- "I would like to see improved migration tools. It is improving week by week. They just need to make sure that they keep up with the new functionality provided in other clouds."
Azure Portfolio & Innovation Architect at a tech services company with 1,001-5,000 employees
All classic storage configuration settings are now managed by the platform
Pros and Cons
- "Managed storage capabilities, which create a very simple way to create, copy, and replicate local or geo-replicate, it's very simple to assign workloads."
Information Security Consultant at a tech services company with 51-200 employees
Consultant
Jun 30, 2015
The low cost is attractive, but stored procedures don't exist.
When I first had the idea to build https://report-uri.io, the biggest thing that jumped out at me was that there could be potentially huge amounts of inbound data that would need to be logged, stored and queried in an efficient manner. Doing some quick research it's obvious that most of the time, sites shouldn't really be generating CSP or HPKP violation reports, or so I thought. Once you have setup and refined your policy, you'd expect not to be getting any reports at all unless there was a problem, but this turned out not to be the case. Even excluding things like malvertising, ad-injectors and advertisers serving up http adverts on https pages, which I see a steady stream of constantly, there were things like policy misconfiguration and a genuine XSS attack that could also cause reports to be generated and sent, potentially in huge numbers. Every browser that visits a page with a violation would send a report and there could, and regularly is, multiple violations on a single page. Multiplied by a few heavily trafficked sites and you could very quickly have hundreds if not thousands of reports flooding in every single minute.
SQL Database
My first thought, as is fairly typical when one thinks 'I need a database', was towards the time tested SQL Server (or MySQL depending on your preference). Having had plenty of interactions with SQL Server in the past, I knew that it was more than capable of handling the simple requirements of a site like this. That said, I was also aware that the requirements of running a high performance and highly available database can be quite demanding. I knew I was going to want someone else to take care of this for me so I started looking around at different cloud providers. It became apparent pretty quickly that SQL Server in the cloud was fairly pricey for the budget I had in mind for the site!
SQL Azure was coming in at between £46 and £92 a month for a database capable of handling just a few thousand transactions a minute. Relatively cheap to some I have no doubt, but considering that all I'd looked at so far was the cost of the database, it wasn't a great start. Amazon also have their own offering of various flavours of RDBMS hosting but again, for a reasonable level of throughput and performance, I was looking at starting prices in the £40 - £50 a month region just to meet some basic needs.
My largest concern with having a fixed throughput would be the easy ability for an attacker to saturate it given the nature of the site. If the database is only provisioned for 5,000 transactions per minute, the number of inbound reports, queries against the data and my session store (more on that in another blog) could be quite demanding and if the database becomes unavailable, the whole site stops working. I needed something without the throughput restrictions and a lot cheaper.
NoSQL Database
Having used MongoDB for one of my previous projects the next logical step was to look and see what what was available in terms of NoSQL databases. Again, the hosted solutions seemed to be fairly pricey and were constrained by the typical CPU/RAM tiers or just a given performance metric. With great database as a service offerings from both Amazon and Microsoft in the form of DynamoDB and Table Storage respectively, I fired up a small test on both to try them out. One of the first things that cropped up with DynamoDB was the provisioned throughput again. You aren't actually billed for the transactions you make, you're billed to have a maximum available throughput after which transactions will start to fail. If you don't use them, you're still paying for them, but as soon as you go over the limit, you're in trouble. This means that you'd need to provision a good portion above your average requirements to be able to handle bursts in traffic.
Still, it's a little cheaper at ~£30 a month for the equivalent level of throughput as the SQL Server database mentioned above, but, we still have that maximum throughput limit. Microsoft do things a little differently with Table Storage in Azure and you're only billed for the transactions you actually use, there is no concept of provisioning for throughput. Each storage account can use as much or as little of the of the scalability limits as is required, and you never pay any more or less, just the per transaction cost.
Microsoft Azure Table Storage
Having been fairly impressed with my initial testing of Table Storage, I decided to throw some numbers on a piece of paper and see what the costs were going to come out at. Each storage account has a performance target of 20,000 transactions per second. Yes, 20,000 per second! That means that my application can perform up to this limit with 1 restriction. There is a 2,000 transaction per second target on a Partition, which is similar to the concept of a table in a traditional relational database. This shouldn't be a problem as long as the data is partitioned properly, a note for later on. Beyond this though, there aren't any other limitations. If you make 1 transaction in a second you pay the cost of 1 transaction, if you make 1,000 transactions in a second you pay the cost for 1,000 transactions. There are no penalties or additional costs as your throughput increases. The really staggering part is that the cost of a single transaction is £0.000000022, or, to make that a bit easier to get your head around, £0.022 per 1,000,000 transactions. Not only is the incredibly low cost really attractive here, the requirements of my application don't really fit very will with being fixed into a set throughput limit, and Table Storage does away with that.
Beyond this, the only additional cost, like all other providers, is storage space for the database and outbound bandwidth, both of which are again billed based on exactly what you use without any limits or requirements to provision allowances. Data storage is billed at £0.0581/GB/month and the first 5GB of outbound bandwidth is free with a cost of £0.0532/GB after that.
To sum all of this up with a really simple example, I drew up the following.
To store 5Gb of data, with 5Gb of egress and to issue 10 million transactions against that data would cost: £0.5105 per month. That's less money that I lose down the side of the couch each month!
Even if we get really silly with these numbers and put 100Gb in the database with 100Gb of egress and issue 200 million transactions against the data, we're still only talking £15.264 per month! That equates to an average of about 4,629 transactions per minute, a fraction of any other quote from other providers and proved attractive enough to tip the balance in favour of Azure Table Storage.
What's the catch?
Well, there isn't really a catch, as such, but Table Storage does have a very limited feature set when compared to something like SQL Server. That's no to say it's a bad thing, but it can be difficult not having some of the things that you're typically used to. You can read up much more on the difference between the two in Azure Table Storage and Windows Azure SQL Database - Compared and Contrasted. There are no foreign keys for example, joins and stored procedures don't exist either, but the biggest thing for me to get my head around was the lack of a row count feature. In Table Storage if you want to keep track of your row count, you have to keep track of it yourself. If you don't keep track of your row count the only way to obtain it is to query out your entire dataset and count the records in it. That's an incredibly slow, inefficient and arduous task! In coming blogs I'm going to be covering a lot of the problems that I hit whilst trying to adapt to using Table Storage and how I adapted my implementation of the service to get the best possible performance and scale out of it. Keeping track of the count of incoming reports, querying against potentially huge datasets efficiently, offloading my PHP session storage to Azure so that I could have truly ephemeral application servers behind my load balancers and much, much more.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Operations Expert at a tech services company with 5,001-10,000 employees
Consultant
Aug 5, 2013
Bring Windows Azure to your datacenter
Technical Architect at a tech services company with 10,001+ employees
It gives you the power to process lots of data, but it could be integrated better with other solutions
Pros and Cons
- "Databricks is really nice because you have the power to process lots of data and you can create queries and provide big analysis for the business using a robust cluster."
- "Maybe Azure could add an address code to create your analysis without SQL or Python because some business users don't want it to code. So it's good to have a service application that connects to the data lake to conduct analysis and simplify the business process."
Good cost management and billing, simple UI, but needs better alerts management and VPN
Pros and Cons
- "The management part of it is good. Its UI is simple to use. The cost management and billing part is also good. These are the top things that I like in Azure."
- "The alerts management should be improved. Alerts management is very complicated to configure. You have to go through a lot of tests and config action groups to set up those things. It is very complicated, and it can be simplified."
Buyer's Guide
Download our free Microsoft Azure Report and get advice and tips from experienced pros
sharing their opinions.
Updated: December 2024
Popular Comparisons
Amazon AWS
Oracle Cloud Infrastructure (OCI)
Akamai Connected Cloud (Linode)
Google Cloud
Google Firebase
Alibaba Cloud
SAP S4HANA on AWS
VMware Cloud Foundation
Nutanix Cloud Clusters (NC2)
DigitalOcean
SAP HANA Enterprise Cloud
Equinix Metal
Google Compute Engine
NTT Cloud
Skytap Cloud
Buyer's Guide
Download our free Microsoft Azure Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Gartner's Magic Quadrant for IaaS maintains Amazon Web Service at the top of the Leaders quadrant. Do you agree?
- PaaS solutions: Areas for improvement?
- Rackspace, Dimension Data, and others that were in last year's Challenger quadrant became Niche Players: Agree/ Disagree
- What Is The Biggest Difference Between Microsoft Azure and Oracle Cloud Platform?
- Which backup and recovery solution can backup Azure machines to its own (dedicated) cloud?
- Which is better - SAP Cloud Platform or Microsoft Azure?
- Which solution do you prefer: Alibaba Cloud or Microsoft Azure?
- How does Microsoft MDS (vs Informatica MDM) fit with Azure architecture?
- SAP HANA Enterprise Cloud (HEC): how to migrate to Microsoft Azure?
- Does F5 Advanced WAF work with Azure App Service?
Writing such an article today shall not miss the Azure DocumentDB, especially when you talk about NoSQL. Table storage is not real NoSQL. It is just a massive-scale Key-Value store.