Best Database Article of May 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 UI-Grid Pagination Server Side

4 May 2016Shashangka Shekhar

In this post I am going to demonstrate how to use Angular UI Grid with server side pagination in ASP.Net MVC application.

SQL

HTML

VS2013

Real time Spreadsheet

27 May 2016Aless Alessio

Reat time Spreadsheet, updating and retrieving data through a Web Service. Using SQL Server DB.If two or more users are working on the same spreadsheet, they can see what the other users are doing. Mouse pointing is highlighted by filling the cell with diagonal stripes, while data saved is highlight

Command Line Tool and C# Class for Uploading Videos on Vimeo

23 Aug 2019Andreask84

A command line tool and a simple C# class with a complete set of functions to easily upload videos on Vimeo

Working with API Help Page Controller Action Description in Web API

12 May 2016Sibeesh Passion

How to enable the API descriptions for better understanding of how our API controller works and what exactly it is supposed to do

SQL

HTML

VS2013

SQL Server Grant Permission to Particular Table

27 May 2016Shashangka Shekhar

In this post, we will create a new user in SQL Server Management Studio (SSMS) & allow access to that user to perform a specific operation.

T-SQL

How to Query Comma Separated Value Column in SQL

28 May 2016Karthik_Mahalingam

How to query comma separated value column in SQL

SQL

Good Performance: Three Developers’ Behaviors that Prevent It!

2 May 2016Android on Intel

In this article, I will talk about applications’ good performance and three developers’ behaviors that prevent it.

Simple Dynamic Scheduler

23 May 2016Miljan Radovic

Simple, open-source, fully customizable, lightweight SQL Server scheduler

MongoDB Tutorial Day 4: Aggregation

21 May 2016VijayRana

Aggregation in MongoDB

SQL

MongoDB

database

Error Message: Saving Changes Is Not Permitted

3 May 2016Michael Haephrati

How to overcome an error message preventing you from saving a change in an SQL Server database

SQL-Server

database

Use SQL CLR Function to Overcome Limitation of SQL User-Defined Function

7 May 2016Tomz_KV

Explain how to use a SQL CLR function to overcome the limitation of a standard SQL user-defined function to execute ad-hoc SQL query.

Measuring COM+ Performance

21 Jun 2016Alexandros Pappas

Measuring COM+ performance

Storing ASP.NET Session Outside webserver – SQL Server vs Redis vs Couchbase

30 May 2016Omar Al Zabir

Storing ASP.NET session outside webserver - SQL Server vs Redis vs Couchbase

SQL

server

Unit Testing Your Repositories – The Code

20 May 2016Gaston Verelst

Unit testing your repositories - the code

SQL

Rednet DataAccess

18 Jul 2021Rednet Software

Rednet.DataAccess is yet another component to work with data that simplifies your use.

Keyboard Query Shortcuts In SQL Server Management Studio

12 May 2016Sibeesh Passion

Some shortcuts that may be useful to you when you work with SQL Server Management Studio

SQL-Server

C++ Object Relational Mapping (ORM)- Eating the Bun - Part 1 of N

20 Apr 2019BrainlessLabs.com, sibani.p

Creating a simple ORM for C++ on-top of SQL database

Adding Permissions to Add/Edit Data Models and Add Reports in BI Publisher 12c

20 May 2016Khrystyna Popadyuk

Provides steps to add permissions to adding or editing data models or adding reports in Oracle BI Publisher 12c.

Oracle

SQLite configuration for C# application targeting any CPU - Part 1

30 Apr 2016Southmountain

A discussion on how to configure folder structures for C# application with SQLite databases and ADO.NET assemblies with targeting to any CPU, no matter 32-bit or 64-bit. Part 1 is theoretic consideration for project folder structures. Part 2 will give a demo to approve this concept.

MySQL Data Importer

20 Feb 2019Igor Krupitsky

Tool that will let you import data from SQL Server and Access to MySQL

How to Insert a DateTime Value into an Oracle Table

17 Jul 2017Database Star

This article explains how to insert a DATE with or without a time into an Oracle table using the INSERT statement.

SQL

Oracle

SQL Server Exercise for Data Warehouse Candidates

21 May 2016Sifiso W Ndlovu

SQL Server exercise for data warehouse candidates

SQL

WCF

Database Normalization

23 May 2016Gaston Verelst

Introduction After I published last week’s article somebody asked me why I stated that (in this case) the problem didn’t originate in having a function with logic, but merely having to work with a database that is not normalized. So let’s talk … Continue reading →

database

Current Participants

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

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

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.

Andreask84

Software Developer

Unknown

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

Android on Intel

United States

Intel is inside more and more Android devices, and we have tools and resources to make your app development faster and easier.

BrainlessLabs.com

Architect

India

I like to explore different aspects of technology. Try new things, and get delighted. My interests are programming language, and Imaging. But its not hard to work on other things also. Algorithms delight me over a coffee break.

