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

Lightning-Fast Nested User Groups in C#

5 Dec 2015Daniel Miller

This article describes the C# implementation for a high-performance user/role security principal hierarchy.

Javascript

.NET4.5

.NET

Hadoop For .Net & AngularJS Developers

29 Dec 2015Bert O Neill

Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)

Javascript

.NET-Compiler-Platform

How to Split Microsoft SQL Server Table Row Data

18 Dec 2015Md. Marufuzzaman

This tip shows you an easy way to split Microsoft SQL Server table row data.

MySQL Double Instance Creation and Database Transfer in CentOS

13 Dec 2015Nazar.Bukhari

This tutorial will demonstrate the creation of second mysql instance and transfer a database from the first instance to the second.

Linux

MySQL

Import Images to SQL Server using SSIS

26 Dec 2015sandeepmittal11

Import Images to SQL Server Database using SSIS

SQL

SSIS

Entity and Mapping Class Generator for EF

29 Dec 2015Daniel Miller

This tip provides a simple solution to automate the generation of entity and mapping classes for Entity Framework.

Data Cache Synchronization using AWS SNS and Lambda

29 Dec 2015Peter Carrasco

This article describes a pub-sub model using AWS Lamdba along with SNS to keep your AWS-hosted RDMB system of record and cache in sync.

Best Database Managers for Developers

14 Dec 2015Steve Naidamast

The technical management of relational databases is a highly mature technology in the software development profession.

database

SCALA : TESTING OUR CODE

14 Dec 2015Sacha Barber

So last time we looked at how to use Slick to connect to a SQL server database. This time we look at how to use one of the 2 popular Scala testing frameworks.

Scala

SQL-Server

Attunity Connectors to Transfer Data from Oracle to SQL Server using SSIS

7 Dec 2015Divyant Kulshrestha

This tip is useful when we have to move data from Oracle database to SQL Server database or vice-versa using SSIS.

Using Java Codes to Capture PIV4/IPV6 Packages

20 Dec 2015JinWenQiang

How to capture and process packages using Java language

Pushing Compression from node.js to SQL Server

11 Dec 2015Jovan Popovic(MSFT)

In this article, you will see how to compress data in SQL Server using GZip algorithm and send it via node.js to browser.

SCALA : Connecting to a database

14 Dec 2015Sacha Barber

This time we will proceed to look at using Scala to connect to SQL server.

Scala

database

Dynamic Pivot Grid Using MVC, AngularJS and WEB API 2

6 Dec 2015syed shanu

Simple MVC Pivot HTML Grid using AngularJS and Web API 2

Import a Flat file with Header and Detail Rows in SSIS

17 Dec 2015sandeepmittal11

Import a Flat file with Header and Detail Rows in SSIS

SQL

SSIS

Part 1: Building web app using react.js, express.js, node.js and mongodb

31 Dec 2015Nishant_Chaturvedi

This is a multi-parts series on building web applications using react.js, node.js, express.js, and mongodb.

DBA Skills for developers

3 Feb 2016DataBytzAI

Useful things to know for developers put in charge of an MS database server

SQL

SQL-Server

Dev

Christmas Carol: XML Signatures

30 Dec 2015Ivan Krivyakov

Christmas Carol: XML Signatures

ERP INFRASTRUCTURE

15 Dec 2015databaseobjectmodel

A sample infrastructure project such as erp, mrp, crm, admin panel.

SQL

HTML

.NET-Compiler-Platform

Authentication and Authorization using Asp.net Identity in MVC Project

21 Dec 2015Khademul Basher

Authentication and Authorization using Asp.net Identity

DataGridView CRUD With Saving Image to SQL Server using C#

16 Dec 2015syed shanu

In this article, you will learn how to perform DataGridView CRUD with saving image to SQL Server using C#.

SQL Server Table and Column Naming Conventions

30 Dec 2015Daniel Miller

This article describes standard naming conventions for tables and columns, and it provides code that leverages the conventions to visualize dependencies and automatically validate and generate foreign key constraints.

Learn to create MSBI ( Microsoft Business Intelligence) project in 7 days

28 Dec 2015 Marla Sukesh

In this article we Learn step by step how to create project with MSBI.

SQL

artificial-intelligence

A Simple and Another Way to Find Rows on n’th Maximum Number from a Table

23 Dec 2015Md. Marufuzzaman

A simple tip/trick to get rows on n’th maximum number from a table

A Plug and Play Logging Library for Dummies

20 Dec 2015shijo joseph

An easy to implement yet powerful logging library which requires absolute zero learning curve

Creating Date dimension from scratch in Microsoft SSAS

12 Dec 2015Miljan Radovic

Script to generate DimDate for specified date range

A Simple Example of Microsoft SQL Server Pad String

18 Dec 2015Md. Marufuzzaman

A simple example of Microsoft SQL Server Pad String

Verify Oracle Client Installation

1 Dec 2017WernfriedD

Single .exe to verify if your Oracle Client is properly installed and working. Verify supported technologies for Oracle connection.

How to identify worst performing queries & improve their performance

2 Dec 2015Rajesh Kumar

This article is all about how to identify the worst performing queries in the running application or some specific module of the aplication.

Overloaded Server: Quick Fix

7 Dec 2015Igor_A

Review of an approach of increase clustered server performance. Library sample and test utility.

Getting Started with Mean Stack

23 Dec 2015Ashwin. Shetty

Writing your first app using Mean Stack (M = MongoDB, E = Express.JS, A = Angular.JS and N = Node.js)

Current Participants

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

DataBytzAI

Chief Technology Officer SocialVoice.AI

Ireland

