Click here to Skip to main content
14,271,798 members

Best Database Article of October 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. The top 50 entries are shown.

16 Oct 2014
Gaurav Aroraa
In this step-by-step article, we will discuss all about CRUD (Create Read Update Delete) operations with Web API using Repository pattern.
22 Oct 2014
Kalvin Lawrence Ernst
Generate a web app instantly, directly from a database(SQL Server)
22 Oct 2014
essentialSQL
Database normalization in SQL explained in simple English
9 Oct 2014
Suvendu Shekhar Giri
Sort the result set as per your need
3 Nov 2014
essentialSQL
Database Third Normal Form explained in simple English
22 Oct 2014
essentialSQL
Introduction to database joins in SQL
21 Oct 2014
essentialSQL
Database Second Normal Form explained in simple English
22 Oct 2014
essentialSQL
Introduction to Outer Joins in SQL Server
22 Oct 2014
essentialSQL
Introduction to Inner Joins in SQL Server
22 Oct 2014
essentialSQL
How to combine table rows using UNION in SQL Server
4 Oct 2014
tanmoysarkar
SQL queries to know the instance messages state
23 Oct 2014
essentialSQL
Simplified Data Modeling in SQL
23 Oct 2014
essentialSQL
How to Group and Summarize your Results in SQL
23 Oct 2014
essentialSQL
Query Results Using Pattern Matching in SQL
24 Oct 2014
essentialSQL
How to sort your query results in SQL Server
26 Oct 2014
Bimaln
Describe about the SOAP message in WCF with example.
29 Oct 2014
essentialSQL
Grouping results returned from your queries using the GROUP BY clause
22 Oct 2014
Sacha Barber
Powershell selecting from SQL Server
25 Oct 2014
Marc Clifton
No word has a value that can be identified independently of what else is in its vicinity.
26 Oct 2014
Bimaln
Describe about the SOAP message in WCF with example.
21 Oct 2014
Steven T. Schowiak
This article will describe and demonstrate a technique for resizing and storing image files on the local file system and image meta data in SQL Server using ASP.NET 4.51.
1 Oct 2014
James Dale
My Windows Sever 2003 reaches its end of life in 2015. I do not look forward to moving to Server 2012. Surely there has to be a better, portable, and cross platform solution that features zero install and fits on a USB stick.
10 Oct 2014
Kalvin Lawrence Ernst
Generate a web app instantly, directly from a database (SQL Server)
5 Oct 2014
Antonio Ripa
A real world implementation of a Many to Many relation using MVC5 and Entity Framework
16 Oct 2014
Pavel Durov
Article about dynamic Sqlite database management on Android platform using Java class reflection.
1 Sep 2016
NaibedyaKar
SQL Server database project creation using Visual Studio 2013
15 Oct 2014
Jose Segarra
Fast, really fast, import/export from Excel OOXML
1 Mar 2016
Jörgen Andersson
Fluent database access
21 Oct 2014
essentialSQL
Database First Normal Form explained in simple English
27 Oct 2014
Lopamudra Pradhan
How to fix the error "MySQL can't specify target table for update in FROM clause" while executing an update query.
1 Oct 2014
NaibedyaKar
How to check the query locking the table and to unlock it
13 Nov 2014
Nirosh
This tutorial is designed for .NET programmers who need to understand ‘Nido’ framework and its application.
16 Oct 2014
Thomas Yee
How to implement exception logging and trace logging using global MVC filters
3 Nov 2014
Mohd Manzoor Ahmed
jQuery Based Ajax ASP.NET MVC Google Maps Web App
21 Oct 2014
Jose Segarra
Getting SQL Server XML nested data as a JSON string
17 Oct 2014
Han Bo Sun
In this article, I will show you how to integrate Hibernate Search into a simple yet feature complete web application with the Spring MVC and Hibernate enabled.
30 Oct 2014
Arvind Singh Baghel
I show a SQL query which finds the size of database mdf and ldf file in SQL Server.
30 Oct 2014
Vaclav Naydenov
How C++ library YB.ORM can help manipulate the data stored in RDBMS using domain classes. Basic concepts of ORM are explained by examples.
12 Oct 2014
binit.ku.singh
MongoDB was designed from the beginning to scale out. Its document-oriented data model allows it to automatically split up data across multiple servers.
30 Sep 2014
Afzaal Ahmad Zeeshan
This article tells the beginners the basic concepts about connecting to the SQL Server database using C#.
1 Oct 2014
Dukhabandhu Sahoo
Handle optimistic concurrency using Entity Framework Code First.
24 Oct 2014
essentialSQL
Learn more about filtering results returned from your queries using the WHERE clause
24 Oct 2014
essentialSQL
In today’s lesson, you’re going to learn how to filter the results returned from your queries using the WHERE clause.
19 Oct 2014
Afzaal Ahmad Zeeshan
What are the wearable devices and what is the role of Internet of Things in them and how do they interact to make things better and easy.
25 Oct 2014
essentialSQL
Simple SELECT queries in SQL Server
16 Oct 2014
banitabisht
Tip to get comma separated string for a column in SQL query using XML path method

