Best Database Article of November 2016

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.

ASP.NET Web API - Keeping It Simple

25 Nov 2016kannankeril

This article is an attempt at splitting out the controller layer to reduce its complexity and improve quality and maintainability of the resulting code.

.NET4.5

.NET

SQL-Server

How to migrate DevExpress XAF SecuritySystemUser to PermissionPolicyUser

8 Nov 2016mblataric

Instructions on how to migrate existing XAF security system to new permission policy.

How to Publish ASP.NETCore MVC Web Application to IIS in Less Than 5 Minutes

1 Nov 2016O.Nasri

A good tutorial in how you can publish your ASP.NETCore MVC web application to IIS.

PowerShell Script to Split Single-file Routines Export from MySQL Server

28 Nov 2016Sujay Sarma

PowerShell script to split single-file routines export from MySQL Server

PowerShell

MySQL

Continuous Delivery with TFS / VSTS – Commissioning TFS or VSTS

1 Nov 2016Graham D Smith

Commissioning TFS or VSTS

SQL

WCF

Custom pagination and cascaded filtering with rad grid

4 Nov 2016Nagaraj Muthuchamy

Design and implementation of custom pagination and cascaded filtering with rad grid.

Introduction to SQL Server Data Modification Statements

4 Nov 2016essentialSQL

Introduction to SQL Server Data Modification statements

SQL-Server

Generating Random Int SQL Values between Upper and Lower Limits

23 Nov 2016jamuro77

This SQL mini-article is about generating random int values between upper and lower limits, in particular, to load data into demo database.

SQL

Code Review Checklist

24 Feb 2017Ebenezar John Paul

An Ideal Code Review Checklist that applies for most programming languages

Using MongoDB .NET Driver with .NET Core WebAPI

28 Nov 2017Petru Faurescu

How to build step by step an ASP.NET Core WebAPI (.NET Core 2.0) with latest MongoDB driver. The project supports all requests to MongoDB asynchronously.

SQL Server CRUD Actions Using Node JS

1 Dec 2016Sibeesh Passion

In this post, we will see how we can perform CRUD application in our SQL database using Node JS.

SQL

Node.js

Node.js-tools

How to Save Object Graph in Master-Detail Relationship with One Stored Procedure

26 May 2023Vadim Loboda

A way to persist C# object graph to database with single procedure using ADO.NET and table valued parameters

SQL

DBA

database

Artisan.Orm or How to Reinvent the Wheel

15 Jun 2020Vadim Loboda

ADO.NET Micro-ORM to SQL Server

Input, Output and Input/Output SqlParameter Behavior Explained

1 Nov 2016Bob Crowley

In this article, I will explain the sometimes surprising behavior of the ADO.NET SqlParameter and particularly the effects of ParameterDirection, null value and DBNull.Value on how the parameter is sent to the database.

Automate multiple Excel instances

25 Nov 2016JamesFaix

.NET library to access to any running instance of Excel.

C++ Template Classes to Make COM Marshalling Simple

24 Nov 2016Leif Simon Goodwin

I have created two C++ template classes which allow a COM interface to be marshalled between threads with no fuss and no pain

C++

COM

How to use geometry datatype in SSIS for an intersect query

21 Nov 2016sunettew

In this article we will show how you can use SSIS with geometry and intersect.

T-SQL

.NET

data

Hello B4A: Develop Native Android Apps using Visual Basic Syntax

8 Nov 2016Anele 'Mashy' Mbanga

Using Basic4Android, develop your first Android Native App

Introduction to the UPDATE Statement

23 Nov 2016essentialSQL

An introduction to the UPDATE statement

SQL

Introduction to the Delete Statement

23 Nov 2016essentialSQL

Here is an introduction to the Delete statement

SQL

Angular2 & WebApi (SPA) for Enterprise App - Part 6 - RESTful & WebApi

28 May 2017tranthanhtu.vn

In this article, We will have a look to unserstand how RESTful/WebApi was applied in my code

Dodgy Database Solution with JSON

30 Nov 2016Michael Breeden

Using JSON to simplify, solve and enhance SQL Database issues

How to Use COALESCE with Different Data Types

7 Nov 2016Database Star

Use the COALESCE function with different data types correctly

SQL

Oracle

Using PIVOT with SQL Server

3 Dec 2016jamuro77

This article intends to help everybody to write queries with PIVOT clause in SQL Server

SQL

Current Participants

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

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

Bob Crowley

Software Developer (Senior) EVO Payments International

United States

Full stack developer on .Net and related technologies with heavy emphasis on back-end API development and integrations.

Database Star

Software Developer

Australia

I'm currently working as a Software Consultant, with a background in Oracle database development. I also run a website that provides SQL and database advice to database developers. I like sharing information and advice with others, so they can improve their career and improve the way that they work.

Ebenezar John Paul

Software Developer Gislen Software

India

Ebenezar John Paul is a Software programmer & Blogger. He loves to code and rethinks the conventional way of the world.

He believes that pushing limits is the only way to find out what we are really capable of, which is how the human race can redefine impossible and perfection.

And he prefers ideas over rules, results over excuses, people over things, satisfaction over completion and passion over any other.

essentialSQL

Easy Computer Academy, LLC

United States

