SQLBits encompasses everything from in-depth technical immersions to the enhancement of valuable soft skills. The full agenda will be announced in the spring; in the meantime check out the timetable and content we cover below.
2024 Training Days
Presenting 2024’s selection of training days, encompassing a deep dive into a range of subjects with some of the best data trainers in the world.
- 08:00 Registration opens and breakfast served.
- All training days run simultaneously across the venue from 09:00 – 17:00 with co-ordinated breaks.
- All training days include regular refreshment breaks and a lunch stop to rest, recharge, and chat to fellow delegates.
- No evening events planned, but if you’re staying over the night beforehand, why not join us in the Aviator on Monday night to meet the training day speakers for an informal drinks reception.
Database Administration
Automate Deployments with Azure DevOps
Description
Developing databases and Azure Data Factory pipelines is just the beginning. Once the code has been committed to source control, moving code between environments can be cumbersome in a manual environment. When multiple databases are involved or database changes need to be deployed with ADF pipeline changes, tracking the proper builds of each solution is critical. Otherwise, the quality assurance team may test incompatible builds, leading to wasted time and potentially allowing unsupported changes to be deployed together.
This session will introduce database developers and administrators to build and release pipelines in Azure Data Factory. Participants will gain hand-on experience, working with a demonstration database and a set of Data Factory artifacts to deploy to a target environment. Additionally, PowerShell will be used to do basic tests to ensure the database and ADF artifacts were deployed correctly. There are many nuances and advanced settings in DevOps, which will not be covered in this course.
This session will introduce database developers and administrators to build and release pipelines in Azure Data Factory. Participants will gain hand-on experience, working with a demonstration database and a set of Data Factory artifacts to deploy to a target environment. Additionally, PowerShell will be used to do basic tests to ensure the database and ADF artifacts were deployed correctly. There are many nuances and advanced settings in DevOps, which will not be covered in this course.
Learning Objectives
Attendees should leave with a basic understanding of Azure Dev Ops build and release pipelines. With this basic knowledge, they will be able to return to their environments and create their own build and release pipelines for databases and Azure Data Factory artifacts. While not directly covered in the session, resources will be provided to show examples of other types of Azure solutions that can be deployed through Azure Dev Ops.
Previous Experience
Understanding of SQL Server database objects (schemas, tables, views, stored procedures, users, etc.)
Experience with Visual Studio and Git repositories.
Exposure to Azure Data Factory is nice
Tech Covered
Azure, Azure SQL Database, Managed Instance, deployment, Database Administration, Developing, Managing, DataOps & Automation