Click here to Skip to main content
14,576,041 members

Best Database Article of April 2014

This competition has ended

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.

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

Current Participants

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

Ankur .K. Vishwakarma
Software Developer Maxus Technologies
India India
No Biography provided
Aqeeel
Software Developer
Pakistan Pakistan
No Biography provided
B. Clay Shannon
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
Bankey Sharma
Software Developer
India India
No Biography provided
derekman9707
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.
doug433
Software Developer DOUGLAS B. MILLER, COMPUTER PROGRAM DESIGNER
United States United States
No Biography provided
Eric Goedhart
Software Developer Eric Goedhart
Netherlands Netherlands
Smile | :)
FaizanMubasher
Software Developer (Senior) Shaukat Khanum Memorial Cancer Hospital and Resear
Pakistan Pakistan
No Biography provided
FLouis38
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.
formlesstree4
Student
United States United States
I am a professional Software Developer at Digital Alchemy. 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.
grantliu
United States United States
No Biography provided
gunjan k saxena
Team Leader Wipro
United States United States
No Biography provided
Hexa How
United States United States
No Biography provided
Jack Ross
Italy Italy
I work as consultant for primary customers with Security solutions based on Novell, NetIQ, McAfee, Imperva, Arcsight, and Netforensics.
Jeffrey T. Fritz
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
Jesús López Méndez
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.
Khademul Basher
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
Kinyanjui Kamau
Software Developer (Senior) GetNet
Kenya Kenya
http://www.kinyanjuikamau.com
Kirill__
Engineer
Ukraine Ukraine
No Biography provided
Kristian Guevara
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/
Leszek Koc
Technical Lead
Poland Poland
No Biography provided
Mack Ait-Aoudia
Software Developer (Senior) http://www.m2a.ca
Canada Canada
No Biography provided
madagaga
France France
Just studying everytime !
Marco Bertschi
Software Developer
Switzerland Switzerland
I'm a young Software Engineer. Whilst I may accept a 'status quo' as given, it's my responsibility to improve it as soon as the opportunity arises.
Very familiar with the .Net framework since it has been the underlying foundation for most of my professional work so far. I'm that kind of guy who gets stuff done, while I may also improve the way things work whilst I'm at it. Generally can get along well with most people I meet as a professional.
Fervent volunteer firefigter, captain-ranked air force militia spec officer.
Great friend and generally nice to have me around - For a talk, a beer, or a bonfire (I might as well do all of those things combined). Oh, and I really love music - Rock & country that is, mostly.
Mike_1989
Systems Engineer
United Kingdom United Kingdom
No Biography provided
mohamedkamaleed
Systems Engineer Contech Schneider System Integrator
Egypt Egypt
No Biography provided
Mohammed El-Afifi
Software Developer (Senior)
Egypt Egypt
No Biography provided
Peter Leow
Instructor / Trainer
Singapore Singapore
Stop by my website at https://peterleowblog.com/

Check out my publications at https://www.amazon.com/author/peterleow

Follow me on twitter at https://twitter.com/peterleowblog

“Live as if you were to die tomorrow. Learn as if you were to live forever.”
― Mahatma Gandhi

子曰:"三人行,必有我师焉;择其善者而从之,其不善者而改之."
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

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

"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
"Luck is a dividend of sweat. The more you sweat, the luckier you get" - Ray Kroc
"Curiosity is the key to Creativity" - Akio Morita
Pragmateek
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.
Rajendra D. Patel
Software Developer TUV SUD South Asia
India India
I am a senior software developer in .net and also Team leader in SKN organization.
Redgate Software
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.
Group type: Organisation

1 members

Robert Lindblom
Software Developer (Senior)
Sweden Sweden
Working as an independent software contractor, specializing in .Net technologies.
smoore4
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.
SRS(The Coder)
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
Stephen_Ball
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
Stewa11
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.
subhajit bhadury
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
sukeshchand
Technical Lead Soft To Rule Solutions
India India
Working as a Freelance application software developer.
Tal Bronfer
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