Click here to monitor SSC
  • Av rating:
  • Total votes: 0
  • Total comments: 0
Various Simple-Talk Authors

Database Lifecycle Management Patterns & Practices Library

08 April 2014

Patterns and Practices


Moving Towards Version Controlling Your Database

Source Control

Get Your Database Under Version Control

Continuous Integration

Getting Started With Continuous Integration

Assessing SQL Code Quality

Getting started with automated database testing

Getting started with tSQLt for automated database testing

Getting started with test-driven database development

Release Management

Getting started with database deployments

Getting started with database migration scripts

Getting started with continuous delivery

Managing database releases

Managing infrastructure and configuration for continuous delivery

Monitoring and recovery for database releases

Culture and Organization

Database Lifecycle Management

Agile for Continuous Delivery


Coming Soon:

  • Testing database releases after continuous integration

  • Documenting database releases

  • Reporting for database releases

Various Simple-Talk Authors

Author profile:

A collection of articles from Simple-Talk about Database Delivery.

Search for other articles by Various Simple-Talk Authors

Rate this article:   Avg rating: from a total of 0 votes.





Must read
Have Your Say
Do you have an opinion on this article? Then add your comment below:
You must be logged in to post to this forum

Click here to log in.
Simple-Talk Database Delivery

Patterns & Practices Library

Visit our patterns and practices library to learn more about database lifecycle management.

Find out how to automate the process of building, testing and deploying your database changes to reduce risk and make rapid releases possible.

Get started

Phil Factor
Documenting your SQL Server Database

One of the shocks that a developer can get when starting to program in T-SQL is that there is no simple way of... Read more...

 View the blog

Top Rated

A Start with Automating Database Configuration Management
 For a number of reasons, it pays to have the up-to-date source of all the databases and servers that... Read more...

Archiving Hierarchical, Deleted Transactions Using XML
 When you delete a business transaction from the database, there are times when you might want to keep a... Read more...

Rollback and Recovery Troubleshooting; Challenges and Strategies
 What happens if your database deployment goes awry? Do you restore from a backup or snapshot and lose... Read more...

MySQL Compare: The Manual That Time Forgot, Part 1
 Although SQL Compare, for SQL Server, is one of Red Gate's best-known products, there are also 'sister'... Read more...

Highway to Database Recovery
 Discover the best backup and recovery articles on Simple-Talk, all in one place. Read more...

Most Viewed

Beginning SQL Server 2005 Reporting Services Part 1
 Steve Joubert begins an in-depth tour of SQL Server 2005 Reporting Services with a step-by-step guide... Read more...

Ten Common Database Design Mistakes
 If database design is done right, then the development, deployment and subsequent performance in... Read more...

SQL Server Index Basics
 Given the fundamental importance of indexes in databases, it always comes as a surprise how often the... Read more...

Concatenating Row Values in Transact-SQL
 It is an interesting problem in Transact SQL, for which there are a number of solutions and... Read more...

Reading and Writing Files in SQL Server using T-SQL
 SQL Server provides several "standard" techniques by which to read and write to files but, just... Read more...

Why Join

Over 400,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.