Best Database Article of February 2018

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.

How to Configure Node.js and MongoDB for Production in Ubuntu

23 Feb 2018Manjunath Matathamana

Setting up Node.js and MongoDB backend, and then getting an application up and running can be challenging. This tutorial helps you make the whole process easier.

ECMAScript

Javascript

Ubuntu

Node.js

Case Insensitive Search Filter in OData ASP.NET Core 2.0 Web API as an OWIN Middleware

31 Jan 2018Pawel idzikowski

How to replace the web API request query string to provide case insensitive OData search

ETL Testing, If Only An Automation Rule Testing Engine was Possible …

1 Feb 2018Member 11127135

ETL Testing and data-validation, dynamic SQL rule generator

Snapshot Isolation Level

8 Feb 2018Viral Surani

Snapshot Isolation Level in SQL Server

SQL

SQL-Server

Troubleshooting SQL Code Using Comments

3 Feb 2018Alvin Bunk

How to troubleshoot SQL code using comments

SQL

WCF

Listing Sheets in an Excel File

21 Feb 2018PIEBALDconsult

A simple way to use ADO.NET to get a list of sheets in an Excel file

ADO.NET

Entity Framework Not Inserting Rows into SQL Server Database Table

25 Feb 2018GuyThiebaut

Solving the "Store update, insert, or delete statement affected an unexpected number of rows (0)" response.

SQL Server Brute Force Attack Detection: Part 1

25 Mar 2018Ryan G Conrad

Prevent brute-force login attacks on a remotely accessible SQL Server database using T-SQL

GMaps Control Simplified in VB.NET

16 Feb 2018Len van den berg

GMaps Control Simplified in VB.NET

.NET4.6

.NET

ADO.NET

Securing ASP.NET CORE Web API using Custom API Key based Authentication

6 Feb 2018 Saineshwar Bageri

In this article, we are going to learn how to create a secure Web API in ASP.NET Core MVC.

SQL

VS2017

ASP.NET-Core

Bulk Operations using Entity Framework

3 May 2018Måns Tånneryd

Extending the entity framework with bulk operations for both inserts and updates

SQL Unit Testing with SQL Server Data Tools (SSDT)

8 Feb 2018RahulMittal2018

SQL unit testing with SQL Server data tools (SSDT)

SQL

unit-testing

SSIS custom logging to manage start point for Re-Runs packages

25 Feb 2018ShamimSiddiquee

Manage broken batch packages re-run start point.

Enumerating OleDb Providers

22 Feb 2018PIEBALDconsult

A simple way to enumerate the OleDb Providers installed on the system

.NET

ADO.NET

How to Tell Which Way a One-to-Many Relationship Should Go

22 Feb 2018Database Star

This article explains how to tell if a relationship in a database should be many-to-one or one-to-many.

Learn MongoDB With Me

20 Feb 2018Sibeesh Passion

Here we are going to do some exercises with MongoDB, we will be talking about Mongo Shell, how we can configure MongoDB, what are Indexes in MongoDB, etc.

SQL

Javascript

MongoDB

Repeatable Read and Serializable Isolation Level

6 Feb 2018Viral Surani

To make sure your read data won't be altered during the current transaction.

SQL

SQL-Server

High Performance ADO Database Library

7 Feb 2018Matthew Ruffell

A high-performance and well tested C# ADO library for connecting and querying a SQL database

.NET

VS2013

ADO.NET

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

Alvin Bunk

Software Developer Taft College

United States

I’m a software developer. Currently I’m working at Taft College as a Programmer.

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.

GuyThiebaut

Software Developer

United Kingdom

Graduated with BSc(hons) in Information Systems in 1992 and have had to learn pretty much everything on the job since then.

Currently: Software Developer (Oracle, .NET and Javascript).
Used to be: Developer (SQL Server and .NET), Analyst(Using Oracle, SAS, Excel...) and before that a SQLServer 2000 DBA, Microsoft XAL developer.

Main skill set includes SQL Server, PL/SQL, C#, Javascript, VB .NET, Access, Excel, Word - VBA, SAS...

Interests include reading and things that fly.
I am a keen origami(paper folding) amateur.
Was once a classical guitarist, however Metallica have corrupted my tastes.

I run teboweb.com as a hobby

Len van den berg

Software Developer (Senior)

United Kingdom

