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

WPF Disabled Items Behaviour

6 Aug 2016Clifford Nelson

This tip presents a way to have disabled items in your ComboBox

Javascript

SQL

.NET

VS2013

WPF

Dev

Creating detail grid template at runtime using devexpress gridview

28 Aug 2016Ali Adly

A simple example that shows how to create detail grid template at runtime using ASPxGridView

The Stored Procedure Framework Now Supports Dynamic Fields within Multiple Recordsets

1 Aug 2016dibley1973

The stored procedure framework now supports dynamic fields within multiple recordsets

Using SQLite, Leverage the create_aggregate(), and SQL's Between Operator to Create a Normal Probability Distribution Histogram, or What is More Commonly Referred to as a Bell Curve

8 Dec 2016rerhart585

Using SQLite, leverage the create_aggregate(), and SQL's Between Operator to create a Normal Probability Distribution Histogram, or what is more commonly referred to as a Bell Curve.

Generic Entity Framework AddOrUpdate Method with Composite Key Support

10 Aug 2016Nathan Minier

Generic AddOrUpdate for EF with composite key support

Default Dimension Members Generator (T-SQL)

22 Aug 2016Miljan Radovic

T-SQL script which generates and executes INSERT statements for missing default dimension members (Unknown, Not Available, Not Applicable)

SQL

Azure

data

Transform Clipboard Contents Between Copy and Paste

2 Jan 2021Brad Joss

Alter your clipboard contents before pasting to automate tasks

ASP.NET Core1.0 Insert/Select to Database Using Angular2 and WEB API

24 Aug 2016syed shanu

In this article you will learn about Insert/Select to database using Angular2 and WEB API in ASP.NET Core1.0.

CRUD USING .NET CORE 1.0, ANGULAR V2, WEBAPI

13 Aug 2016Shashangka Shekhar

In our previous article we have seen how to startup with .Net Core. In this article we will take a look on database operation according to previous sample application based previous concept.

Masking Sensitive Data with SQL Server 2016

15 Aug 2016Suvendu Shekhar Giri

How sensitive data in SQL Server 2016 can be masked from the outer world using Dynamic Data Masking

SQL-Server-2016

SQL-Server

database

Validate XML File with XSD Schema in SQL Server

7 Aug 2016Rahul S Chavhan

Validate an XML document in SQL Server using XSD by Rahul Chavhan

Top 10 Exciting New Features in SQL Server Management Studio 2016

23 Aug 2016Suvendu Shekhar Giri

Introduction of new useful features in SSMS 2016

Random Date/Time Test Data Generation

25 Aug 2016Gene R. Browning

Generate random dates (and times if you like) for your test data environment.

Create OData endpoint for MongoDB on MEAN stack

28 Nov 2016Neal Pandey

This article is a tutorial on creating a basic OData (Open Data Protocol) endpoint for a MongoDB database using MEAN stack.

Ways to Compare and Find Differences for SQL Server Tables

18 Aug 2016Michael Ecklin

Sometimes, we need to compare 2 tables to see what was changed. This tip shows you 2 different ways to compare data.

T-SQL

SQL-Server

Video Streaming using Entity Framework and HTML5 in MVC5

13 Oct 2016Sachin Makwana

Convert uploaded video to MP4 and store it in database. Create thumbnail of the uploaded video and Stream the video from Database using HTML5 video tag and Entity Framework.

DROP IF EXISTS in SQL Server 2016 (DIE)

24 Aug 2016Manjuke Fernando

DROP IF EXISTS in SQL Server 2016 (DIE)

Repository Pattern For .Net

28 Aug 2016Halit Yurttaş

Repository Pattern sample over Multiple Datasource or Resource on Domain Object Model

ASP.NET WebForms: Uploading and Importing CSV File to SQL Server

18 Aug 2016Vincent Maverick Durano

A quick demo that highlights how to upload and import CSV file to SQL Server database in ASP.NET WebForms.

Work with Excel Documents on the Server

17 Aug 2016Michael Ecklin

