Best Database Article of October 2015

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.

Software Developers are lazy but smart, that's why we RAD: The PHP.Show Concept

8 Oct 2015Anele 'Mashy' Mbanga

A look at a flexible Java MySQL CRUD PHP script generator

SQL

Java

Mobile

Windows

Semafon™ semantic phone number-to-text converter

8 Oct 2015DrABELL

App implements bi-directional semantic phone number-to-text converter, extended with novel Lottery+Quiz engine

Protocol Association Enumerator

6 Oct 2015Maxim Komlev

.NET classes to enumerate applications associated with protocol

Testing Your Rest API Controller Methods - Using SoapUI

16 Oct 2015Bert O Neill

Validate your Restful Service Methods using SoapUI (which can then be integrated into TFS build CI)

How to Calculate the Length of the Largest Text Value in Every Table Column

22 Nov 2015Daniel Miller

This tip shows how to display the length of the longest string value in every table and column in your database.

T-SQL

SQL

LiteDB - A .NET NoSQL Document Store in a Single Data File

14 Oct 2015Terence Wallace

Alternative VB.NET version of "LiteDB - A .NET NoSQL Document Store in a single data file"

Multiple URL Stress

23 Oct 2015Hernán Hegykozi

Multiple URL Stress is a tool to test the performance of servers and websites, allowing you to test multiple URLs at the same time

Evolution of Data Objects Within Database Applications

27 Oct 2015Alexander Imas

The subject of this article is database applications. These applications reflect objects from the real world in program objects in the application.

DBA

NoSQL

Elevate permission on a SQL login having read only access to Execute Stored Procedures and to View Database Schemas

26 Oct 2015Manjuke Fernando

Due to an unavoidable situation, it was decided that all the write access to a particular server (SQL Server) was required to be removed immediately. And only few people should be able to access the server with full privileges.

C++

Windows

COM

Is SQL Server killing your application’s performance?

13 Oct 2015Ben Emmett

When an application suffers from performance problems, it’s common to assume the database is at fault. Ben Emmett examines why this often isn’t the case, and shows how you can dig into a .NET application’s use of SQL Server with ANTS Performance Profiler.

SQL Server FILESTREAM with Nhibernate

23 Oct 2015Codeman the Barbarian

In the tip, I go through one approach to integrating SQL Server's FILESTREAM type with Nhibernate.

Anyone Who Is Querying Ought To Know These

15 Oct 2015Shyam S Singh

This is a simple tip to describe how to write an optimized SQL query when we are dealing/working on large amount of data.

SQL

Implementing Repository pattern and Dependency Injection in ADO.NET using Generics in C#

22 May 2016Ehsan Sajjad

Repository pattern implementation in ADO.NET using Generics

Perfect Pagination with Repeater Control in ASP.NET C#

10 Oct 2015ChienVH

Perfect Pagination with Repeater Control in ASP.NET C#

Projecting on Linq to SQL, From Different Layers

20 Oct 2015Reader Man San

Projecting on Linq to SQL, from different layers

SQL

WCF

Serilog - An Excellent Logging Framework Integrated With .NET Applications

20 Oct 2015Andy Feng

Serilog is a portable and structured logging framework to record diagnostic logs into files, console and SQL/NoSQL databases.

Introduction to MongoDB

7 Oct 2015Vikas Sharma

Introduction to MongoDB

MongoDB

JSON

Handle NULL in SQL Server

2 Oct 2015Math08avan

The important things to understand, how missing values are treated in SQL Server

SQL

SQL-Server-2012

SQL Server Data Tools to Visual Studio 2013 - Database Reverse Engineering

30 Oct 2015JoaoSousa23

SQL Server Data Tools to Visual Studio 2013 - Database Reverse Engineering

SQL

server

database

Fast and Simple IDataReader Implementation to Read CSV Files

3 Oct 2015shijo joseph

A simple and fast CSV reader which you can directly use against Oracle and SQL Server databases or for any direct implementation

Using Effort - Entity Framework Unit Testing Tool

9 Dec 2015Roger C Moore

This tip is a guide for using the Codeplex project Effort for testing Entity Framework applications without requiring the unit tests to actually hit the SQL Server database.

