Continuous Integration

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.

• 119 SQL Code Smells
• Basic Defensive Database Programming Techniques
• Ten Common SQL Programming Mistakes

Technical articles on the art of database design.

• Better Ways to Build a Database
• Defusing Database Time Bombs: Avoiding the Need to Refactor Databases

Get started applying automated testing to your database code with this article collection, covering the basics of applying routine testing to your databases and working with test data.

• Close These Loopholes in Your Database Testing
• Generating Test Data in TSQL
• Managing Test Data as a Database CI Component – Part 1
• Managing Test Data as a Database CI Component – Part 2
• Routine SQL DML Testing for the Unenthusiastic Tester

Learn how to develop with database continuous integration using popular tools like Jenkins to move from static database releases to automated builds as part of a devops development pipeline.

• What is database continuous integration?
• Database Continuous Integration with SQL CI and Jenkins
• Implementing Continuous Integration for Databases
• Database Build Automation – The First Step to Continuous Integration
• Introduction to Continuous Integration Servers

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.

• Test-driven Database Development – Why tSQLt?
• Test-driven Database Development – Why Bother?

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.

• Getting Started Testing Databases with tSQLt

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

• Collect Your SQL Server Auditing and Troubleshooting Information Automatically