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

Aggregation in MongoDB

27 Oct 2016Vikas Sharma

In this article, we will focus on aggregation pipeline. I'll try to cover each major section of it using simple examples. We will be writing mongo shell commands to perform aggregation.

SQL

MongoDB

NoSQL

Writing into a File from Database

4 Nov 2016Wendelius

Few CLR procedure concepts to write into a file from SQL Server database

How to Format Repeating Values in SQL Result Set

13 Oct 2016Wendelius

A little tip on how to format repeating values in SQL output using LAG function

SQL

SQL-Server

Dev

Master Chef (Part 2) ASP.NET Core MVC with Fluent NHibernate and AngularJS

3 Oct 2016Fred Song (Melbourne)

In this article I talk about how to use ASP.NET Core MVC, Fluent NHibernate and Angular JS to implement a CRUD SPA (Single Page Application).

Enable Cross-origin Resource Sharing (CORS) in ASP.NET Core

27 Oct 2016Shashangka Shekhar

In this article, we will focus on how to enable CORS in ASP.NET Core application, get knowledge about CORS policy how we can share resource through different origin.

A simple method to measure execution time in SQL Server

31 Oct 2016Chris Maunder

Timing SQL calls with millisecond accuracy

SQL-Server-2008

SQL-Server

Data Version Control on MS SQL Server (using a generic trigger)

4 Oct 2016Martin Lachman

How to create a system on MS SQL Server for detection of actual changed records in a database table.

Restricting Logon to SQL Server

18 Oct 2016Wendelius

Discussion and a few approaches to restrict logging into SQL Server using a logon trigger or into a database by using a specific procedure

MongoDB CRUD Operations with .NET

2 Oct 2016dileep

This post explains how to implement CRUD Operations in the MongoDB by using C#.

C#5.0

.NET4.5

MongoDB

Always Encrypted Feature in SQL Server 2016

19 Oct 2016Manjuke Fernando

Always encrypted feature in SQL Server 2016

Replace Cyrillic Letters with Visually Similar Latin Letters Using T-SQL

28 Oct 2016Pavel Sinkevich

If data source is populated manually, there is a typical problem: a mix of visually similar Cyrillic and Latin letters. This tip describes how to fix it.

Uechi APM Web is an APM (Application Performance Management) Open Source Server Performance Monitor

7 Oct 2016Paulo Uechi

Uechi APM Web is an APM (Application Performance Management) Open Source Server Performance Monitor written and developed in Java and C # for all Linux and Windows platforms. The Uechi.APM.Web offers a complete resource for unlimited monitoring servers in real time. Have full control of the CPU cons

ODP.NET User Defined Type Implementation

14 Oct 2016George MVC Study

How to use ODP.NET user defined type feature

.NET

ADO.NET

Dev

Creating Custom Key Store Provider for SQL Always Encrypted (Without Key Vault Example PoC)

16 Oct 2016Z Kavtaskin

How to create a Custom Key Store Provider for SQL Always Encrypted (Without Key Vault Example PoC)

Task Server with RDLC Handler and Customizable Handlers

23 Oct 2016Matthew So (Hong Kong)

A task processing server with RDLC Implementation and extensible to customized handlers

SQL

VS2013

dependency

Developing a sample project in Repository Design Pattern with the combination of Entity Frameworks (Code First), Unit of Work Testing, Web API, ASP.NET MVC 5 and Bootstrap

24 Oct 2016Kelum Priyadarshane

This project developed using combination of Entity Framework 6.0 + Code First Approach + Web API 2 + Repository Pattern + ASP.NET MVC 5 + SQL Server 2012 + Unit of Work Testing + Bootstrap.

Understanding JOINs in SQL Server

4 Dec 2016Manjuke Fernando

It's very important to know what sort of JOINs are available in SQL Server and where exactly we can use them, in order to produce accurate results.

DROP IF EXISTS in SQL Server 2016

1 Oct 2016Suvendu Shekhar Giri

Enhancement on dropping an object with check for existence in SQL Server 2016

SQL-Server-2016

SQL-Server

database

Securing ASP.NET Web API when consumed by other .NET Application

15 Oct 2016 Saineshwar Bageri

In this article we are going to have a look on how to secure WEBAPI.

ASP.NET MVC Hotel Booking System Using AngularJS

27 Oct 2016syed shanu

Tutorial for creating a simple web based Hotel Room Booking System using MVC, AngularJS, and WebAPI

Single Page Application (SPA) for Enterprise App (Angular2 & WebApi) - Part 1 - Overview

