Automate Deployments with Azure DevOps – Erin Dempster (20240227)

Topic:

Moving code from development to QA to UAT and, eventually, production can be a project in itself.  This is especially true when multiple projects might be across multiple repositories.  Keeping track of the correct set of builds for a release can be challenging.  With Azure DevOps, this challenge can be eliminated with pipelines.  This session will step through building and releasing database projects in the same pipeline.  Opportunities for adding approvals will also be covered.

Speaker: Erin Dempster

Erin is currently the Data Operations Team Lead at Trean Corporation in Wayzata, MN, USA. In 2023, Erin was honored as a Microsoft MVP for Data Platform community activity. She has been working with SQL Server for nearly 20 years, both as a developer and a database administrator. Over the past several years, PowerShell and Azure have become areas of interest.

Links:

Azure SQL Database for DBAs – Ameena Lalani (20210831)

Topic:

In this session you will get fundamentals of Azure SQL PaaS (Platform as a Service) options from DBA perspective. I will go over Azure SQL DB and Managed Instance options first and then describe what are the differences between the two and why would you choose one over the other. Azure SQL is a very mature Microsoft product and can handle enterprise level SQL Server workload while providing security, high availability and performance for your data. I will also explain the main differences in supporting databases on-premises versus Azure SQL to alleviate your fears if you have one that is what is blocking you from adopting Azure SQL. If you are a DBA or your organization is considering moving to Azure Cloud, this session is for you.

Speaker:

Ameena Lalani

Ameena Lalani is a SQL Server veteran and started her journey with SQL Server 2000. She works at Microsoft as a Customer Engineer. She has implemented numerous High Availability and Disaster Recovery solutions at various companies. Ameena imparts high quality training to her customers. She is a Microsoft Certified Trainer. She holds other certifications; Azure Associate Administrator and MCSA on SQL Server 2016 Database Administration. She is a co-leader of the Chicago Suburban SQL User Group. Ameena volunteers and speaks about SQL Server and Azure SQL at various community events throughout the United States.

Links: