Improving database development with source control

2010

TL; DR

This demonstration shows you how to manage database changes using source control within SQL Server Management Studio.

Session Details

This demonstration shows you how to manage database changes using source control within SQL Server Management Studio. Source controlling the database is quick, and lets you track database changes, seeing who made them, when, and why. Source control can work with your continu-ous integration environment so database changes kick off automated tests. This ensures any problems are caught quickly. Once these changes have been tested, deployment to your test or production servers be-comes a simple operation.

3 things you'll get out of this session

Red Gate's previous sessions

The secret to pain-free database deployments? Automation

Starting at version control, we’ll look at typical patterns and practices, how to tackle known challenges, and the safety checkpoints you should plan for as you work towards continuous delivery for databases, and painless deployments.

Social Media, BI, and Bridging The SSMS-VS Divide

In this session, Noemi and Tom explain how they developed a system to import information from Twitter into a SQL Server data warehouse, and to export their analysis into Google Docs using Red Gate tools to help them on their way.

BI Development using SQL Developer Tools

In this session Noemi Moreno, BI Developer and Tom Austin, SQL Tools representative, will show you how to use SQL Developer tools to simplify and enhance your Business Intelligence application.

End-to-end database development has arrived

TBA

How to Monitor your SQL Servers

TBA