Best Database Article of March 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.

Angular Single-Page Applications - Cool Privilege Control System

29 Mar 2016wells cheung

Angular Single-Page Application, MEF, Privilege Control, WCF Restful Service, ui-router,

SQL

AngularJs

entity-framework

WCF

MEF

How to create a Titled and Labeled Excel Pie Chart with C#

21 Mar 2016B. Clay Shannon

Creating a simple sample Excel Pie Chart, with labeled slices using C# and Excel Interop

.NET

COM

Dev

Progress Bar in Cell – Excel

18 Mar 2016johnniealan

This article describes about adding progress bar in cell.

.NET to Hadoop Connection using Kerberos Ticket

26 Mar 2016Amit Kumar Tiwari

.NET to Hadoop connection using Keytab file

MongoDB Version 2 Some Operations

3 Mar 2016witnes

CRUD with filtering for MongoDB version 2 driver

.NET

MongoDB

MDI Case Study Purchasing - XII - Working With Data

30 Mar 2016stebo0728

Create Azure Database and use it via C#

1 Mar 2016Emiliano Musso

In this short article we will see how to create a SQL database using the services provided by Microsoft Azure cloud platform, and then connect to it via C # code, to perform the normal data insertion and retrieval operations

ADO.NET Implementation of Google API IDataStore

25 Mar 2016freedeveloper

Simple Implementation of Google API IDataStore that use MS-SQL server to store your token file

Use existing sqlite database in Windows phone 8.1

20 Mar 2016Sumit Samediya

In this article we will learn how to use existing sqlite database in WP 8.1 apps.

Log4j2.xml Tweaks

3 Mar 2016Jameson Triplett

Log4j2.xml Tweaks

How to Hash Your Binary Data that Exceed the Limit (8000bytes) of Input Parameter of HASHBYTES in SQL Server

6 Mar 2016markkang

This is about how to hash your binary data that exceed the limit (8000bytes) of allowed input values of HASHBYTES in SQL Server.

Connection Pool Implementation

2 Mar 2016Mahmoud_Gamal

Connection pool java without ConnectionContext

Java

Oracle

Duplicate MySQL Table Using phpMyAdmin

15 Mar 2016Sifiso W Ndlovu

Duplicate MySQL table using phpMyAdmin

All-Topics

MySQL

SVG Filters and Interactivity in Your Project

25 Mar 2016Member 12149082

Description of useful SVG Filters and Interactivity

Building ORM Objects and Store Procedures from an ERD Using Java and Eclipse

29 Mar 2016Giancarlo Rhodes

ORM objects and basic CRUD operation procedures are first phase tasks that come after establishing a first version of the database. This java-based code generation tool builds those classes and stored procedures.

Iterators and Snapshots for LevelDB UWP

13 Mar 2016Zohaib Sibte Hassan

A more detailed look into Iterators and Snapshots in LevelDB UWP

Connection Error While Running Simple ETL Process With Excel using SSIS

22 Mar 2016Bhawesh Tiwari

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager failed with error code 0xC0209303.

SQL

RESTful Day #8: Unit Testing and Integration Testing in WebAPI using NUnit and Moq framework (Part2)

7 Mar 2016Akhil Mittal

In this article we’ll learn on how to write unit tests for WebAPI controllers i.e. REST’s actual endpoints.

Hidden Gems of DEFAULT TRACE in SQL Server

21 Mar 2016Sergii Syrovatchenko

Starting from SQL Server 2005, the default trace is enabled by default on every SQL server. Default trace is a lightweight system trace, which stores a lot of useful information about the changes in the system...

Mongo DB Tutorial and Mapping of SQL and Mongo DB Query

18 Mar 2021VijayRana

A tutorial for MongoDB Tutorial

CRUD Using Scaffolding And Entity Framework

1 Mar 2016syed shanu

In this article, we will see in detail how to create a simple Student Master CRUD (Create/Read/Update and Delete) using scaffolding.

Read Write Excel file with OLEDB in C# (without Interop)

30 Mar 2016koolprasad2003

Read write Excel file without interop using OLEDB in C#

RESTful Day #7: Unit Testing and Integration Testing in WebAPI using NUnit and Moq framework (Part 1)

1 Mar 2016Akhil Mittal

In this article we learn how to write unit tests for core business logic and primarily on basic CRUD operations.

Create a WCF DataService in Visual Studio 2017

15 May 2018NobsterTheLobster

Publish a WCF DataService with entity model, updatable views, filtering and authentication

Inserting JSON Text into SQL Server Table

