redgate

SQL in the City Streamed

  • April 3, 2019

Welcome to the first of our popular SQL in the City Streamed events in 2019.

The theme for the first SQL in the City Streamed event of 2019 was a topical one – standardizing database change management across your organization. If different teams work in different ways, perhaps using their own tools and processes, inefficiencies creep in. Errors occur as changes move from development through testing to staging and production. Think collaboration, automation, tool and process standardization, and it’s a different story. Workflows are streamlined, errors are minimized, and real value starts being delivered to the business.

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 about the cultural shift necessary to introduce collaboration between and across teams
  • Discover the top ten SQL Toolbelt tips for standardizing and automating database changes
  • See the advantages to be gained by provisioning masked database copies for use in development
  • Hear about the critical role the database now plays in software development
  • Understand the business case for database change management

Watch the recording of SQL in the City Streamed April 2019

Register your interest for the next SQL in the City event

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.

Sign up now

Session schedule

Time (BST)Session
2:00PMOpening Keynote: Why DBAs and Developers Must Redefine 'Change Management'
Kendra Little, Microsoft Data Platform MVP and Product Evangelist at Redgate

Database administrators and IT-minded developers traditionally think of 'Change Management' as a part of the IT Infrastructure Libraries (ITIL) Framework – a bureaucratic approach to managing technical changes which requires assessment and approval for changes near the end of the software development lifecycle (SDLC) for that change.

But these days, the meaning of the term 'Change Management' itself has been transformed: the term now refers to a set of approaches that help individuals and teams manage all manner of changes inside their organizations – including the critical change of shifting risk assessment and change approval to earlier stages in the SDLC.

In this 15 minute talk, Microsoft MVP Kendra Little will share why this mindset shift in redefining change management is critical to the evolving roles of developers and DBAs.

Show abstract

2:15PMGetting Team Collaboration: The Culture Shift
Steve Jones, Microsoft Data Platform MVP and Editor at SQLServerCentral.com

One of the hardest parts of adopting a Database DevOps process is the need to work together and generate synergies during development. This 40 minute session examines how different tools and techniques support a cultural change to a more collaborative process.

Show abstract

2:55PMTop 10 SQL Toolbelt Tips to Standardize and Automate Database Changes
Tom Austin, Head of Pre-Sales Engineering (ROW) at Redgate, and Arneh Eskandari, Head of Pre-Sales Engineering (AMER) at Redgate

The SQL Toolbelt includes all the components that enable Database DevOps. Join Tom and Arneh as they share their top tips for using the SQL Toolbelt to optimize your database development processes.

Whether you're trying to decide how to set things up to implement new workflows, or you’re looking for ways to improve your existing workflows, Tom and Arneh can help. Find out how to save time during database development, reduce the risk of error, ensure your databases are compliance ready, have more confidence when deploying to your target environments, analyze the impact of database changes, and monitor or document those environments.

Show abstract

3:40PMComfort break
3:45PMThe Value of Monitoring at BMW
Tony Maddonna, Microsoft Platform Lead & SQL Server Enterprise Architect at BMW, and James King, Enterprise Account Manager at Redgate

With 100s of servers spanning multiple continents, BMW needed a way to efficiently monitor their large and growing estate. In this session, Redgate's James King speaks with Tony Maddonna, Microsoft Platform Lead and SQL Server Enterprise Architect at BMW, about how the company identified their monitoring need, the process they took to implement it, and the results they are now seeing.

Show abstract

4:15PMEnvironment Provisioning: The Third Age
Grant Fritchey, Microsoft Data Platform MVP and Product Evangelist at Redgate

First, we were hunters.

Creating and refreshing environments for dev/test/UAT by "hitting it 'til it works". Running a restore job using the SSMS wizard. Then running it again from T-SQL after adding the WITH MOVE option to reflect the different disk layout. Then yet again after freeing up some diskspace.