Hello my name is Kris. I’m here because I am passionate about helping non-techie people to overcome their fear of learning SQL.

I know what it is like to not know where to start or whether the time spent learning is worth the effort. That is why I am here to help you to:
- Get started in an easy to follow step-by-step manner.
- Use your time wisely so you focus on what is important to learn to get the most value from your time.
- Answer your questions. Really! Just post a comment and I’ll respond. I’m here to help.

It wasn’t long ago that I was helping a colleague with some reporting. She didn’t know where to start and soon got overwhelmed and lost as she didn’t know SQL.

I felt really bad, as she was under pressure to get some summary information to her boss, the built-in reports were falling short, and to make them better would require her to know SQL. At that time that seemed impossible! It in dawned on me, it doesn’t have to be that way.

Then I discovered a way for anyone with the desire to easily learn SQL. I worked with my co-worker, started to teach her what I learned and soon she was able to write reports and answer her boss’ questions without getting stressed or ploughing hours into manipulating data in Excel.

It hasn’t always been easy. Sometimes the information seems abstract or too conceptual. In this case I’ve found out that a visual explanation is best. I really like to use diagrams or videos to explain hard-to-grasp ideas.

Having video, pictures, and text really help to reinforce the point and enable learning.

And now I want to help you get the same results.

The first step is simple, click here http://www.essentialsql.com/get-started-with-sql-server/

Graham D Smith

United Kingdom

Dr Graham Smith is a former research scientist who got bitten by the programming and database bug so badly that in 2000 he changed careers to become a full-time software developer. Life moves on and Graham currently manages a team of software engineers and specialises in continuous delivery and application lifecycle management with the Team Foundation Server ecosystem.

JamesFaix

Software Developer

United States

I am a professional developer, but I really create software because it's fun. I've always been interested in deconstructing complex systems, and software engineering has proven to be an inexhaustable supersystem of such systems. In the past I've also spent time focusing on music composition, audio engineering, electronics, game design, history, and philosophy.

My strongest languages are English and C#, in fact I'm a Microsoft Certified Professional for "Programming in C#". I do not have any certifications for English, so please trust me there. I've spent a lot of time working on Windows desktop applications, particularly for interacting with SQL Server or automating Microsoft Office programs, using technologies such as C#, VB.NET, VBA, T-SQL, WinForms, WPF, ADO.NET, the MS Office PIA's, ExcelDNA, EPPlus, and Crystal Reports. I've also done some web development using JavaScript, HTML, CSS, TypeScript, ASP.NET, WCF, jQuery, and requirejs. I am very interested in functional programming (F#, Haskell, Clojure), and try to use C# and JavaScript in a "functional" way at times, but I haven't had the opportunity to use a functional language for a serious project yet.

jamuro77

Architect

Spain

Telecommunication Engineer by University of Zaragoza, Spain.

Passionate Software Architect, MCPD, MCAD, MCP. Over 10 years on the way building software.

Mountain Lover, Popular Runner, 3km 8'46, 10km 31'29, Half Marathon 1h08'50, Marathon 2h27'02. I wish I could be able to improve, but It's difficult by now

kannankeril

United States

ASP.Net Developer
Seattle, WA

Leif Simon Goodwin

United Kingdom

C#/WPF/C++ Windows developer

mblataric

Croatia

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

Michael Breeden

Software Developer (Senior) Magellan Health Services

United States

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

Nagaraj Muthuchamy

Software Developer (Senior) Cognizant

India

Software developer with 10 years experience in developing .NET web applications.

O.Nasri

Technical Lead

France

Microsoft certified professional in C# ,HTML 5 & CSS3 and JavaScript, Asp.net, and Microsoft Azure.

Petru Faurescu

Architect

Denmark

My name is Petru Faurescu and I am a solution architect and technical leader. Technical blog: QAppDesign.com

Sibeesh Passion

Software Developer

Germany

I am Sibeesh Venu, an engineer by profession and writer by passion. I’m neither an expert nor a guru. I have been awarded Microsoft MVP 3 times, C# Corner MVP 5 times, DZone MVB. I always love to learn new technologies, and I strongly believe that the one who stops learning is old.

My Blog: Sibeesh Passion
My Website: Sibeesh Venu

Sujay Sarma

India

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

sunettew

Software Developer (Senior)

New Zealand

I am passionate about BI, data analytics and statistical analysis. I love learning and would one day like to decode the reasoning skills of my 3 year old.

tranthanhtu.vn

Architect

Vietnam

I have more than 8 years in web development for multiple types of applications (ERP, Education System, ...).
I usually organize training/ coaching on specified topic (such as: RESTful/ WebApi, Angular2, BEM, LESS, SASS, EF, NodeJs ....). Please contact me on Skype (tranthanhtu83) or email (contact@tranthanhtu.vn) if need.
For more information about me, Please visit http://www.tranthanhtu.vn/page/about-me

Vadim Loboda

Russian Federation

"It is best to erase all personal history, because that would make us free from the encumbering thoughts of other people."

Journey to Ixtlan by Carlos Castaneda

First Prize	Vadim Loboda - How to Save Object Graph in Master-Detail Relationship with One Stored Procedure
Prize pool	CodeProject Mug - CodeProject


Second Prize	Bob Crowley - Input, Output and Input/Output SqlParameter Behavior Explained
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.