Very often, Excel spreadsheets are using to transfer data between applications. CSV files are also used for the same purposes.

Logtext with Parameters using sqlite3

15 Aug 2016Anthony Lansbergen

Using sqlite3 for a multi language log where logdata can contain parameters.

SQL

SQLite

SQL Table Hierarchy

16 Aug 2016Alexandros Pappas

An SQL script to see the table hierarchy in a database.

Sql Server In Clause With Multiple Literal Values Performance Behaviour

26 Aug 2016Neeraj Prasad Sharma

This article deals with performance difference with literal values

Import CSV Files to SQL Server Process and Common Error

26 Aug 2016sajidur rahman

This article describes about CSV/Excel File import in SQL Server with common problems.

SQL

SQL-Server

file

How Do You Calculate the End of the Month in SQL?

30 Aug 2016essentialSQL

How to calculate the end of the month in SQL

SQL

WCF

Using locks to manage concurrent access to compound relational documents - for MS SQL and other servers

24 Aug 2016Roman Ivantsov

The article provides a comparative analysis and gives patterns of using explicit locks to manage concurrent access to database documents (data split over multiple tables) in MS SQL Server, MySql, PostgreSql and Oracle. As it turned out, the solution is not always obvious or simple.

Connecting to an MS SQL Instance using NodeJS (Fixing ConnectionError: Port for SQLServer not found in ServerName & Failed to connect to localhost:undefined in 15000ms)

15 Aug 2016Manjuke Fernando

Connecting to MS SQL Server using NodeJS

SQL

Node.js

How to Get Geolocation Address by Using Google geolocation API in ASP.NET Web API

7 Oct 2016Shamim Uddin

In this article, we are going to learn how to get geolocation address by using Google geolocation API in ASP.NET Web API.

Hierarchical Query in Database

27 Aug 2016Shamim Uddin

We will learn about hierarchical query in database with real example.

SQL Server 2016 - Always Encrypted

19 Aug 2016RahulBansode

SQL Server 2016 - Security Feature - Always Encrypted

Current Participants

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

Alexandros Pappas

Software Developer (Senior) Unisystems

Greece

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

Ali Adly

Software Developer (Senior) TecSolutionGroup

Saudi Arabia

