SQLOrlando - Intro to SQL Server on AWS

Event Information

Share this event

Date and Time

Location

Location

Nova Southeastern University

4850 Millenia Blvd

Orlando, FL 32839

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Eventbrite's fee is nonrefundable.

Event description

Description

SQLOrlando - Intro to SQL Server on AWS

If you're thinking about moving to the cloud or just wanting to make sure you're keeping your skillset current you probably have a LOT of questions about SQL Server on AWS. What's different, better? How is HA/DR handled? What are the best practices and anti-patterns? What does a migration to RDS look like? What does it really cost? If you're asking those kinds of questions, this is the class for you!

Who Should Attend

This class is structured for a DBA or a manager with a good understanding of how SQL Server works in an enterprise environment but developers and analysts will also benefit from attending.

Prerequisites

None.

Class Outline

This class is presented as four modules of approximately 45 minutes each.

Module 1 - Why AWS?

We'll start the class with a review of why many companies choose to migrate their SQL Server workloads to AWS. We'll also talk about why there are very few "doesn't fit" scenarios. For most the biggest decision is whether to use RDS or EC2 (we'll explain the acronyms too!).

Module 2 - Licensing, Right Sizing, and HA/DR

Licensing matters for SQL Server, it is not cheap. We'll start by looking at whether you should bring your own license or not. Then we'll move into right sizing your hardware because if you're over provisioned or just running on old hardware you may save money just from picking the right instance type in AWS. We'll finish up by looking at how HA/DR works in RDS, what it costs in EC2, and options like SIOS Datakeeper as a way to avoid using an Enterprise license.

Module 3 - Migrating to AWS

This module explores migration strategies. Backup/restore is the obvious option, but if minimizing downtime matters then log shipping and Availability Groups are other choices that can be used. This module also includes a demo of moving data using the AWS migration service.

Module 4 - Monitoring & Tuning

You can monitor SQL Server in AWS using the same tools you do now if you're using EC2 instances. If you're using RDS you'll be interested to see what CloudWatch and RDS Performance Insights provide. We'll discuss best practices for configuring SQL in AWS and also how to use RDS parameter groups.

About the Instructor

Tom Staab is a Solutions Architect for AWS specializing in SQL Server. He is a frequent presenter at Florida meetups and SQLSaturdays.

Event Logistics

Parking is free. No food will be provided. Wifi should be available.

Share with friends

Date and Time

Location

Nova Southeastern University

4850 Millenia Blvd

Orlando, FL 32839

View Map

Refund Policy

Refunds up to 7 days before event

Eventbrite's fee is nonrefundable.

Save This Event

Event Saved