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]

May 052012

Transactions are an integral part of any (serious) database development when there is need for data consistency. Transactions in a database environment have two main purposes: To provide reliable mechanism to allow correct recovery from failures and keep a database consistent To provide isolation between programs accessing a database concurrently. It’s impossible to mention transactions without mentioning the ACID (Atomic, Consistent, Isolated and Durable) attributes [… read more]