Jul 102017

Recently I had a pleasure to provide a short interview to Syncfusion about the newly published “MongoDB 3 Succinctly” book. Original (entire) blog post can be found here and the free e-book can be downloaded directly from the Syncfusion web-site. What should people know about MongoDB? Why is it important? MongoDB is an open-source document database that provides high performance, high availability, and automatic scaling. This short [… read more]

MongoDB 3 Succinctly

 Posted by on June 9, 2017
Jun 092017

MongoDB 3 Succinctly e-book is available for a free download. If you are interested in using the MongoDB database for building your applications (especially with .NET), then this e-book is a great start. Check It out by downloading it for free from the Syncfusion web site I would like to thank James McCaffrey  for the great contribution and the whole Syncfusion team for the fantastic support. [… read more]

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]

silmon_napoleon masucci@mailxu.com