Click here to Skip to main content
15,885,914 members
This competition has ended

Best Database Article of April 2014

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.
7 Apr 2014B. Clay Shannon
Step-by-step instructions on how to view SQLite data from Android Studio and SQLite Data Browser
Please Sign up or sign in to vote.
14 Apr 2014Ankur .K. Vishwakarma
This tip shows you a T/SQL function to split a string concatenated by a delimiter.
Please Sign up or sign in to vote.
7 Apr 2014subhajit bhadury
nKnight - RBAC Solution for C#.NET
Please Sign up or sign in to vote.
16 Apr 2014madagaga
Converting MSSQL database to MySQL
Please Sign up or sign in to vote.
14 Apr 2014Jack Ross
A nice CLI for managing the BMC trouble ticketing service
Please Sign up or sign in to vote.
12 Apr 2014Robert Lindblom
Removing entity if it exists
Please Sign up or sign in to vote.
5 Apr 2014derekman9707
A SQL Cmdlet a Day 2 Piping and Select
16 Apr 2014Stephen_Ball
How to write once, and test encrypted data storage for Windows, Mac, Linux, Solaris, Android and iOS
Please Sign up or sign in to vote.
7 Apr 2014Stewa11
This case study suggests starting with decoupling the aspx/aspx.cs into the View's CSS3, HTML5, javascript, AJAX and JSON
3 Apr 2014Redgate Software
An interview with senior .NET Developer, Lyle Keeton on use of SQL Source Control
Please Sign up or sign in to vote.
10 Mar 2016Marco Bertschi
Serial communication with an Arduino Board via C# and the SerialPort class from the System.IO.Ports namespace
Please Sign up or sign in to vote.
1 Apr 2014smoore4
Run programs on remote machines without PsExec or WMI
Please Sign up or sign in to vote.
2 Apr 2014Kinyanjui Kamau
I have written this tip to help developers automatically set Crystal Report parameters from variables in code (WinForms) at report run time.
Please Sign up or sign in to vote.
9 Apr 2014Jesús López Méndez
This article introduces you to EntityLite and explains how to use it
Please Sign up or sign in to vote.
6 May 2014Eric Goedhart
Building a ASP.Net datadriven website
Please Sign up or sign in to vote.
16 Apr 2014sukeshchand
Speed up your SQL Stored Procedure by changing IF...ELSE Block and Loop's with SQL Queries
Please Sign up or sign in to vote.
29 Apr 2014Tal Bronfer
Introduction to ASP .NET MVC 5 for .NET developers that are completely new to Web development, MVC frameworks and Web Application Frameworks in general.
Please Sign up or sign in to vote.
30 Apr 2014Leszek Koc
Generic Repository Framework (Generic Unit of Work)
Please Sign up or sign in to vote.
17 Apr 2014gunjan k saxena
This tip will help to create an action filter to compress the contents like Json, partial view, etc.
Please Sign up or sign in to vote.
1 Apr 2014formlesstree4
Another article on C# .NET SQL, but with smarts
Please Sign up or sign in to vote.
10 Apr 2014Hexa How
Display visitor's sunrise and sunset time based on their IP address using C#
Please Sign up or sign in to vote.
1 Apr 2014Khademul Basher
Single Page Application development using Backbone and performing database operations using Web API services.
Please Sign up or sign in to vote.
2 Jul 2014Mohammed El-Afifi
Given an existing win32 application, how to provide COM automation capability to it?
Please Sign up or sign in to vote.
23 Apr 2014Rajendra D. Patel
How to insert data using stored procedure in ASP.NET
Please Sign up or sign in to vote.
15 Apr 2014Kirill__
How to create databese with forst 3 normal forms of relationship
Please Sign up or sign in to vote.
16 Jul 2014Praba Prakash
Apache Hadoop 2.3 for Big Data Analytics
Please Sign up or sign in to vote.
23 Apr 2014mohamedkamaleed
Network check v1.0
Please Sign up or sign in to vote.
9 Apr 2014Peter Leow
Learn to setup a development environment on a PC to support the development and testing of PHP and MySQL projects.
Please Sign up or sign in to vote.
25 Apr 2014doug433
This tip shows how PHP can be used to access a MySQL database to retrieve data for a scroll list. Here, I will discuss one that lists 12 rows at a time on a web page.
Please Sign up or sign in to vote.
2 Apr 2014PIEBALDconsult
Using the ADO.NET Interfaces to build a small framework to simplify Database Access
Please Sign up or sign in to vote.
24 Apr 2014Bankey Sharma
Converting DataReader Result into List of Objects Using Generic Type, Property Attribute and Reflection
Please Sign up or sign in to vote.
24 Apr 2014Mack Ait-Aoudia
Entity Framework 6: Update an entity with a many-to-many relation
Please Sign up or sign in to vote.
9 Apr 2014Aqeeel
Implementing security in SQL Server by only allowing TCP/IP Network Protocol and changing default TCP port
Please Sign up or sign in to vote.
24 Apr 2014Pragmateek
Introduction Following my previous article on a similar subject, Extend your VBA code with C#, VB.Net or C++/CLI, I’ve received an interesting feedback from a VBA developer who wanted to leverage the advanced support of the .Net framework for regular … Continue reading →
Please Sign up or sign in to vote.
15 Apr 2014Mike_1989
The following code populates a mainmenu within VB.Net dynamically using recursion, until all items are added to the main menu
Please Sign up or sign in to vote.
25 Apr 2014grantliu
Utilize NLog.net in a Service-oriented architecture
Please Sign up or sign in to vote.
13 Apr 2014Mack Ait-Aoudia
Pocker Planning, Estimation, Velocity And Other Scrum Practices
Please Sign up or sign in to vote.
24 Apr 2014FaizanMubasher
This article helps developer to start working with new mobile application development framework Oracle ADF Mobile.

