Select Page

SQL Server on AWS: You Had Questions, Jeff Has Answers!

Author: Jeff Duncan | | March 11, 2020

Last week I presented a webinar in partnership with PASS webinar titled: Accelerate SQL Server to the AWS Cloud. I wanted to follow up with some questions that came through that we were unable to get to at the end of the webinar.

Check out the questions and answers below and feel free to contact us if you have further questions. Additionally, since I ran out of time at the end despite my speedy pace to fit it in, I’m planning on recording a follow up session and blogs that will dig a bit deeper on the topics:

  • Choosing between SQL Server RDS & EC2
  • Cost Reduction on AWS Cloud for Running SQL Server
  • Performance Baselining
  • Post-migration activities
  • DBAs responsibility in the Cloud


Here’s the questions and my answers that came in during the webinar.

Question #1: AWS implements the SQL Agent, but Azure doesn’t, at least in the managed service.

Not exactly a question, but worth a response. Azure does have an agent in the IaaS offering.

Question #2: What do you use for Monitoring SQL Server on EC2 SQL Server

You can use any current monitoring system with EC2. Datavail has a proprietary software called Delta that we use. But we also utilize any current third-party tools a customer owns that can be installed on Windows for SQL.

Question #3: If you are specialized in SQL Server why did you choose AWS instead of Azure? I mean, Azure has Azure SQL Database natively and include all new features in there

Datavail supports and recommends both AWS and Azure. We focused the presentation on AWS because they have been the outstanding leader for 14 years and still hold double the market over Microsoft. AWS has more to offer currently, as well as less downtime. But Microsoft still has its advantages and may be a better fit for some customers, especially those with a strong Microsoft relationship.

With that said, the journey to the cloud is just that, a journey – not a destination. If you’re looking for a partner along the way, Datavail is here to help guide you. We’re an AWS Advanced Tier Partner and a Microsoft Gold Partner with 100+ migrations to the cloud, whether it’s the AWS or Azure cloud we can help determine the best solution for your organization.


We’d love to know where you’re at on the cloud readiness journey. Take our survey and you’ll be automatically entered to win a pair of Sony wireless headphones ($200 value).

Watch The Webinar

Accelerate SQL Server Migration to the AWS Cloud

This webinar is in partnership with PASS, download the recording to learn more about reasons to go to the cloud, SQL Server on AWS EC2 vs. AWS RDS, SQL Server high availability (HA) & disaster recovery (DR),
SQL Server migration methodology, and DBAs role in the cloud.

How to Solve the Oracle Error ORA-12154: TNS:could not resolve the connect identifier specified

The “ORA-12154: TNS Oracle error message is very common for database administrators. Learn how to diagnose & resolve this common issue here today.

Vijay Muthu | February 4, 2021

Data Types: The Importance of Choosing the Correct Data Type

Most DBAs have struggled with the pros and cons of choosing one data type over another. This blog post discusses different situations.

Craig Mullins | October 11, 2017

How to Recover a Table from an Oracle 12c RMAN Backup

Our database experts explain how to recover and restore a table from an Oracle 12c RMAN Backup with this step-by-step blog. Read more.

Megan Elphingstone | February 2, 2017

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.


Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.