Select Page

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

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.

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.

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017
sharepoint ideas

9 Awesome Things You Can Do with SharePoint

This blog post discusses out-of-the-box uses for SharePoint that you can execute in just a few clicks without using any code.

Amol Gharat | May 23, 2017

Shortcut to Fixing a Corrupted Oracle Inventory

Oracle Central Inventory files are essential to installing and patching software, ensuring it’s operating correctly and is critical to database stability and availability. The process for fixing a corrupted file can be found here.

Chad Cleveland | February 23, 2016

Work with Us

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

CONTACT US

Work for Us

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

EXPLORE JOBS