26 Mar 2016Jovan Popovic(MSFT)

How to easily insert array of JSON objects into SQL Server 2016 tables

High Level Data Profiler Script

3 Mar 2016Gene R. Browning

Get a quick look at your data characteristics using this tool.

How to Access web-server MySQL Database in Java?

23 Mar 2016rohit7209

Use AccessRemoteMySQLDB-API in your project to access web-server MySQL database

Create Insert SQL Statement from the Records in an Existing Table

8 Mar 2016markkang

This tip describes how to generate insert SQL statement from the records in an existing table in SQL server database

SQL Server Web Based Backup Tool

18 Mar 2016M.M.Mohseni

An ASP.NET one page application for getting backup from MS-SQL Server

One Click - DB Script Deployment

26 Mar 2016Mahesh Rajaram Shinde

This project is designed for addressing SQL Server Script deployment on multiple servers and databases.

RESTORE DATABASE is Terminating Abnormally

30 Mar 2016Bryian Tan

Restore Database is terminating abnormally

database

Node.js Application written in Typescript with MongoDB, Express and Socket.io.

28 Mar 2016Prince Cheruvathur

Step by step development of a Node.js application in Typescript using Express and MongoDB with real-time update using Socket.io

Caching in Web API

25 Mar 2016Sibeesh Passion

How to use caching in Web API

Code Sharing in Windows Universal App

20 Mar 2016Sumit Samediya

In this article we will learn how to share code between Windows store app and Windows phone app using Windows Universal App development.

Get Table Column Value as Comma Separated Value (CSV) in SQL

9 Mar 2016Arslan Elahi

Get the Comma Separated Value of one or multiple columns from SQL table

SQL

SQL-Server

CSV

Web API With HttpClient Or Consume Web API From Console Application

28 Mar 2016Sibeesh Passion

Web API With HttpClient Or Consume Web API From Console Application

SQL

HTML

VS2013

spGet Framework 1.0

17 Mar 2016Daniel JXHV

No more ORM, EF, A Stored Procedure direct Access framework for JavaScript.

How To Send Mail Using SQL Server: Part 2

27 Mar 2016Manish kumar choudhary

In this article, you will learn how to select data from a table and send that data to an email using SQL Server 2008.

My DAL Design--- ASP.NET MVC

21 Mar 2016Jamescookxj

Repository Pattern with Generic Interface and Dependency Injection

C#3.0

C#2.0

.NET-Compiler-Platform

How to Send Mail Using SQL Server: Part 3

27 Mar 2016Manish kumar choudhary

In this article, I will explain how to schedule a daily mail from SQL Server 2008.

Current Participants

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

Akhil Mittal

Architect https://codeteddy.com/

India

Akhil Mittal is two times Microsoft MVP (Most Valuable Professional) firstly awarded in 2016 and continued in 2017 in Visual Studio and Technologies category, C# Corner MVP since 2013, Code Project MVP since 2014, a blogger, author and likes to write/read technical articles, blogs, and books. Akhil is a technical architect and loves to work on complex business problems and cutting-edge technologies. He has an experience of around 15 years in developing, designing, and architecting enterprises level applications primarily in Microsoft Technologies. He has diverse experience in working on cutting-edge technologies that include Microsoft Stack, AI, Machine Learning, and Cloud computing. Akhil is an MCP (Microsoft Certified Professional) in Web Applications and Dot Net Framework.
Visit Akhil Mittal’s personal blog CodeTeddy (CodeTeddy ) for some good and informative articles. Following are some tech certifications that Akhil cleared,
• AZ-304: Microsoft Azure Architect Design.
• AZ-303: Microsoft Azure Architect Technologies.
• AZ-900: Microsoft Azure Fundamentals.
• Microsoft MCTS (70-528) Certified Programmer.
• Microsoft MCTS (70-536) Certified Programmer.
• Microsoft MCTS (70-515) Certified Programmer.

LinkedIn: https://www.linkedin.com/in/akhilmittal/

This is a Collaborative Group

780 members

Arslan Elahi

Software Developer (Senior) TECNEX System LLC

Pakistan

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

B. Clay Shannon

Founder Across Time & Space

United States

I am in the process of morphing from a software developer into a portrayer of Mark Twain. My monologue (or one-man play, entitled "The Adventures of Mark Twain: As Told By Himself" and set in 1896) features Twain giving an overview of his life up till then. The performance includes the relating of interesting experiences and humorous anecdotes from Twain's boyhood and youth, his time as a riverboat pilot, his wild and woolly adventures in the Territory of Nevada and California, and experiences as a writer and world traveler, including recollections of meetings with many of the famous and powerful of the 19th century - royalty, business magnates, fellow authors, as well as intimate glimpses into his home life (his parents, siblings, wife, and children).

