SQL in the City StreamedWelcome 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.
Watch the recording of SQL in the City Streamed September 2018
| Time (GMT) | Session |
| 12:00PM | Introduction 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:05PM | 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. |
| 12:35PM | Yes, 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. |
| 1:25PM | Wise 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. |
| 1:40PM | Comfort break / or tune into Redgate Videos |
| 1:45PM | Azure 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. |
| 2:30PM | Strategies 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. |
| 3:00PM | Automating 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 |
| 4:00PM | Comfort break / or tune into Redgate Videos |
| 4:05PM | Panel Discussion Q&A: Skillsets for a Successful Career Host: Steve Jones Speakers: Grant Fritchey, Rob Richardson, Kathi Kellenberger |
| 4:50PM | The 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:10PM | Repeat 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. |
| 5:40PM | Ends |
Data Platform MVP, Advocate at Redgate, scarydba.com
Grant Fritchey is a Data Platform MVP with over 30 years' experience in IT, including time spent in support and development.
He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. 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.
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.
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.
Data Platform MVP, DevOps Advocate at Redgate, 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 an Advocate in 2018.
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.
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.
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.
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.”
Compliant Database DevOps
Standardize team-based development
Automate database deployments
Monitor performance and availability
Protect and preserve data
@GFritchey