The holy grail of database development is the ability to treat database objects (tables, views, stored procedures, etc.) as if they were just like any other form of source code. While SQL Server Data Tools doesn’t quite that level, it gets very close.
It’s unthinkable for modern application developers to work without source control. The benefits it brings to software development are so well and so long understood that even lone hobbyist developers will tend to employ a source control system. Yet somehow, databases are often left out. David Atkinson shows how this doesn’t have to be the case with Red Gate’s SQL Source Control.
Automated Testing (unit/integration) is an integral part of any agile development process. However a project with significant logic housed in database code creates severe constraints to writing unit level tests, especially if it is large, complex and depend on data. We will explore the TST framework and a few ideas for writing and maintaining good tests for database code.
Yevhen Shchyholyev discusses some of the problems that the user may face in the process of developing an application with Entity Framework that interacts with Oracle, MySQL, PostgreSQL and SQLite.
Grzegorz Gogolowicz and Trent Swanson discuss how to work SQL Server Reporting Services and overlay data on report forms. 1
InfoQ has reviewed William Vaughn's Hitchhiker's Guide to Visual Studio and SQL Server. Also included is a sample chapter.