Peripatetic and picaresque, I have lived in eight states; specifically, besides my native California (where I was born and where I now again reside) in chronological order: New York, Montana, Alaska, Oklahoma, Wisconsin, Idaho, and Missouri.

I am also a writer of both fiction (for which I use a nom de plume, "Blackbird Crow Raven", as a nod to my Native American heritage - I am "½ Cowboy, ½ Indian") and nonfiction, including a two-volume social and cultural history of the U.S. which covers important events from 1620-2006: http://www.lulu.com/spotlight/blackbirdcraven

Bhawesh Tiwari

Software Developer (Senior)

New Zealand

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

Bryian Tan

Software Developer (Senior)

United States

I have over 10 years of experience working with Microsoft technologies. I have earned my Microsoft Certified Technology Specialist (MCTS) certification. I'm a highly motivated self-starter with an aptitude for learning new skills quickly.

Daniel JXHV

United States

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

Emiliano Musso

Software Developer

Italy

Working in IT since 2003 as Software Developer for Essetre Srl, a company in Northern Italy.
I was awarded in 2014, 2015 and 2016 with Microsoft MVP, for Visual Studio and Development Technologies expertise. My technology interests and main skills are in .NET Framework, Visual Basic, Visual C# and SQL Server, but i'm proficient in PHP and MySQL also.

freedeveloper

Software Developer (Senior) Avalon Development

United States

Jose A. Garcia Guirado, Electronic Engineer, graduated in Havana/Cuba 1982, MCTS, MCSD.NET, MCAD.NET, MCSE. Worked in the Institute for Cybernetics and Mathematics of Academy of Science of Cuba for 8 years; since 1995 working as free software architect, developer and adviser, first in Argentina and from 2003 to 2010, in Germany as External consultant in DWS Luxembourg, AIXTRON AG and Shell Deutschland GmbH and from 2010 to 2012 in Mexico working for Twenty Century Fox, and Mexico Stock Exchange (BMV). From 2013 to now in USA, Florida, First in FAME Inc. and now as Senior Software Engineer in Spirit Airlines.

Gene R. Browning

Technical Lead

United States

I have extensive experience in the Information Technology field utilizing a broad range of technologies in a variety of industries with significant knowledge of Information Technology Management, Database Development, Database Administration, Database Architecture/Design, Transactional/ETL Application Development and Data Warehousing.

Giancarlo Rhodes

Software Developer (Senior)

United States

Started engineering as a 5 year old by completely dissembled my father's .38 special replica pistol. I was trying to figure out GOTOs and GOSUBs on the Commodore Vic-20 at 10. Graduated from the University of Missouri-Columbia with a degree in Computer Science in 1998 and have been programming since. My area of focus has been web programming for the last 10 years.

Jamescookxj

Unknown

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

Jameson Triplett

Product Manager Workday

United States

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

johnniealan

Team Leader

United States

My passion is working on solutions architecture and software development, using an extensive range of technical knowledge and expertise in protocol and driver development, programming, communication peripherals and software applications. Leading projects with major global clients I have developed strong skills in all stages of the software development lifecycle and project management, and possess strong communication skills for working with stakeholders from different backgrounds to understand requirements, lead development and testing, deliver reporting, training and post-implementation support.

I am ambitious and committed to always providing a professional service, and am proud to have consistently received promotions and awards in reward and recognition programs.

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.

koolprasad2003

Technical Lead

India

Hi there, I am Prasad. Author, Blogger, contributor and passionate about Microsoft .NET technologies. I like to write an articles/blogs on different .NET aspects and like to help Developers, to resolve their issues and boost them on Microsoft Technologies.

Certifications: Microsoft Certified professional (MCP), Microsoft Certified technology specialist (MCTS), Agile-Scrum Master.

Awards: Microsoft Re-connect MVP (GSC Member), Most valuable member at dotnetspider, Most popular curator, Most active curator, featured curator at Microsoft Curah, Editor at dotnetspider.

Microsoft MVP 2014 [ASP.NET/IIS]
Click here for more .NET Tips
-After all Knowledge is an endless entity

M.M.Mohseni

Software Developer (Senior)

Sweden

