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

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

Please Sign up or sign in to vote.
22 Oct 2014Kalvin Lawrence Ernst
Generate a web app instantly, directly from a database(SQL Server)
Please Sign up or sign in to vote.
16 Oct 2014Gaurav Aroraa
In this step-by-step article, we will discuss all about CRUD (Create Read Update Delete) operations with Web API using Repository pattern.
Please Sign up or sign in to vote.
22 Oct 2014essentialSQL
Database normalization in SQL explained in simple English
Please Sign up or sign in to vote.
9 Oct 2014Suvendu Shekhar Giri
Sort the result set as per your need
Please Sign up or sign in to vote.
22 Oct 2014essentialSQL
Introduction to database joins in SQL
Please Sign up or sign in to vote.
3 Nov 2014essentialSQL
Database Third Normal Form explained in simple English
Please Sign up or sign in to vote.
22 Oct 2014essentialSQL
Introduction to Inner Joins in SQL Server
Please Sign up or sign in to vote.
21 Oct 2014essentialSQL
Database Second Normal Form explained in simple English
Please Sign up or sign in to vote.
22 Oct 2014essentialSQL
Introduction to Outer Joins in SQL Server
Please Sign up or sign in to vote.
22 Oct 2014essentialSQL
How to combine table rows using UNION in SQL Server
Please Sign up or sign in to vote.
23 Oct 2014essentialSQL
How to Group and Summarize your Results in SQL
Please Sign up or sign in to vote.
23 Oct 2014essentialSQL
Query Results Using Pattern Matching in SQL
Please Sign up or sign in to vote.
24 Oct 2014essentialSQL
How to sort your query results in SQL Server
Please Sign up or sign in to vote.
23 Oct 2014essentialSQL
Simplified Data Modeling in SQL
Please Sign up or sign in to vote.
29 Oct 2014essentialSQL
Grouping results returned from your queries using the GROUP BY clause
Please Sign up or sign in to vote.
26 Oct 2014Bimaln
Describe about the SOAP message in WCF with example.
Please Sign up or sign in to vote.
4 Oct 2014tanmoysarkar
SQL queries to know the instance messages state
Please Sign up or sign in to vote.
22 Oct 2014Sacha Barber
Powershell selecting from SQL Server
28 Oct 2014Grant_Fritchey
Grant Fritchey argues that getting your databases under source control is not only vital for the stability of development and deployment, but it will make your life easier when something does go wrong.
Please Sign up or sign in to vote.
10 Oct 2014Member 10843807
An example to illustrate how esProc Helps Process Structured Text in Java–Conditional Filtering
Please Sign up or sign in to vote.
7 Oct 2014Alex_2979
How to get on track with Active Directory
Please Sign up or sign in to vote.
25 Oct 2014Marc Clifton
No word has a value that can be identified independently of what else is in its vicinity.
Please Sign up or sign in to vote.
26 Oct 2014Bimaln
Describe about the SOAP message in WCF with example.
Please Sign up or sign in to vote.
21 Oct 2014Steven 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.
Please Sign up or sign in to vote.
1 Oct 2014James 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.
Please Sign up or sign in to vote.
10 Oct 2014Kalvin Lawrence Ernst
Generate a web app instantly, directly from a database (SQL Server)
Please Sign up or sign in to vote.
5 Oct 2014Antonio Ripa
A real world implementation of a Many to Many relation using MVC5 and Entity Framework
Please Sign up or sign in to vote.
16 Oct 2014Pavel Durov
Article about dynamic Sqlite database management on Android platform using Java class reflection.
Please Sign up or sign in to vote.
27 Oct 2014Lopamudra Pradhan
How to fix the error "MySQL can't specify target table for update in FROM clause" while executing an update query.
Please Sign up or sign in to vote.
1 Sep 2016NaibedyaKar
SQL Server database project creation using Visual Studio 2013
Please Sign up or sign in to vote.
1 Mar 2016Jörgen Andersson
Fluent database access
Please Sign up or sign in to vote.
21 Oct 2014essentialSQL
Database First Normal Form explained in simple English
Please Sign up or sign in to vote.
1 Oct 2014NaibedyaKar
How to check the query locking the table and to unlock it
Please Sign up or sign in to vote.
13 Nov 2014Nirosh
This tutorial is designed for .NET programmers who need to understand ‘Nido’ framework and its application.
Please Sign up or sign in to vote.
16 Oct 2014Thomas Yee
How to implement exception logging and trace logging using global MVC filters
Please Sign up or sign in to vote.
15 Oct 2014Jose Segarra
Fast, really fast, import/export from Excel OOXML
Please Sign up or sign in to vote.
3 Nov 2014Mohd Manzoor Ahmed
jQuery Based Ajax ASP.NET MVC Google Maps Web App
Please Sign up or sign in to vote.
21 Oct 2014Jose Segarra
Getting SQL Server XML nested data as a JSON string
Please Sign up or sign in to vote.
17 Oct 2014Han 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.
Please Sign up or sign in to vote.
30 Oct 2014Arvind Singh Baghel
I show a SQL query which finds the size of database mdf and ldf file in SQL Server.
Please Sign up or sign in to vote.
30 Oct 2014Vaclav 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.
Please Sign up or sign in to vote.
12 Oct 2014binit.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.
Please Sign up or sign in to vote.
30 Sep 2014Afzaal Ahmad Zeeshan
This article tells the beginners the basic concepts about connecting to the SQL Server database using C#.
Please Sign up or sign in to vote.
1 Oct 2014Dukhabandhu Sahoo
Handle optimistic concurrency using Entity Framework Code First.
Please Sign up or sign in to vote.
24 Oct 2014essentialSQL
Learn more about filtering results returned from your queries using the WHERE clause
Please Sign up or sign in to vote.
24 Oct 2014essentialSQL
In today’s lesson, you’re going to learn how to filter the results returned from your queries using the WHERE clause.

Current Participants

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

Software Developer
Pakistan Pakistan
Afzaal Ahmad Zeeshan is a computer programmer from Rabwah, Pakistan, currently living in The Netherlands, likes .NET Core and Node.js for regular everyday development. Afzaal Ahmad works at Adyen as a Developer Advocate.

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.
Russian Federation Russian Federation
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
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
This is a Collaborative Group

10 members
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.
Software Developer APTA
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 Mindfire Solutions
India India
Software engineer in Mindfire Solutions.
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.
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.
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/
Chief Technology Officer
India India
Learning never ends.
Canada Canada
Grant Fritchey, SQL Server MVP, works for Red Gate Software as Product Evangelist. In his time as a DBA and developer, he has worked at three failed dot–coms, a major consulting company, a global bank and an international insurance & engineering company. Grant volunteers for the Professional Association of SQL Server Users (PASS). He is the author of the books SQL Server Execution Plans (Simple-Talk) and SQL Server 2008 Query Performance Tuning Distilled (Apress). He is one of the founding officers of the Southern New England SQL Server Users Group (SNESSUG) and it’s current president. He earned the nickname “The Scary DBA.” He even has an official name plate, and displays it proudly.
Team Leader The Judge Group
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 (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.
Database Developer
Sweden Sweden
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Spain Spain
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer (Senior) KalFabriq
Australia Australia
Blazor wasm expert.

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.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
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.
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.
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]
Technical Lead Mindfire Solutions
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
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


Other Links
Software Developer
Israel Israel
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
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
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


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.
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.
Software Developer (Senior)
India India
my name is Tanmoy Sarkar. I am currently working as a BizTalk developer.
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.
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