PartsUnlimited example e-commerce website

• Welcome
• DevOps Practices and Principles
• PartsUnlimited Setup with Visual Studio
• PartsUnlimited Manual Deployment to Azure App Services with Visual Studio and ARM Templates
• CI and CD with Azure DevOps - Quickstart
• Infrastructure as Code
• Azure Automation Runbook Deployments
• Deploy and Configure Azure Resources with ARM Templates
• Azure Automation with DSC
• Deploy Application to Azure Service Fabric
• Deploy Application to Azure App Services
• Deploy Application to Azure Kubernetes Service
• Implement Security and Compliance in an Azure DevOps pipeline
• Configure CD of Azure SQL database using Azure DevOps and Visual Studio
• Azure Deployments using Resource Manager templates
• Continuous Integration and Continuous Deployment
• Continuous Deployment with Visual Studio Team Services
• Continuous Integration with Azure DevOps
• Continous Delivery with Octopus
• Configuration Management For Containerized Delivery
• Working with Containers
• Patching Containers
• Deploy and Manage Container App with Service Fabric
• Deploy and Manage Container App with Azure Container Services
• Continuous Delivery with Windows Containers and Azure Devops
• Continuous Delivery with Windows Containers and Azure Devops
• Testing
• Create and Run Unit Tests for Managed Code
• Testing In Production
• Create a Coded UI Test using Selenium in Visual Studio
• Create a Coded UI Test using Visual Studio
• DevOps for Databases
• Changes Using a State-Based Methodology
• Setup WideWorldImporters sample database Development Environment
• Setup VSTS for Database Development
• Setup SSDT and Sample db with Visual Studio and VSTS
• Setup ReadyRoll in Visual Studio
• Add Environment, Set Variables and Approvals for a Release in VSTS
• Monitor Wait Statistics By Using Power BI
• Merge Code from Two Branches
• Create Manual Release with State-Based Development
• Create Manual Release with Migration-Based Development
• Changes Using a Migration-Based Methodology
• Continuous Intregration with a State-Based Methodology
• Continuous Intregration with a Migration-Based Methodology
• Automated Release to Azure SQL Database in State-Based Development
• Application Monitoring and Feedback Loops
• User Telemetry and Perf Monitoring with App Insights
• Usage Analysis with App Insights
• Feature Flag for Web Applications
• Feature Flag for an API
• Fault Injection with Azure PaaS
• Experimentation and A/B Testing with Optimizely
• Error Reporting and Monitoring with DataDog
• Advanced Feature Flag for Web Applications
• DevOps for Mobile Apps
• Getting Started in Visual Studio App Center
• Distribute a Mobile App in VSAC
• Create, Upload and Run Tests in VSAC
• Connect, Configure and Build Android and iOS Apps in VSAC
• Architecting Distributed Cloud Applications
• Optimistic Concurrency with PostgreSQL source
• Messaging Communication
• Fault Injection for Service Fabric
• Build a Sample Application with Microservices
• Advanced DevOps Practices
• Advanced Feature Flag for Web Applications
• Feature Flag for Web Applications
• Feature Flag for a Mobile Solution
• Feature Flag for an API
• Fault Injection for Service Fabric Hackathon Starter
• Fault Injection for Service Fabric
• Fault Injection for Azure PaaS

This lab will demonstrate how to setup your local database development environment with the sample development database.

DevOps MPP Course Source

• This lab is used in course DevOps200.6x: DevOps for Databses - Module 1.

Pre-requisites:

• Visual Studio 2017
• Local SQL Server 2016 installation (optional)
• SQL Server Management Studio
• SQL Server 2016 SP1 installed locally

Lab Tasks:

• Download WideWorldImporters sample database
• Restore multiple copies of the database

Estimated Lab Time:

• approx. 30 minutes

Task 1: Download WideWorldImporters sample database

In this step, you will get the sample database from the official Microsoft repository.

1. The Microsoft Database Sample Database repository is located at https://github.com/Microsoft/sql-server-samples/. This is the location for all sample databases.

2. We will be using the WideWorldImporters sample database, so naviate to https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0 to find the various versions of WideWorldImporters that are available for download.

3. Download the Azure SQL Database Standard tier .bacpac file for the OLTP version. Since we will deploy to Azure SQL database and use LocalDB, we want this file: WideWorldImporters-Standard.bacpac.

   This should be located on the page below the SQL Server 2016 SP1 versions and Azure SQL Database Premium tier samples.

   

4. Save this file in a location on your local machine.

Task 2: Restore multiple copies of the database

In this step, you will restore the various development copies that are needed for future labs.

1. Start SQL Server Management Studio

2. Connect to your LocalDB instance. The address, by default for Visual Studio 2017, is: (localdb)\ProjectsV13. The connection dialog is shown below:

   

3. In Object Explorer, right-click the Databases folder and click Import Data-tier Application, as shown below.

   

4. Skip the first dialog of the wizard by clicking Next

   

5. On the Import Settings page of the wizard, ensure the Import from local disk radio button is selected. Click the Browse button and navigate to the location of the WideWorldImporters-Standard.bacpac file that you downloaded in the first part of this lab.

   

   Click Next to continue.

6. On the Database Settings page, change the New database name text box to WideWorldImporters-SSDT. The data file path and log file path default to the AppData folder under your local user. Leave these at the defaults.

   

7. Review the Summary page, then click Finish.

   

8. On the Results page, when processing finishes, all items should show success. Click Close once you have reviewed this page.

   

9. Verify that the database has been created by expanding the Databases folder in Object Explorer. There should be a database named WideWorldImporters-SSDT

   

10. Repeat steps 3-9 to create another new database named WideWorldImporters-RR

Summary

In this lab you have downloaded the WideWorldImporters sample database from the official Microsoft repository and restored the various development copies that are needed for future labs.