Best Database article of November 2013

This competition has ended

Overview
Entries
Participants
Winners
Prizes
Rules

Contribute to CodeProject and you'll automatically be in the running for a monthly prize!

Each month at CodeProject we gather together the best of the articles submitted the previous month and ask our readers to choose the best of the best. Entry is automatic - just submit you articke and we'll do the rest.

Check out the submission guidelines for information on posting articles.

Current Entries

Articles that match the contest criteria are automatically entered.

System Availability Charts in SSRS

6 Nov 2013Sichen D

How to build system availability timeline in SSRS

SSRS

SQL-Server

Design

Dev

chart

Quick Tip: Oracle – Commit on Exit

6 Nov 2013Sam Varadarajan

Oracle - commit on exit

All-Topics

Oracle

Failproof Bulk Upload SqlBulkCopy

29 Nov 2013lalitsrana

Demonstrate a simple yet efficient way to upload the data (SqlBulkCopy)

.NET

ADO.NET

12 reasons to consume OData feeds using Simple.OData.Client

22 Nov 2013Vagif Abilov

The article describes limitations of WCF Data Services client and shows how Simple.OData.Client can become a better alternative

How to use recursive CTE calls in T-SQL

15 Nov 2013Johan Ohlin

How to use recursive CTE calls in T-SQL.

How to find column or text in entire stored procedure of a database?

11 Nov 2013Rajat-Indiandotnet

Find column or Text in entire stored procedure

Scientific Data Visualizer

7 Nov 2013Alexander Chernosvitov

ActiveX component for 3D visualization, embedded in different client applications.

Common Table Expression to find all related nodes

12 Nov 2013Jobless Creature

CTE To find all the related nodes in a hierarcy

Emoji and web application

27 Nov 2013Tharaka MTR

Emoji; is the Japanese term for the ideograms or smileys used mostly in Japanese electronic messages and webpages.

XMeLon Schema

12 Nov 2013Alejandro Xalabarder

Yet another XML to database aproach

Day 1: Spider Database Navigator Website

3 Nov 2013Marc Clifton

Creating a website in Ruby on Rails for dynamically displaying and navigating a SQL Server database

Microsoft ASP.NET Identity MerlinFramework 2.0

28 Apr 2014Marc Leger

Microsoft ASP.NET Identity MerlinFramework

Entity Framework 5 vs. NHibernate 3.3 with Oracle 11g

4 Dec 2013Alexander Iskhakov

A comparison Entity Framework 5 and NHibernate 3.3 on a real-world .NET application with Oracle 11g.

Code First with SQL CE

9 Nov 2013Damijan Vodopivec

Sample Code First project with SQL CE 4.0 database

Part 2: Overcoming Windows 8.1's Deprecation of GetVersionEx and GetVersion APIs

5 Nov 2013Ehsan A Samani

Get Windows Version from WMI

SQL Scripts Runner

4 Nov 2013Lyubomir Rumenov Velchev

A simple console application, which executes all SQL files added by developers working with decentralised development environment.

How to Archive SharePoint List Items to SQL Server

4 Nov 2013Raymund Macaalay

This post will show you how to archive SharePoint List Items to SQL Server

SharePoint

SQL-Server

Service for StackExchange: Implementing a Data Provider

5 May 2014Shuqian Ying

Client side data provider for data importing to a relational data service build for StackExchange data dump.

A Unique Feature of SQL SERVER Loop with Go Statement

10 Nov 2013Rajat-Indiandotnet

A unique feature of SQL SERVER Loop with Go statement

Self-Synchronized Data Access Layer - Part II

11 Feb 2015Aydin Homay

In the software implementing business synchronizing structures/templates of the database entities with Data Access Layer SQL (commands/Transactions) is the most expensive thinks because you need to re-implement when you have change/s in your entities structure's such as Data-type, Name, and etc.

Understanding Complex MySQL JOIN

21 Nov 2013Vijay-Srivastava