20 Nov 2018tranthanhtu.vn

How to build the SPA for enterprise application using Angular2 and WebApi (RESTful)

Linked Object Oriented Programming (POOV)

27 Oct 2016Eduardo Mireles

POOV is a programming technique for object-oriented languages developed in MIRA Software Factory by Ing. Eduardo Mireles and experts programmers. It facilitates coding software solutions.

Stored Procedure for Single & List Object in ASP.NET MVC with angularJS

9 Oct 2016Md._Mehedi_Hasan

CRUD operation in .net MVC using Stored Procedure for Single and List Object Data along with SQL Transaction.

A Closer Look at Lookup Tables

20 Oct 2016Bryan Kowalchuk

The two most common database lookup table patterns are examined

How to Establish Dedicated Admin Connection (DAC) to SQL Server

4 Oct 2016Wendelius

Few tips for connecting to an SQL Server instance using DAC

SQL

SQL-Server

Dev

Build Your Own Movie Database with SQL Server

24 Oct 2016Aless Alessio

Use the OLE Automation Procedures to retrieve data from a Web Service and parse the JSON response into a table format

Mocking EF DbContext and DbContextTransaction with Proxy

12 Oct 2016MaDOnos

Accessing SQL from Entity Framework Core Queries in ASP.NET Core

19 Oct 2016Rion Williams

How to access SQL from Entity Framework Code Queries in ASP.NET core

SQL

ASP.NET

Angular2 & WebApi (SPA) for Enterprise App - Part 4 - Multi-Languages (i18n)

28 May 2017tranthanhtu.vn

In this article, we will see how to use multi-languages(i18n) in angular2

Angular2 & WebApi(SPA) for Enterprise App - Part 3 - Project Structure

4 Jul 2017tranthanhtu.vn

This tip explains how we should structure our project folder

Weight History Application for Desktop and Android using the Ring Programming Language

10 Oct 2016Mahmoud Samir Fayed

Simple database application for Desktop and Android written in the Ring Programming Language

Recursive CTE

25 Oct 2016Rahul_Biswas

A simple explanation of the recursive CTE concept of T-SQL

Angular2 & WebApi (SPA) for Enterprise App - Part 5 - DI & IoC - Why and Why not?

15 Jun 2017tranthanhtu.vn

In this article, we will why and why not using DI & IoC from my real situation.I did not tell you that DI is not good. From my view, each tech has it own pros and cons. So It is better if we know when we can use which techs for our business.

Current Participants

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

Saineshwar Bageri

Technical Lead

India

Microsoft Most Valuable Professional
Code Project Most Valuable Author
C# Corner Most Valuable Professional

I am Senior Technical lead Working on.Net Web Technology
ASP.NET MVC,.Net Core,ASP.NET CORE, C#, SQL Server, MYSQL, MongoDB, Windows

Aless Alessio

Software Developer (Senior)

Ireland

Summary
I am an Informatics Engineer with a University Degree in Informatics Engineering and a PhD in Information Engineering.
I have more than 9 years of working experience ICT (from Development to Team Leader) with and In-depth technical / IT know-how.
Practical competences in development, analysis and project management in terms of coordination and content.

Keywords / Skill Set
C# 7.0, NET Core, ASP NET Core, EF Core; HTML(5), CSS(3), Typescript, JavaScript, jQuery,Telerik Kendo, AngularJS, SignalR; MVC, MVVM; SQL, T-SQL, Sql Server; Azure cloud based services, Amazon Web Services
Relevant Web Applications / Tools:
Visual Studio 2017, SQL Server 2016; TFS, Git

Languages: Italian (mother tongue), English (fluent).

Education:

1998 – 2004, University Of Siena (IT), Tuscany

BSc in Informatics Engineering

2004 – 2007, Superior School of Doctorate, University of Siena (IT), Tuscany

PhD in Information Engineering

Bryan Kowalchuk

Web Developer

Canada

Bryan Kowalchuk is a Lead Developer/Architect working in Oakville, Ontario, Canada.

Bryan has been developing large systems using Microsoft technologies for over 15 years in aerospace, legal, financial and logistics industries.

Chris Maunder

Founder CodeProject

Canada

Current passion project: CodeProject.AI Server. Please join in!

Chris is the Co-founder of the popular code-sharing site CodeProject.com, the digital advertising agency DeveloperMedia.com and the content marketing agency ContentLab.IO.