Current Participants

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

Software Developer Maxus Technologies
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer
Pakistan Pakistan
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Founder Across Time & Space
United States United States
I am in the process of morphing from a software developer into a portrayer of Mark Twain. My monologue (or one-man play, entitled "The Adventures of Mark Twain: As Told By Himself" and set in 1896) features Twain giving an overview of his life up till then. The performance includes the relating of interesting experiences and humorous anecdotes from Twain's boyhood and youth, his time as a riverboat pilot, his wild and woolly adventures in the Territory of Nevada and California, and experiences as a writer and world traveler, including recollections of meetings with many of the famous and powerful of the 19th century - royalty, business magnates, fellow authors, as well as intimate glimpses into his home life (his parents, siblings, wife, and children).

Peripatetic and picaresque, I have lived in eight states; specifically, besides my native California (where I was born and where I now again reside) in chronological order: New York, Montana, Alaska, Oklahoma, Wisconsin, Idaho, and Missouri.

I am also a writer of both fiction (for which I use a nom de plume, "Blackbird Crow Raven", as a nod to my Native American heritage - I am "½ Cowboy, ½ Indian") and nonfiction, including a two-volume social and cultural history of the U.S. which covers important events from 1620-2006: http://www.lulu.com/spotlight/blackbirdcraven
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.
Database Developer
United States United States
David retired as a Sergeant with the Cape Coral Police Department after 22 years of service. His final 10 years of duty were as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to Administrative Services in 2002 and was responsible for database administration, software integration, and development for public safety. David’s primary focus and expertise is with SQL Server, reporting services, integration services, and analysis services, and he was recognized for his work by SQL Server Magazine as “Innovator of the Year” runner up in 2007. David is an MCITP for SQL Server 2005 and 2008 in both database administration and business intelligence and is a Microsoft Certified Trainer. He regularly posts on the MSDN SQL Server forums where he also serves as a moderator, and is a contributor at SQLCLR.net. In addition to his knowledge of SQL Server David works as a software developer using VB.net and C# and has worked extensively in SharePoint development.
Software Developer DOUGLAS B. MILLER, COMPUTER PROGRAM DESIGNER
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer Eric Goedhart
Netherlands Netherlands
Smile | :)
Software Developer (Senior) Shaukat Khanum Memorial Cancer Hospital and Resear
Pakistan Pakistan
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Technical Lead
United States United States
I'm a developer, blogger and all around technology enthusiast. He writes and stays abreast with the latest innovative ideas, news, and trends.
Student
United States United States
I am a professional Software Developer. I work primarily in C# and interact with Microsoft SQL Server at my job. I have been developing software since I was 15 and continue to learn more and more every day.
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Team Leader Wipro
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Italy Italy
I work as consultant for primary customers with Security solutions based on Novell, NetIQ, McAfee, Imperva, Arcsight, and Netforensics.
Architect i-nercya intelligent software
Spain Spain
Working on i-nercya intelligent software as a Database Administrator, IT Manager and Software Architect.

I developed my first programs 30 years ago in BASIC on a CASIO PB 100 programmable calculator which had 1.5 Kb of RAM (with extended memory, factory version had 512 bytes of RAM). Later I programmed on a Commodore 64 micro computer, data was stored on a music-like magnetic tape. Oh My!

I worked for the Spanish Air Force, I have a master degree on aeronautical engineering after all. But making software is my passion.

My other passions are dancing tango and ballroom, cooking good food and watching cinema. And of course and mainly, to love my girlfriend and my daughter.

I also worked on Solid Quality Mentors where my job was SQL Server consulting. I optimized lot of queries on that job. I also worked teaching SQL Server.

I was a Visual Basic MVP during three years several years ago. But I think I don't remember VB sintax anymore, c# is my development language now.
Founder http://softwarelandmarks.com/
Bangladesh Bangladesh
I am in Software Development for more than 12 years. I am expert on Microsoft Platform for Web Forms, MVC, MVC Core, Web API, Desktop App, PHP etc. I am also expert on jQuery, AngularJS, Bootstrap, Font Awesome, Telerik UI, Kendo UI etc. I know BackboneJS, KnockoutJS also. I am an article writer. I have many articles in CodeProject.