Fetching complex data from multiple table using nested MySQL queries, JOIN operations, LIKE operator and aggregate functions(eg. GROUP BY, GROUP_CONCAT, etc.)

Map Data from Database Context to Excel Sheet using LINQ & Microsoft.Office.Interop.Excel

16 Nov 2013Debopam Pal

Using Microsoft.Office.Interop.Excel library, you can bring your data from your database against LINQ query and store them into an Excel Sheet.

Easiest Way of Cancelling All SharePoint Workflows in Progress

7 Nov 2013Raymund Macaalay

The easiest way to cancel all SharePoint workflows in progress

SQL

SQL-Server

SQL script for creating an ASP.NET Identity Database

4 Nov 2013Mr.Thursday

SQL script for creating ASP.Net Identity Database

Ansychronous triggers and cursors

22 Nov 2013h_wiedey

Asynchronous processing of triggers using cursors

SQL

SQL-Server

Asynchronous calls in C++ and MFC using boost and tbb

1 Nov 2013Gabi Barcan

Call methods of an existing class in MFC asynchronously, while still preserving the thread affinity required by MFC and COM.

Group concatenation in T-SQL using CTE

15 Nov 2013Johan Ohlin

Group concatenation in T-SQL using CTE.

Shortest Path in SQL Server using hierarchyid

29 Nov 2013Mehdy Moini

Implementing a map as a tree, and finding the shortest path, between the streets, is what you will see.

Oracle – Forward Slash Contd… (PL/SQL)

4 Nov 2013Sam Varadarajan

Oracle SQL*Plus - Forward slash contd... (PL/SQL)

SQL

Dev

DBA

Checking MS SQL Server database files default paths

18 Nov 2013skydger

Checking MS SQL Server database files default paths.

SQL

SQL-Server

Understanding Three Layer Architecture and its Implementation in C# .NET

8 Nov 2013Debopam Pal

What is three layer architecture and how to implement it.

Current Participants

Those with articles that match the contest criteria are automatically entered.

Alejandro Xalabarder

Germany

I have a Telecomunications Engineering degree but since I learnt the first language (Pascal), almost I haven't stopped developing software. Mainly with C and C++ but I have touched many other languages and scripts. I use also to develop for fun (reinventing the wheel, of course!), currently almost all of such programs and tools are written in java (visit www.elxala.de).

Alexander Chernosvitov

Instructor / Trainer Peter the Great St.Petersburg Polytechnic Universi

Russian Federation

