Azure Dev Ops CICD Real World Example David

Azure Dev. Ops CI/CD Real World Example David Brinn - Factal Data

David Brinn The CTO and director of Factal Data and is also one of the hosts of Data Swindon. Worked with the Microsoft data platform for over 20 years as a DBA, Dev, SSIS Dev and everything else in between. Lives and breaths anything technical and the Microsoft data platform is as much a hobby as a profession. Introduction Factal Data is a data and cloud consultancy based in Chippenham, Wiltshire. We are newly formed but backed by over 20 years of experience in Data and Cloud projects for organisations of all sizes and levels of data maturity. We specialise in Microsoft data products, Azure and AWS and are also founding members of the Data Swindon user group. Our aim is to become a trusted partner rather than just a provider of a single service or product. We are confident in our services and offer a free consultation without any obligation. We are a lean and customer focused start up and keep our costs to a minimum so that we can pass on the savings to our customers.

Firstly, what is Dev. Ops? A compound of development (Dev) and operations (Ops), Dev. Ops is the union of people, processes and technology to continually provide value to customers. Introduction to Azure Dev. Ops How can Microsoft help? A single portal that provides the following integrated tools: • Continuous integration and continuous delivery (CI/CD) Azure Dev. Ops Pipelines • Version control / Infrastructure as code - Azure Dev. Ops Repos • Agile software development - Azure Dev. Ops Boards / Artifacts • Automated testing - Azure Dev. Ops Test Plans

Azure Dev. Ops Pricing • Open source projects are free for the first 5 users • Other projects are then free for the first 5 users £ 4. 48 per user per month • Larger teams should contact Microsoft for a price

Overview of Azure Dev. Ops • Overview - Summary, stats and users of the project • Boards – Agile project boards, backlogs and sprints • Repos – Source control, code checked in from Visual Studio • Pipelines – Build and release pipelines CICD • Test plans – Automated Test plans • Artifacts – Contains Nu. Get, CI/CD packages

Prerequisites and setup Setting up the build server by installing SSDT / Visual Studio, connectivity to the receiving servers user accounts and permissions, adding the Visual Studio project to source control and checking in or committing the project, don’t forget to setup the SSIS Catalog Azure Dev. Ops Pipelines App pool and the build agent Creating the Agent Pool in Azure Dev. Ops and Installing the build agent The build pipeline Creating and running the build pipeline The release pipeline Creating and running the release pipeline Setup the CI/ CD Updating the Build and release pipelines to enable CI/CD

Demo time…

Thank You, Any Questions? Thank you for listening to my session and please feel free to get in touch if you want to setup Azure Dev. Ops in your organisation. David. Brinn@Factal. Data. com www. Factal. Data. com