Email: khademulbasher@gmail.com
Software Developer (Senior) GetNet
Kenya Kenya
http://www.kinyanjuikamau.com
Engineer
Ukraine Ukraine
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer
Philippines Philippines
A Software Architect, Full-stack developer and a visionary residing in the Philippines. An enthusiast of Microsoft and Open-source technologies particularly from the web, extending to the emerging Big Data and Cloud technology. Out of the keyboard, he love's reading books and watching documentary videos.

Visit him at his website: https://xtianguevara.com/
Technical Lead
Poland Poland
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer (Senior) http://www.m2a.ca
Canada Canada
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
France France
Just studying everytime !
Switzerland Switzerland
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Systems Engineer
United Kingdom United Kingdom
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Systems Engineer Gizasystems
Egypt Egypt
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer (Senior)
Egypt Egypt
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Instructor / Trainer
Singapore Singapore
“Live as if you were to die tomorrow. Learn as if you were to live forever.”
― Mahatma Gandhi

子曰:"三人行,必有我师焉;择其善者而从之,其不善者而改之."
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
India India
"Luck is a dividend of sweat. The more you sweat, the luckier you get" - Ray Kroc
"Curiosity is the key to Creativity" - Akio Morita
Instructor / Trainer Pragmateek
France (Metropolitan) France (Metropolitan)
To make it short I'm an IT trainer specialized in the .Net ecosystem (framework, C#, WPF, Excel addins...).
(I'm available in France and bordering countries, and I only teach in french.)

I like to learn new things, particularly to understand what happens under the hood, and I do my best to share my humble knowledge with others by direct teaching, by posting articles on my blog (pragmateek.com), or by answering questions on forums.
Software Developer TUV SUD South Asia
India India
I am a senior software developer in .net and also Team leader in SKN organization.
Red Gate Software Ltd.
United Kingdom United Kingdom
Redgate makes ingeniously simple software used by 804,745 IT professionals and counting, and is the leading Microsoft SQL Server tools vendor. Our philosophy is to design highly usable, reliable tools which elegantly solve the problems developers and DBAs face every day, and help them adopt database DevOps. As a result, more than 100,000 companies use products in the Redgate SQL Toolbelt, including 91% of those in the Fortune 100.
This is a Organisation

1 members
Software Developer (Senior)
Sweden Sweden
Working as an independent software contractor, specializing in .Net technologies.
Database Developer
United States United States
I am an MBA with a bunch of MS certifications. Technically, I am a DBA, but I do a good deal of sys admin work and web development using .NET. I like to focus on business intelligence, database design, messaging architectures, and web services.
Software Developer
India India
Having more than 9 years of development experience in various Microsoft Technologies like :-
ASP.Net, MVC, SQL Server, WCF, MS Commerce Server, Xamarin etc.

Also hands on experience on the client side coding with JavaScript/jQuery and framework like AngularJS. Worked with third party ASP.net controls like Telerik and DevExpress as well.

Very much interested in Microsoft technologies to explore and implement. Now started to helping coders who really need me.

My Blog


Microsoft Technology Master

Programming Communities


JS Fiddle | Stack Overflow

Awards


Microsoft MCTS Certification in ASP.Net 4.0
United Kingdom United Kingdom
Stephen Ball is a Chartered IT Professional and product Evangelist for Embarcadero regularly speaking across Europe and Africa. Stephen is also the Associate Product Manager for InterBase. Stephen brings a unique sense of product and practical business insight from over a decades multi-national first-hand experience leading development teams on projects working with RadStudio and InterBase on products for a range of blue chip companies including Hilton, American Express, Virgin Active, Range Servant and Fitness First. Stephens blog is http://blogs.embarcadero.com
Program Manager
United Kingdom United Kingdom
I am an experienced and qualified PRINCE2 and Agile programme/project manager.
I took up web programming in Microsoft ASP.NET in 2006 because I wanted to modernise my skill set and so that I could work better with people who have different skill sets.
In the past I have delivered projects, either as a full time member or a contractor member of the team, for Jaguar LandRover, Aviva, BAE SYSTEMS, Airbus, The NHS, Revlon and many more companies.
The types of projects I have delivered have been business, application and infrastructure based.
Feel free to get in touch with me using my codeproject.com profile.

I am business sector, application and technology agnostic. I started with green screens on an NCR I-series, through Unix, Windows, IBM AS400s. My most successful times have been as an ERP consultant/project manager.

I have been trained in formal programme/project management, business analysis and programming while working for large consultancy practices.
Software Developer (Senior) Nevaeh Technology Pvt. Ltd
India India
I have over 8 years of experience in the following,

1. C#.net win-forms application
2. Image processing
3. TWAIN
4. SCOSTA based smart card
Technical Lead Soft To Rule Solutions
India India
Working as a Freelance application software developer.
Software Developer
Israel Israel
Software Developer specializing in .NET, Web Development and Software Test Automation.

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. Multiple votes from the same IP will be automatically disqualified.
  11. The judges’ decision is final and no correspondence will be entered into.
  12. Only those who live in jurisdictions in which this contest is legal may enter.
  13. Any breach of the rules and the prize will be awarded to the runner up.
  14. 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.
  15. 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 2014