Implementing SQL Server on Amazon RDS

A guide for database administrators to implement SQL Server on Amazon RDS.
Course info
Rating
(45)
Level
Intermediate
Updated
Oct 19, 2015
Duration
2h 20m
Table of contents
What Is Amazon RDS?
Building Your SQL Server on Amazon RDS
Connecting and Managing SQL Server on Amazon RDS
Moving Data in and Out of SQL Server on RDS
Configuring Backups and High Availability
Known Service Limitations
Description
Course info
Rating
(45)
Level
Intermediate
Updated
Oct 19, 2015
Duration
2h 20m
Description

Amazon is one of the biggest providers of cloud computing in the world. Part of their offering is the database cloud service known as Amazon RDS. In this course, we'll cover what these service can do, the option and configuration choices for SQL Server, and the differences from the on-premises SQL Server that you already know.

About the author
About the author

Warner is a SQL Server Certified Master, MVP, and Principal Consultant at Pythian. He manages clients in many industries and leads a talented team that maintains and innovates with their data solutions. When he's not working in Ottawa, Ontario, he can be found in his home country of Costa Rica.

More from the author
Azure SQL Database for the SQL Server DBA
Intermediate
2h 47m
20 Dec 2016
Section Introduction Transcripts
Section Introduction Transcripts

What Is Amazon RDS?
Hi. This is Warner Chaves with Pluralsight and welcome to my course, Implementing SQL Server on Amazon RDS. This course is all about deploying and managing SQL Server on the Amazon RDS platform. Before diving in let's take a look at some of the fundamental concepts of the course. First of all, we're going to focus on Microsoft SQL Server on RDS. There's other database products that can run on RDS, such as Oracle or MySQL, but here we're going to focus exclusively on SQL Server. Amazon RDS stands for Relational Database Services and is part of the Amazon Web Services public cloud platform. RDS specifically, is a Database as a Service offering. This is also referred to as Platform as a Service sometimes, so if you're ever in a conversation and somebody refers to RDS either as Database as a Service or Platform as a Service they're referring to the same thing. What is Amazon RDS? RDS runs inside the bigger Amazon Web Services platform, which is Amazon's public cloud that provides compute storage and network power to many companies around the world. RDS is a Database as a Service offering, and we'll go into a lot more detail later on on what that really means, but for now what you really need to realize is that it makes running platforms, such as SQL Server, a lot easier for the DBA and for a business. This type of service should not be confused with Infrastructure as a Service, which is another very popular offering of the public clouds, and just really translates to running virtual machines in the public cloud.

Building Your SQL Server on Amazon RDS
Hi. This is Warner Chaves with Pluralsight and welcome to the module two of the Implementing SQL Server on Amazon RDS course. In module one we learned the basic concepts of RDS, the differences between Database as a Service and Infrastructure as a Service, and the main advantages of running SQL Server on RDS. In this module we'll go through the process of planning and building your SQL Server on RDS. In this module we'll go through the process of planning you SQL Server RDS deployment. We'll go through all the different things that you can configuration and pick and choose before you create your SQL Server instance, and finally, we'll go through how to configure your SQL Server RDS instance. This is very different than running SQL Server on-premises and configuring it on premises, so it's important for you to know this.

Connecting and Managing SQL Server on Amazon RDS
Hi. This is Warner Chaves with Pluralsight and welcome to module three of the Implementing SQL Server on Amazon RDS course. In the previous module we went over the steps for planning, creating, and configuring your SQL Server on RDS. In this module we'll look into connecting into it and managing SQL Server with the differences of managing it on RDS, as opposed to managing it on-premises. In this module we'll go through connecting you SQL Server to RDS, and we'll walk through the different security settings that you need to enable to make this possible. We'll also go into understanding the RDS administrator role and the subtle differences to the SYS admin SQL Server role that usually is used on-premises. We'll also go into the bigger management differences to the on-premises SQL Server. This will go into running jobs, checking trace files, and other administrative tasks.

Moving Data in and Out of SQL Server on RDS
Hi. This is Warner Chaves with Pluralsight. Welcome to module four of the Implementing SQL Server on Amazon RDS course. In the previous module we saw all about connecting and managing your SQL Server on RDS. In this module we'll go over the different tools and options for moving data in and out of your SQL Server on RDS. In this module we'll take a look at moving data with the Import/Export Wizard included on SQL Server Management Studio. We'll look at moving data as well in the command line with the BCP utility. Finally, we'll take a look at moving data with the SQL Database Migration Wizard, a free CodePlex tool.

Configuring Backups and High Availability
Hi. This is Warner Chaves with Pluralsight. Welcome to module five of the Implementing SQL Server on Amazon RDS course. In the previous module we went over the methods and tools to move your data between on-premises SQL Servers and Amazon RDS. In this module we're going to go over backups and high availability for SQL Server on RDS. In this module we'll go over working with backups, their configuration settings, and what the restore process looks like on RDS. We'll go over what snapshots are, how they're different from regular backups, and how to restore from them from RDS as well. Finally, we'll go through working with highly available SQL Servers by using multi-availability zone deployments on RDS.

Known Service Limitations
Hi. This is Warner Chaves at Pluralsight. Welcome to module six of the Implementing SQL Server on Amazon RDS course. In the previous module we learned about backups, snapshots, and high availability with SQL Server on RDS. In this module we'll learn about the known service limitations. In this module we'll go over the known limitations for SQL Server on RDS. Because it is not a full version of SQL Server, but is a version managed by Amazon, we need to know that some things are not exactly the same and might limit your migration to RDS. In the case where there's a possible work around we'll also explore it.