SQL in the City Streamed
September 2018

Welcome to the third instalment of SQL in the City Streamed, live every quarter during 2018.

The theme for September 2018's SQL in the City Streamed was Adapt and thrive as a data professional. At Redgate we recognize that companies from all industries are facing new challenges and need to stay agile to survive. As data professionals you may need to rethink how you work in this era of disruption and ensure you’re best equipped to keep up with or, better still, be ahead of your competition.

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

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 what’s needed to sustain your career in today’s constantly changing climate
  • Discover how best to monitor your SQL Server estate in the cloud
  • Find out how to expand your skills in Azure and analytics
  • 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 September 2018

Register now

Register now for the next SQL in the City Streamed, live streaming on December 12 2018.

By registering for SQL in the City Streamed you're signing up to be notified about SQL in the City, other upcoming livestreams, webinars, and physical events, and news from Redgate.

Session schedule

Time (GMT)Session
12:00PMIntroduction to SQL in the City Streamed
Meet the livestream speakers as they introduce their favorite areas of the Redgate Hub.
Annabel Bradford, Events Marketing Manager at Redgate & all livestream speakers
12:05PMKeynote: Adapt and Thrive
Kendra Little, Microsoft Data Platform MVP and Product Evangelist at Redgate

Do you know where your career is going? Do you know what skills you need to be successful in the current climate? This keynote will discuss the challenges, as well as the opportunities facing you as a data professional in this ever-changing landscape. You’ll also hear recommendations about which skills are needed to help you succeed in your role and how you can in turn support your IT team and business’ needs.

Show abstract
Download slides

12:35PMYes, You Should Monitor Azure SQL Database
Grant Fritchey, Microsoft Data Platform MVP and Product Evangelist at Redgate

Since Azure SQL Database is online and fully managed by Microsoft, there’s just no need to monitor any more, right? Wrong. Monitoring Azure SQL Database is still a necessary part of understanding how your system is behaving. This session will show you the important metrics that you need to track on your Azure SQL Databases. Learn how you can better support and maintain your cloud-based offerings through SQL Monitor, which already has these metrics built in to its data collection. Monitoring Azure SQL Database ensures that you have the information needed to make necessary decisions about your databases in a timely and accurate manner.

Show abstract
Download slides

1:25PMWise Up and Get on the Redgate Hub
Chris Kerswell, Pre-sales Engineer at Redgate & Chris Unwin, Data Privacy and Protection Specialist at Redgate

The Redgate Hub has something for everyone, and is the go-to place for sharing ideas, solving problems, and getting the most from your Redgate products. This session will give you a taste for everything the Hub has to offer – from sharpening your skills with in-depth technical articles to engaging with SQL Server community.

Show abstract
Download slides

1:40PMComfort break / or tune into Redgate Videos
1:45PMAzure Machine Learning 101
Kathi Kellenberger, Microsoft Data Platform MVP and Simple Talk Editor at Redgate

The skills needed for database professionals are constantly evolving. Data science will see tremendous growth over the next few years, and will be a highly sought after skill. If you are interested in learning more about data science, you should know about Azure Machine Learning Studio, a service that is available in a free tier. In this session, Kathi will cover the concepts of machine learning and how to use Azure Machine Learning Studio to create a predictive model. She will also tell you how you can get free training from Microsoft to learn even more.

Show abstract
Download slides

2:30PMStrategies for Solving Compliance Challenges for the Technology industry
Steve Jones, Data Platform MVP and Editor at SQLServerCentral & Chris Unwin, Data Privacy and Protection Specialist at Redgate

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 the challenges that we, as technology professionals, face in our software development and administrative work. Learn compliant DevOps strategies for reducing your attack surface area by ensuring you know where sensitive data is located and avoid copying that data to non-production environments.

Show abstract
Download slides

3:00PMAutomating Database Deployments on the Microsoft Stack
Rob Richardson, Software Craftsman and Microsoft MVP

Are your automation practices accounting for the database? How do you verify database software quality? Most importantly, how do you care for customer data as the schema evolves? Let's dig into building a CI/CD pipeline for databases.

We'll leverage SQL Change Automation, TeamCity, and Octopus Deploy for automation to set up a simple and powerful build & release system that removes the fragility and ensures consistent quality delivery

Show abstract
Download slides

4:00PMComfort break / or tune into Redgate Videos
4:05PMPanel Discussion Q&A: Skillsets for a Successful Career
Host: Steve Jones
Speakers: Grant Fritchey, Rob Richardson, Kathi Kellenberger
4:50PMThe Latest from Redgate’s Product Teams
Hear from our development teams as they share their latest product releases. Much of what our teams are working on is based on feedback from our users
5:10PMRepeat of Keynote: Adapt and Thrive
Kendra Little, Microsoft Data Platform MVP and Product Evangelist at Redgate

Do you know where your career is going? Do you know what skills you need to be successful in the current climate? This keynote will discuss the challenges, as well as the opportunities facing you as a data professional in this ever-changing landscape. You’ll also hear recommendations about which skills are needed to help you succeed in your role and how you can in turn support your IT team and business’ needs.

Show abstract
Download slides

5:40PMEnds

Speakers

Grant Fritchey

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

Grant 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 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

Kendra Little

Microsoft Data Platform MVP, Evangelist at Redgate Software, littlekendra.com

Kendra is a Microsoft Certified Master and a Microsoft MVP. She has taught developers and DBAs around the world to write fast, reliable code for SQL Server.

Kendra fell in love with the challenge of deploying software to a complex database environment when she worked in a build operations team at a software startup. She went on to manage and deploy changes to performance critical databases at Microsoft Corporation, working with systems from internal source control databases to customer-facing very large databases (VLDBs). Since then, Kendra has worked internationally as a trainer and consultant, specializing in performance tuning and practical code patterns for SQL Server. She joined Redgate as a Product Evangelist in 2018.

@Kendra_Little

Rob Richardson

Software Craftsman and Microsoft MVP

Rob is a software craftsman building web properties in ASP.NET and Node, Angular and React. He’s a Microsoft Visual Studio MVP, published author, frequent speaker at conferences, user groups, and community events, and a diligent teacher and student of high quality software development. You can find this and other talks on his blog at https://robrich.org/presentations.

@rob_rich

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

Chris Kerswell

Pre-Sales Engineer at Redgate

Chris joined Redgate in March this year, 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.

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