Older rss

Unified Data Modeling for Relational and NoSQL Databases

Posted by Allen Wang on  Feb 28, 2016

Current enterprise data architectures include NoSQL databases co-existing with RDBMS. In this article, author discusses a solution for managing NoSQL & relational data using unified data modeling. 5

Diagnosing Common Database Performance Hotspots in our Java Code

Posted by Andreas Grabner Harald Zeitlhofer on  Feb 16, 2016

Java performance issues are often attributable to bad database access patterns. In this article a top performance field engineer demonstrates his patterns for diagnosing database related issues.

Real-time Data Processing in AWS Cloud

Posted by Oleksii Tymchenko on  Nov 11, 2015

In this article, author discusses a bio-informatic software as a service (SaaS) product which was built as a public data warehousing and analytical platform for mass spectrometry data. 3

Big Data Solutions with MS SQL ColumnStore Index

Posted by Aleksandr Shavlyuga on  Oct 11, 2015

ColumnarStore can offer performance improvements over traditional tables, but 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

Posted by Jonathan Allen on  Nov 04, 2014

The holy grail of database development is the ability to treat database objects as if they were normal 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

Posted by Sytze Harkema on  Oct 23, 2014

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

Posted by David Atkinson on  Oct 01, 2014

It’s unthinkable for modern application developers to work without source control, yet somehow, databases are often left out. But it doesn’t have to be that way.

Don’t jump the SQL ship just yet

Posted by Lukas Eder on  Dec 18, 2013

Some users are interacting with databases through complex SQL queries, both in terms of performance as well as expressivity. If SQL and JPA are diverging, where will our data interaction patterns go? 4

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

Posted by Justin Weiler on  Jul 22, 2013

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.