Current Participants

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

Afzaal Ahmad Zeeshan
Software Developer
Pakistan Pakistan
Afzaal Ahmad Zeeshan is a computer programmer from Rabwah, Pakistan, and likes .NET Core and Node.js for regular everyday development. He is an expert with Cloud, Mobile, and API development. Afzaal has experience with the Azure platform and likes to build cross-platform libraries/software with .NET Core. Afzaal is an Alibaba Cloud MVP, twice he has been awarded Microsoft MVP status for his community leadership in software development, four times CodeProject MVP status for technical writing and mentoring, and 4 times C# Corner MVP status in the same field.
Antonio Ripa
Architect
Switzerland Switzerland
I really like coding. And i really like improve my knowledge about design pattern and new architecture. I started at 13 just thirty one years ago ( self taught ) when I bought my first Sinclair ZX Spectrum. Nowadays I am a Senior Software ( Agile ) Engineer with more than 18 years of experience in Enterprise Application design and development, both back-end and front-end.
I am particularly interested in Enterprise Design Pattern, Domain Driven Design, Test Driven Design and Scrum Methodology, looking for new patterns in software development
I do not want to keep my learnings to myself, so I had joined code project, and adding few more learnings which may benefit many other software engineers and developers working in this lovely industry. I'm not going to dictate any of the points, but all the practices listed here contributed a lot in my software development career, so if you think they make some sense for you then try to adopt few. If you have any +/- comments, kindly feel free to write me back
Group type: Collaborative Group

10 members

Arvind Singh Baghel
Software Developer
India India
I am a software developer having 3.6+ years experience in .Net technology with Sql server database, Having working knowledge of ASP.Net, C#.Net, SQL Server 2005/2008, AJAX, Java Script, JSON, Crystal Report and WPF.
I have great fun while working on database.
banitabisht
Software Developer
India India
No Biography provided
Bhim B Thapa
Software Developer APTA
United States United States
No Biography provided
Bimaln
Software Developer Mindfire Solutions
India India
Software engineer in Mindfire Solutions.
binit.ku.singh
Software Developer
India India
No Biography provided
Dukhabandhu Sahoo
Software Developer (Senior)
India India
I have developed web applications using ASP.NET Web Forms, MVC, Web API, Entity Framework, SQL Server, LINQ, C#, jQuery, BootStrap UI and few other related libraries and tools.

Apart from programming, I love to watch cricket matches.
essentialSQL
Easy Computer Academy, LLC
United States United States
Hello my name is Kris. I’m here because I am passionate about helping non-techie people to overcome their fear of learning SQL.

