Category Archives: Database

NoSQL at Twitter presentation

Posted on September 12, 2010 by Kon

Man these guys are smart.  http://www.slideshare.net/kevinweil/nosql-at-twitter-nosql-eu-2010 Talks about Twitters many different approaches to storage (Hadoop, Cassandra, FlockDB) and the tools used in querying of that data to answer questions (Pig)

Posted in Cloud, Database, Spring | Tagged , , , , | Leave a comment

Mongo DB

Posted on September 1, 2010 by Kon

Watched this presentation about how Sourceforge chose MongoDB for their customer facing webapp.  You know, the one you go to download Azuerus and all those open source apps from Sourceforge chose Mongo because it offered them high read performance although … Continue reading →

Posted in Database | Tagged , | Leave a comment

CouchDB

Posted on June 13, 2010 by Kon

Much like Neo4J I blogged about recently, there is also CouchDB from Apache.  CouchDB is a document database which isn’t a graph database like Neo4J, but what that exactly means I’m not sure yet – the purpose seem to overlap … Continue reading →

Posted in Database | Leave a comment

Graph Databases

Posted on June 6, 2010 by Kon

A great article on the NoSQL movement, focusing on Graph Databases and the Neo4J implementation appeared on InfoQ. Graph databases store a Node (aka vertex), that has properties (aka attributes), that is then linked to another node.  The relationship (aka … Continue reading →

Posted in Database, Groovy, Java | Leave a comment

SQL Joins

Posted on February 20, 2009 by Kon

This great article on codeproject talks about the different sorts of joins there are in SQL.  Sounds pretty easy right, but then there are ones I dont remember learning in school, Left and Right EXCLUDING join, and Full Excluding Join.  … Continue reading →

Posted in Database | Leave a comment

Even more T-SQL

Posted on May 25, 2007 by Kon

These are from MSDN. http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.agent.aspx http://msdn2.microsoft.com/en-us/library/ms162162.aspx

Posted in Database, Software Development, Windows | Leave a comment

Sending Email in T-SQL

Posted on May 25, 2007 by Kon

For the uninitiated (like me), Microsoft SQL Server has T-SQL (think PL/SQL for Oracle).  Of course being an MS product, it has to have some VB scripting integration, which is cool.  Part of this integration lets you get your hands … Continue reading →

Posted in Database, Software Development, Windows | Leave a comment