Day 2 - Database Connectivity (Retrieve Value from Database and Bind to Gridview)

18 Oct 2015VijayRana

Retrieve value from database and bind to gridview

Unlimited Category List Table

3 Oct 2015Pedram_Niloufari

How to create an unlimited category list table in database and how to read category list

Exclusive lock in distributed solutions with MongoDB

8 Dec 2016urigg123

Describes how to design a lock like mechanism in a distributed solution to allow exclusive access or leader election to one of the server components.

MongoDB Messaging

26 Oct 2015Paul Welter

MongoDB Messaging library is a lightweight queue pub/sub processing library based on MongoDB data store

.NET Runtime Library for Delphi

11 Oct 2015Bismark Appah

.NET Runtime Library for Delphi

Using COM Without Registration

9 Oct 2015imagiro

A small class for using COM DLL modules without registering them

Bulk Insert into SQL from C#

26 Oct 2015Sacha Barber

Bulk insert into SQL from C#

SQL

WCF

How to Resolve: "The Data Source value in the connection string specifies an instance of SQL Server that is not installed" or "LocalDB instance does not exist"

21 Oct 2015yash soman

The error occurs when we try to create a new Microsoft SQL Server Database File (SqlClient) using Visual Studio IDE

Windows

SQL-Server-2008R2

SQL-Server

SQL recursive common table expression in Project Scheduling practice

14 Oct 2015csabahegyi79

Project Scheduling Engine with recursive SQL common table expression

Best Embedded RDBMS Databases for .NET Developers

22 Oct 2015Steve Naidamast

Best Embedded RDBMS Databases for .NET developers

.NET

SQL-CE

DBA

Horizontal scaling .net C# / NodeJS, MongDB with Micro Services

29 Oct 2015Ashwin. Shetty

Scaling application Horizontally using Message queue

Documenting SQL Stored Procs in C# Code

5 Oct 2015#realJSOP

Yes, you CAN document your stored procs in C# code.

SQL Prompt Review

14 Oct 2015MarkDunn

I love tools that save me and my team time which ultimately translates to saving money for my employer and I’ll proceed to show you how SQL Prompt can do that for you .

GoFlex Repair And Snooping Around

5 Jan 2016marcus obrien

Fix your goflex media server files and have poke around on the device.

SQL

Linux

BackUp and Restore with SMO of SQL Server 2008

26 Oct 2015Hernán Hegykozi

This tip will show how to perform a backup and restore database from an application in VB.NET 2010.

Day 1 : Database Connectivity ASP.NET/C# with SQL Server (Create Operation)

29 Mar 2016VijayRana

CRUD operation in ASP.NET/C# with SQL Server for beginners

Execute Long Running SQL Statements Asynchronously from .NET

21 Oct 2015Anil Kumar @AnilAwadh

A beginner's tutorial for understanding Asynchronous execution of SQL statements using a simple application.

VS2013

ADO.NET

Does 'GROUP BY' Confuse - SQL ?

17 Oct 2015Shyam S Singh

This is a simple tip to describe the GROUP BY clause and when we use this in our SQL statements with and without using HAVING clause.

SQL

Projecting on Linq to SQL, from different layers

25 Oct 2015Reader Man San

The Need I needed to add the possibility for upper layers like the Model/Service to make projection on Linq to SQL statements but without leaking IQueryable. As the normal Linq to SQL projection is: var query = from c in Cars … Continue reading →

SQL

WCF

Installation of SQL Server Express 2014 on Windows 10

6 Oct 2015Mithun Pattankar

Step by step process of installation of SQL Server Express 2014 on Windows 10

Windows

SQL-Server

Best Embedded RDBMS Databases for .NET Developers

9 Oct 2015Steve Naidamast

Best Embedded RDBMS Databases for .NET Developers

All-Topics

DBA

SQL Server Lock Critical Section

23 Oct 2015Hernán Hegykozi

Marks a statement block as a critical section by obtaining the mutual-exclusion lock

Current Participants

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

#realJSOP

Software Developer (Senior) Paddedwall Software

United States

