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.

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