I am a software engineer at TecSolutionGroup company.
About 3 years experience in developing server side modules for Enterprise Solutions using technologies of Java (C#,ASP.net MVC, Razor).

Specialties: Back ends, Server side development, System Design, OOP, Test, Driven Development

Languages:
Java, SQL, XML, HTML, C#, ASP.NET,python

Anthony Lansbergen

Netherlands

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

Brad Joss

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.

Clifford Nelson

Software Developer (Senior) Clifford Nelson Consulting

United States

Has been working as a C# developer on contract for the last several years, including 3 years at Microsoft. Previously worked with Visual Basic and Microsoft Access VBA, and have developed code for Word, Excel and Outlook. Started working with WPF in 2007 when part of the Microsoft WPF team. For the last eight years has been working primarily as a senior WPF/C# and Silverlight/C# developer. Currently working as WPF developer with BioNano Genomics in San Diego, CA redesigning their UI for their camera system. he can be reached at qck1@hotmail.com.

dibley1973

Software Developer

United Kingdom

Duane has worked in a commercial software development environment for 9 years, with all but three for a global fashion retailer.

He is proficient in ASP.Net, MVC, C#, HTML, CSS, JavaScript, SQL Server TSQL.

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/

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.

Halit Yurttaş

Software Developer (Senior)

Turkey

Senior software developer working over 15+ years. Familiar wide range development experience as database, service, game, multiplatform etc applications. Have turkish blog is http://halityurttas.com.tr for looking somethings.

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

Michael Ecklin

United States

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

Miljan Radovic

Australia

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

Nathan Minier

Software Developer

United States

Specialized in Web Application back-end development using .NET(C#)

Neal Pandey

Technical Lead / Consultant

United States

I am a Full Stack Web Developer/Architect with 15+ years of experience. My primarily expertise is in building Web Application on .NET stack but I do often indulge in open source technologies and NoSQL world. C# and SQL are my favorite languages but I don't mind learning anything new which makes life easier for us. My genuine interest in software technology motivates me to evaluate different technologies and develop solution that suits the best.

Neeraj Prasad Sharma

Software Developer (Senior) Netprophets Cyberworks Pvt Ltd

India

Neeraj Prasad Sharma is a SQL Server developer who started his work as a dot net programmer.
He loves SQL Server query optimizer`s capability to process the queries optimally.
For the last six years he has been experimenting and testing Query Optimizer default behavior and if something goes wrong his goal is to identify the reason behind it and fix it.

Rahul S Chavhan

Software Developer

India

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

RahulBansode

Program Manager

United States

- Over 12 years of experience in IT Industry and performed various roles Including Associate Project Manager, Project Lead, Sr. Software Engineer.
- Performed various operations like Delivery, Managing, Designing, Analysis, Development, Implementation and Testing/Reviewing software products and applications
- Over 6+ years of experience in Customer Engagement, Delivery, and Project Management.
- Excellent skills in Project Management, Customer Expectation Management, Inter-personal communication, Team Building and Analysis
- Executed various project on domain likes Capital Market, Corporate Banking, Retail Banking, Exhibition Industry etc.
- Executed various projects developed on Microsoft Platforms technologies like .NET, C#, VB.Net, ASP. Net, MVC, WCF, WPF, VC++, MS SQL Server.

Specialties: Microsoft .Net Platform, SQL Server, Finance Domain, Project Management

rerhart585

Software Developer

United States

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

Roman Ivantsov

Software Developer (Senior) Microsoft

United States

25 years of professional experience. .NET/c#, databases, security.
Currently Senior Security Engineer, Cloud Security, Microsoft

Sachin Makwana

Software Developer

India

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

sajidur rahman

Bangladesh

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

Shamim Uddin

Software Developer Amber Software Solution Ltd.

Bangladesh

Hi, I am Shamim Uddin.Working with Microsoft Technologies.

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

Vincent Maverick Durano

Architect

United States

A code monkey who loves to drink beer, play guitar and listen to music.

My Tech Blog: https://vmsdurano.com/
My Youtube Channel: https://www.youtube.com/channel/UCuabaYm8QH4b1MAclaRp-3Q

I currently work as a Solutions Architect and we build "cool things" to help people improve their health.

With over 14 years of professional experience working as a Sr. Software Engineer specializing mainly on Web and Mobile apps using Microsoft technologies. My exploration into programming began at the age of 15;Turbo PASCAL, C, C++, JAVA, VB6, Action Scripts and a variety of other equally obscure acronyms, mainly as a hobby. After several detours, I am here today on the VB.NET to C# channel. I have worked on Web Apps + Client-side technologies + Mobile Apps + Micro-services + REST APIs + Event Communication + Databases + Cloud + Containers , which go together like coffee crumble ice cream.

I have been awarded Microsoft MVP each year since 2009, awarded C# Corner MVP for 2015, 2016,2017 and 2018, CodeProject MVP, MVA, MVE, Microsoft Influencer, Dzone MVB, Microsoft ASP.NET Site Hall of Famer with All-Star level and a regular contributor at various technical community websites such as CSharpCorner, CodeProject, ASP.NET and TechNet.

Books written:
" Book: Understanding Game Application Development with Xamarin.Forms and ASP.NET
" Book (Technical Reviewer): ASP.NET Core and Angular 2
" EBook: Dockerizing ASP.NET Core and Blazor Applications on Mac
" EBook: ASP.NET MVC 5- A Beginner's Guide
" EBook: ASP.NET GridView Control Pocket Guide

First Prize	Alexandros Pappas - SQL Table Hierarchy
Prize pool	CodeProject Mug - CodeProject


Second Prize	Suvendu Shekhar Giri - Masking Sensitive Data with SQL Server 2016
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.