Try our new research platform with insights from 80,000+ expert users
PeerSpot user
Senior Consultant | Architect at DHL
Consultant
The most valuable feature is using different types of servers on one environment.
Pros and Cons
  • "The most valuable feature is the possibility of using Microsoft and non-Microsoft services on one environment."
  • "Monitoring options should be more sophisticated, as there are dashboards on which a end user is able to pin a lot of charts and a number of web parts, but for example, I would love to have some option like in Operational Management Suite."

How has it helped my organization?

This product helps companies to build their own infrastructure in the cloud without the need of any physical server. This is nice for new, small companies. For big companies, there are services like containers, docker, and infrastructure as a service for making their environment less heavy and saving some costs, using hybrid infrastructure and service concept.

What is most valuable?

The most valuable feature is the possibility of using Microsoft and non-Microsoft services on one environment. For example, Windows servers, Linux servers, backup solutions from Veeam, etc.

There is no one special feature for me, as it makes sense as a complete package. I would mention container services as well, as this is the most modern concept of bimodal IT. For example, doing development in companies without the need of building development servers. You can just using some special parts as micro-services and putting them together like Lego pieces. This is the real benefit of cloud and Azure.

What needs improvement?

There should definitely be some improvement in the UI. It is lacking in terms of where the end user has to click on other icons and go back to the main menu to change some small settings and then go back through many options to the main request. This is something which Microsoft is constantly working on, but still it needs improvement.

Monitoring options should be more sophisticated, as there are dashboards on which a end user is able to pin a lot of charts and a number of web parts, but for example, I would love to have some option like in Operational Management Suite. For instance, some queries and filters Maybe those are already there, but I have not been able to find them. I have to combine the Operational Management suite for Infrastructure, PowerBI for subscription and Application Insight for applications.

Alternatively, I can create a PowerBI dashboard for everything, but this is not for everybody, as it is not always so easy.

Managing of separate subscriptions if you have more than one and in separate domains, it is not so easy to manage. I can’t merge all of my subscriptions, as I am able to have only one enterprise subscription in one account.

What do I think about the stability of the solution?

There have been no stability issues. I have some problems related to subscription management, but this is because I have more than one subscription and there were some problems related to merging those into one management.

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.
859,957 professionals have used our research since 2012.

What do I think about the scalability of the solution?

There were no issues related to scalability at all.

How are customer service and support?

Technical support is provided by ticketing system in the portal, so you can create a ticket and a few hours after that, the support guys will contact you, and will try to call you during business hours and will help you immediately. I had really specific problems a few times that needed longer discussion with support, but standard tasks were quickly resolved.

How was the initial setup?

Nice and smooth since the beginning.

What's my experience with pricing, setup cost, and licensing?

Related to pricing and licensing, you have to be careful how you operate with the concept. You would like to set some automation rules for automated shutdown and start up your virtual machines so that they are not consumed costs, etc. So it is about the logic of using this solution.

Which other solutions did I evaluate?

We evaluated Google and Amazon.

What other advice do I have?

Prepare everything before implementation. Make your plan and calculate what should be the best solution or alternative for you.

This solution is at the top of what you can get at the moment on the market. There are huge amounts of separate tools and scenarios from infrastructure monitoring and administering, to hybrid scenarios or quick service creation and maintenance. The main benefit is the possibility of creating quick services, which you can select from many Microsoft and third-party service providers as well.

Disclosure: My company has a business relationship with this vendor other than being a customer. I am a Microsoft MVP, so I have some relationships with Microsoft from technical point of view.
PeerSpot user
PeerSpot user
IT & PMO Manager at a retailer with 1,001-5,000 employees
Vendor
Has integration with Active Directory and Office 365.

What is most valuable?

  • Quick and easy deployment
  • Complete packaged solutions to deploy (Web Apps service)
  • Clear pricing
  • Low cost
  • Easy scaling
  • Cost effectiveness (stopping a VM when not in use)
  • High availability
  • Easy restore and recovery
  • Integration with Active Directory and Office 365. There are many benefits. For example, there is a special customized portal for all apps and services built in Azure AD (myapps.microsoft.com) with a seamless single sign-on experience for the users in AD or Office 365.