That was the first age of environment provisioning.

Some of us moved onto rubbing sticks together; putting the script into a SQL agent job, scripting out the permissions, and sticking our sledgehammer masking techniques in as a job step. We gathered up our jobs, which often failed and took too long, but that was the way things were. Nobody had told us about the schema change, or the tiny diskspace we were trying to land in.

We were pleased to be hunter-gatherers.

In this session, we discover the third age of environment provisioners. The farmers. Developers, analysts, and others can self-serve, through repeatable and audited processes. In today's age, masking desensitizes environments to mitigate against breaches and ensure compliance, while enabling developers and testers to work with realistic data. Whole environments are delivered at scale with databases customized to their specific security needs.

Learn how you can join the farmers!

Show abstract

5:15PMWhat's New in Product Development at Redgate
Redgaters from across our product teams

A look at what's new in our ingeniously simple products with some of the Redgaters who create them.

Show abstract

5:45PMComfort break
5:50PMPanel Discussion: Database Development Disasters
Data Platform MVPs Kathi Kellenberger, Steve Jones, Grant Fritchey, and Kendra Little

We asked the Redgate community to tell us a true story in 500 words or less about a time when they were involved in an Agile or DevOps project that went full steam ahead in speeding up delivery of application code, but didn't modernize database development practices.

Join Data Platform MVPs Kathi Kellenberger, Steve Jones, Grant Fritchey, and Kendra Little as they talk through the best submissions and reveal the winners of the contest. This is a great session for any database professional who's on the hunt for real-world evidence for why the database should not be an afterthought.

Show abstract

6:30PMGetting Consistent Builds: Fixing Cross-Database Dependencies
Kendra Little, Microsoft Data Platform MVP and Product Evangelist at Redgate

Building database code is critical to Database DevOps: automated builds ensure that you can reliably recreate your schema from source control in a standardized fashion. But building database code is often tricky due to cross-database dependencies. In this demo packed session, you will learn:

  • Which types of cross-database dependencies impact building your code with SQL Change Automation
  • How to quickly validate and test your builds with PowerShell
  • Methods for quickly supplying dependencies without slowing down your builds
  • Coding and build configuration best practices for consistently successful database builds

You'll also get to see Microsoft's new Notebooks feature in action in Azure Data Studio as we script and test our way to a successful build.

Show abstract

6:55PMClosing Remarks
Data Platform MVPs Kathi Kellenberger, Steve Jones, Grant Fritchey and Kendra Little
7:00PMEnd

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

Data Platform MVP, Evangelist 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 a Product Evangelist in 2018.

@Kendra_Little

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.

Arneh Eskandari

Head of AMER Pre-Sales Engineering at Redgate

Arneh has been with Redgate for over eight years. During this time, he has partnered with organizations across a range of sectors, helping them to improve their overall database change management process. Recent projects have included evaluating DevOps maturity, implementing future recommendations such as automation, tackling complex and cross dependent databases, and delivering proof of concepts to large siloed development teams.

James King

Enterprise Account Manager at Redgate

James has been part of the Redgate team for over 8 years. During this time, he has worked with hundreds of organizations from tech start-ups to large institutions within the Fortune 100. As a veteran Enterprise Accounts Executive, he has used his experience across many different industries to help Redgate improve its tools and his customers improve their processes in both database development and estate management.

Tony Maddonna

Microsoft Platform Lead & SQL Server Enterprise Architect at BMW

Tony is the Microsoft Platform Lead & SQL Server Enterprise Architect at BMW. He manages the direction and operation of the Microsoft Platform Team, as well as design and build of SQL Server and its implementation functions globally. He is responsible for setting the parameters and functional use set of Microsoft Platform Services, (.NET, IIS, SQL Server, et al) globally for the BMW Group.

Tony holds a Lean Six Sigma Black Belt and is currently working on the evaluation and design of SQL VNext (2019) for global distribution.

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