BT

InfoQ Homepage SQL Content on InfoQ

Articles

RSS Feed
  • How to Source Control Your Databases for DevOps

    A robust DevOps environment requires having continuous integration for every component of the system. But far too often, the database is omitted from the equation. In this article, we discuss the unique aspects of databases, both relational and NoSQL, in a successful continuous integration environment.

  • Monitoring SRE's Golden Signals

    Golden signals are increasingly popular these days due to the rise of SRE. This article outlines what golden signals are, and how to monitor and use them in the context of various common services.

  • Introduction to SQL Server Containers

    Containers are just around the corner for the Windows community, and this article takes a closer look at using SQL Server containers. The author discusses the value, use cases, and means for taking advantage of SQL Server containers today.

  • Big Data Solutions with MS SQL ColumnStore Index

    Columnar data storage can offer significant performance improvements over the way database tables are traditionally stored, but they aren’t always faster. Aleksandr Shavlyuga explores the power, and limitations of SQL Server’s ColumnStore Indexes.

  • SQL Server Source Control and Deployment with Visual Studio

    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.

  • How to Effectively Map SQL Data to a NoSQL Store

    Sytze Harkema explains how to save and retrieve relational SQL data into a NoSQL key-value store as implemented by FoundationDB, an open source, scalable, fault tolerant and ACID database.

  • Introduction to Red Gate’s SQL Source Control

    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.

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

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

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

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

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

BT

Is your profile up-to-date? Please take a moment to review and update.

Note: If updating/changing your email, a validation request will be sent

Company name:
Company role:
Company size:
Country/Zone:
State/Province/Region:
You will be sent an email to validate the new email address. This pop-up will close itself in a few moments.