How has it helped my organization?

It improved our project completion time. A new server or solution requirements are now solved in hours instead of in weeks.

What needs improvement?

What we experienced after two years with an Azure suscription is that there is good knowledge in Microsoft Partners for Azure, but generally they are too specialized and couldn't cover everything, because they allways miss something related by example to networking, database, web apps, security, or integration on Azure. So you must contract more than one Microsoft Partner to have a successful project in Azure.

For how long have I used the solution?

I have been using Azure for two years.

What do I think about the stability of the solution?

We had no stability issues.

What do I think about the scalability of the solution?

It is very easy and quick to scale up or scale out. It has automatic scaling by CPU performance or other rules.

How are customer service and technical support?

Support is very good, fast, responsive, and effective.

Which solution did I use previously and why did I switch?

We used traditional on-premises virtual machines and switched to Azure for better cost and faster deployment.

How was the initial setup?

The only complexity was the initial setup of a site-to-site VPN to connect our LAN to Azure. The required Azure site-to-site VPN gateway is not fully supported on older firewalls, so you must be careful. For details please read: https://docs.microsoft.com/en-...

What's my experience with pricing, setup cost, and licensing?

Azure’s price is very competitive with traditional hosting (in-house or outsourced). Windows and database licenses are included in the solution price or you can bring your own license (BYOL). There are also several free or open source solutions in Azure.

Which other solutions did I evaluate?

We looked at AWS. In our case, Microsoft had very competitive pricing due to our Office 365 agreement.

What other advice do I have?

Test it for free with the advice of an experienced Microsoft partner.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
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.
859,957 professionals have used our research since 2012.
it_user657774 - PeerSpot reviewer
Server and StorageIO Group (Storage IO): Independent IT Advisor, Author, Blogger and Consultant with 1-10 employees
Vendor
This product has facilitated development, testing, and deployment.

What is most valuable?

  • Virtual machines, both Windows and Linux based
  • Blob storage
  • Azure file storage
  • SQL server

How has it helped my organization?

This product has facilitated development, testing, rapid deployment, spot resource needs, with a remote off-site that compliments on-premises for the hybrid cloud.

What needs improvement?

The user interface is great if you like tablet, a.k.a., Windows type functionally. The PowerShell is robust. However, there is not much in between, although you can do a lot of customizing views, dashboards, and other things.

I like the extensiveness of the new VS classic interface. At times, I still find the AWS dashboards simpler and more streamlined. Nevertheless, Azure is more elegant.

For how long have I used the solution?

I have used the product for several years.

What do I think about the stability of the solution?

I had no stability issues.

What do I think about the scalability of the solution?

There were no issues, as long as your credit card can also scale.

How are customer service and technical support?

I don't know about technical support, as I have not had to deal with them. But the various communities, forums, and resources are outstanding.

Which solution did I use previously and why did I switch?

We have deployed, and continue to use:

  • AWS EC2
  • EBS
  • S3 Glacier
  • Route 53
  • Lightsail
  • Google
  • Bluehost DPS
  • An onsite mix of Microsoft Hyper-V and VMware

We are doing hybrid to address different needs.

How was the initial setup?

Having used AWS, VMware, as well as Windows, there was a little bit of a learning curve, just as there was for others.

However, navigating the UI, shells, and figuring out what was where, without spending weeks in seminars, training, and watching videos, was actually pretty intuitive.

If you are not used to working with AWS or others, or if you have some tools, Azure is actually pretty extensible and getting easier to working from Windows and vice versa.

What's my experience with pricing, setup cost, and licensing?

Do your homework, understand the type and sizes of resources, see if there are any extra fees, and find out what tools are needed.

Check what level of performance, availability, capacity and economic (PACE) budget, as well as the services that are needed.

Watch your costs and look for value versus the lowest cost.

Which other solutions did I evaluate?

We looked at AWS, Rackspace, Google, Microsoft, Bluehost, and VMware.

What other advice do I have?

Don't be scared, be prepared; do your homework.