Peter the Great St. Petersburg Polytechnic University professor,
Microsoft Authorized Educational Center trainer,
Microsoft Certified Professional (C# Desktop Apps and MFC)
Lectures on OOP, C# and C++, Windows programming with C# and C++.
Have long practice and experience in finding the right way to formulate and numerically solve differential equations.

Alexander Iskhakov

Team Leader

Ukraine

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Alfred Molnar

Software Developer

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Aydin Homay

Software Developer (Senior) BHGE

Germany

I worked as a software engineer and researcher in different countries with a wide range of related projects and engineers from all around the world. I was involved in Oil&Gas, Telecommunication, Transportation, and Semiconductor projects and played various roles such as junior, senior, and lead engineer both in embedded and non-embedded devices and technologies.

During my professional carrier, I was directly involved in designing and maintaining editor, compiler, and interpreter for IEC 611131-3 (PLC programming standard) and fault-tolerant communication layer for distributed automation standard IEC 61499, and many other projects such as DCS (Distributed Control Systems), (SCADA) Supervisory Control and Data Acquisition System, Oilfield (CMS) Computerised Maintenance Systems, Oil&Gas Laboratory Automaton Systems, and Semiconductor Equipment Connectivity Solutions.

Currently, I pursue a Ph.D. degree in Computer Science in the Technical University of Dresden and works as a software engineer in Germany. Beside, I am a certified specialist in Microsoft technologies since 2011.

My main research and work areas are Industrial Communication and Automation Systems, Real-Time Systems, Service-Oriented Systems, IEC 61131-3, IEC 61499, and Distributed Embedded Systems.

Damijan Vodopivec

Software Developer

Slovenia

Senior C# .NET developer in gaming industry

Specialties
C#, XML, WebServices, WCF

Debopam Pal

Software Developer National Informatics Centre (NIC)

India

Hello! Myself Debopam Pal. I've completed my MCA degree from West Bengal University of Technology at 2013. I'm from India. I’ve started to work with MS Technologies in 2013 specially in C# 4.0, ASP.NET 4.0. I've also worked in PHP 5. Now I work in JAVA/J2EE, Struts2. Currently I'm involved in a e-Governance Project since Jan, 2014. In my leisure time I write Blog, Articles as I think that every developer should contribute something otherwise resource will be finished one day. Thank you for your time.

Visit: Linkedin Profile | Facebook Profile | Google+ Profile | CodeProject Profile

Ehsan A Samani

CEO NanoToolkit, Inc

United States

I have been doing some sort of Software Development since 1998. I started with C Programming but quickly upgraded to C++. I am proficient in Windows UI, Windows Server/Service, COM, C# and WinForms, C# and Asp.net. I can also claim some know-how in VB.NET and java. Every once in a while I hone in my scripting skills by doing more JQuery and Powershell but I quickly forget it all. I also have a working knowledge of CSS and HTML as well.
check out my Blog

h_wiedey

Germany

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Jobless Creature

Software Developer (Senior) TATA Communications

India

I have a total experience of around 5 years out of which 4 years in MS technologies. I have a passion towards coding.

Johan Ohlin

CEO BJ Focus Ltd

United Kingdom

Johan is the CEO of BJ Focus Ltd, a UK company specialised in the development of business structure platforms helping companies to structure flows of organisable data.

He writes articles on the BJ Lab's blog, especially when his customers keep asking the same thing. You might find a few of these articles here on CodeProject.

Currently his focus is on building MVC web apps on the Azure platform, but PHP and MySQL get their share of attention as well.

Johan has double masters, in business and in software development, and an MCTS in .Net Framework 4, web applications.

lalitsrana

Software Developer (Senior)

India

More about me on my website
http://lalit.50webs.com

Lyubomir Rumenov Velchev

Software Developer (Senior) Softopia

United Kingdom

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Marc Clifton

Architect Interacx

United States

Blog: https://marcclifton.wordpress.com/
Home Page: http://www.marcclifton.com
Research: http://www.higherorderprogramming.com/
GitHub: https://github.com/cliftonm

All my life I have been passionate about architecture / software design, as this is the cornerstone to a maintainable and extensible application. As such, I have enjoyed exploring some crazy ideas and discovering that they are not so crazy after all. I also love writing about my ideas and seeing the community response. As a consultant, I've enjoyed working in a wide range of industries such as aerospace, boatyard management, remote sensing, emergency services / data management, and casino operations. I've done a variety of pro-bono work non-profit organizations related to nature conservancy, drug recovery and women's health.

Marc Leger

Web Developer Epsilon

United States

20+ years experience developing web solutions.

Mehdy Moini

Software Developer Idea Tolue Software

Iran (Islamic Republic of)

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Mr.Thursday

Software Developer (Senior)

South Africa

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Rajat-Indiandotnet

Team Leader

India

I am Rajat Jaiswal from India. I am working as a Technology specialist in one of the reputed company in India with 12+ years of experience. I am a Microsoft Data Platform MVP & Alibaba Cloud MVP.
I have always had an affinity to learn something new in technology. Database, Web development, Cloud computing are the areas of my interests always.
I have been a regular contributor to technologies with more than 300+ tips. Learning & Sharing is one of my aims always. Writing blogs, delivering sessions, helping on forums is my hobby.

Raymund Macaalay

Technical Lead

New Zealand

http://nz.linkedin.com/in/macaalay
http://macaalay.com/

Sam Varadarajan

Software Developer (Senior) City of Los Angeles

United States

Originally a Physics major, fell in love with Microprocessors and switched to Computer Science 20+ years ago. Since then, dabbled in various languages including, PowerBuilder, Oracle, Java, C, C++, Perl, Python etc. Constantly striving for quality and performance too.

I try to help fellow developers with technology as a way of "giving back to the community". Blogging became a natural extension of that effort. Still learning to perfect that art. If one new programmer out there benefits from this blog, my time and effort are fully worth it.

The underlying theme in my blogs is power and beauty of programming (and technology in general). A well written program gives me the sense of awe you get when you look at a man made wonder like Angkor Wat. You experience poetry, art, mystique, power all at once. A program and the troubleshooting that ensues also gives you a feeling you get while reading a mystery novel!

Shuqian Ying

Founder CryptoGateway Software Inc.

Canada

His interests in software research and development include security, domain specific meta-language development technologies and tools, meta-language driven code generation, generation of non-invasive and virtual SQL database for "un-structured" data (sqlization), automated relational data service production technologies, file system sqlization technologies and products, structured multi-lingual documentation tools and technologies, sqlization of user's personal data, like emails, etc..

He was a physicist before year 2000. He studied theoretical physics (the hidden symmetry between the past and future, quantum field theories, mirror universe, cosmological dark energies etc.) in which he think to had made fundamental breakthroughs[^] but the community is either not ready for it or is actively rejecting/ignoring it Smile | :) .

