SQL Azure Benefits

Naresh Reddy - PeerSpot reviewer
Enterprise Solutions Architect at OORWIN LABS INC

It provides good analytics. We can see which database is getting more requests, etc. We are able to see everything in Azure SQL. Its analytics are in a readable format, so a layman can understand them.

View full review »
Zubair_Ahmed - PeerSpot reviewer
Senior Consultant at Veraqor

Previously, the database was on-premises, but now, with the SQL database in the Azure cloud, extracting information from on-premises automatically makes it available in the Azure cloud. The data becomes instantly accessible in the cloud, making it more efficient for you to work with. It's a straightforward and easy process.

View full review »
MJ
Senior Database Administrator at a comms service provider with 10,001+ employees

It has cut our costs. That's the big thing.

View full review »
Buyer's Guide
SQL Azure
March 2024
Learn what your peers think about SQL Azure. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.
it_user261489 - PeerSpot reviewer
Program and Project Manager at a tech services company with 10,001+ employees

We are a solutions provider and we have implemented this solution for many organizations. With these customers, we have managed to reduce a lot of infrastructure budgets and to provide an eco-friendly setup. Organizations can reduce, by a lot, electricity consumption and simplify their cooling plant setup.

View full review »
SJ
Chief Technology Officer & Vice President, Delivery at a recruiting/HR firm with 1-10 employees

It helps us deploy new applications very quickly. We have set up everything on Azure, including SQL Azure. 

It has a lot of out-of-the-box features, which is useful. It is easy to move applications for disaster recovery or availability, and all these features are out of the box.

View full review »
Marco Cenzato - PeerSpot reviewer
Product Architect at Wolters Kluwer

With Azure, we can achieve very high workloads (~6K queries/min) and, if necessary, scale databases in real-time with only one minute of downtime for our customers. It enables us to scale up on demand and to scale down when needed. 

View full review »
PW
Manager of Architecture/Design with 51-200 employees

We developed our product with a small team of .NET developers for a client, a law university in Delhi, India.

We received the requirements from conversations of our team with our client, over the phone, and with email.

There was minimal training required for the team to be trained in cloud, as every developer in the team had basic .NET skills.

This product was then intended to be used by law university students for their training in court room sessions as student lawyers debating against each other to deduce lawful judgements of a case under study.

We provided virtual chat rooms for the students and had facilitated a method to share video sessions of their debates in virtual court rooms.

View full review »
RP
Solutions Architect - Cloud at a manufacturing company with 10,001+ employees

We find the uptime and multi-region features available. Additionally, the dashboard is valuable.

View full review »
IM
IT Manager at a pharma/biotech company with 201-500 employees

I have an old SQL server, and it's not stable. I have two choices, to renew the server or move the data to Azure. So I decided to move everything to the cloud. The database has since become more stable, and I have less troubleshooting, which saves time and money.

View full review »
AK
Consultant at kulki data management & consultants

The on-premise SQL Server licenses can be used since it is on Azure, so it's a significant savings for the customers.

View full review »
it_user660030 - PeerSpot reviewer
Data Management Architect at a healthcare company with 201-500 employees

It provides faster turnaround time to getting solutions customer facing.

View full review »
it_user402807 - PeerSpot reviewer
IT Manager at a tech services company with 51-200 employees

We have configured this solution into a worldwide application based on Microsoft SQL with SQL Azure and with SQL Azure elastic pool.

View full review »
Akin Ayodele - PeerSpot reviewer
General Manager at a tech services company with 11-50 employees

The solution allows us to bring automation to previously manual processes. Payment for permits is made online which eliminates discretion and fraud, and the wider process is streamlined. 

View full review »
it_user158343 - PeerSpot reviewer
Software Architect at a tech consulting company with 51-200 employees

Some customers' applications require very large tables (large number of records). Here are examples of how this solution helped them:

  • Performance of memory-optimized tables in SQL Azure exceeds that of an on premise SQL Server
  • Microsoft adds new features, including bug fixing, to SQL Azure every fortnight on the average.
  • Performance benchmark: There is a benchmark suite that is relevant, Azure SQL Database Benchmark (ASDB). This benchmark includes metrics in plans for the three-service tiers, Basic, Standard and Premium. (In-Memory OLTP support is only available in Premium tier plans.)

The main reason for the business case of using SQL Azure for a few large tables for our customer was as follows:

  • Most of the tables in the data model (DM) for the application are small enough to have required performance in a Standard Edition of an on premise SQL Server instance. Only four tables are large enough and have peaks of concurrent transactions per minute that are large enough to require in-memory OLTP support.
  • We needed to compare TCO for an Enterprise on premise SQL Server instance for the entire DM (that would be mainly under-utilized) versus TCO of a Standard on-premises for most of the DM + TCO of SQL Database with in-memory OLTP support for these four tables. (TCO for this scenario includes an estimate of changes in the design of the application.)
  • This TCO comparison was calculated for a period of two years. That is the time between a given version of on premise SQL Server and the next version.
  • The end result was a lower TCO for the second scenario. The first scenario implies paying an Enterprise instance up-front at the start of the two year period.
  • In the second scenario, the application would have two data repositories. Transactional control for the app is the reason why I mentioned the limitation of the SQL database. It only supports distributed transactions between instances of SQL Azure. That was a technical problem to solve. This was one of the main reasons for the changes in the app in the second scenario.
  • We had to make some changes to the app to separate transactions and their contexts for the two repositories.
  • In this case, it would be an improvement if Microsoft were to provide support of distributed transactions between SQL Azure instances. We would also like to see support for other kinds of services for Microsoft and other vendors who support standard distributed transactions.
View full review »
it_user131562 - PeerSpot reviewer
Owner at AFF Group

In many cases we use Azure as a service platform.

When larger data is collected by continuous business operations and will be processed for further analysis, we use SQL Azure.

View full review »
RA
Business Analyst at Paunaste OÜ

It provides regular database functionality

View full review »
Buyer's Guide
SQL Azure
March 2024
Learn what your peers think about SQL Azure. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.