Click here to Skip to main content
15,881,757 members
This competition has ended

Best Database Article of April 2015

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.
2 Apr 2015Dr Gadgit
Written in C# and VS2010 as a class libary to be used in your own project.
Please Sign up or sign in to vote.
5 Apr 2015Anele 'Mashy' Mbanga
Demonstrates creation of apps using JQM.Show, a RAD JQuery Mobile Development Platform: A second installment of the article
Please Sign up or sign in to vote.
10 Apr 2015Rajeesh Madambat
Refer and write your own business logic in C# and add it to SSIS script task.
Please Sign up or sign in to vote.
26 Apr 2015Anton Angelov
Tutorial how to create test cases statistics for the automation status and their distribution by priority. Steps how to setup SSRS and TFS Data Warehose.
Please Sign up or sign in to vote.
8 Apr 2015ColdskyXia
How to get started with mongodb
Please Sign up or sign in to vote.
20 Apr 2015Karsten Krug
A workaround for reporting services' missing ability to customize report parameter placement.
Please Sign up or sign in to vote.
29 Apr 2015AjithKp560_
FTP Client for Web server.
20 Apr 2015Jeffrey T. Fritz
How IT operations can engage more with a customer’s experience and assist software development in isolating problems in a production environment with no code changes needed from the development engineers.
6 Apr 2015Android on Intel
The objective of this article is to show a method for accessing a REST based database backend from an Android* app using MongoDB* and Spring IO*.
Please Sign up or sign in to vote.
5 Apr 2015ColdskyXia
Installing Mongodb
Please Sign up or sign in to vote.
12 Apr 2015ColdskyXia
How to add new documents to a collection more efficiently
Please Sign up or sign in to vote.
12 Apr 2015ColdskyXia
How to remove documents from a collection more efficiently
Please Sign up or sign in to vote.
7 Apr 2015Anele 'Mashy' Mbanga
Demonstrates creation of web apps using JQM.Show, a RAD JQuery Mobile Development Platform: 3rd final installment.
Please Sign up or sign in to vote.
8 Apr 2015Anele 'Mashy' Mbanga
Demonstrate how you can create a JQuery Mobile app and use XML as a backend - single XML record approach by using xml2json.js and json2xml.js.
Please Sign up or sign in to vote.
3 Apr 2015SatyLepide
MS SQL Server, a popular database management system from Microsoft, is widely used by organizations to store their data and to fetch them when required.
Please Sign up or sign in to vote.
21 Apr 2015Braden Murphy
Lightweight SQL & HTML Web Server Reporting
Please Sign up or sign in to vote.
22 Apr 2015lakhdarr
Working with different data stores (SQL, NoSQL ..) in high performance enterprise application using DDD and Repository unit of work pattern
Please Sign up or sign in to vote.
27 Oct 2015Wonde Tadesse
An article that explain hows to expose SignalR feature through an ASP.NET Web API, which helps applications that can use REST service and to broadcast a real-time message to their clients.
Please Sign up or sign in to vote.
9 Sep 2015syed shanu
Use AngularJS and WCF Rest Service to create an online Mind Reader quiz game
Please Sign up or sign in to vote.
6 Apr 2015Dr Gadgit
Covers SSDP messages and XML replies plus how to stream a play-list
Please Sign up or sign in to vote.
27 May 2015Sander Rossel
The first in a series on MEAN web development.
Please Sign up or sign in to vote.
27 Jul 2015syed shanu
Design your Winform at Runtime.Perform CRUD operation to your Form at Runtime with out writting any code using Stored Procedure.
Please Sign up or sign in to vote.
22 Apr 2015John Atten
Installing and configuring PostgreSQL on a Linux box is either simple, because you are a Linux and/or Postgres expert, or not so simple, because you are new(er) to Linux, Postgres, or both. Over the past year, I have resided firmly in the latter camp.
Please Sign up or sign in to vote.
11 Apr 2015Database Star
This article explains how to download and install Oracle Express and SQL Developer on your own computer, to get started with running SQL queries.
Please Sign up or sign in to vote.
18 Apr 2015Soufiane Rabhi
Business application based on WPF MVVM and Entity Framework 6
Please Sign up or sign in to vote.
17 Apr 2015Emiliano Musso
A quick method to add days to a date, skipping weekend days if the number of days added results in a Saturday/Sunday
Please Sign up or sign in to vote.
29 Apr 2015santosh poojari
The idea is to source SSRS report datasource with web api output. The datasource can take XML input datasource hence we can allow web api to give us desired XML output dataset in defined format or schema. Once we have that it is easy to sourced or housed it into SSRS reports -RDL or Client RDLC in .
Please Sign up or sign in to vote.
1 Apr 2015Ajit Kumar Thakur Microsoft
This tip describes steps to learn DOS batch programming.
Please Sign up or sign in to vote.
21 Dec 2016John C Rayan
MyBatis.NET as DataMapper
Please Sign up or sign in to vote.
16 Apr 2015Acharya Raja Sekhar
Capture SQL Server queries fired from your application
Please Sign up or sign in to vote.
9 Apr 2015Gordon Beeming
They said Select * was bad but...
Please Sign up or sign in to vote.
28 Apr 2015Piusn
Management Studio for Mongodb, -Mongodb Part 3
Please Sign up or sign in to vote.
22 Apr 2015Shivangi_K
SQL Server health check up
Please Sign up or sign in to vote.
16 Apr 2015sx2008
how to get as much information about your database as possible via ADO.NET