It struck me on Apr. 11, 2023 that the said theory above can even generate General Relativity naturally after a recent discussion in the Insider News group that triggers a rethinking of the subject on my side. The first stage of the work is completed in Sept. 2023, it is and will be continue to be published online

On Vacuum
Quantum and Gravity

Most recent software system to share:
- V-NET[^] - Full stack virtualization management system including networking, storage, virtual machines and containers, with an emphasis on networking ... to be released.

Sichen D

Software Developer Acxiom Corpopration

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

skydger

Architect

Russian Federation

Since the middle of 90-s when I was able to deal only with ZX Spectrum, I became addicted to programming. It was a strange path from Sinclair Basic through old-school Fortran, C and C++ to C# and SQL.

I fond of Microsoft technologies but also interested in Linux development. I like to learn new technologies, patterns and techniques and gladly share with my experience to others.

If you wish to contact with me feel free to write down a message through any of social network.

Tharaka MTR

Technical Lead Eyepax IT Consulting (Pvt) Ltd.

Sri Lanka

Having more than 9 year hands-on industry experience in software development
Responsible for designing, implementing and managing complex software systems with stringent up-time requirement.

Visit my blog

Vagif Abilov

Architect Miles AS

Norway

Vagif Abilov is a Russian/Norwegian software developer and architect working for Miles. He has more than twenty years of programming experience that includes various programming languages, currently using mostly C# and F#.

Vagif writes articles and speaks at user group sessions and conferences. He is a contributor and maintainer of several open source projects, including Simple.Data OData adapter, Simple.OData.Client and MongOData.

Vijay-Srivastava

India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

	Aydin Homay - Self-Synchronized Data Access Layer - Part II
Prize pool	CodeProject Mug - CodeProject CodeProject Mousepad - CodeProject SQL Prompt from Red Gate Software - Redgate Software

Contest Entries and Requirements

