Git Product home page Git Product logo

mcw-sql-server-hybrid-cloud's Introduction

This workshop is archived and is no longer being maintained. Content is read-only.

SQL Server hybrid cloud

Fabrikam Publishing is a media and publishing company in Seattle, Washington with approximately 5000 employees. They have a successful direct-to-consumer e-commerce site built with .NET, and they use SQL Server to store customer profile and order information.

They are interested in increasing the availability of their e-commerce application and have selected using Microsoft Azure as a fail-over target. They are interested in designing a solution where their application can be deployed on-premises as well as in the cloud, so if either location has an outage their application is available.

June 2020

Target audience

  • Infrastructure Architect
  • Database Administrator

Abstracts

Workshop

In this workshop, you will work with a media publishing company to design a hybrid cloud disaster recovery solution. You will design the solution to handle large spikes in load and harden the security to include encryption of Payment Card Industry (PCI) data. Additionally, you will implement an archival strategy to keep databases sizes in check.

At the end of this workshop, you will be better able to design a hybrid disaster recovery solution between an on-premises VMWare environment and Azure. In addition, you will design a SQL Server scale-out solution, protect database backups from local failures, archive cold data from an on-premises SQL Server, and perform end-to-end encryption on sensitive application data.

Whiteboard design session

In this whiteboard design session, you will look at how to design an application for hybrid deployment between on-premises and Microsoft Azure. You will consider how the web tier must be made available in the event of an outage as well as how to configure SQL Server Always-on Availability Groups to deploy and failover between both locations.

At the end of this whiteboard design session, you will be better able to design a hybrid disaster recovery solution between an on-premises VMWare environment and Azure. In addition, you will design a SQL Server scale-out solution, protect database backups from local failures, archive cold data from an on-premises SQL Server, and perform end-to-end encryption on sensitive application data.

Hands-on lab

In this hands-on lab, you will build a disaster recovery site for an on-premises environment. You will enhance the existing database solution to support a hybrid cloud-based disaster recovery solution, implement an archiving strategy and a backup/restore strategy designed to protect data.

At the end of the lab, you will be better able to design and use availability sets, Managed Disks, SQL Server Always on Availability Groups, Stretch DB and SQL Server Managed Backup.

Azure services and related products

  • SQL Server (On Prem)
  • Azure SQL Database
  • Azure Site Recovery
  • Azure Traffic Manager
  • Azure Storage

Azure solutions

Data Modernization to Azure

Related references

mcw-sql-server-hybrid-cloud's People

Contributors

andrewconniff avatar dawnmariedesjardins avatar hopero929 avatar microsoftopensource avatar msftgits avatar mwasham avatar paulopsgility avatar thesqlpro avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

mcw-sql-server-hybrid-cloud's Issues

Consistent Diagrams

Let's edit those diagrams into a consistent style, representing current standards for icons, etc. Every diagram appears to represent a different generation of style at the moment.

Step 3: Present the solution

The text says:

"Determine which table will be paired with your table before Step 3 begins."

Which is "your table"?

I think this should probably read, "Check the pairing of tables before step 3 begins."

Remove student guide from trainer guide

I suggest removing the student guide content from the trainer guide. There is a risk of difference between them, potentially leading to confusing instructions from trainer to student.

HTML files

Once merge conflict is resolve, just need HTML files updated to complete. ๐Ÿ‘

January 2020 - content update

This workshop is scheduled for a January 2020 content update. Please review open issue #22 and give your suggestions for further changes recommended for SME review.

SQL VM Resource Provider

Request from @nderhem "We now have an option to register SQL VMs with Resource Provider which adds a lot of benefits to our customers. Is this something we can inject into this MCW?"

Reevaluate this at the next update.

September 2019 - Content update

This MCW is scheduled for content update.
Opsgility - please review current content and recommended updates for SME review.

Customer Objections

PPT - Slide 11 lists 8 Customer objections
PPT - Slides 34 - 40 - answer 7 customer objections
WDS Trainer guide & student guides have 7 customer objections

Need to review and correct please.

Update Readme file

Please update readme file to include:
Introduction
New abstract format

Content review scheduled

This workshop is scheduled for an update. Please review the contents of this repo and comment on this issue with suggested updates. All suggestions must be added to this issue by EOD November 12, 2018.

WDS - student/trainer guides

Trainer guide: Plan for high availability and disaster recovery. The student guide asks 5 questions. The 5th question is to diagram the solution. The trainer guide does not include a diagram in the preferred solution section.

Trainer guide: Same as above with Offsite backup

June 2020 Update Suggestions

Here are our suggested updates for the June 2020 update. Please add any other suggestions or feedback to this issue.

  • Update diagrams to use new Azure icons
  • Update to SQL 2019
  • Add Key Vault to lab
  • Add Always Encrypted with Secure Enclaves

December Updates

Update diagrams for more consistency. This was logged as an issue.

Updates:
โ€ข Key management enhancement for architecture diagram etc
โ€ข Backup enhancement to use Azure Backup and a process for recovery of stretched database
โ€ข Deeper requirements/details for ASR failover scripting
โ€ข Add requirement for testing DR site (How to do this with a transactional database)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.