SQL in the City Streamed
June 2018

Welcome to the second instalment of Redgate’s free virtual SQL Server training event, SQL in the City Streamed, which streams live every quarter during 2018.

The theme for June 2018's SQL in the City Streamed was Compliant Database DevOps. Data privacy regulations such as the GDPR, HIPAA, and SOX make it essential for SQL Server teams to implement controls and processes for protecting personal data. But this doesn’t mean you need to lock your data away or slow down your development processes.

Redgate’s tools help you to put in place Database DevOps processes that align neatly with data privacy and protection requirements. Enabling database updates and changes to be delivered in a consistent, reliable and repeatable way, while keeping sensitive information safe.

Redgate’s Microsoft Data Platform MVPs, Steve Jones, Grant Fritchey and Kathi Kellenberger (Editor of Simple Talk) head up the speaker line-up, and are joined by other technical experts from the team at Redgate.

The schedule includes sessions to help you learn how to demonstrate compliance with regulations such as the GDPR, reduce your attack surface area, and monitor your entire estate while improving the way you deliver database changes.

  • Discover how to standardize GDPR-compliant processes with Database DevOps
  • Learn how to monitor and keep sensitive data secure
  • Keep up with the latest advances in Microsoft SQL Server and Redgate tools
  • Connect with the Redgate community via the forum

Watch the recording of SQL in the City Streamed June 2018

Register your interest

Register your interest in the next SQL in the City Streamed on September 5 and we'll notify you once it's available for registration.

Session schedule

Time (GMT)Session
12:00PMIntroduction to SQL in the City Streamed
Annabel Bradford, Events Marketing Manager at Redgate
Download slides
12:05PMKeynote: Compliance, Accelerating DevOps Adoption
Grant Fritchey, Data Platform MVP and Product Evangelist at Redgate
Download slides
12:35PMHow to create a living SQL Server data catalog
Richard Macaskill, Product Manager at Redgate

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 organisations 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 estate.

Show abstract
Download slides

1:35PMComfort break / or tune into Redgate Videos
1:40PMHow to minimize the impact of data breaches
Steve Jones, Data Platform MVP and Editor at Sqlservercentral.com

According to Gartner, more than 80% of companies use sensitive data in dev and test. Hackers view non-production environments as a tempting target since they often have less rigorous security controls. In this session, you’ll learn about compliant DevOps strategies for reducing your attack surface area, how to put in place reliable and repeatable processes for protecting personal data, and why data masking is fast becoming a best practice for securing sensitive information in dev and test environments.

Show abstract
Download slides

2:40PMHow to maintain a compliant SQL Server estate
Kathi Kellenberger, Data Platform MVP and Simple Talk Editor

Once you have your data protection policy in place, it’s essential to keep track of your estate to ensure compliance. In this session, Kathi Kellenberger will show you how to detect activity that could be a sign of a data breach caused by unauthorized access, how to restore availability and access to personal data in a timely manner, and how to gain the insights you need to respond before it impacts your business. She will also show you the wider benefits of monitoring your SQL Server estate to improve performance and reduce downtime.

Show abstract
Download slides

3:40PMComfort break / or tune into Redgate Videos
3:45PMHow to optimize your database deployment pipeline for compliance AND release frequency
Tom Austin, Head of Pre-Sales Engineering at Redgate

So you’ve started automating parts of your database deployments. You’ve set up version control, and maybe started thinking about continuous integration.

But those demands keep stacking up – can our database support even more frequent application releases? Can we stay compliant with the latest regulations? What are we doing to eliminate the risk of data breaches in development?

Where do you begin? In this session, including an in-depth demo, Tom Austin will show you why it’s now easier than ever to build these additional requirements into your pipeline, and how you can continue to reap the benefits of more development time for value-added work.

Show abstract
Download slides

4:30PMMaking Your Team’s Code Better
Grant Fritchey, Data Platform MVP and Product Evangelist at Redgate

Getting T-SQL code right can be difficult. The challenge is to avoid common bad practices and write consistently readable code. That challenge multiplies as soon as you find yourself in a team environment with multiple people working on the same T-SQL queries. This session is targeted at showing you multiple methods to enhance your T-SQL while working with a team. You’ll learn mechanisms that lead to better quality T-SQL that is more readable, more consistent, and avoids common pitfalls. Put these practices to work on your own code to make it better and make it easier to work on a team.

Show abstract
Download slides

5:30PMEnds

Speakers

Grant Fritchey

Data Platform MVP, Product Evangelist at Redgate, scarydba.com

Grant Fritchey is a SQL Server MVP with over 20 years experience in IT including time spent in support and development.

Grant has worked with SQL Server since version 6.0 back in 1995. He has developed in VB, VB.Net, C# and Java. Grant volunteers at PASS with the Editorial Committee and is president of the Southern New England SQL Server Users Group (SNESSUG). He has authored books for Apress and Simple-Talk, and joined Redgate as a Product Evangelist in January 2011.

@GFritchey

Steve Jones

Data Platform MVP, Editor at sqlservercentral.com

Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001.

Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.

@way0utwest

Kathi Kellenberger

Data Platform MVP, Editor at Simple Talk

Kathi Kellenberger is the Editor of Simple Talk and a Microsoft Data Platform MVP. She has worked with SQL Server for almost 20 years and has authored, co-authored, or tech edited over a dozen technical books.

Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings.

@auntkathi

Richard Macaskill

Product Manager at Redgate

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.

@DataMacas

Tom Austin

Head of Pre-Sales Engineering at Redgate

Tom is an experienced Pre-Sales Engineer who has worked with Redgate SQL Server tools since 2008. During that time he has worked with hundreds of clients across the globe, from start-ups to FTSE/Fortune 100 companies and everything in between. He specialises in helping clients to improve their approach to Database Lifecycle Management (DLM) and has recently been writing and delivering DLM training courses in Europe and Asia.

Annabel Bradford

Events Marketing Manager at Redgate

Annabel is the Events and Communities Marketing Manager at Redgate, and has 10 years’ experience in community and events marketing. For the past 7 years she’s specialised in creating, organising, marketing, and managing events and community marketing for Redgate software.

@abjbradford

“SQL in the City is a great opportunity to see what's coming next from Redgate, as well as a chance to get some free training. The presenters are knowledgeable and their enthusiasm is contagious. Watch and learn.”