Southampton and Reading Data Platform and Cloud Meeting - 5th May 2021

Welcome to Southampton Data Platform and Cloud Group.

Please join us for some great quality content, and feel free to supply your own pizza!

We hope we'll be back to in person events in the future, please bear with us for the time being.

Agenda

18:30 Welcome and Intros

18:45: Rob Sewell - Introduction to Azure Arc Enabled Data Services

Azure Arc Enabled Data Services allow you to provide the capabilities, functionality, and ease of management of Azure Data Services but hosted on your own infrastructure. This allows you to get all the latest Azure Data innovations, elastic scaling, and a single pane for all your data workloads with or without a direct connection to the cloud.

Being able to host your own PaaS services, no longer worrying about patches, upgrades and utilising system managed backups but still being able to manage those services from the Azure Portal and utilise Azure Monitor and Security systems will be appealing to many organisations who cannot fully migrate to the cloud or who want the ability to move to a different cloud provider in the future.

This service is in Public Preview and evolving all the time but in this session we will explore the current capabilities so you can understand what the service is able to offer.

19:45: 5 minute break

19:50: Kamil Nowinski - Databases with SSDT: Deployment in CI/CD process with Azure DevOps

When working on a database in SSDT, there is a need to deploy our changes to further environments and at the same time maintain the consistency of databases between environments. During the session, I will present how we can publish the solution manually and then go to the Continuous Integration and Continuous Deployment process using the Azure DevOps environment (formerly VSTS). In addition, we will work on inserting the unit tests, approval steps and the others using Pester and PowerShell in order to gain full automation in our database deployment process.

SSDT allows you to import and maintenance a database project within Visual Studio. Prepare a few steps more to test and deploy changes and data into target SQL Server with Azure DevOps pipelines.

Speaker Bios:

Rob Sewell:
Rob was a SQL Server DBA with a passion for Powershell, Azure, Automation, and SQL (PaaS geddit?). Now he just helps people. He is a Cloud and Data Center MVP and a Data Platform MVP, an officer for the PASS DevOps Virtual Chapter, co-leader of Data South West and PSConf EU organiser and has spoken at and volunteered at many Data and PowerShell events all over the world. He is a proud supporter of the Data and Powershell communities.

Twitter: @sqldbawithbeard
Linked In: linkedin.com/in/robsewellsqldba
Blog: blog.robsewell.com (blog)

Kamil Nowinski:
Blogger, Speaker, Microsoft Data Platform MVP. Group Manager & Analytics Architect. MCSE Data Management and Analytics
For many years tied with Data Community Poland (former PLSSUG), between 2012-2018 acted as a Member of the Audit Committee. He worked a couple of years as a volunteer and now as a co-organizer and speaker of the biggest SQL Server conference in Poland (SQLDay).

Twitter: @NowinskiK
Linked In: linkedin.com/in/kamilnowinski/
Blog: sqlplayer.net