Apr 092017
 

As we all know document databases are very different from the so-got-used-to Relational Databases (RDBMS). In RDBMS when designing the database, one goes through the process of the so called data normalization. Normalization involves arranging attributes in relations based on dependencies between attributes, ensuring that the dependencies are properly enforced by database integrity constraints. Normalization is accomplished through applying some formal rules either by a process of [… read more]

Apr 022017
 

If we were to implement a solution that uses queues, the first thing that comes to our mind is to use one of the already baked systems that support queuing. There is really a proliferation of open-and-closed source software such as: RabitMQ ZeroMQ IBM MQ Series MSMQ (Microsoft Message Queuing) and many many others There are however other kind of queues, and those are directly [… read more]

Oct 282014
 

This is the continuation of the previously written post. Open DBDiff Open DBDiff is a free and open source database schema comparison tool for SQL Server 2005/2008. It reports differences between two database schemas and provides a synchronization script to upgrade a database from one to the other.  Open DBDiff can synchronize> Tables (including Table Options like vardecimal, text in row, etc.), Columns (including Computed Columns, [… read more]

Jul 022014
 

Syncfusion published yet another book on their Succinctly Series – MongoDB Succinctly. Once again I had the pleasure to be the Technical Editor of the book.     In MongoDB Succinctly, author Agus Kurniawan explains the essentials of the MongoDB database system. Starting with creating a MongoDB database, you’ll learn how to make collections and interact with their data, how to build a console application [… read more]

May 232013
 

I was completely unaware of the SQL Server “ghost records” until recently I’ve started using a table in SQL Server database to temporarily store and then delete generated PDF documents as part of a nightly job. Because of a large amount of data being processed (inserted and then deleted) few days later our DBA realized that the database data files started growing in a rhythm [… read more]

Feb 232013
 

Recently I have participated to a couple of discussions about whether the triggers or stored procedures should be used or not in a “real” project, so I decided to write this post to express my point of view. This said, I warn you, there is no a “right” answer, but most probably a “pro” and “cons” about anything written in this post. An old problem [… read more]

Feb 082013
 

I am migrating some old posts to this blog, so I though it would be good to migrate this one too. This post has been originally written in February 2010, but still actual and valid. Today I run into a problem of finding out when was the last time a specific Stored Procedure (SP) has been changed. Obviously, there are different ways to find out, [… read more]

Jan 102013
 

Recently I started working on my side-hobby-project on the linktotweet.com web site, and one of the functionality I want to offer to site members is the possibility to track the statistics, and more precisely the location of their visitors. In other words, I need to translate the IP address to an actual location. While this is almost a trivial task for whoever is using the [… read more]

Oct 082012
 

Whenever you are working on a database solution that involves more than one deployment environment you need to be sure that you are running the same database schema and usually the same reference data. If you were to manage manually various databases in order to be sure that there are no differences, you would spend long hours with no guarantee when you were done that [… read more]

LINQ Standard Query Operators

 Posted by on June 10, 2012
Jun 102012
 

Standard Query Operators are the “heart” of LINQ, as those operators are representing the API that we need to go through in order to do any LINQ query. There are two sets of LINQ standard query operators, one that operates on objects of type IEnumerable and the other that operates on objects of type IQueryable. They are defined as extension methods of the type that [… read more]

May 072012
 

The primary key of a table on an RDBMS uniquely identifies each record in the table. It can either be a normal attribute that is guaranteed to be unique or it can be generated by the RDBMS (such as a globally unique identifier). Primary keys may consist of a single attribute (single key) or multiple attributes in combination and in that case we speak about [… read more]

An introduction to NoSQL

 Posted by on May 7, 2012
May 072012
 

In my working career I had to deal with databases since my first day at work and it is a bit a hate-and-love relationship. Usually well working application is always backed up by a good designed database schema and good accessing mechanism. So far I always used RDBMS – Relationship databases such as Microsoft SQL Server, Oracle, MySql, Sybase. Right now there is a big [… read more]

tinnes@mailxu.com rindal.carissa@mailxu.com