I know what it is like to not know where to start or whether the time spent learning is worth the effort. That is why I am here to help you to:
- Get started in an easy to follow step-by-step manner.
- Use your time wisely so you focus on what is important to learn to get the most value from your time.
- Answer your questions. Really! Just post a comment and I’ll respond. I’m here to help.

It wasn’t long ago that I was helping a colleague with some reporting. She didn’t know where to start and soon got overwhelmed and lost as she didn’t know SQL.

I felt really bad, as she was under pressure to get some summary information to her boss, the built-in reports were falling short, and to make them better would require her to know SQL. At that time that seemed impossible! It in dawned on me, it doesn’t have to be that way.

Then I discovered a way for anyone with the desire to easily learn SQL. I worked with my co-worker, started to teach her what I learned and soon she was able to write reports and answer her boss’ questions without getting stressed or ploughing hours into manipulating data in Excel.

It hasn’t always been easy. Sometimes the information seems abstract or too conceptual. In this case I’ve found out that a visual explanation is best. I really like to use diagrams or videos to explain hard-to-grasp ideas.

Having video, pictures, and text really help to reinforce the point and enable learning.

And now I want to help you get the same results.

The first step is simple, click here ==> http://www.essentialsql.com/get-started-with-sql-server/
Gaurav Aroraa
Architect
India India
There is no age limit for learning and its never late, to start.
Han Bo Sun
Team Leader The Judge Group
United States United States
No Biography provided
James Dale
Software Developer (Senior)
Canada Canada
I started programming on a Commodore PET with 8K memory and a cassette drive for storage. I used Commodore BASIC and 6502 assembler. I have been coding for 35 years and still consider Delphi 7 the most productive IDE and language I have used. I use C# and Visual Studio when I have to in order to satisfy some clients.

I prefer ColdFusion and Railo for server language as they are so productive. Again I use asp.net when I have to.

I am a big fan of JavaScript on the client but I am still not sold on Node.js as a server platform.
Jörgen Andersson
Database Developer
Sweden Sweden
No Biography provided
Jose Segarra
Spain Spain
No Biography provided
Kalvin Lawrence Ernst
Software Developer (Senior) KalFabriq
Australia Australia
Many years experience in developing software for Government, Health, Biotech enterprises.
Early adopter of .NET platform, with over 10 years hands-on experience in ASP.NET.
Solid track record of successful project management and technology implementation.
Highly skilled in SQL Server and Oracle, design, installation and management.
Proficient in gathering user’s requirements and writing technical specifications.
Conducted training in various technologies and acted as a mentor.

Have recently developed an ASP.NET MVC code generator tool to fast track the development of
common application functions.
No Biography provided
Marc Clifton
Architect Interacx
United States United States
Blog: https://marcclifton.wordpress.com/
Home Page: http://www.marcclifton.com
Research: http://www.higherorderprogramming.com/
GitHub: https://github.com/cliftonm

All my life I have been passionate about architecture / software design, as this is the cornerstone to a maintainable and extensible application. As such, I have enjoyed exploring some crazy ideas and discovering that they are not so crazy after all. I also love writing about my ideas and seeing the community response. As a consultant, I've enjoyed working in a wide range of industries such as aerospace, boatyard management, remote sensing, emergency services / data management, and casino operations. I've done a variety of pro-bono work non-profit organizations related to nature conservancy, drug recovery and women's health.
Mohd Manzoor Ahmed
Founder ManzoorTheTrainer.com
India India
Manzoor is a Microsoft Certified Trainer who has been working on MS .Net technologies for more than a decade. Apart from development he is also passionate about delivering training on various MS .Net technologies and he has 10+ years of experience as a software development teacher. He writes articles for code-project as well. His YouTube channel has 1 million hits. He is the founder of ManzoorTheTrainer portal.

"I focus on simplifying, complex concepts..." - ManzoorTheTrainer