Look beyond lower cost and instead focus on value, enablement, ease of use, compatibility, resiliency, ability to scale with the stability of performance, capacity, and availability.

Look at the extensiveness of services versus a simple check box.

You also need to identify any concerns about the cloud, categorize them, and then discuss with others how to address them, or seek a workaround.

If you cannot find somebody to chat with, drop me a note.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
PeerSpot user
IT Analyst at a government with 501-1,000 employees
Real User
The Canvas flow interface brings a very nice functionality that improves self-learning.

What is most valuable?

The Canvas flow interface brings a very nice functionality that improves self-learning.

How has it helped my organization?

Selecting and applying a machine learning algorithm is not a click-and-run process. In this case, clustering our data has helped us to find patterns and trends that were not visible using conventional (internal) classification.

What needs improvement?

Stronger R integration in a circular fashion (Azure->R->Azure). Nowadays, it has an unidirectional bias.

For how long have I used the solution?

I've used Machine Learning Studio for the last six months.

What was my experience with deployment of the solution?

We've had no issues with the deployment.

What do I think about the stability of the solution?

By using a free account for cloud services can bring you "queued" status, but normally it runs smoothly. The quota defined for free account is enough for a variety of experiments and none of the features are blocked.

What do I think about the scalability of the solution?

We've had no issues with the scalability.

How are customer service and technical support?

Customer Service:

As a cloud service, online chat and email service are available, but the community forums are the best place to solve issues.

Technical Support:

We have a support maintenance agreement for Windows/Office.

Which solution did I use previously and why did I switch?

There are a few competitors in place, and their number is increasing, but friendliness is the strong point of AzureML, comparing to Amazon AWS or BigML.

How was the initial setup?

It does not involve any setup, just having an Outlook or Microsoft account.

What's my experience with pricing, setup cost, and licensing?

Using a free account leads to offline projects. For online projects those issues must be evaluated according to client side company's environment.

What other advice do I have?

Machine learning is just one part of the whole data science cycle. Big data (streaming, video, etc.) or deep learning needs must be addressed with additional tools. But for prediction/classification this is a fantastic tool.

Below is a PCA graph generated by K-means training model and its Qlik Sense panel. The idea is to segment unlabeled data based on numerical features in order to find common patterns that can be grouped, named clusters.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
PeerSpot user
Technical Solutions Specialist at a tech services company with 1,001-5,000 employees
Consultant
We have lower production times because we don't make any more hardware purchases or have software and vendor support contracts.

Valuable Features:

Easy and fast provisioning of Cloud Services including Web sites, Virtual Machines and Databases.

Great for application development testing, staging and production slots.

Better Support and community than the others.

The onboarding services are great for new customers.

Improvements to My Organization:

No more hardware purchases, software and vendor support contracts = Lower times to production.

Great storage capabilities.

Room for Improvement:

N/A

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
it_user281949 - PeerSpot reviewer
Software Developer at a tech services company with 51-200 employees
Consultant
There are limits to resources you can use in Azure, but it enables us to offload demand from our data center when additional hosting capacity is required without notice.

What is most valuable?

  • Resource manager
  • API
  • Cloud storage
  • Virtual machine hosting

How has it helped my organization?

Our company plans to use Azure for training and for internal use. We use ADFS and the cloud storage mostly. We are also moving to host labs in Azure to offload demand from our datacenter, when additional hosting capacity is required without notice.

What needs improvement?

The system has some limitations on resource use, such as number of cores, max transactions, I/O, maximum number of VMs etc. These limits make some things very difficult, and could be improved. Also Azure is constantly undergoing changes, and the move to Azure API v2 offers a lot of improvement, but is still rather unfinished. Once it is complete it will be great, but in the meantime there is much room for improvement. Microsoft is constantly looking for ways to improve, so many of the improvements I can think of, they are already working on.

For how long have I used the solution?

A little over one year

What was my experience with deployment of the solution?

There were some issues with development and the resource limitations. We also ran into a problem with networking. Network changes over the API are synchronous, and only one change can occur at any given time, locking the subscriptions networking config until the last operation completed. This was resolved in the V2 API. Most of the problems we ran into with V1 are resolved and simplified in V2.