Current Participants

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

Software Developer (Senior)
India India
Working as a Senior Developer in an MNC with 3+ years of experience in .Net related technologies. Passionate about programming and software architecture.
Database Developer Microsoft
India India
I am Ajit Kumar Thakur. I am Consultant in Microsoft Global Delivery India. I work on Database (SQL Server), BI (SSAS, SSRS,SSIS),and Windows Powershell. I have 8 years of experience in Database and BI project development.
Systems Engineer Tata Consultancy Service Ltd.
India India
Name Ajith Kp. Currently working at Tata Consultancy Service Ltd. I completed MCA from School of Information Science and Techonolgy, Kannur University Campus, Mangattuparamba. I like programming as well as computer/network security analyzing. I'm concentrating programming in Android, PHP, Python, Ajax, JQuery, C# and JAVA.

Blog: http://www.terminalcoders.blogspot.com

Knowledge in Java, Python, PHP, and Android.
United States United States
Intel is inside more and more Android devices, and we have tools and resources to make your app development faster and easier.

Software Developer SITHASO HOLDINGS (PTY) LTD
South Africa South Africa
I'm a Bachelor of Commerce graduate, fell inlove with ICT years back with VB5. Used Pick & System Builder to create a windows app. Very curious, developed my first web database app called Project.Show using ExtJS. Published on Google Play Store, learned JQuery Mobile, a project manager at best. My first intranet app eFas with MySQL.

Fear closes people to a lot of things and we hold ourselves back being held by it. Thus the sooner you believe you can't do something, the sooner everything will work towards that belief. Believe in yourself at all times because you can do anything you set your mind to it!

I have a very beautiful woman and four kids, the best joys in the world. East London, South Africa is currently home.

Awards:

Best Mobile Article of February 2015 (First Prize)
http://www.codeproject.com/Articles/880508/Create-a-CRUD-web-app-using-JQuery-Mobile-and-Loca

Best Mobile Article of May 2015 (Second Prize)
http://www.codeproject.com/Articles/991974/Creating-JQuery-Mobile-CRUD-Apps-using-JQM-Show-Ge

Apps
Bible.Show (Android Store App)
https://www.facebook.com/bibleshow
https://play.google.com/store/apps/details?id=com.b4a.BibleShow

JQM.Show (Android Store App)
https://www.facebook.com/jqmshow
https://play.google.com/store/apps/details?id=com.b4a.JQMShow

