AWS Quick Start for SQL Server 2017 on Amazon EC2

TL;DR

AWS QuickStart allows users to deploy SQL Server 2017 on EC2, providing flexibility and ownership over the deployment process.

Transcript

welcome to this is my architecture I'm Matt from AWS if you've been watching this series in order that normally we talk to customers and partners about how they build their solutions on top of AWS but once a while we talk to our own internal teams and learn how they build their own solutions so today I'm joined by Santiago from the ABS QuickStart t... Read More

Key Insights

• 🤩 AWS QuickStart provides reference deployments and best practices for key workloads on AWS, offering flexibility and convenience to users.
• 📁 Deploying SQL Server 2017 on EC2 using QuickStart allows users to have direct access to the file system and administrative privileges, providing greater control and customization options.
• 😒 QuickStart deployments make use of CloudFormation templates, scripts, and deployment guides to simplify and automate complex architecture deployments.
• 👥 High availability is achieved in the QuickStart deployment through the use of an always-on availability group and automatic failover across availability zones.
• 👤 QuickStarts can be customized and expanded based on user requirements, such as deploying in multiple availability zones or regions.
• ❓ AWS Directory Services is used for identity and authentication purposes in the QuickStart deployment of SQL Server 2017 on EC2.
• 👻 The modular approach of QuickStart allows users to choose which components to deploy, offering flexibility and customization options.

Questions & Answers

Q: What is AWS Quick Start?

AWS QuickStart is a reference deployment that provides best practices and solutions for key workloads on AWS, built with partners and AWS solution architects.

Q: How are QuickStarts built?

QuickStarts are built using CloudFormation templates, which include confirmation code, scripts for bootstrapping, and a deployment guide.

Q: Why would a user need to use QuickStart to deploy SQL Server 2017 on EC2?

QuickStart offers flexibility and ownership to users, allowing direct access to the file system, administrative privileges, and the ability to install additional agents or tools.

Q: How is high availability achieved in the QuickStart deployment of SQL Server 2017 on EC2?

The deployment utilizes an always-on availability group with automatic failover across availability zones, ensuring high availability for the SQL Server instances.

Key Insights:

• AWS QuickStart provides reference deployments and best practices for key workloads on AWS, offering flexibility and convenience to users.
• Deploying SQL Server 2017 on EC2 using QuickStart allows users to have direct access to the file system and administrative privileges, providing greater control and customization options.
• QuickStart deployments make use of CloudFormation templates, scripts, and deployment guides to simplify and automate complex architecture deployments.
• High availability is achieved in the QuickStart deployment through the use of an always-on availability group and automatic failover across availability zones.
• QuickStarts can be customized and expanded based on user requirements, such as deploying in multiple availability zones or regions.
• AWS Directory Services is used for identity and authentication purposes in the QuickStart deployment of SQL Server 2017 on EC2.
• The modular approach of QuickStart allows users to choose which components to deploy, offering flexibility and customization options.
• AWS QuickStarts are designed to save time, reduce human errors, and ensure adherence to best practices for deploying complex solutions on AWS.

Summary & Key Takeaways

• AWS QuickStart is a reference deployment on AWS that offers best practices and solutions for various workloads, including enterprise and open-source tools.

• QuickStarts are built using CloudFormation templates, accompanied by scripts and deployment guides, enabling automatic and complex architecture deployments.

• Deploying SQL Server 2017 on EC2 using QuickStart offers flexibility, ownership, and access to the file system and administrative privileges.