What do I think about the stability of the solution?

There have been few problems with stability. Only a couple times there were outages that only impacted our development environment. Notice of these service interruptions are generally given with plenty of time to prepare.

What do I think about the scalability of the solution?

There are limits as to how much resources you can use in Azure (as with all cloud platforms). This can be a problem if you plan to host hundreds of virtual machines with an hours’ notice. They have a process that requires a customer to go through tech support, and request/justify the need for a resource increase. If you need more than 20 networks, you will need to open a new subscription, and move resources to that subscription. They simply will not budge on some limit increases, and will on others. Currently opening up a new subscription is the solution to the resource limit problem. Azure is not really intended to handle our level of churn (creation and deletion of hundreds of VMs per minute), but we have been able to work with them and work around the problems we ran into.

How are customer service and technical support?

Customer Service:

The level of customer service is generally very good. They are quick to respond and resolve the problem quickly. I have had a couple of issues where the technical support staff didn’t interpret the problem correctly and moved a severe issue down from a two hour response time to a 24 hour response time. I quickly responded and told them that it was impacting ongoing business, and they moved the ticket back up, and resolved it within the two hour timespan. All other interaction with customer service has been outstanding. After a co-worker posted on Twitter making a remark about the UI, we received a call from customer service. They setup a meeting with us to discuss what problems we ran into with the new UI, and they asked us for input on what their developers could do to improve our experience. They were taking a proactive approach to customer service, not waiting for a problem to come to them, but sought out those with problems and resolved them.

Technical Support:

I would rate their support at 8/10. A ten being perfect support without ever running into a problem, one being at a very poor level of customer support. I consider a rating of 8 to be a high rating. I should also add that the only support I have received has been for free, this only includes sales related issues and limit increases. I don’t have experience with their paid technical support which I would expect to be much better. They will charge for support even if you are a paying customer, so a rating of 8/10 reflects the support fees as well.

Which solution did I use previously and why did I switch?

In the past, we used our own solution. We have datacenters where we host our in house solutions. We didn’t completely switch to Azure, but did offload some things to free up hardware for other purposes. We also want to offload hosting to Azure in times of high demand.

How was the initial setup?

The setup for us is quite complex because we need to integrate it into a custom solution. The setup includes development time and changes to our core systems. This is not an easy task, but it's not at the fault of Azure or any other cloud service provider. The API has a learning curve, but anyone familiar with cloud services, and the use of a remote API should have no problem learning and implementing their system.

What about the implementation team?

We implemented our solution in house. Most Azure integration is done by me. Azure is simple enough that interfacing your system with Azure can be done by a single person.

What was our ROI?

As for time to ROI I am not sure, these details are determined by upper management. The main components for the return is the idea that we will not only be able to offer a new set of training material for Azure specific material as a new product, but we can also avoid purchasing expensive equipment to satisfy a short term need for hardware and resources. Long term needs are hosted in house on our equipment. Even with the high cost of Azure hosting, purchasing additional equipment for a temporary need can result in a large amount of unnecessary costs.

What's my experience with pricing, setup cost, and licensing?

Our setup costs are the costs of development time to integrate our system with Azure. Because the project is ongoing, this is difficult to determine. The cost for subscriptions in development is about $150 a month. Our MSDN subscription includes a credit which takes care of this cost. In production we forward the costs of events to the customer who is hosting the event. I don’t get the exact details on the day to day operation costs for internal subscriptions.

Which other solutions did I evaluate?

We evaluated the Google Cloud and AWS. All have a varying range of features and paradigms. Some appear to be cheaper, but when you add up the costs and read the fine print, you find that this may not be the case. We do plan to offer services on other platforms as well, but that is a different project. I have done research on all platforms to make sure the core system is compatible with all others. Azure is so far my favourite. The support is great, and the pricing is easy to work out. Other options had a lot of fine print and stipulations. Also the API is very easy to use, with plenty of references on MSDN.

What other advice do I have?

