BT

Facilitating the Spread of Knowledge and Innovation in Professional Software Development

Write for InfoQ
News Articles Presentations Podcasts Guides

Topics

Choose your language

InfoQ Dev Summit Boston

Discover transformative insights to level up your software development decisions. Register now with early bird tickets.
InfoQ Dev Summit Munich

Get practical advice from senior developers to navigate your current dev challenges. Register now with early bird tickets.
QCon San Francisco

Level up your software skills by uncovering the emerging trends you should focus on. Register now.
The Software Architects' Newsletter

Your monthly guide to all the topics, technologies and techniques that every professional needs to know about. Subscribe for free.

InfoQ Homepage SQL Content on InfoQ

Articles

RSS Feed
Newer Older

  • Don’t jump the SQL ship just yet

    The SQL language has been evolving steadily over the last two decades. At the same time, the verbosity caused by the JDBC API in Java client code and the lack of first class SQL support within the Java language have led to the introduction of ORMs such as Hibernate, which was later standardised into JPA and the Criteria API.If SQL and JPA are diverging, where will our data interaction patterns go?

    Lukas Eder
    on Dec 18, 2013

  • Building Scalable Applications in .NET: Introducing the FatDB Distributed Computing Platform

    Justin Weiler introduces FatDB, a NoSQL DB and a distributed platform built on Mission Oriented Architecture meant to abstract and generalize the essential characteristics of enterprise applications.

    Justin Weiler
    on Jul 22, 2013

  • Exploring the Architecture of the NuoDB Database, Part 2

    In Part 2 of this article the author takes a look at how the transaction system is implemented, the role of the administrative layer, how all components work together and what to expect in the future.

    Seth Proctor
    on Jul 17, 2013

  • Exploring the Architecture of the NuoDB Database, Part 1

    In Part 1 of this article the author introduces NuoDB and covers some of its main features: 3-tiered architecture, nodes are equal peers, Atoms - the fundamental data unit, and the versioning and concurrency system used to handle data update conflicts and implement consistency.

    Seth Proctor
    on Jul 12, 2013

  • The State of NoSQL

    Stefan Edlich, Senior Lecturer at Beuth HS of Technology Berlin, Germany, reviews NoSQL, considering its evolution, financial impact, the standards or their lack of, the current landscape, books, the leaders and some newcomers, concluding that NoSQL is here to stay.

    Stefan Edlich
    on Nov 21, 2012

  • 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
  • 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

  • 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
Newer Articles
Older Articles
BT