microsoft/mcw-sql-server-hybrid-cloud

MCW SQL Server hybrid cloud

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

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.

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

March 2019 - Scheduled content update/lab addition

@mwasham @Jeff-Opsgility
Opsgility team -
This workshop is scheduled for an update/lab build. Please update this issue with suggested content changes. Once done, we will assign to our SME team for review and additional feedback.

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.

HTML files

Once merge conflict is resolve, just need HTML files updated to complete. 👍

all issues resolved

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.

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.

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)

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."

Update Readme file

Please update readme file to include:
Introduction
New abstract format

AdventureWorks is not available in the SQL server

In Exercise 1 Task 2, we are asked to select the AdventureWorks in SQL server Management studio and AdventureWorks is not available.

ready for qc

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.

September 2019 - Content update

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

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

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.