I basically code in C++, but JAVA is not so alien for me. I know few scripting languages also. Basically I feel that knowing a programing language is just a matter of getting introduced to it.

For my other articles check my blog on homepage:

http://brainlesslabs.com/

https://github.com/BrainlessLabsInc

http://www.luxrender.net/en_GB/authors_contributors - SMISRA

Database Star

Software Developer

Australia

I'm currently working as a Software Consultant, with a background in Oracle database development. I also run a website that provides SQL and database advice to database developers. I like sharing information and advice with others, so they can improve their career and improve the way that they work.

Gaston Verelst

Architect Faq.be bvba

Belgium

Gaston Verelst is the owner of Faq.be, an IT consultancy company based in Belgium (the land of beer and chocolate!) He went through a variety of projects during his career so far. Starting with Clipper - the Summer '87 edition, he moved on to C and mainly C++ during the first 15 years of his career.

He quickly realized that teaching others is very rewarding. In 1995, he became one of the first MCT's in Belgium. He teaches courses on various topics:
• C, C++, MFC, ATL, VB6, JavaScript
• SQL Server (he is also an MSDBA)
• Object Oriented Analysis and Development
• He created courses on OMT and UML and trained hundreds of students in OO
• C# (from the first beta versions)
• Web development (from ASP, ASP.NET, ASP.NET MVC)
• Windows development (WPF, Windows Forms, WCF, Entity Framework, …)
• Much more

Of course, this is only possible with hands-on experience. Gaston worked on many large scale projects for the biggest banks in Belgium, Automotive, Printing, Government, NGOs. His latest and greatest project is all about extending an IoT gateway built in MS Azure.

"Everything should be as simple as it can be but not simpler!" – Albert Einstein

Gaston applies this in all his projects. Using frameworks in the best ways possible he manages to make code shorter, more stable and much more elegant. Obviously, he refuses to be paid by lines of code!

This led to the blog at https://msdev.pro. The articles of this blog are also available on https://www.codeproject.com/script/Articles/MemberArticles.aspx?amid=4423636, happy reading!

When he is not working or studying, Gaston can be found on the tatami in his dojo. He is the chief instructor of Ju-Jitsu club Zanshin near Antwerp and holds high degrees in many martial arts as well.

Gaston can best be reached via https://www.linkedin.com/in/gverelst/.

Igor Krupitsky

Web Developer

United States

Igor is a business intelligence consultant working in Tampa, Florida. He has a BS in Finance from University of South Carolina and Masters in Information Management System from University of South Florida. He also has following professional certifications: MCSD, MCDBA, MCAD.

Karthik_Mahalingam

Software Developer Infosys

India

All is well Smile | :)

Khrystyna Popadyuk

Software Developer

Ukraine

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

Michael Haephrati

CEO Secured Globe, Inc.

United States

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

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

Read our Corporate blog or read my Personal blog.

Follow @haephrati

Miljan Radovic

Australia

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

Omar Al Zabir

Architect BT, UK (ex British Telecom)

United Kingdom

I am: Head of Engineering Consumer CRM & Billing, BT (ex British Telecom).
I got: 11 Microsoft MVP Awards, 4 CodeProject MVP awards.
I like: Performance and Scalability Challenges.
My Book: Building a Web 2.0 portal using ASP.NET 3.5. Also on Amazon
My Blog: http://omaralzabir.com
My Specialization: Web 2.0, SaaS, Performance and Scalability of Web Apps.
My Email: OmarALZabir at gmail dot com

Follow Me: twitter.com/omaralzabir

My Projects:
Droptiles: Open Source Web 2.0 AJAX Portal
SQL Server real-time monitor
Oracle real-time monitor
Codeuml - UML diagrams as fast as you can type
Fastest Streaming AJAX Proxy
CPU Alerter - Save power, work faster

My Articles:
Top 10 caching mistakes
99.99% Available Production Architecture
10 ASP.NET Performance and Scalability Secrets
UFrame: UpdatePanel and IFRAME combined
Fast ASP.NET web page loading
Fast Streaming AJAX Proxy
Using COM safely inside "using" block without requiring interop assembly
Implementing Word Like Automation Model
Distributed Command Pattern

Rednet Software

Software Developer Rednet Software

Brazil

Working with development since 1995.
I have used Clipper, VB6 e now C#.
Love develop apps with Xamarin

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 12+ years of professional experience, currently working as Technical Lead at Surbana Jurong Private Limited.

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

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.

Southmountain

Software Developer

United States

turns good thoughts into actions...

Tomz_KV

Web Developer

United States

Web & Database Developer. Design and implement web and database applications utilizing Microsoft and other development tools.

VijayRana

Technical Lead

India

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

First Prize	VijayRana - MongoDB Tutorial Day 4: Aggregation
Prize pool	CodeProject T-Shirt - CodeProject


Second Prize	koolprasad2003 - Debug your stored procedure
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.