CodeProject.Show (An offline CodeProject Article writer)
http://www.codeproject.com/Articles/993453/CodeProject-Show-A-CodeProject-offline-article-wri
CEO Automate The Planet
Bulgaria Bulgaria
CTO and Co-founder of Automate The Planet Ltd, inventor of BELLATRIX Test Automation Framework, author of "Design Patterns for High-Quality Automated Tests: High-Quality Test Attributes and Best Practices" in C# and Java. Nowadays, he leads a team of passionate engineers helping companies succeed with their test automation. Additionally, he consults companies and leads automated testing trainings, writes books, and gives conference talks. You can find him on LinkedIn every day.
Software Developer Symmetric Technology Software
South Africa South Africa
Braden has a degree in Information Technology from the University of Greenwich in the United Kingdom. He has been developing specialized software for Security Applications, Biometrics and Distributed Building Management since 2009. Braden has a passion for innovative software and smart visualization.
China China
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
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.
United Kingdom United Kingdom
Old dog that is tired of learning new tricks when the new dish they are cooking never tastes quite so good as the old one.
Software Developer
Italy Italy
Working in IT since 2003 as Software Developer for Essetre Srl, a company in Northern Italy.
I was awarded in 2014, 2015 and 2016 with Microsoft MVP, for Visual Studio and Development Technologies expertise. My technology interests and main skills are in .NET Framework, Visual Basic, Visual C# and SQL Server, but i'm proficient in PHP and MySQL also.
Architect SSW
South Africa South Africa
Program Manager
United States United States
Jeff Fritz is a senior program manager in Microsoft’s Developer Division working on the .NET Community Team. As a long time web developer and application architect with experience in large and small applications across a variety of verticals, he knows how to build for performance and practicality. Four days a week, you can catch Jeff hosting a live video stream called 'Fritz and Friends' at twitch.tv/csharpfritz. You can also learn from Jeff on WintellectNow and Pluralsight, follow him on twitter @csharpfritz, and read his blog at jeffreyfritz.com
Software Developer XIV Solutions
United States United States
My name is John Atten, and my username on many of my online accounts is xivSolutions. I am Fascinated by all things technology and software development. I work mostly with C#, Javascript/Node.js, Various flavors of databases, and anything else I find interesting. I am always looking for new information, and value your feedback (especially where I got something wrong!)
Engineer
United Kingdom United Kingdom
Areas of Expertise:

.NET, MVC, SQL Server, XML , SOA and WEB solutions.

* Microsoft certified in C# Programming.
* Microsoft certified Techology Specialist (ASP.NET)
* IBM certified in XML Technology
* Sun certified Java Programmer
* Sun certified Web Solution Developer
Software Developer
Germany Germany
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
France France
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
CEO Sharelogic Technologies Limited
Kenya Kenya
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer (Senior) RM Education Solutions ind pvt
India India
6+ years of experience in designing and developing Microsoft technologies applications.
My expertise skills are ASP.Net, MVVM, WEB API, C#, WCF, Design Pattern, JQuery, SQL server.

You can reach me @ rajeeshmadambat@gmail.com
https//www.linkedin.com/profile/view?id=191868301
CEO JUUN Software
Netherlands Netherlands
Sander Rossel is a Microsoft certified professional developer with experience and expertise in .NET and .NET Core (C#, ASP.NET, and Entity Framework), SQL Server, Azure, Azure DevOps, JavaScript, MongoDB, and other technologies.

He is the owner of JUUN Software, a company specializing in custom software. JUUN Software uses modern, but proven technologies, such as .NET Core, Azure and Azure DevOps.

You can't miss his books on Amazon and his free e-books on Syncfusion!

He wrote a JavaScript LINQ library, arrgh.js (works in IE8+, Edge, Firefox, Chrome, and probably everything else).

Check out his prize-winning articles on CodeProject as well!
Technical Lead
Australia Australia
Whatsup-->Exploring--> MVC/HTML5/Javascript & Virtualization.......!
www.santoshpoojari.blogspot.com
Tester / Quality Assurance Lepide Software
India India
Software Testing Manager at Lepide Software Pvt. Ltd.
Software Developer
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Technical Lead
France France
Sofiene Rabhi is Microsoft certified professional in C# ,HTML 5 and JavaScript, Asp.net and Microsoft Silverlight, consultant, trainer specializing in application development with Microsoft technologies, including c#, Vb.net, and Microsoft Azure.
Software Developer (Senior)
Germany Germany
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Team Leader
India 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
Architect
United States United States
MSCS, MCTS, Senior Software Engineer, Architect, Craftsman, The Ultimate DEV ...
Azure Series

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 Apr - 30 Apr 2015