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.

ORA-12154: TNS:could not resolve the connect identifier specified

Most people will encounter this error when their application tries to connect to an Oracle database service, but it can also be raised by one database instance trying to connect to another database service via a database link.

Jeremiah Wilton | March 4, 2009

12c Upgrade Bug with SQL Tuning Advisor

Learn the steps to take on your 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

Recover a Table from an RMAN Backup in an Oracle 12c

This blog post will is to show a table restore for one table in a container database.

Megan Elphingstone | February 2, 2017

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