A Senior SQL Server DBA at AlbumPrinter in the Netherlands, Sjors Takes is an advocate of database continuous integration. An expert in SQL Server administration and performance tuning, he builds database deployment pipelines to make the database delivery process as simple and smooth as possible. A member of PASS, Sjors blogs about continuous integration and deploying databases at www.devopsdba.com, is a regular attendee at SQL Server events, and has also been a speaker at SQL in the City.
Continuous integration (CI) is becoming more and more common in application development. It ensures code and related resources are integrated regularly and tested by an automated build system, and highlights problems early in the development process. But what about database development? Can the same advantages of CI be applied to production databases? Where do you start? How do you tackle it? Sjors Takes relates his experience.… Read more