I've been paid as a programmer since 1982 with experience in Pascal, and C++ (both self-taught), and began writing Windows programs in 1991 using Visual C++ and MFC. In the 2nd half of 2007, I started writing C# Windows Forms and ASP.Net applications, and have since done WPF, Silverlight, WCF, web services, and Windows services.

My weakest point is that my moments of clarity are too brief to hold a meaningful conversation that requires more than 30 seconds to complete. Thankfully, grunts of agreement are all that is required to conduct most discussions without committing to any particular belief system.

Alexander Imas

Germany

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

Andy Feng

Software Developer

Canada

Andy Feng is a software analyst/developer based in Toronto, Canada. He has 9+ years experience in software design and development. He specializes in Java/J2EE and .Net solutions, focusing on Spring, Hibernate, JavaFX, ASP.NET MVC, Entity framework, Web services, JQuery, SQL and related technologies.

Follow up with my blogs at: http://andyfengc.github.io/

Anele 'Mashy' Mbanga

Software Developer SITHASO HOLDINGS (PTY) LTD

South Africa

I'm a Bachelor of Commerce graduate, fell inlove with ICT years back with VB5. Used Pick & System Builder to create a windows app. Very curious, developed my first web database app called Project.Show using ExtJS. Published on Google Play Store, learned JQuery Mobile, a project manager at best. My first intranet app eFas with MySQL.

Fear closes people to a lot of things and we hold ourselves back being held by it. Thus the sooner you believe you can't do something, the sooner everything will work towards that belief. Believe in yourself at all times because you can do anything you set your mind to it!

I have a very beautiful woman and four kids, the best joys in the world. East London, South Africa is currently home.

Awards:

Best Mobile Article of February 2015 (First Prize)
http://www.codeproject.com/Articles/880508/Create-a-CRUD-web-app-using-JQuery-Mobile-and-Loca

Best Mobile Article of May 2015 (Second Prize)
http://www.codeproject.com/Articles/991974/Creating-JQuery-Mobile-CRUD-Apps-using-JQM-Show-Ge

Apps
Bible.Show (Android Store App)
https://www.facebook.com/bibleshow
https://play.google.com/store/apps/details?id=com.b4a.BibleShow

JQM.Show (Android Store App)
https://www.facebook.com/jqmshow
https://play.google.com/store/apps/details?id=com.b4a.JQMShow

CodeProject.Show (An offline CodeProject Article writer)
http://www.codeproject.com/Articles/993453/CodeProject-Show-A-CodeProject-offline-article-wri

Anil Kumar @AnilAwadh

Software Developer (Senior)

India

