Best Database Article of January 2017

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.

Entity Framework: Storing Complex Properties as JSON Text in Database

18 Jan 2017Jovan Popovic(MSFT)

Mapping properties in EF model to database columns that contain JSON

HTML

.NET

entity-framework

SQL-Server

Dev

Architect

Database Bot using Oscova

17 Jan 2017DaveMathews

Use Oscova, a bot development framework, to create a Natural Language Interface to an SQL Database

The Secrets of Internet Explorer Credentials

30 Jan 2017Michael Haephrati

Third of several articles covering the secrets of obtaining stored (and encrypted) credentials stored by browsers

A Basic Introduction to Sqoop Import & Export for MySql Table to be Used as Hadoop Distributed File System (HDFS) in Cloudera

7 Jan 2017SrikantSahu

This tip gives basic commands to import table from Mysql to Hadoop File system and Import the files from HDFS back to Mysql.

Use SQL to develop your REST API

20 Jan 2017Ole Oren

Fast and simple REST development for SQL devs

Master Chef (Part 3) ASP.NET Core MVC with Entity Framework Core and Angular2

26 Jan 2017Fred Song (Melbourne)

From this article, I’d like create ASP.NET Core (Net Core) application with Angular 2.

PHPFM: A Single File, Responsive File Manager

5 Feb 2017Michael Chourdakis

A very quick file manager for your PHP site

SQL

SQLite

PHP

Angular 2 Custom Controls with ASP.NET Core WebAPI

25 Jan 2017Nesreen Maged

Angular 2 Type Script Custom Controls Integrated with ASP.NET Core web API

Getting Started with SQLite on Android

3 Jan 2017Peter Leow

Perform CRUD, i.e., Create, Read, Update, and Delete, on data using a SQLite Database on Android

Java

Android

SQLite

Kickstart with .NET Core and MongoDB - Console App

19 Jan 2017AHMAD ANAS

In this article, you will learn how to create console application in .NET Core with NoSQL- MongoDB.

Using Graphviz in your project to create graphs from dot files

5 Jan 2017Andre van Dun

Graphviz graphs from dot specification

Data Change Tracking Solution for Auditing SQL Server

29 Jan 2017Bart Ducal

Universal data change tracking solution for auditing SQL Server databases

Angular 2 & .NET Core Developing Web App From Scratch Part 1: Implementing Restful Web Server

2 Feb 2017O.Nasri

Great article to learn how you can create web application from scratch using Angular2 & .NET Core Web API

What Are The NVL and NVL2 Functions And When Should I Use Them?

24 Jan 2017Database Star

This article explains the difference between the NVL and NVL2 functions in Oracle SQL.

SQL

Oracle

Convert column into rows without using pivot

24 Jan 2017VINEET MISHRA 086

Convert column into rows without using pivot function in SQL

SQL

SQL-Server

Generating Data Dictionary for SQL Server with CatFactory

8 Jan 2017HHerzl

HowTo for generating a data dictionary from existing database

HTML

.NET

SQL-Server

Current Participants

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

AHMAD ANAS

Software Developer

India

I am an passionate technology evangelist. I like reading and talks on technology you can join me on twitter or join my small group on WhatsApp for technology activities https://chat.whatsapp.com/F9LLSJVwKiT8GIOaSXb7u5

Andre van Dun

Program Manager

Netherlands

Engineer with a lot of experience in C-based programming languages and IT in general.

Bart Ducal

Database Developer Internet Solutions

Poland

This member doesn't quite have enough reputation to be able to display their biography and homepage.

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.

DaveMathews

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.

Fred Song (Melbourne)

Software Developer (Senior)

Australia

Fred is a senior software developer who lives in Melbourne, Australia. In 1993, he started Programming using Visual C++, Visual Basic, Java, and Oracle Developer Tools. From 2003, He started with .Net using C#, and then expertise .Net development.

Fred is often working with software projects in different business domains based on different Microsoft Technologies like SQL-Server, C#, VC++, ASP.NET, ASP.Net MVC, WCF,WPF, Silverlight, .Net Core and Angular, although he also did some development works on IBM AS400.

HHerzl

Software Developer

El Salvador

CatFactory Creator.

Full Stack Developer with Experience in C#, Entity Framework Core, ASP.NET Core and Angular.

Jovan Popovic(MSFT)

Program Manager Microsoft

Serbia

Graduated from Faculty of Electrical Engineering, Department of Computer Techniques and Informatics, University of Belgrade, Serbia.
Currently working in Microsoft as Program Manager on SQL Server product.
Member of JQuery community - created few popular plugins (four popular JQuery DataTables add-ins and loadJSON template engine).
Interests: Web and databases, Software engineering process(estimation and standardization), mobile and business intelligence platforms.

Michael Chourdakis

Software Developer

Greece

I'm working in C++, PHP , Java, Windows, iOS, Android and Web (HTML/Javascript/CSS).

I 've a PhD in Digital Signal Processing and Artificial Intelligence and I specialize in Pro Audio and AI applications.

My home page: https://www.turbo-play.com

Michael Haephrati

CEO Secured Globe, Inc.

United States

Michael Haephrati is a music composer, an inventor and an expert specializes in software development and information security, who has built a unique perspective which combines technology and the end user experience. He is the author of a the book Learning C++ , which teaches C++ 20, and was published in August 2022.

He is the CEO of Secured Globe, Inc., and also active at Stack Overflow.

Read our Corporate blog or read my Personal blog.

Follow @haephrati

Nesreen Maged

Technical Lead

Egypt

I am experienced in web development with Microsoft technologies using ASP.NET Core ,C#, ASP.NET MVC, ASP.NET Web Api, ADO.NET ,LINQ, web services. I have a working experience with Model View Controller (MVC), and have been involved in maintaining versions of source code using TFS (Team Foundation Server) 2010. I have also developed web user controls, master pages, validation controls, CSS files using technologies like AJAX Toolkit, JQuery, JavaScript, Telerik UI controls, XML, HTML ,angular 1.4., angular 2 , typescript, SPA single page application.

O.Nasri

Technical Lead

France

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

Ole Oren

Software Developer

Norway

My name is Ole Oren

I am a developer living in Oslo, Norway. I have been working with ASP.NET since version 1.1. Currently I develop mobile business apps using Ionic, Angular and SQL Server.

Peter Leow

Instructor / Trainer

Singapore

“Live as if you were to die tomorrow. Learn as if you were to live forever.”
― Mahatma Gandhi

子曰："三人行，必有我师焉；择其善者而从之，其不善者而改之."

SrikantSahu

Software Developer (Senior)

India

I am a software engineer working in an MNC. I have 4 years of experience in various web technologies.

VINEET MISHRA 086

Software Developer (Senior) Ideavate Indore

India

Vineet Mishra is a Software Engineer. He have been working more than 3 years of professional experience in Software Development industry. Currently he is working with IT
Technical expertise: ASP.NET, C#, Sql Server, MVC , WCF, Windows Service, Jquery

First Prize	Jovan Popovic(MSFT) - Entity Framework: Storing Complex Properties as JSON Text in Database
Prize pool	CodeProject Mug - CodeProject


Second Prize	Ole Oren - Use SQL to develop your REST API
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.