The DevOps Lab - Channel 9

Damian chats to MVP Thomas Rayner about Azure Automation Runbooks. You don't always need to jump into the portal to get things done in Azure. In this episode, Thomas walks us through how to configure and execute PowerShell inside Azure - all from the commandline! Install Azure PowerShell on Windows with PowerShellGet PSReadLine Create a Free Account (Azure): https://aka.ms/c9-azurefree

Damian talks to Microsoft's Paige Bailey as well as MVP Terry McCann about DevOps for Data Science. These two really popular fields are not often combined, but there are some fantastic opportunities for cross-pollination of ideas. Damian, Paige and Terry discuss what's important to data scientists and where to start when it comes to a DevOps process. From using source control, testing and refreshing predictive models to operationalizing and evaluating success in production. Data scientists are rarely developers, and developers are rarely data scientists, but they can work together, using tools and techniques that still allow the experts to do what they do best! Follow Paige on Twitter: @DynamicWebPaigeFollow Terry on Twitter: @SQLSharkFollow Damian on Twitter: @damovisa Resources: The DataOps ManifestoMicrosoft AI SchoolVisual Studio Team ServicesCreate a Free Azure Account: https://aka.ms/c9-azurefree

How Azure global monitoring team uses VSTS to deploy their Azure Cloud Collab dashboard Damian sits down with Deepak Saini and Vinod Kumar to talk about Continuous Availability. Is it enough to deploy your changes continuously, or is there more you can do for projects that absolutely need to be available all the time? Deepak and Vinod talk about how they use Visual Studio Team Services (VSTS) to deploy the dashboard application at the Azure Cloud Collaboration Centre - a 1,600 square foot video wall that shows Azure availability across the globe! With some clever techniques including randomly selecting regions and infrastructure as code, they can maintain availability through every update. ** Recorded LIVE at Microsoft Build 2018 ** Resources: Azure Cloud Collaboration Center - Blog Post: https://azure.microsoft.com/en-us/blog/the-azure-cloud-collaboration-center-a-first-of-its-kind-facility/Create a Free Account (Azure): https://aka.ms/c9-azurefree

Damian is joined by fellow Aussie Simon Waight at the MVP Summit to talk about deploying Azure Functions with VSTS. Many Azure DevOps demos show how to deploy websites, but there are so many Azure features. Simon shows us how easy it is to deploy Azure Functions, both consumption and service plans, including writing configuration settings and letting Application Insights know about a release. Follow Simon on Twitter: @simonwaightFollow Damian on Twitter: @damovisa Resources: Functions Continuous Deployment demo RepositoryFunctions Continuous Delivery blog postAzure Functions CD on Microsoft DocsSimon's BlogCreate a Free Account (Azure): https://aka.ms/c9-azurefree

Damian talks to Deepak Kaushik about moving data warehousing from on-premises servers to Azure SQL Data Warehouse. Data warehouses are traditionally hosted on physical servers located at central locations that are self-managed, but there's another way! Deepak talks about the advantages of using Microsoft's hosted offering, and walks through how to move from on-prem to Azure. Follow Deepak on Twitter: @ThinkForDeepakFollow Damian on Twitter: @damovisa Resources: Azure Data WarehouseWhat is Azure Data WarehouseDeepak's blog: Why choose Azure Data Warehouse?Webinar on Azure Data WarehouseCreate a Free Account (Azure)

Damian sits down with fellow Aussie and Microsoft Regional Director Troy Hunt to talk about dramatically improving performance for his new Pwned Passwords offering. Troy runs a popular high traffic site - https://haveibeenpwned.com - so amazing performance is a must, even through unexpected traffic spikes. In this episode, Troy shows us how he's dramatically reduced response times for his new Pwned Passwords feature, and explains how that's a win-win for both him and his users. Follow Troy on Twitter: @troyhuntFollow Damian on Twitter: @damovisa Pwned Passwords: https://haveibeenpwned.com/passwordsBlog post: I wanna go fast - why searching through 500m pwned passwords is so quick

Damian meets with Hamish Watson at the MVP Summit to talk about testing your database changes. Unit testing is vital in a good process but tests don't often extend to the database. Can it be done at all? And do DBAs have to learn a new language? Hamish shows us two tools that can help you write database tests, in TSQL, and run them as part of your CI/CD pipeline. Resources: tSQLt: http://tsqlt.org/ Unit Tests for SSDT Projects: https://aka.ms/SSDTTests Hamish's Blog: https://hybriddbablog.com/ Follow Hamish on Twitter: @TheHybridDBA Follow Damian on Twitter: @damovisa

Damian talks to Dylan Smith about building security into your DevOps process. Now that we're deploying to production so regularly, what do the security teams do? How do we make sure none of our changes introduce a new vulnerability. Dylan answers these questions for us and even shows what Microsoft does to help avoid security disasters. Follow Damian on Twitter: @damovisa Follow Dylan on Twitter: @dylan_smith

Damian is joined by Brian Clark to show off some of the cross-platform support in VSTS and Azure. Can you use traditionally non-Microsoft languages and platforms with VSTS and Azure? You sure can! In this short episode, Brian shows a process tying together VSCode on a Mac, a PR process through GitHub, CI builds (on hosted Linux agents), Azure Container Registry hooks, and Azure App Services running containers on Linux. Follow us on Twitter: Damian Brady: @damovisa Brian Clark: @_clarkio Show links: Define a continuous integration (CI) build process for your GitHub repository Build and push a docker image with VSTS Set up an Azure Container Registry webhook Hosted Agents in VSTS Create a Free Account (Azure)

Damian is joined by Abel Wang to show us one way of tracking and deploying database changes alongside your code. The SQL Server Data Tools (SSDT) project type in Visual Studio allows you to keep an up to date version of your code in source control. Visual Studio Team Services (VSTS) natively supports deploying any changes to an SSDT project to your SQL Server instance.