Allen is CTO of SocialVoice (https://www.socialvoice.ai), where his company analyses video data at scale and gives Global Brands Knowledge, Insights and Actions never seen before! Allen is a chartered engineer, a Fellow of the British Computing Society, a Microsoft mvp and Regional Director, and C-Sharp Corner Community Adviser and MVP. His core technology interests are BigData, IoT and Machine Learning.

When not chained to his desk he can be found fixing broken things, playing music very badly or trying to shape things out of wood. He currently completing a PhD in AI and is also a ball throwing slave for his dogs.

Marla Sukesh

Founder Just Compile

India

Learning is fun but teaching is awesome.

Who I am? Trainer + consultant + Developer/Architect + Director of Just Compile

My Company - Just Compile

I can be seen in, @sukeshmarla or Facebook

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

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.

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.

databaseobjectmodel

Turkey

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

Divyant Kulshrestha

Database Developer

India

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

This is a Social Group (No members)

Igor_A

Technical Lead

Ukraine

Igor Alexeev (axaprj2000@yahoo.com)
.NET Development, Architecture, Tech. Consulting

Ivan Krivyakov

Technical Lead Thomson Reuters

United States

Ivan is a hands-on software architect/technical lead working for Thomson Reuters in the New York City area. At present I am mostly building complex multi-threaded WPF application for the financial sector, but I am also interested in cloud computing, web development, mobile development, etc.

Please visit my web site: www.ikriv.com.

JinWenQiang

Engineer

China

WenQiang Jin received his B.A in Information and Telecommunication Engineering from CQUPT, China. He is currently a Masters student in Telecommunication at CQUPT. He received network engineering certificate from China Government. His research interest is SDN, wireless network programming,Network Calculus,Network Computing,and software testing.

HE IS CONSIDERING TO APPLY A Ph.D DEGREE IN ENGLISH-SPEAKING COUNTRIES. PLEASE CONTACT HIM.

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.

Khademul Basher

Founder http://softwarelandmarks.com/

Bangladesh

I am in Software Development for more than 12 years. I am expert on Microsoft Platform for Web Forms, MVC, MVC Core, Web API, Desktop App, PHP etc. I am also expert on jQuery, AngularJS, Bootstrap, Font Awesome, Telerik UI, Kendo UI etc. I know BackboneJS, KnockoutJS also. I am an article writer. I have many articles in CodeProject.

Email: khademulbasher@gmail.com

Md. Marufuzzaman

Architect

Bangladesh

A well experienced leader with successful track record of software development, product innovations, brand management and corporate communication etc. Some successful product innovations have also achieved and awards “Most Valuable Professional” (MVP) at 2010 and 2011 by codeproject.com and also selected as a mentor of codeproject.com. Published over 100 technical articles in various software development resource sites (i.e., codeprojetc.com, Microsoft MSDN, and IEEE & IBM (In progress)) and various IT Forums, Blogs etc.

Over fourteen years of professional experiences in ICT field having extensive experience in formulating corporate vision and long term strategy. Leading development related functions including design, development, services, data management and analytics, customer experience management, content services, digital analytics and optimization.I have also more than two years’ of strong experience in mobile-VAS (platform development).

An individual with results-driven approach and relentless in pursuit of excellence from a business and organizational standpoint.Honest, believes in transparency, commitment and teamwork.

Expertise: Software/Solution Architect, Technical Research, MIS, Data Analytics, Data Mining, BI, SaaS platform base application development, Large scale Win32 Form/Web based business software solutions, Security, Enterprise applications development, integration, etc.

Technologies/Tools: Microsoft.Net, Microsoft SQL Server , Oracle, MySQL, ETL, Visual C#, VB.NET, ASP.NET, , Python, Java, API, MVC, Cloud Computing, SaaS, Open FaaS, AWS,AWS Lambda, MS Azure, WebAPI , WPF, WCF, PHP, Microsoft Power BI, SPSS, PS2, R, Add-In, Visual Basic etc.

.Net UI component: Telerik, DevExpress, Ext.Net etc.
Scripting language: JavaScript, AngularJS, node.JS etc.
Source control / Subversion: Git, Smart SVN, Assembla etc.
Development methodologies: Agile,RAD etc.
Project Management / Issues Tracking Tools: JIRA, Trello, Slack, Clockingit etc.

Miljan Radovic

Australia

Business Intelligence Professional passionate about turning data into meaningful information and helping business grow and make better "data-driven" decisions.

Nazar.Bukhari

Software Developer Onnorokom Software

Bangladesh

I am a passionate java developer ,interested in Cyber Security . Completed my graduation in Computer Science and Engineering from Jahangirnagar University,Dhaka. I have a keen interest on developing web application.
Professional working experience on java based application along with API design using node.js

Mail address : nazar.bukhari12@gmail.com

Nishant_Chaturvedi

Software Developer (Senior)

India

I am a technology lover and software engineer by profession. I enjoy writing code and I work on .NET, JavaScript, NodeJs, Microsoft Azure and other related web technologies.

Peter Carrasco

Team Leader

United States

I am a senior software engineer and technical lead for a mid-sized technology firm. I have an extensive background in designing, developing, and supporting ASP.NET web-based solutions. I am currently extending my skill-set to the area of application identity management and access control.

Rajesh Kumar

Architect GlobalLogic (Hitachi Group)

United States

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

sandeepmittal11

India

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

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.

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.

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

WernfriedD

Software Developer (Senior)

Switzerland

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

First Prize	Marla Sukesh - Learn to create MSBI ( Microsoft Business Intelligence) project in 7 days
Prize pool	CodeProject T-Shirt - CodeProject


Second Prize	DataBytzAI - DBA Skills for developers
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.