How To Become A SQL Server Cloud Architect on AWS
Posted by Superadmin on June 12 2023 08:27:37

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


01_001 Course Introduction. What Will We Be Doing and Is It Right For You/h1>



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


01_002 Services We Will Be Talking About In This Course..html



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


01_003 What Is a Cloud Computing Lets Define it Before We Look At Amazons Take.



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


01_004-Amazon AWS Overview



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


01_005 Amazon RDS Overview. RDS Stands For Relational Database Services.



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


01_006 Summary. Lets Wrap Up What Weve Learned About the Cloud and AWS..html



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


01_007 Errata. The User Guides For AWS Are Living Documents..html



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


02_001 Download Course Material Here..html



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


02_002 Creating an Account in the AWS Free Tier. There is one Caveat You Should Know.



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


02_003 Monitoring Our Cost. How Much Do We Owe



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


02_004 Summary. Lets Wrap Up What Weve Learned About the Cloud and AWS..html



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


03_001 The Two Approaches To Putting SQL Sever in The Cloud.



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


03_002 What is EC2?



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


03_003 Creating A SQL Server Instance Inside of EC2.



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


03_004 Whats a Virtual Private Cloud Lets Get A 1000 Foot View of VPCs.



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


03_005 Summary. Let's Wrap Up What We've Learned About Other AWS Services.



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


04_001 Blueprint for Spinning Up Our Instance in RDS..html



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


04_002 Instance Specifications - Our First Three Options.html



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


04_003 Instance Specifications - Our Fourth Option is DB Classes



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


04_004 Instance Specification - Our Fifth Option is About Availability Zones



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


04_005 Instance Specification - Our Sixth Option is About Storage Selection



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


04_006 Instance Specification - Our Seventh Option is Database Settings.html



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


04_007 What is SSL Our Next Option Will Deal With Security So Lets Set The Backdrop



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


04_008 Our Eighth Option Will Deal With Database Parameters



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


04_009 The Ninth And Final Option is Backups.



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


04_010 Limits For SQL Server Databases. There Are Some Big Ones. Pay Attention Here.



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


04_011 Cloud VS Local. A Simple IO Test Before You Move Your Database to The Cloud



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


04_012 Summary. Lets Wrap Up What Weve Learned About RDS..html



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


05_001 Create A Highly Available RDS Instance and Fail it Over



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


05_002 Using Snapshots. Creating, Restoring and Renaming. A Snapshot is a Backup



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


05_003 Vertically Scale An Instance With the Click of A Button



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


05_004 Monitoring Our Instances With ClouldWatch. This is Amazons Perfmon.



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


05_005 Summary. Lets Wrap Up Creating A RDS Instance..html



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


06_001 Moving AdventureWorks To The Cloud. The Recommended Approach



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


06_002 Moving AdventureWorks To The Cloud. My Recommend Way.



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


06_003 Scripting Logins From On Premise To Our Cloud. This Will Work For All Servers.



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


06_004 Summary. Lets Wrap Up What Our Schema and Data Migration Tools..html



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


07_001 Interview Questions Specific to AWS and RDS..mp3



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion

How To Become A SQL Server Cloud Architect on AWS

Created by Mike West


07_002 Congratulations and Thank You.html



How To Become A SQL Server Cloud Architect on AWS

 

What you'll learn

  • This Course was Designed for SQL Server DBAs moving their Databases to Amazon's Cloud
  • You will be Architecting SQL Server Instances Using RDS.
  • As an Amazon SQL Server Cloud Architect You'll be Learning the vernacular of Amazon's Cloud.

Requirements

  • You'll need a FREE tier account on AWS but don't create one now. We cover this in great detail before we start the course.
  • You should have SQL Server 2012 installed on your computer. The version is important because currently RDS only supports SQL Server 2008R2 and SQL Server 2012.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
  • You Will Need a Cell Phone. All AWS Accounts use multi-factor authentication. We Will Cover Why At the Start of This Course.

 

Description

This course focuses on moving SQL Server Databases to Amazon's Cloud. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

 

Who this course is for:

  • You will need to have a solid understanding of SQL Server fundamentals.
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to RDS

 

      
Course Contents
01 Getting Our Heads in the Cloud. It Will Soon Be The New Normal 02 Cloud Preparation. Lets Create Our AWS Account 03 Amazon AWS Services We Need to Know Before We Begin With RDS 04 Stepping Through Every Database Option For An RDS Instance 05 Creating Various RDS Instances. Its Time To Get Our Hands Dirty 06 Moving AdventureWorks to the Cloud 07 Conclusion