Amazon Web Services RDS with SQL Server Housekeeping

Amazon Web Services RDS with SQL Server

Housekeeping v Please be sure to visit the sponsors during breaks and enter their end-ofday raffles! v Remember to complete session surveys! You will be emailed a link after the event or you visit http: //www. sqlsaturday. com/662/Sessions/Session. Evaluation. aspx v Event After Party § v At Will’s Training Table (Formally Beef O’Bradys) near the Pentagon starting at 5: 45 PM Want More Networking and Training? § (605) SQL meets the 2 nd Tuesday of every month. https: //605 sqlusergroup. sqlpass. org

Bio Christopher Wolff SQL Server DBA at Xero We’re hiring Over 16 years using SQL Server and other database technologies Twitter: @tickytong Email: tickytong@gmail. com Blog: https: //chriswolffdba. wordpress. com/

Overview What is RDS? What is required to get started? Create an RDS instance Querying the instance Compatibility issues Automation with Cloud. Formation

What is RDS Relational Database Services A web service to set up, operate, and scale a relational database in the cloud Not just SQL Server Postgre. SQL Oracle My. SQL Comes in 2 flavours Regular Aurora Manages all administration tasks Restrictive access

What is required to get started? Create an AWS account https: //aws. amazon. com/ Select your instance type SQL Server 2008 R 2 to 2016 Includes Express, Web, Standard, or Enterprise Production or not Make a DB instance name, master user, and password Specify virtual private cloud and security groups Specify backup retention period

DEMO Create an RDS instance Query the instance Compatibility issues

Automation With Cloud. Formation uses templates to automatically create an AWS instance Templates can be made in JSON or YAML

DEMO Launch RDS instance using Cloud. Formation

Credits What is Amazon Relational Database Service (Amazon RDS)? http: //docs. aws. amazon. com/Amazon. RDS/latest/User. Guide/Welcome. html Creating a Microsoft SQL Server DB Instance and Connecting to a Database on a Microsoft SQL Server DB Instance http: //docs. aws. amazon. com/Amazon. RDS/latest/User. Guide/CHAP_Getting. Started. Creating. Connecting. SQLServer. html AWS: : RDS: : DBInstance http: //docs. aws. amazon. com/AWSCloud. Formation/latest/User. Guide/aws-properties -rds-database-instance. html What is AWS Cloud. Formation? http: //docs. aws. amazon. com/AWSCloud. Formation/latest/User. Guide/Welcome. html

THANK YOU SPONSORS