InfoQ Homepage Relational Databases Content on InfoQ

Articles

RSS Feed

Newer Older

Testing SQL Server Code with TST

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.

Roopesh Shenoy
on Jun 18, 2012
CAP Twelve Years Later: How the "Rules" Have Changed

The CAP theorem asserts that any networked shared-data system can have only two of three desirable properties (Consistency, Availability and Partition Tolerance). In this IEEE article, author Eric Brewer discusses how designers can optimize consistency and availability by explicitly handling partitions, thereby achieving some trade-off of all three.

Eric Brewer
on May 30, 2012
AI, ML & Data Engineering

Using Entity Framework to Successfully Target Multiple Databases

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.

Yevhen Shchyholyev
on Jul 25, 2011
Making Microsoft Sync Framework work with PostgreSql

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.

Roopesh Shenoy
on Mar 18, 2011
Scout - Extensible Server and Application Monitoring

Scout is an extensible server and application monitoring service which focuses upon ease of installation and configuration. Scout offers default alerts to help administrators understand how the application is behaving under various loads as well as allowing developers to create plugins to extend Scout.

Robert Bazinet
on Feb 16, 2010
SQL Server Reporting Services and Working with Overlay Data

In this article, Grzegorz Gogolowicz and Trent Swanson tackle the problem of generating reports in SQL Server Reporting Services when the source is scanned images and other supplied formats yet a fixed layout report or pixel perfect report is the desired outcome.

Grzegorz Gogolowicz Trent Swanson
on Jun 11, 2009
Using Ruby Fibers for Async I/O: NeverBlock and Revactor

Rails 2.2 is schedule to be thread safe - but will blocking I/O libraries make it necessary to run multiple Ruby instances? We take a look at how non-blocking I/O and Ruby 1.9's Fibers help solve the problem. We talked to Mohammad A. Ali of the NeverBlock project and Tony Arcieri of the Revactor project.

Werner Schuster
on Aug 28, 2008
Java Object Persistence: State of the Union

In this virtual panel, the editors of InfoQ.com (Floyd Marinescu) and ODBMS.org (Roberto V. Zicari) asked a group of leading persistence solution architects their views on the current state of the union in persistence in the Java community.

Carl Rosenberger Mike Keith Ted Neward Craig Russell
on Mar 06, 2008
Book Excerpt and Review: Hitchhiker's Guide to Visual Studio and SQL Server

With SQL Server 2000's hitting its end of life date next April, many shops that have been delaying the upgrade to SQL Server 2005 need to start looking at it seriously. This is why we have chosen to review the seventh edition of William Vaughn's Hitchhiker's Guide to Visual Studio and SQL Server.

Jonathan Allen
on Aug 27, 2007
Ruby on Rails case study: ChangingThePresent.org

Bruce Tate, author and CTO of ChangingThePresent.org gives a glimpse inside the day to day operations of ChangeThePresent.org with a broad overview of how his team works, the technology trusted for production environments, tools, and most important Rails frameworks.

Bruce Tate
on Mar 26, 2007