He's been programming way too long and has been, in various guides, an astrophysicist, mechanic, mathematician, physicist, breeder of carnivorous plants, hydrologist, geomorphologist, defence intelligence researcher and then, when all that got a bit rough on the nerves, a serial entrepreneur.

Chris has programmed everything from FORTRAN on a CRAY to Python on a Pi, but generally leans on TypeScript, C#, and SQL for the front, middle and back bits of his applications. His current focus is on ensuring developers know enough about Artificial Intelligence to be dangerous.

dileep

United States

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

Eduardo Mireles

Systems Engineer MIRA

Mexico

Mireles Applications Software Factory
ADAX & POOV

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.

George MVC Study

Software Developer

Canada

I am working with ASP.NET related technologies.

Kelum Priyadarshane

Software Developer (Senior) OCBC Bank Singapore

Singapore

Blog - https://kelums.wordpress.com/
Portfolio - https://kelumkp.github.io/

MaDOnos

Software Developer (Senior)

Turkey

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

Mahmoud Samir Fayed

Egypt

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

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

Martin Lachman

Software Developer (Senior)

Czech Republic

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

Matthew So (Hong Kong)

Founder Software Force

Hong Kong

I am always interested in finding innovative ways for building better applications and founded a technology company since 2003. Welcome to exchange any idea with you and if I am not too busy before deadline of projects, I will reply your emails. Also, if you willing to pay for consulting works and customized software development, you can leave me message.

Md._Mehedi_Hasan

Software Developer

Bangladesh

Worked on ASP.NET MVC, AngularJS, jQuery, T-SQL, LINQ, Kendo UI, SQL Server, Bootstrap. Working on web based application development and fully concentrated on both client side and server side programming.

Paulo Uechi

Architect Uechi.com.br

Brazil

Resume:

Architect specialist technology company, 20 years of experience in software development, working on various technology platforms, high languages and low-level, structured and oriented.

Specializations:

(JAVA/C#/C++/VB.NET/VB 6.0/ ASP.NET / HTML5 / jQuery / MVC / RIA / WCF / WPF / XNA / JSP/ Servlets/ Struts/ Struts2/ JDBC/ SOA /PHP / LUA / Ruby / XML / ASP 3.0 / Silverlight / Frameworks 1.0/1.1/2.0/.3.5/4.0/4.5)
(VS.NET 2003/2005/2008/2010/2012/2013 MS E Blend/VS 6-5/VSS/TFS/SVN/ Eclipse / Netbeans / Rational)
(PL-SQL / DTS / LINQ / SQL Server / Sybase / Oracle / MySQL / Postrgree / Informix / CrystalReports / MS Reporting Service)

Pavel Sinkevich

Belarus

T-SQL developer, SSIS developer, C# developer. Have experience in .Net development, minor experience in web development (ASP.NET, Sharepoint).
Microsoft certification in MS SQL Server 2008 development.
Most recent experience with MS SQL Server 2012, SSIS 2012.

Rahul_Biswas

Database Developer

India

Rahul Biswas is a MSBI developer with 8+ years of industry experience. He is currently employed with a Fortune500 IT MNC. His expertise covers T-SQL, SSIS, SSAS and SSRS.

Rion Williams

Software Developer (Senior)

United States

An experienced Software Developer and Graphic Designer with an extensive knowledge of object-oriented programming, software architecture, design methodologies and database design principles. Specializing in Microsoft Technologies and focused on leveraging a strong technical background and a creative skill-set to create meaningful and successful applications.

Well versed in all aspects of the software development life-cycle and passionate about embracing emerging development technologies and standards, building intuitive interfaces and providing clean, maintainable solutions for even the most complex of problems.

Shashangka Shekhar

Software Developer (Senior) s3 Innovate Pte Ltd

Bangladesh

Hi, I am Shashangka Shekhar,

Working with Microsoft Technologies. Since March 2011, it was my first step to working with Microsoft Technologies, achieved bachelor’s degree on Computer Science from State University of Bangladesh(Dhaka). Have 10+ years of professional experience, currently working as Senior Software Engineer at s3 Innovate Pte Ltd.

I believe in desire of learning & also love to be a part of .Net Community by sharing knowledge’s.

Suvendu Shekhar Giri

Software Developer

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

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

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.

Wendelius

Architect

Europe

Biography provided

Z Kavtaskin

United Kingdom

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

First Prize	Manjuke Fernando - Understanding JOINs in SQL Server
Prize pool	CodeProject Mug - CodeProject


Second Prize	Wendelius - Writing into a File from Database
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.