Stairway to Continuous Delivery for Databases
Red Gate's SQL Server MVPs, Steve Jones (Editor of SQLServerCentral.com) and Grant Fritchey (Product Evangelist) will take you on a journey of patterns and practices to bring continuous integration and continuous delivery to your database deployments. Previously thought to be the realm of application development, automating database change management processes is becoming easier, and Grant and Steve will present ways you can introduce automation to points in your database deployment pipeline to result in faster, more reliable releases.
The sessions will start with an overview of the areas to consider as you evolve your release processes towards automation. You’ll see how DBAs and developers can work together to deliver database changes more smoothly. You’ll also get a chance to see different tools in action and how to use some of the Red Gate tools you already have, so that you can put your learning into practice when you’re back in the office.
This seminar is designed for the intermediate database developer and DBA. If you develop software using databases, struggle with deployment problems and failures, manage a development team, or just want to learn more about how others are already using automation to deploy software more often and successfully, this is a must-attend seminar.
Register now to secure your seat for this half-day event.
12:30PM – 12:45PM ~ Attendee arrival & networking ~
1PM - Session 1 –
Session 2 – Version Control for Databases, Getting your database under version control is ultimately a way of communicating and collaborating with team members, maintaining an audit trail and ensuring you always have a version to roll back to.
In this session, we’ll cover why this gives you and your team a crucial advantage in reducing the risk in your development processes. We’ll also discuss another door that your team opens by adopting solid version control: setting up the fundamentals of continuous integration. You will learn what build automation means as a first step towards continuous integration and the value it brings as part of your evolving deployment process. We'll also discuss branching strategies, and how to manage this for databases as part of your evolving deployment process.
~ Break ~
Session 3 – tSQLt is a testing framework designed to help you write repeatable, isolated tests against your database code. In this session, we will briefly examine the goals of testing, where it can be used in an automated deployment pipeline, and introduce you to the tSQLt framework.
You'll learn how to incrementally write tests that help you build higher quality code and minimize the introduction of errors against your existing objects. We’ll show you how to design and write tests to enforce standards, check calculations and other DML operations, and check exception handling. Plus, you'll see how a real world refactoring task can be tested in a repeatable manner.
~ Break ~
Session 4 – Automating Your Database Deployments, Grant Fritchey
Deploying your database changes to production can be nerve-wracking. We’ll discuss methods that take the stress out of the process by ensuring that you practise your deployments using continuous integration before you ever get near production. Automating the deployment and testing processes through your testing and pre-production environments can make the whole experience of production deployments more repeatable, more reliable and more robust.
In this session we’ll explore the concepts of continuous integration and continuous delivery for databases – what to consider, the challenges, the benefits, the testing, and the crucial approval gates necessary for a reliable production deployment. We’ll discuss these and other release strategies as you think about how to evolve your deployment pipeline towards a more automated approach, starting with continuous integration and ending at your production systems.
~ 5.30PM – 6.30PM ~ Happy Hour & continued discussions in the venue bar (Beers and sodas on Red Gate) ~
Register now to confirm your place at this exclusive event, where space is limited.
Special thanks to New England SQL Server User Group for suggesting that this SQL in the City Seminar replace the regular monthly meet-up.
We make the world's most trusted tools for shipping changes to your database.
Our tools are technically challenging to make, but really intuitive to use – a philosophy we call ingeniously simple.
New to Visual Studio Enterprise 2017, extend DevOps processes to SQL Server databases with Redgate Data Tools.
If you have any questions about this event, please get in touch with firstname.lastname@example.org.
Join millions of people on Eventbrite.
In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.