Founder of www.ManzoorTheTrainer.com [Free .net video tutorials on MS SQL Server, Asp.Net, C#.Net, Ado.Net, Entity Framework, MVC, Web Services, Android]
NaibedyaKar
Technical Lead Mindfire Solutions
India India
No Biography provided
Nirosh
Architect Virtusa Pvt. Ltd.
Sri Lanka Sri Lanka
In-depth coverage of Microsoft .Net, Cloud and many other cutting-edge Technologies.

- The Mandelbrot set – someone has called it the thumb-print of God – is one of the most beautiful and remarkable discoveries in the entire history of mathematics. My profile picture is generated with that equation.

You may contact Nirosh for Consultations, Code Reviews and Architecture Guide Workshops via c_nir*o*sh@hotmail.com (Remove * to use)



View Nirosh L.W.C.'s profile on LinkedIn
Pavel Durov
Software Developer
Israel Israel
No Biography provided
Sacha Barber
Software Developer (Senior)
United Kingdom United Kingdom
I currently hold the following qualifications (amongst others, I also studied Music Technology and Electronics, for my sins)

- MSc (Passed with distinctions), in Information Technology for E-Commerce
- BSc Hons (1st class) in Computer Science & Artificial Intelligence

Both of these at Sussex University UK.

Award(s)

I am lucky enough to have won a few awards for Zany Crazy code articles over the years

  • Microsoft C# MVP 2016
  • Codeproject MVP 2016
  • Microsoft C# MVP 2015
  • Codeproject MVP 2015
  • Microsoft C# MVP 2014
  • Codeproject MVP 2014
  • Microsoft C# MVP 2013
  • Codeproject MVP 2013
  • Microsoft C# MVP 2012
  • Codeproject MVP 2012
  • Microsoft C# MVP 2011
  • Codeproject MVP 2011
  • Microsoft C# MVP 2010
  • Codeproject MVP 2010
  • Microsoft C# MVP 2009
  • Codeproject MVP 2009
  • Microsoft C# MVP 2008
  • Codeproject MVP 2008
  • And numerous codeproject awards which you can see over at my blog
Sibeesh KV
Software Developer
India India
B-Tech (IT) Graduate,Holds 3+ Years of Experience in Dot Net,Asp.Net,C#, Vb.Net,SQL,LINQ,JQuery ,JavaScript ,CSS, HTML


===================!!!====================!!!========================

So much complexity in software comes from trying to make one thing do two things.



Achievements


Steven T. Schowiak
Software Developer (Senior) HP Enterprise Services
United States United States
A native Michigander, Steven is a Software Developer and Engineer with Hewlett-Packard Enterprise Services in Pontiac, Michigan and is currently assigned to Detroit Diesel Corporation, Detroit Michigan. He has been working in Information Technology in a variety of industries around the U.S. since 1995 after receiving a B.S. degree in Information Systems at Tarleton State University, Stephenville Texas, and an A.A.S. degree in Business Programming at Central Texas College, Killeen Texas. Prior to college, he served in the United States Army for over eight years overseas and at Fort Hood, Texas and participated in Operations Desert Shield and Desert Storm. He is the proud father of daughter Tina, a Special Education Teacher, and granddaughter Mia.
Suvendu Shekhar Giri
Software Developer
India India
No Biography provided
tanmoysarkar
Software Developer (Senior)
India India
my name is Tanmoy Sarkar. I am currently working as a BizTalk developer.
Thomas Yee
Software Developer (Senior)
United States United States
I have been a software developer since 1995, although my education was in molecular biology. I started as an embedded systems C/C++ developer during the telecom boom, but now consider myself a .NET developer comfortable with all aspects of software development from the user interface to the back end. My spare time is spent writing for Wikipedia (focusing on physics, molecular biology, and science biography), and I have trained in aikido since 2000.
Vaclav Naydenov
Software Developer (Senior) Yandex
Russian Federation Russian Federation
Senior developer at Yandex:
Billing System application logic and WEB-interface development,
Communication protocols for various Payment Systems.
Teacher of Computer Science at Moscow State University of Mechanical Engineering.

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 Oct - 31 Oct 2014