The contest period covers the the first day of the month 12AM US Eastern Standard Time and ends the final day of the month at 11:59:59 PM US Eastern Standard Time. All entries must be submitted during this period in order to qualify.
Must be an article, or blog entry
With the exception of the overall category, the article must be tagged with at least one of the tags corresponding to that competition's category (for example, to enter the C# Competition you would need to tag your article with a C# tag).
The contest period covers the the first day of the month 12AM US Eastern Standard Time and ends the final day of the month at 11:59:59 PM US Eastern Standard Time. All entries must be submitted during this period in order to qualify.
Articles entries must follow the CodeProject submission guidelines.
No cheating, lying, plagiarizing articles, chicanery, or kicking.
Authors may only have their article considered for multiple categories if that second category is the Overall monthly category. Under no circumstance will an article be nominated in a second category that is not the Overall monthly category.
No author can be nominated twice in the same category.
If an author writes has two separate articles, each article may be considered in their respective categories provided none of the aforementioned rules are broken. For example, if an author wrote two separate articles, one related to C# and one related to VB.NET, the author and article could be nominated in the C# and VB.NET competitions, respectively.
In the event an author wins multiple competitions, and repeat, identical prizes, the number of prizes issued is solely at the discretion of the prize issuer.
Multiple votes from the same IP will be automatically disqualified.
The judges’ decision is final and no correspondence will be entered into.
Only those who live in jurisdictions in which this contest is legal may enter.
Any breach of the rules and the prize will be awarded to the runner up.
By entering the contest you agree to the rules, conditions of entry, and agree that your member alias and any submitted material can be used for promotional purposes by CodeProject.
Entries shall be deemed to be submitted by the authorized account holder of the email address submitted at the time of entry unless clearly indicated otherwise. "Authorized account holder" is defined as the natural person who is assigned to an email address by an internet access provider, on-line service provider, or other organization (e.g. business, educational institution, etc.) that is responsible for assigning email addresses for the domain associated with the submitted email address.

Eligibility

This competition is open to software development professionals & enthusiasts who are of the age of majority in their jurisdiction of residence; however, residents of Quebec and of the following countries are ineligible to participate due to legal constraints: Cuba, Iran, Iraq, Libya, North Korea, Sudan, and Syria. Employees (or a member of their immediate family) of CodeProject or any of their affiliates, subsidiaries, advertising or promotional agencies are also ineligible to participate. Void where prohibited by law.

How to Enter

Entry is by the submission process described. Please read the submission requirements before submitting your entry.

Lost, late, misdirected, or illegible entries will be disqualified. Any entry containing content that CodeProject deems objectionable for any reason will be disqualified. All decisions of CodeProject with respect to any aspect of the competition, including, without limitation, the eligibility of entries, are final and binding on all entrants in all matters as they relate to this competition. CodeProject reserves its right to modify the Rules.

CodeProject assumes no responsibility for lost, late, delayed, destroyed or misdirected mail, voice messages, email or any computer errors or malfunctions. No correspondence will be entered into with entrants.

CodeProject does not assume any responsibility for incorrect or inaccurate capture of entry information, technical malfunctions, human or technical error, lost, delayed or garbled data or transmissions, omission, interruption, deletion, defect or failures of any telephone or computer line or network, computer equipment, software or any combination thereof. Entry materials/data that have been tampered with or altered are void. If for any reason, in the opinion of CodeProject in its sole discretion, the competition is not capable of running as originally planned, or if the administration, security, fairness, integrity or the proper conduct of the competition is corrupted or adversely affected, including by reason of infection by computer virus, bugs, tampering, unauthorized intervention, fraud, technical failures or any other causes beyond its control, CodeProject reserves its right to cancel, terminate, modify, amend, extend or suspend the competition including cancelling any method of entry, and select a winner from previously received eligible entries. CodeProject reserves its right in its sole discretion to disqualify any individual it finds to be tampering with the entry process or the operation of the competition or to be acting in violation of the Rules or otherwise in a disruptive manner. CodeProject reserves its right to seek remedies and damages to the fullest extent of the law for any attempts to deliberately damage the competition web site or to undermine the legitimate operation of this competition. CodeProject shall not be held responsible for any errors or negligence that may arise or occur in connection with the competition including any damage to an entrant's computer equipment, system, software or any combination thereof, as a result of their participation in this competition or from downloading any material from the competition website where applicable.