Mehdi Mohseni is a Software senior developer (Consultant) in Sigma ITC (www.sigmait.se), Mehdi has a deep experience in N-Tier software applications as well as MVC design pattern. Mehdi has led more than 100 Asp.Net C# or VB.Net Automation applications. Mehdi is working in Toyota Material Handling Logistic Solution as Senior .Net Developer now.

Mahesh Rajaram Shinde

Technical Lead Thomson Reuters

India

Mahesh Shinde is Leader in SQL Server with 14+ years of experience. I’m Microsoft Certified professional in SQL Server, ITIL 3.0 v foundation and Six Sigma Green Belt. As a lead Database Engineer I’ve proven experience in Database Technologies and able to Architect / Design / implement a DB solution which meet client requirement of High Availability, Performance and Reliability with complex SQL server/Oracle database infrastructure. Expert in managing complex production SQL servers across different data centres with wide range of MS SQL servers versions (7.0 To 2012). I’ve proven expertises in SQL server consolidation with virtualization and data cloud offerings helped clients deploy SQL servers in cost effective manner. I’m looking to take up a bigger opportunity where I would be working as solution architect for DB infrastructure as a whole.

Mahmoud_Gamal

Software Developer (Senior)

Egypt

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

Manish kumar choudhary

Software Developer

India

Manish Kumar Choudhary is a passionate and pragmatic software engineer specializing in web application development with ASP.NET MVC, Web API, Entity Framework, NHibernet, Angular, Backbone, HTML5, and CSS. He started programming at the age of twelve on VB.Net and fell in love with it. His dream at the time was to become a software engineer so he pursues programming both academically and professionally. He has a Bachelor of Science in Computer Application and a Master of Science in Computer Application. He has over 3.5 years’ professional experience developing web applications. Outside the software world, he enjoys photography, swimming, cricket and football. Manish is based in Hyderabad, India.

markkang

CEO intelcells

China

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

Member 12149082

Ukraine

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

NobsterTheLobster

Ireland

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

Prince Cheruvathur

Software Developer (Senior)

United States

I work as a consultant in the Seattle/Redmond area. Most of the projects in the past were for Microsoft Corporation.

rohit7209

Student

India

I am a java lover, with some experience of working in web development and mobile development. I have a keen interest in developing java libraries and utility classes. Am not so experienced in software development but still i love to share whatever i know and use techniques. I enjoy learning new things, new stuffs to be a better developer.

Sergii Syrovatchenko

Database Administrator DraftKings Inc.

Ukraine

SQL Server DBA/DB Developer with 10+ years of experience in SQL Server 2005-2019, Azure/GCP. Worked on high-load OLTP/DW projects and develops system tools for SQL Server. In depth understanding of SQL Server Engine and experience in working with big databases. Domain knowledge of ERP/CRM, crawlers, gambling and retail sales. Blogger, mentor and speaker at local SQL Server events.

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

Sifiso W Ndlovu

Technical Lead select SIFISO

South Africa

Sifiso W. Ndlovu is a certified Microsoft professional who holds a Master’s degree in IT Management from the University of Johannesburg. He specializes on a range of enterprise and consumer technologies using open source and proprietary software. He is the member of the Johannesburg SQL User Group wherein he has made several presentations on User Group Meetings and SQL Saturday sessions. He has written for a number of publications including SQLShack.com and SQLServerCentral.com.

stebo0728

United States

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

Sumit Samediya

Software Developer (Senior)

India

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

syed shanu

Team Leader

India

Microsoft MVP | Code Project MVP | CSharp Corner MVP | Author | Blogger and always happy to Share what he knows to others. MyBlog

My Interview on Microsoft TechNet Wiki Ninja Link

VijayRana

Technical Lead

India

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

wells cheung

Software Developer (Senior)

United States

ASP.NET Developer 3.5(Microsoft® Certified Professional Developer)
.NET Framework 3.5, ASP.NET Applications(Microsoft® Certified Technology Specialist)

Wild-Programmer

Technical Lead

United States

I am a developer in Microsoft Technologies like .NET, SharePoint etc.

witnes

Software Developer (Senior) Kensium

Ukraine

Hi,
I'm Acumatica ERP Solutions architect at Kensium. Besides ERP programming my area of interests includes Neural Networks, Machine Learning, Statistics and of course performance optimization.
Here is my blog: http://blog.zaletskyy.com

Zohaib Sibte Hassan

Pakistan

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

First Prize	Jovan Popovic(MSFT) - Inserting JSON Text into SQL Server Table
Prize pool	CodeProject T-Shirt - CodeProject


Second Prize	VijayRana - Mongo DB Tutorial and Mapping of SQL and Mongo DB Query
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.