Anil Kumar has good exposure on Automobile, Airways, and Financial domain in diverse technologies. Now he is primarily focus on Microsoft Technologies (ASP.Net, C#, ADO.Net, WCF, MVC, Ajax, SQL Server ..). He contributes in technical forums along with education and Career Advice on many websites. He has been awarded with C# Corner MVP for year 2012-13, and 2013-14. You can contact Anil Kumar on his email: Anil[dot]Kumar[at]CodePattern.net , follow him @AnilAwadh , +AnilKumarMVP

blog: http://codePattern.net

Ashwin. Shetty

Architect

India

I have 17 years of experience working in Microsoft Technology & Open source. Now a days I enjoy playing with Nodejs, Angular, docker, Gcloud & Kubernetes. My complete profile is available at https://in.linkedin.com/in/ashwinshetty and you can mail me at ashwin@shettygroup.com

Ben Emmett

United Kingdom

Ben is a technical product manager for Redgate’s developer tools. He spends his days digging into what makes applications grind to a halt, what makes them bloat and fall over, and what it takes to build something fast and scalable. When he’s not doing that, he’s probably messing with some electronics, cooking, or playing the violin.

Bert O Neill

Architect

Ireland

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

Bismark Appah

Software Developer (Senior) Real Asset management Plc

United Kingdom

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

ChienVH

Product Manager

Vietnam

Updated LinkedIn: https://vn.linkedin.com/in/chienvh

I am currently working as the position of project manager for a long time. Had to take care a lot of projects at the same times, so I don't have many free times in a day for contributing the articles, tips/tricks on codeproject.
While I was at the previous company sometimes I participated in training courses for new employees, so I have good teaching skills and ability to convey information to others. Meaning in each my post I will try to explain more detail as possible for the junior devs are able to implement/understand what's I have done.

Also, would like to share my responsibilities for current position:

• Coordinate internal resources and third parties/vendors for the flawless execution of projects
• Ensure that all projects are delivered on-time, within scope and within budget
• Assist in the definition of project scope and objectives, involving all relevant stakeholders and ensuring technical feasibility
• Ensure resource availability and allocation
• Develop a detailed project plan to monitor and track progress
• Report and escalate to management as needed
• Perform risk management to minimize project risks
• Establish and maintain relationships with third parties/vendors
• Create and maintain comprehensive project documentation
• Support team members to solve technical issues

Opening and looking forward to finding suitable jobs.

Codeman the Barbarian

Unknown

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

csabahegyi79

Software Developer (Senior) Levo Group

Australia

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

Daniel Miller

Chief Technology Officer Shift iQ

Canada

I have been building software systems for more than 20 years, working for organizations that range from small non-profit associations in my local community to global Fortune 500 enterprises.

I specialize in the design and implementation of online database solutions. My work-related research interests include software design patterns and information architecture.

DrABELL

Engineer

United States

Dr. Alexander Bell (aka DrABell), a seasoned full-stack Software (Win/Web/Mobile) and Data Engineer holds PhD in Electrical and Computer Engineering, authored 37 inventions and published 100+ technical articles and developed multiple award-winning apps (App Innovation Contests AIC 2012/2013 submissions) Alexander is currently focused on Microsoft Azure Cloud and .NET 6/8 development projects.

Ehsan Sajjad

Software Developer

Pakistan

Ehsan Sajjad is a Microsoft Certified Professional, Microsoft Certified C# Specialist and he is also among the top users on StackOverflow from Pakistan with 50k+ reputation at time of writing this and counting.

He is a passionate software developer with around 5 years of professional experience in Microsoft Technologies both web and desktop applications and always open to learn new things and platforms especially in mobile application development and game development.

Some Achievements :

5th Top Contributor from Pakistan on Stackoverflow.com
Top User in ASP.NET MVC from Pakistan on Stackoverflow.com
21st June 2017 - Article of the Day - ASP.NET Community (Beginners Guide on AJAX CRUD Operations in Grid using JQuery DataTables in ASP.NET MVC 5)
19th April 2017 - Article of the Day - ASP.NET Community (ASP.NET MVC Async File Uploading using JQuery)
March 2017 - Visual C# Technical Guru Silver Medal on Microsoft Tech Net Wiki Article Competition
20 January 2017 - Article of the Day - ASP.NET Community (Async File Uploading in ASP.NET MVC)
22nd September 2016 - Article of the Day - ASP.NET Community (GridView with Server Side Filtering, Sorting and Paging in ASP.NET MVC 5)
22nd August 2016 - Article of the Day - ASP.NET Community (Beginners Guide for Creating GridView in ASP.NET MVC 5)
December 2015 - C-SharpCorner Monthly Winner

Hernán Hegykozi

Team Leader

Argentina

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

imagiro

Software Developer

Germany

Born in 1968 I do programming since over 25 years now. I started with Basic on a ZX81 and with hacking hexcodes in a Microprofessor before I switched to C++ and other languages.

Since more than 10 years I work as a professional software developer, currently for Salsitasoft in Prague.

JoaoSousa23

Software Developer (Senior) Devscope

Portugal

I am João Sousa, and since i finish my degree I’m working in software development using Microsoft technologies.

I was awarded

Microsoft Most Valuable Professional (MVP) 2015 – .Net

My profissional profile:

Azure Developer
.NET Developer

My Certifications:

MCTS - .NET Framework - Application Development Foundation
MCTS - .NET Framework 2.0 - Windows-based Client Development
MCTS - .NET Framework 3.5 ADO.NET Applications
MCTS - .NET Framework 3.5 ASP.NET Applications
MCSD - Programming in HTML5 with JavaScript and CSS3
MCSD - Developing ASP.NET MVC 4 Web Applications
MCSD - Developing Windows Azure and Web Services
MCSA Office 365 - Managing Office 365 Identities and Requirements
MCSA Office 365 - Enabling Office 365 Services
MCSD - Implementing Microsoft Azure Infrastructure Solutions

Manjuke Fernando

Technical Lead Air Liquide Industrial Services (Singapore)

Singapore

My passion lies in building business intelligence and data-based solutions, writing about things I work with and talking about it. New technologies relevant to my line of work interest me and I am often seen playing with early releases of such technologies.

My current role involves architecting and building a variety of data solutions, providing database maintenance and administration support, building the organization’s data practice, and training and mentoring peers.

My aspiration over the next several years is to achieve higher competency and recognition in the field of Data Analytics and move into a career of data science.

Specialities: SQL Server, T-SQL Development, SQL Server Administration, SSRS, SSIS, C#, ASP.Net, Crystal Reports

marcus obrien

Technical Lead

Canada

I have a blog here

http://www.electricalengineeringschools.org/blog/

And my robotics web site is here :

http://www.roboticsfordreamers.com/

I have been a software engineer for over 20 years now. I'm an expert in writing scalable restful web API services, which I've been doing for over 7 years now for games companies such as EA and Ubisoft. I've also worked on several video games, including Skate 2 and 3, NHL, Need for Speed, various Assassins Creed games, Far Cry 3 and 4, Driver San Francisco and most recently with a team of 15 on EA's UFC free to play. On this latest project I designed, implemented, tested (including load tests in Gatling and JUnit on AWS), deployed and supported all the web services for the game client, supporting up to a half a million active sessions.

I am proficient at programming in C, C++, C#, Java etc. I've developed many types of games, applications, SDKs and web services in Linux, Unix, iOS, Android and Windows.

My spare time is spent teaching and lecturing computing languages and science. I have a PhD in Artificial Intelligence (specialising in knowledge representation - Semantic networks with inference engines).

Currently I am also building an A.I. general purpose robot. The brains behind it are a mix of 6 Raspberry Pi and Banana Pros, with 2 USB cameras, SATA drive, Router Switch with inter-pi Comms, 2 motorised track systems, plus various sensors including motion/pir/sound etc.

The six pi's are split according to functions, including eyes (image processing/recognition), ears (speech processing and simulated speech),motor (object avoidance, environment mapping, drives all movement), entertainment (web browsing, media playing etc), brain (knowledge system, and adaptive learning/memory systems) and development system ( logging, diagnostics, debugging).

I am available as a consultant, so if you need to get something out the door quick, or want to set down an expandable and resilient framework, ping me !

MarkDunn

United States

Mark Dunn has over 25 years of experience in the disciplines of software engineering, database administration, and project management. Software that Mark developed for the radio industry is still in use today. He was a lead developer on the team that created Tapscan, a well-known Arbritron ratings analysis package that has dominated that industry for many years. Since 2003, Mark has been awarded MVP (Microsoft Most Valuable Professional) status for his contributions to the Visual Studio .Net community and he serves as Microsoft's Regional Director covering the Southeast United States. Mark also co-founded .Net Rocks, an Internet radio program for .Net developers recognized in over 80 countries and now hosted by Microsoft on the MSDN site. Mark is also a Microsoft Certified Trainer, Application Developer, Solution Developer for .Net, and Database Administrator. Mark is the president of DUNN Training (www.dunntraining.com) an Atlanta, GA based technical training and consulting company.

Math08avan

Software Developer (Senior) iPower Lanka

Sri Lanka

I am Mathavan. I have been programming since 2008. My programming experience includes C/C++, C#, ASP.NET.

Maxim Komlev

Software Developer Netgear Inc

United States

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

Mithun Pattankar

India

I am Mithun Pattankar, a Software Professional on day job and blogger at nights. My interests are in Microsoft Technologies like DotNet, Visual Studio, ASP.NET, WPF, WCF, C#, HTML5

URL: www.mithunvp.com

Paul Welter

Software Developer (Senior)

United States

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

Pedram_Niloufari

Program Manager

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.

Reader Man San

Software Developer (Senior) Dev

United Arab Emirates

Hussain Naji Al-Safafeer

Work: Software Developer (Assistant manager)
Like: Programming, reading.
Technical site: https://readerman1.wordpress.com

Roger C Moore

Software Developer (Senior)

Canada

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

Sacha Barber

Software Developer (Senior)

United Kingdom

I currently hold the following qualifications (amongst others, I also studied Music Technology and Electronics, for my sins)

- MSc (Passed with distinctions), in Information Technology for E-Commerce
- BSc Hons (1st class) in Computer Science & Artificial Intelligence

Both of these at Sussex University UK.

Award(s)

I am lucky enough to have won a few awards for Zany Crazy code articles over the years

Microsoft C# MVP 2016
Codeproject MVP 2016
Microsoft C# MVP 2015
Codeproject MVP 2015
Microsoft C# MVP 2014
Codeproject MVP 2014
Microsoft C# MVP 2013
Codeproject MVP 2013
Microsoft C# MVP 2012
Codeproject MVP 2012
Microsoft C# MVP 2011
Codeproject MVP 2011
Microsoft C# MVP 2010
Codeproject MVP 2010
Microsoft C# MVP 2009
Codeproject MVP 2009
Microsoft C# MVP 2008
Codeproject MVP 2008
And numerous codeproject awards which you can see over at my blog

shijo joseph

Technical Lead

United States

Started Programming career with VB 6 and VC++ and now Into .Net Development. Working with .Net since its first release (Version 1.0 Beta). Lucky enough to continue always with most updated versions of .Net and as of now; May 2007, fighting with .Net 3.0 (WPF,WCF...etc) and it's next most anticipated version LINQ.

Got familiarity up on the .Net Technologies and Guidelines like CAB, and Patterns and Practices, Enterprise Library and now with it's WPF version etc.

Specialized in Windows and Distributed and Service oriented applications.

Shyam S Singh

India

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

Steve Naidamast

Software Developer (Senior) Black Falcon Software, Inc.

United States

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

Terence Wallace

Founder Arkitech EBC Corporation

United States

MS, BBA, software developer, consultant, and trainer. Specializing in building data-centric applications designed for business, university, community & faith based organizations. Started developing Excel VBA macros and never looked back. Freelance developer utilizing VB.Net, SQL Server, Microsoft Access, and ASP.Net.

urigg123

Engineer

Israel

Distributed software specialist with extensive experience with NServiceBus, Azure, NodeJs and other enterprise technologies.

VijayRana

Technical Lead

India

Hi Myself Vijay having around 7 years of experience on Microsoft Technologies.

Vikas Sharma

Software Developer (Senior)

India

I am currently working as a Senior Software Engineer in Quovantis Technologies and have an experience of more than 4 years in C#.Net. I have my graduation in Bachelor of Computer Applications and hold a diploma in Software Engineering GNIIT from NIIT.
I am very passionate about programming, love to learn new technology and believe in sharing knowledge.
My work experience includes Development of Enterprise Applications using C#,.Net,Sql Server,AngularJS and Javascript.

yash soman

Technical Lead

India

I have worked as a technical lead for MNC's. Currently, I conduct trainings on Microsoft Technologies at Ambrosia Knowledge Center. I am interested in learning new technologies,frameworks, designs etc. I like to distribute whatever knowledge i have so that more people can contribute and innovate things for our future. If you are facing any issues or problems and i could be help do feel free to connect me on my email link Send Mail.

My blog is Coding is Simple

First Prize	Sacha Barber - Bulk Insert into SQL from C#
Prize pool	CodeProject T-Shirt - CodeProject


Second Prize	Math08avan - Handle NULL in SQL Server
Prize pool	Bob Sticker - CodeProject

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.
Entries must be an article, or blog entry.
With the exception of the Everything Else 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).
Articles entries must follow the CodeProject submission guidelines.
No cheating, lying, plagiarizing articles, chicanery, or kicking.
Articles may only be considered for a single category. If an article is eligible for multiple categories (for example, it pertains to both the C# and Web Dev categories), CodeProject editors and judges will decide which category the article shall be entered in.
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 articles 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.
In the event an article has multiple authors and/or contributors, the number of prizes issued is solely at the discretion of the prize issuer.
In the event of a tie, 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 above. Please read the submission requirements before submitting your entry and ensure the article is tagged with at least one of the tags corresponding to that competition's category.

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.