| Session Date/Time (dd-MM-YYYY 24h) | Speaker | Category | Track | Title |
|---|---|---|---|---|
| 10-07-2018 17:00 | Chris Kerswell | Breakout Session (60 minutes) | Database Administration and Development | How to Deliver Database Changes Quicker Whilst Keeping Data Safe |
| 10-07-2018 18:00 | Hamish Watson | Breakout Session (60 minutes) | Database Administration and Development | DevOps and the DBA |
| 10-07-2018 19:00 | John Welch | Breakout Session (60 minutes) | Database Administration and Development | Automating Your Data-Centric Deployment Pipeline |
| 10-07-2018 20:00 | Anthony Nocentino | Breakout Session (60 minutes) | Database Administration and Development | I Needed to Install 80 SQL Servers…Fast. Here’s How I Did It! |
| 10-07-2018 21:00 | Simon Sabin | Breakout Session (60 minutes) | Database Administration and Development | DevOps: What you Should Know Before you Start to Avoid the Pain and Humiliation |
| 10-07-2018 22:00 | Alex Yates | Breakout Session (60 minutes) | Database Administration and Development | DevOps, Dev Data and Data Breaches: 5 Solutions |
Event Date: 10-07-2018 17:00 - Category: Breakout Session (60 minutes) - Track: Database Administration and Development
To achieve this, you need processes that guarantee your data stays protected and changes to your database are flawless, every time, without slowing things down.
This talk will walk you through the key components of extending DevOps to your databases, and discuss methods of protecting personal data across your SQL Server estate. Database DevOps can help you to:
• Establish a reliable, scalable and repeatable process for building, deploying and maintaining databases • increase speed of delivery of database changes • enable faster resolution of issues • reduce risk of losing data during the deployment process • minimize application downtime • Standardize processes across database and application to simplify collaboration • Automate the audit trail to easily demonstrate compliance • free up developers time for more added value work
Event Date: 10-07-2018 18:00 - Category: Breakout Session (60 minutes) - Track: Database Administration and Development
In this session I will demystify the concepts of DevOps and we will look at two aspects of DevOps - Continuous Integration & Continuous Delivery.
Continuous Integration is the practice in which software developers frequently integrate their work with that of other members of the development team. It also involves automating tests around the integrated work
?Continuous Delivery is the next step after Continuous Integration in the deployment pipeline and is the process of automating the deployment of software to test, staging, and production environments.
Database migrations/changes are an area that may not be typically automated or utilise Continuous Delivery.
Through the use of a comprehensive live demo to a running database hosted in Azure the audience will learn the benefits and how to implement Continuous Delivery in their database systems deployment pipeline.
Event Date: 10-07-2018 19:00 - Category: Breakout Session (60 minutes) - Track: Database Administration and Development
Agenda: • Why automating your data-centric deployments is important • What you need to include and why • Testing • Standards checking • Recovery mechanism • Production monitoring • How to get started
Event Date: 10-07-2018 20:00 - Category: Breakout Session (60 minutes) - Track: Database Administration and Development
Event Date: 10-07-2018 21:00 - Category: Breakout Session (60 minutes) - Track: Database Administration and Development
In this session we will go through some principles of a DevOps approach that we have established that underpin how we do DevOps. Some are intuitive and you’ll go “Duh” but others aren’t and its likely these not so obvious ones are the ones that if you don’t follow, in 6 months you’ll have a “Doh” moment when you realise why you should have listened. We will look at areas like: Shift Left, To Share or Not To Share, Test Driven Development, Small Change, Green is King, Monitoring is more important than testing, Changing the wings will the plan is flying.
After this session you should have a grasp of some of the core principles that we believe are essential for any DevOps implementation. You will be able to take them to your project to make your adoption of DevOps even more successful.
Event Date: 10-07-2018 22:00 - Category: Breakout Session (60 minutes) - Track: Database Administration and Development
Unfortunately, in the age of data breaches and tighter regulation it's unwise to give developers access to some types of sensitive production data.
So what do you do?
In this session I’ll talk about the GDPR, anonymisation, pseudonymisation and 5 techniques you can use to provide appropriate data that is as “production-like” as possible (within the legal and technical constraints). I’ll demo these techniques both in raw T-SQL and using some of the Microsoft and third party tools that are available to make the task easier.
After this session you’ll be equipped to discuss the problem with your colleagues in an informed manner and you’ll be able to suggest several several solutions and their relative pros and cons.