Tag: SQL Server

"POC21 - Proof of Concept" by POC21 licensed through creative commons https://www.flickr.com/photos/poc21cc/22114029108

Proof of Concept: Making a case to move from relational

Proof of concept may be just what you need to start when you’re evaluating Couchbase. We’ve been blogging a lot about the technical side of moving from a relational database like Oracle or SQL Server to Couchbase. Here are some...

Glass ochem by Purpy Pupple, licensed through Creative Commons https://commons.wikimedia.org/wiki/File:Glass_ochem.png

JSON Modeling for RDBMS Users (video)

JSON modeling was covered in a previous blog post which was, in turn, based on a CSV import blog post that came before that. While writing the post on JSON modeling, it occurred to me that it might be useful...

Glass ochem by Purpy Pupple, licensed through Creative Commons https://commons.wikimedia.org/wiki/File:Glass_ochem.png

JSON Data Modeling for RDBMS Users

JSON data modeling is a vital part of using a document database like Couchbase. Beyond understanding the basics of JSON, there are two key approaches to modeling relationships between data that will be covered in this blog post. The examples...

ETL diagram by JakobVoss licensed through Creative Commons 3.0 https://commons.wikimedia.org/wiki/File:Etl-process.svg

CSV tooling for migrating to Couchbase from Relational

CSV (Comma-seperated values) is a file format that can be exported from a relational database (like Oracle or SQL Server). It can then be imported into Couchbase Server with the cbimport utility. Note: cbimport comes with Couchbase Enterprise Edition. For...

SQL Server and Couchbase Server compare and contrast

SQL Server and Couchbase side-by-side (video)

SQL Server is compared (and contrasted) with Couchbase Server in this video. If you are averse to video, you can check out the corresponding blog post series I wrote a few months ago that covers the same material: Part 1...

Glass ochem by Purpy Pupple, licensed through Creative Commons https://commons.wikimedia.org/wiki/File:Glass_ochem.png

SQL to JSON Data Modeling with Hackolade

SQL to JSON data modeling is something I touched on in the first part of my “Moving from SQL Server to Couchbase” series. Since that blog post, some new tooling has come to my attention from Hackolade, who have recently...

Geese migration licensed through Creative Commons https://commons.wikimedia.org/wiki/File:BrantaLeucopsisMigration.jpg

Moving from SQL Server to Couchbase Part 3: App Migration

Moving from SQL Server to Couchbase Part 3: App Migration In this series of blog posts, I’m going to lay out the considerations when moving to a document database when you have a relational background. Specifically, Microsoft SQL Server as...

Geese migration licensed through Creative Commons https://commons.wikimedia.org/wiki/File:BrantaLeucopsisMigration.jpg

Moving from SQL Server to Couchbase Part 2: Data Migration

In this series of blog posts, I’m going to lay out the considerations when moving to a document database when you have a relational background. Specifically, Microsoft SQL Server as compared to Couchbase Server. In three parts, I’m going to...

Geese migration licensed through Creative Commons https://commons.wikimedia.org/wiki/File:BrantaLeucopsisMigration.jpg

Moving from SQL Server to Couchbase Part 1: Data Modeling

In this series of blog posts, I’m going to lay out the considerations when moving to a document database when you have a relational background. Specifically, Microsoft SQL Server as compared to Couchbase Server. In three parts, I’m going to...

N1QL vs TSQL – Aggregations with Couchbase Server vs SQL Server

SQL has been around for a loooooong time. It is very intuitive and efficient way to process structured data and has been the choice for databases for many years. With the world of BIG DATA however, data has velocity, variety...