PASS Data Community Summit logo

PASS Data Community Summit 2023

Get all the latest announcements direct to your inbox

DevOps, Continuous Delivery & Database Lifecycle Management

This Simple-Talk library links you to free articles from industry experts on the topics of DevOps, Continuous Delivery and Database Lifecycle Management. Reading materials cover best practices and processes for moving towards more agile methods of database delivery. From improving database development practices, to automating the build and deployment of database changes and monitoring their impact in production, you will find a wealth of information to help you get started.

Culture and Organization

Development isn't just a technical discipline - this article series covers the soft skills that help ensure a project goes smoothly.

Agile for Continuous Delivery

Agile and Continuous delivery should go hand in hand, but it's not always easy to turn good intentions into results. These articles examine how to move an organisation towards continuous delivery.

Database Lifecycle Management

This collection of articles covers Database Lifecycle Management - what you gain from moving your database to an automated release process, how to get there from static releases, and the challenges you will face along the way.

DevOps

This Simple-Talk library links you to free articles from industry experts on the topics of DevOps and Continuous Delivery. Reading materials cover best practices and processes for moving towards more agile methods of database delivery. From improving database development practices, to automating the build and deployment of database changes and monitoring their impact in production, you will find a wealth of information to help you get started.

Patterns and Practices

This Simple-Talk library links you to free articles from industry experts on the topics of DevOps, Continuous Delivery and Database Lifecycle Management. The articles cover best practices and processes from getting started with version control, gradually moving towards more agile methods of database delivery. From improving database development practices, to automating the build and deployment of database changes and monitoring their impact in production, you will find a wealth of information to help you get started.

Manual

Manual deployment processes.

Moving Towards Version Controlling Your Database (1)

Moving your database under version control is not just safer, it makes it easier working with teams and helps you move towards shorter development cycles and more rapid releases.

Continuous Integration

Articles on continuous integration.

Assessing SQL Code Quality (3)

Not all T-SQL is created equally. Whether you're refactoring your code or you've inherited a database with some interesting behaviors, these articles will help you work through the issues and fend off future problems.

Getting started with test-driven database development (2)

Test-driven development is one of the key methods for bringing in shorter release cycles to your software development, but the database can be a blocker. Here we show how to apply TDD to the database so it can be a full part of the devops release lifecycle.

Getting started with tSQLt for automated database testing (1)

Testing with tSQLt is popular because it allows you to write tests natively in T-SQL, making it a natural fit for database developers. These articles will help you get started writing tests for your databases.

Monitoring Database Health (1)

These articles will help you get started monitoring the health of your databases so you can fend off problems before they become critical issues.

Automated Deployment

Articles on automated deployment.

Getting started with continuous delivery (3)

Continuous delivery for the database is key to moving to a rapid-release cadence for your data applications, and these articles are a strong foundation for making database deployments safe and repeatable.

Getting started with database deployments (5)

Getting the database deploying automatically alongside your applications greatly simplifies a full devops development pipeline - these articles will give you a grounding in the processes you need to know to start automated database deployments.

Getting started with database migration scripts (2)

Migration scripts are a vital part of database deployments, and these articles will help you understand what you need to know to help bring your databases into an automated deployment process.

Managing database releases (3)

Releasing your database alongside the application isn't impossible, but it does require careful configuration and monitoring to ensure deployment goes smoothly and to ensure rollbacks are both possible and smooth.

Managing infrastructure and configuration for continuous delivery (4)

What are the best practices for your database infrastructure in a continuous delivery development environment? These articles will help you set up your servers and configure your databases for devops practices.

Monitoring and recovery for database releases (2)

Working with databases in automated deployment development environments can present challenges, but with the correct monitoring and recovery preparations it's straightforward to bring the database along on the devops journey.