Overall, it is a great, solution but is a bit expensive, has some minor limitations, and working around these limits can be a challenge. I still gave Azure a high score because of the support, feature set, availability, and the tools and documentation provided for the API.

My advice is to be very clear on the costs associated with what you plan to do. Most people will ask how much it costs to host their infrastructure in Azure, but that question is different for each scenario. Microsoft has an Azure price calculator that you can use to estimate the costs for your planned architecture. I would also recommend doing extensive research on the limits imposed by Microsoft. There is a page that details these limits, but there are some things that are not visible to the users. I would also recommend researching the hidden layers of the storage platform known as storage stamps, and how it can impact the copy speed of storage blobs.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
PeerSpot user
President and Founder with 51-200 employees
Vendor
It has long-term value when you consider cost-benefit analyses (with Microsoft's pricing calculator), but it's difficult to know exactly what the costs would be for services running on Azure.

Originally posted at http://jimwilsonblog.com/?p=250

A recent article of an interview with the Red Hat CEO touts the benefits of private cloud implementation. See it here.

This debate is usually short sited and doesn’t include all CAPEX & OPEX cost associated with the “Free OS” type of cloud operations. Also, the reusable components from more sophisticated partner communities afford both AWS & AZURE much greater long term valuations when responsible enterprise accounting methods are used to drive the cost-benefits analyses. The proper engineering of a cloud infrastructure which includes smart VMs well orchestrated by business-demand-level-driven auto scaling will always push the TCO/ROI argument to a public solution for large scale systems.

Microsoft actually has a TCO tool that they can use to estimate TCO of on-premises vs. Azure. There are many considerations when comparing costs of running an on-premises datacenter with full infrastructure, servers, cooling, power, etc. to a cloud-based service like Azure where you pay a cost based on the services consumed such as storage, compute and network egress. It can be difficult to know exactly what typical costs are for your datacenter and what the costs would be for services running in Azure. Microsoft has a pricing calculator available at http://azure.microsoft.com/en-us/pricing/calculator/ which can help assess costs for Azure services and a VM specific calculator at http://azure.microsoft.com/en-us/pricing/calculator/virtual-machines/.

When running on-premises, you own the servers. They are available all the time which means you typically leave workloads running constantly even though they may actually only be needed during the work week. There is really no additional cost to leave them running (apart from power, cooling, etc.). In the cloud you pay based on consumption which means organizations go through a paradigm shift. Rather than leaving VMs and services running all the time, companies focus on running services when needed to optimize their public cloud spend. Some ways that can help optimize services running are:

  • Auto-scale – The ability to group multiple instances of a VM/service and instances are started and stopped based on various usage metrics such as CPU and queue depth. With PaaS instances can even be created/destroyed as required
  • Azure Automation – The ability to run PowerShell Workflows in Azure and templates are provided to start and stop services at certain times of day making it easy to stop services at the end of the day then start them again at the start of day
  • Local Automation – Use an on-premises solution such as PowerShell or System Center Orchestrator to connect to Azure via REST to stop/start services
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
it_user255330 - PeerSpot reviewer
it_user255330Cloud Architect at a tech services company with 51-200 employees
Consultant

"Free OS". Please check Jim's pricelist. RHEL, RedHat's openstack etc: It is certainly not for free.

Statements like :
short sited (I assume that should read short sighted),
more sophisticated,
much greater longer term valuation,
responsible enterprise accounting methods......

are not documented in any way. I think the author should have a deepdive in things like cloudfoundry, openshift, WSO2, openstack and the likes before using these kind of terms. Or not write about this matter at all. Or at least try to launch a VM named "testwin" in Azure. ;-)

it_user242517 - PeerSpot reviewer
Information Security Consultant at a tech services company with 51-200 employees
Consultant
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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
it_user7842 - PeerSpot reviewer
it_user7842Owner with 51-200 employees
Vendor

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.

See all 2 comments
Buyer's Guide
Download our free Microsoft Azure Report and get advice and tips from experienced pros sharing their opinions.
Updated: December 2024
Buyer's Guide
Download our free Microsoft Azure Report and get advice and tips from experienced pros sharing their opinions.