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 or SQLite as well as SQL Server. It is intended to be useful to both developers using one of these databases for the first time as well as for those who regularly interaction with multiple databases.
Microsoft Sync Framework is used for occasionally connected clients, for peer-peer applications, and other applications where data needs to be synchronized between multiple data stores. While it doesn’t include providers for non-Microsoft databases, the framework makes it easy to add that support. Roopesh Shenoy demonstrates using PostgreSql.
Scout is an extensible server and application monitoring service which focuses upon ease of installation and configuration.
Grzegorz Gogolowicz and Trent Swanson discuss how to work SQL Server Reporting Services and overlay data on report forms. 3
Ruby 1.9's Fibers and non-blocking I/O are getting more attention - we talked to Mohammad A. Ali of the NeverBlock project and Tony Arcieri of the Revactor project. 1
InfoQ has reviewed William Vaughn's Hitchhiker's Guide to Visual Studio and SQL Server. Also included is a sample chapter.
Popular author Bruce Tate reveals the technical details behind the extraordinary web 2.0 charity site, changingthepresent.org. 9