SQL Supper - April 2018

Date: 
Tuesday, April 17, 2018 - 18:00
Source: 
SQL Supper
Attendees: 
57
City: 
London

Hello!

Better late than never, and we've secured the hospitality of the Microsoft Reactor site once again!

Our first talk is from Mark Allison, and he will be talking about implementing monitoring within your DevOps process to prevent releasing code that will cause performance issues.

And then we have Richard Macaskill sharing practical advice on keeping track of your database estate.

The SQL Supper Team

Agenda

18:00 - 18:30 : Doors open

18:30 - 19:00 : Mark Allison - Using a performance tool to automatically prevent performance problems in a DevOps pipeline

19:00 - 19:30 : Pizza, beer and networking

19:30 - 20:30 : Richard Macaskill - Show me, don't just tell me!

Talk summary:

Mark Allison - "Using a performance tool to automatically prevent performance problems in a DevOps pipeline"

In this demo-heavy session (only 1 PowerPoint slide, hooray!), Mark will demonstrate how you can harness a performance monitoring tool in a DevOps pipeline to automatically prevent deployments being shipped to production. By comparing baseline data and configurable performance thresholds, performance metrics can be measured at deployment time and used as inputs to quality gates in VSTS.

Bio: Mark Allison (@dataguzzle) is a DevOps Data Engineer working for Sabin.IO. Mark started on SQL Server 4.21 on OS/2 Warp :D, and has worked on every version since, including 2017 and Azure. He has worked as a DBA, a database developer, architect and now Devops Engineer. He received MVP award for SQL Server between[masked].

Richard Macaskill - "Show me, don't just tell me!" Data mapping for a new era of oversight

Abstract: Protecting data can be difficult. With data often spread across a growing number of different environments, it's hard to know what to restrict and where it's located. This risks non-compliance, and leaves organizations open to data breaches. Article 30 of the GDPR (Records of processing activities), requires organizations to not just "maintain a record of processing activities…" but also to "make the record available to the supervisory authority on request." But it doesn't tell you how. In this session you'll learn about practical steps you can take to create a durable and living record of what you hold in your SQL Server estate.

Richard is a Product Manager at Redgate, having previously spent almost 20 years in IT management, database administration and development for Insurance and Financial Services firms in London, back-filling other roles along the way. He spends much of his time boring anyone in earshot about the DevOps and automation implications of financial compliance and audit.

Microsoft Reactor

70 Wilson Street