Click here to Skip to main content
15,069,297 members
This competition has ended

Best Database Article of February 2018

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.

Please Sign up or sign in to vote.
23 Feb 2018
Manjunath 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.
Please Sign up or sign in to vote.
16 Feb 2018
Len van den berg
GMaps Control Simplified in VB.NET
Please Sign up or sign in to vote.
31 Jan 2018
Pawel idzikowski
How to replace the web API request query string to provide case insensitive OData search
Please Sign up or sign in to vote.
1 Feb 2018
Member 11127135
ETL Testing and data-validation, dynamic SQL rule generator
Please Sign up or sign in to vote.
8 Feb 2018
Viral Surani
Snapshot Isolation Level in SQL Server
Please Sign up or sign in to vote.
3 Feb 2018
Alvin Bunk
How to troubleshoot SQL code using comments
Please Sign up or sign in to vote.
21 Feb 2018
PIEBALDconsult
A simple way to use ADO.NET to get a list of sheets in an Excel file
Please Sign up or sign in to vote.
25 Feb 2018
GuyThiebaut
Solving the "Store update, insert, or delete statement affected an unexpected number of rows (0)" response.
Please Sign up or sign in to vote.
25 Mar 2018
Ryan G Conrad
Prevent brute-force login attacks on a remotely accessible SQL Server database using T-SQL
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
3 May 2018
Måns Tånneryd
Extending the entity framework with bulk operations for both inserts and updates
Please Sign up or sign in to vote.
8 Feb 2018
RahulMittal2018
SQL unit testing with SQL Server data tools (SSDT)
Please Sign up or sign in to vote.
25 Feb 2018
ShamimSiddiquee
Manage broken batch packages re-run start point.
Please Sign up or sign in to vote.
22 Feb 2018
PIEBALDconsult
A simple way to enumerate the OleDb Providers installed on the system
Please Sign up or sign in to vote.
22 Feb 2018
Database Star
This article explains how to tell if a relationship in a database should be many-to-one or one-to-many.
Please Sign up or sign in to vote.
20 Feb 2018
Sibeesh 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.
Please Sign up or sign in to vote.
6 Feb 2018
Viral Surani
To make sure your read data won't be altered during the current transaction.
Please Sign up or sign in to vote.
7 Feb 2018
Matthew Ruffell
A high-performance and well tested C# ADO library for connecting and querying a SQL database

Current Participants

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

Saineshwar Bageri
Technical Lead
India 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 United States
I’m a software developer. Currently I’m working at Taft College as a Programmer.
Database Star
Software Developer
Australia 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 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 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.
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 Sweden
No Biography provided
Matthew Ruffell
Software Developer (Senior) Self
United States 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 Portugal
No Biography provided
Pawel idzikowski
Software Developer (Senior) Polenter - Software Solutions
Germany 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 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 India
No Biography provided
Ryan G Conrad
Database Developer
United States 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 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 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 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

Contest Entries and Requirements

  1. 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.
  2. Entries must be an article, or blog entry.
  3. 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).
  4. Articles entries must follow the CodeProject submission guidelines.
  5. No cheating, lying, plagiarizing articles, chicanery, or kicking.
  6. 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.
  7. No author can be nominated twice in the same category.
  8. 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.
  9. 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.
  10. 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.
  11. In the event of a tie, the number of prizes issued is solely at the discretion of the prize issuer.
  12. Multiple votes from the same IP will be automatically disqualified.
  13. The judges’ decision is final and no correspondence will be entered into.
  14. Only those who live in jurisdictions in which this contest is legal may enter.
  15. Any breach of the rules and the prize will be awarded to the runner up.
  16. 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.
  17. 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.

You must sign in to participate in this contest.
This contest has ended.
1 Feb - 28 Feb 2018