SQL in the City Streamed
December 2018

Welcome to the fourth and final instalment of our live SQL in the City Streamed events in 2018.

The theme for December 2018's SQL in the City Streamed was Your Journey to Compliant Database DevOps. At Redgate we help IT teams balance the need to deliver software faster with the need to protect and preserve business critical data. Compliant Database DevOps gives you an end-to-end framework for extending DevOps to your database while complying with regulations and protecting your data.

Microsoft MVPs, Kathi Kellenberger (Editor of Simple Talk), Grant Fritchey (ScaryDBA.com), Steve Jones (Editor of SQLServerCentral) and Kendra Little (Founder of SQL Workbooks) head up the speaker line-up, joined by members of the team at Redgate.

The schedule includes sessions designed to broaden your skillset, support your ongoing learning, and keep you up-to-date with what’s new in the industry and at Redgate.

  • Learn why 2019 is a crucial time for you to implement controls to secure private customer data.
  • Discover the four keys which enable you to unlock compliant DevOps within your own organization.
  • Find out how proactive estate monitoring can detect, diagnose, and resolve performance problems.
  • Keep up with the latest advances in Microsoft Data Platform and Redgate tools.
  • Connect with the Redgate community via the Redgate Hub.

Watch the recording of SQL in the City Streamed December 2018

Session schedule

Time (GMT)Session
11:00AMIntroduction to SQL in the City Streamed
Annabel Bradford, Events Marketing Manager
11:05AMKeynote: State of Compliant Database DevOps
Steve Jones, Microsoft Data Platform MVP and Product Evangelist at Redgate
Download slides
11:35AMAdopting best practices to standardize team-based development
Kathi Kellenberger, Microsoft Data Platform MVP and Simple Talk Editor at Redgate

With IT teams under pressure to deliver software more quickly, it’s a challenge to ensure the consistency and quality of code during database development. Even more so for large teams of application and database developers with different ways of working, or geographically-distributed teams in different locations and time zones. Without the right processes or tooling in place, precious time is wasted on tedious rework. Time which should be used for added value development. Microsoft Data Platform MVP and Editor of Simple Talk, Kathi Kellenberger, highlights how adopting best practices like standardized formatting, code analysis, and database version control, saves your developers time, avoids tedious rework, and leaves them free to deliver on value-added work

Show abstract

12:20PMReducing the pain and risk in database deployments
Tom Austin, Head Pre-sales Engineer at Redgate

Transitioning from time consuming, error-prone manual deployments to a reliable, repeatable automated deployment process is a complicated journey, particularly with databases. At Redgate we believe it’s important to support the inevitable process and practice change in ways which reduce disruption for the teams involved. It is crucial that automation solutions allow users to start their journey from familiar ground. In this session, Tom Austin shows how automated database deployment can plug into your existing infrastructure and explains how simplifying the organisational transition to automation is at the heart of our ongoing work on automating database deployments.

Show abstract

Download slides
1:05PMComfort break / or tune into Redgate videos
1:10PMThink your databases are safe? Think again
Grant Fritchey, Microsoft Data Platform MVP and Product Evangelist at Redgate

You may think your databases are secure and you’ve taken all the measures recommended by OWASP, but attacks and intrusion attempts can still take place and the more prepared you are, the best chance you’ll have of thwarting them before they cause actual damage to your estate. In this session Grant Fritchey will go through the steps of detecting and defending against SQL Injection attacks, intrusion attempts, unauthorized configuration changes, database drift and more, using Extended Events and SQL Monitor.

Show abstract

Download slides
1:55PMCrucial data privacy and protection insights for 2019
Richard Macaskill, Product Manager at Redgate & Kendra Little, Microsoft Data Platform MVP and Evangelist at Redgate

A recent Harris poll of more than 1,000 C-Level executives found that 66% of respondents were somewhat to very concerned about the threat that security and data breaches pose to the success of their businesses: this was the #1 concern of all respondents. Now is the time for you to implement protections for data privacy to protect your customers and your organization. In this 45-minute session, Redgate's Richard Macaskill and Kendra Little will share three insights into why 2019 is a crucial time for you to implement controls to secure private customer data, and how you can do so while also accelerating developer productivity and controlling spend.

Show abstract

Download slides
Download the summary PDF
2:40PMComfort break / or tune into Redgate videos
2:45PMThe people behind the products
A look behind the scenes with some of the Redgaters who create our ingeniously simple products. Hosted by Ally Parker, Tech Lead at Redgate.
3:05PMThe four keys to unlocking DevOps
Kendra Little, Microsoft Data Platform MVP and Evangelist at Redgate

Why are some companies successful at transforming their businesses and accelerating technical change, while others fail? In this 30-minute session, Kendra Little will examine the journeys of three famous organizations. She will share the patterns and practices that enable successful companies to catalyze change within their cultures and identify anti-patterns that hinder growth and lead to trouble. In closing, Kendra will summarize the four keys which enable you to unlock Compliant DevOps within your own organization.

Show abstract

Download slides
3:35PMCompliant database DevOps: What resources are available to kick start your journey?
Chris Kerswell, Pre-sales Engineer at Redgate & Chris Unwin, Data Privacy and Protection Specialist at Redgate

Although DevOps adoption is gathering momentum, the database community is still facing challenges on this journey. This session will give you a taste of the resources you can access to start your journey to Compliant Database DevOps.

Show abstract

Download slides


Grant Fritchey

Data Platform MVP, Advocate at Redgate, scarydba.com

Grant is a Data Platform MVP and AWS Community Builder with over 30 years' experience in IT, including time spent in support and development.

Grant has experience with both on-premises, and cloud-based data management, and DevOps. He has experience with multiple development languages and platforms. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. Grant volunteers for PASS and is on the Board of Directors as the Immediate Past President. He joined Redgate Software as a product advocate January 2011.


Steve Jones

Data Platform MVP, Editor at sqlservercentral.com

Steve 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.


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.


Kendra Little

Data Platform MVP, DevOps Advocate at Redgate, littlekendra.com

Kendra Little is a DevOps Advocate at Redgate. Kendra started out in tech as a Build Operations Engineer at a startup and developed into a Senior Database Administrator at a Fortune 100 corporation. She later transitioned into consulting and training, focusing on database performance tuning. Kendra has taught developers and DBAs around the world to write fast, reliable code and to improve tempo and code quality in the software engineering process for databases.


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.


Chris Kerswell

Lead Pre-Sales Engineer at Redgate

Chris joined Redgate in 2018, before which he was a Solution Architect and a Pre-sales Consultant at other software companies. Chris brings experience of working with IT professionals from a wide variety of enterprises of all sizes and verticals, where he focused on helping solve their compliance and productivity challenges.

Chris Unwin

Data Privacy and Protection Specialist at Redgate

Chris is the Data Privacy and Protection Solution Specialist at Redgate. He started his career in SQL Server development and ERP configuration and joined Redgate in 2016. Chris works with a variety of companies, helping many of our global customers solve a variety of challenges; from rolling changes forward efficiently, to providing the best possible data-compliant, pre-production environments.

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.


Ally Parker

Technical Lead at Redgate

Ally is a Technical Lead on the Redgate SQL Monitor team, focussing on delivering estate wide insights to his users. Before joining in 2016, Ally started life as a SQL Developer in the finance sector back in the "good old" SQL 2000/DTS days. He later moved into object orientated back-office systems engineering in C# and subsequently into coding mortgage models on trading desks. Ally is passionate about lean start-up delivery methodologies and customer-centric research and feature development.

“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.”