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]
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]
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]
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]
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]
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]
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]
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]
By OBREAKSL penny stocks