I am a relaxed family man, married. I enjoy travelling, cooking (vegetarian), having a coffee and cake in Starbucks, and beach holidays. I like meditation to help me clear my head and relax.

I code and VB6/VB.Net/C#, SAS and SQL, and have over 20 years experience with IT work. I can work remotely or in office. I have a good humorous side and enjoy a good laugh. Life can never be taken too seriously.

Manjunath Matathamana

India

Founder of Storylens - A content publishing platform for the devs. Amateur musician. Favorite quote? "Being a jack of all trades doesn't mean you're a master at none."

Måns Tånneryd

Software Developer (Senior) Tånneryd IT AB

Sweden

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

Matthew Ruffell

Software Developer (Senior) Self

United States

I am a professional software developer, specializing in Microsoft development technologies, with over 18 years experience. I write software and manage software development teams at work, but I also maintain my own apps for personal use.

Member 11127135

Portugal

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

Pawel idzikowski

Software Developer (Senior) Polenter - Software Solutions

Germany

I'm C# developer from Cologne, Germany. Here I owe a small software company. My hobby is general optimization - natural talent of all lazy people Wink | ;-)

PIEBALDconsult

Software Developer (Senior)

United States

BSCS 1992 Wentworth Institute of Technology

Originally from the Boston (MA) area. Lived in SoCal for a while. Now in the Phoenix (AZ) area.

OpenVMS enthusiast, ISO 8601 evangelist, photographer, opinionated SOB, acknowledged pedant and contrarian

---------------

"I would be looking for better tekkies, too. Yours are broken." -- Paul Pedant

"Using fewer technologies is better than using more." -- Rico Mariani

"Good code is its own best documentation. As you’re about to add a comment, ask yourself, ‘How can I improve the code so that this comment isn’t needed?’" -- Steve McConnell

"Every time you write a comment, you should grimace and feel the failure of your ability of expression." -- Unknown

"If you need help knowing what to think, let me know and I'll tell you." -- Jeffrey Snover [MSFT]

"Typing is no substitute for thinking." -- R.W. Hamming

"I find it appalling that you can become a programmer with less training than it takes to become a plumber." -- Bjarne Stroustrup

ZagNut’s Law: Arrogance is inversely proportional to ability.

"Well blow me sideways with a plastic marionette. I've just learned something new - and if I could award you a 100 for that post I would. Way to go you keyboard lovegod you." -- Pete O'Hanlon

"linq'ish" sounds like "inept" in German -- Andreas Gieriet

"Things would be different if I ran the zoo." -- Dr. Seuss

"Wrong is evil, and it must be defeated." –- Jeff Ello

"A good designer must rely on experience, on precise, logical thinking, and on pedantic exactness." -- Nigel Shaw

“It’s always easier to do it the hard way.” -- Blackhart

“If Unix wasn’t so bad that you can’t give it away, Bill Gates would never have succeeded in selling Windows.” -- Blackhart

"Use vertical and horizontal whitespace generously. Generally, all binary operators except '.' and '->' should be separated from their operands by blanks."

"Omit needless local variables." -- Strunk... had he taught programming

RahulMittal2018

Technical Lead Gaja Digital agency

India

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

Ryan G Conrad

Database Developer

United States

I am a database developer working for a SaaS company providing health benefits management software. I have about 8 years of experience working in several SQL database platforms including Microsoft SQL Server, IBM DB2, MySQL, Postgresql, SQLite and possibly others. I particularly enjoy database and query performance tuning.

ShamimSiddiquee

Software Developer

Bangladesh

Working on Microsoft .NET Technology with over 8 years of industry experience. Responsible for developing and managing several applications build on .NET technology. In my day to day, work needs to maintain a set of well-defined engineering practices developed by me and as well as other developer communities, having knowledge in domain-driven design, design architectural framework, user experience, usability engineering and project management.

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

Viral Surani

Architect

India

Software Design Expert with 4+ years of experience working in variety of industries. Very creative problem solver with strong interpersonal skills, Believe in flawless and robust system design, Known for consistently coming up with original ideas and being able to clearly communicate them.

Email : suraniviral@live.com

First Prize	Ryan G Conrad - SQL Server Brute Force Attack Detection: Part 1
Prize pool	CodeProject Mug - CodeProject Bob Sticker - CodeProject


Second Prize	RahulMittal2018 - SQL Unit Testing with SQL Server Data Tools (SSDT)
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.