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

Best Database article of July 2013

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.
11 Aug 2013LarryCharlton
Dynamic data forms.
Please Sign up or sign in to vote.
22 Jul 2013Paw Jershauge
Want your own movie database??? Download IMDB in 20 minutes.
Please Sign up or sign in to vote.
4 Jul 2013sumit_kapadia
Create and Bind gridview at client side with Jquery Template and ajax in asp.net
Please Sign up or sign in to vote.
17 Jul 2013Tom Glick Philadelphia, US
Run-Time Stored Procedure Processing (get input values, return GridView/Excel File)
Please Sign up or sign in to vote.
18 Jul 2013Mircea Sirghi
Jacob for Excel, pivot tables, VBA functions, etc.
Please Sign up or sign in to vote.
19 Jul 2013Sebastian Solnica
Diagnosing a collation issue in a MySQL stored procedure.
Please Sign up or sign in to vote.
1 Oct 2013Espen Harlinn
A reflection based wrapper for the Oracle Data Provider for .NET – allows your application to dynamically load the Oracle.DataAccess.dll assembly installed on your client’s computer.
Please Sign up or sign in to vote.
8 Sep 2013Winfried Wille
MySQL-Fullltext: Start for a simple search-engine using MySQL C-API, WCF, and jQuery
Please Sign up or sign in to vote.
28 Jul 2013Dino Konstantopoulos
Running MapReduce in a SQL Server database.
Please Sign up or sign in to vote.
24 Jul 2013Kumar Pankaj Verma
Truncating log file in SQL Server using T-SQL when log file is too large and database becomes unresponsive.
Please Sign up or sign in to vote.
25 Jul 2013Kumar Pankaj Verma
How to convert a delimited string in SQL Server to a table column.
Please Sign up or sign in to vote.
4 Jul 2013Khaleel Esbaitah
Models (POCO), Entity Framework and Data Patterns
Please Sign up or sign in to vote.
3 Jul 2013Anil kumar Bhardwaj
Create HTML tree or organization structure for web applications.
Please Sign up or sign in to vote.
8 Jul 2013Sarvesh Kushwaha
This article describes what XSS is and how to prevent XSS attacks.
Please Sign up or sign in to vote.
20 Jul 2013AspDotNetDev
This query will show you all tables and columns in a database, and it can be pasted into Excel for easy manipulation.
Please Sign up or sign in to vote.
1 Aug 2013Bikash Prakash Dash
How to create an auto suggestion control like Gmail/Hotmail/Facebook to add items in list.
Please Sign up or sign in to vote.
11 Jul 2013Bhushan W. Juare
This tip shows how to use SQLCMD utility in SQL Server 2008.
Please Sign up or sign in to vote.
22 Jul 2013Kulamani Sahoo
Differences between a stored procedure and a trigger.
Please Sign up or sign in to vote.
8 Jul 2013JP van Mackelenbergh
Abstracting the ORM Framework via Repository/Unit Of Work patterns
Please Sign up or sign in to vote.
10 Jul 2013vinothharshad
Except vs Not In in SQL Server
Please Sign up or sign in to vote.
23 Jul 2013Smitten Ediot
Reporting stored procedure error in email and also log the error in a table.
Please Sign up or sign in to vote.
29 Oct 2017vinothharshad
Use the ON DELETE CASCADE option if you want rows deleted in the child table when corresponding rows are deleted in the parent table.
Please Sign up or sign in to vote.
29 Jul 2013h_wiedey
The article treats the differences between triggers in Oracle and MS SQL and demonstrates the mutating table problem.
Please Sign up or sign in to vote.
30 Jul 2013Gauri Chodanker
SQL function in SQL
Please Sign up or sign in to vote.
9 Jul 2013Bhushan W. Juare
The different ways of retrieving XML data from SQL Server.

Current Participants

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

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.
Web Developer
United States United States

  • Managing Your JavaScript Library in ASP.NET (if you work with ASP.net and you don't read that, you are dead to me).
  • Graduated summa cum laude with a BS in Computer Science.
  • Wrote some articles and some tips.
  • DDR ("New high score? What does that mean? Did I break it?"), ping pong, and volleyball enthusiast.
  • Software I have donated to (you should too):
Software Developer (Senior)
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
Instructor / Trainer Boston University, Northeastern University
United States United States
Dino works at a National Lab, and is a Lecturer at Boston University since 2009, where he teaches Web development (MET CS 651) and Cloud Computing (MET CS 755), and a Lecturer at Northeastern University since 2015, where he teaches about Big Data (INFO 7250).
Architect Sea Surveillance AS
Norway Norway
Chief Architect - Sea Surveillance AS.

Specializing in integrated operations and high performance computing solutions.

I’ve been fooling around with computers since the early eighties, I’ve even done work on CP/M and MP/M.

Wrote my first “real” program on a BBC micro model B based on a series in a magazine at that time. It was fun and I got hooked on this thing called programming ...

A few Highlights:

  • High performance application server development
  • Model Driven Architecture and Code generators
  • Real-Time Distributed Solutions
  • C, C++, C#, Java, TSQL, PL/SQL, Delphi, ActionScript, Perl, Rexx
  • Microsoft SQL Server, Oracle RDBMS, IBM DB2, PostGreSQL
  • AMQP, Apache qpid, RabbitMQ, Microsoft Message Queuing, IBM WebSphereMQ, Oracle TuxidoMQ
  • Oracle WebLogic, IBM WebSphere
  • Corba, COM, DCE, WCF
  • AspenTech InfoPlus.21(IP21), OsiSoft PI


More information about what I do for a living can be found at: harlinn.com or LinkedIn

You can contact me at espen@harlinn.no
Software Developer (Senior)
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Germany Germany
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Architect Altran
Netherlands Netherlands
I am a relaxed guy, born in '73, who likes to develop software professionally in both my work and in my spare time.

Keywords are C#, WCF, WPF.
Software Developer
Australia Australia
.NET Web Developer from Sydney .
Passionate about Technologies.
Likes Video games.
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Technical Lead E. Soft Technologies
India India
Never try out to sort other's problem. Tell them the way only ........... Let do themselves.
United States United States
I enjoy my wife, living in the woods, my 7 dogs, and learning new things. I like to play with UI stuff and model based coding.
Software Developer Endava, Chisinau
Moldova (Republic of) Moldova (Republic of)
Graduate: Romania, University of Bucharest, Mathematical - Informatical faculty.
Software Developer
Denmark Denmark
Software Developer
India India
I do believe life is to help others ... So here i am .. in my spare time i learn new things of programming and try to help people with my knowledge .
I'm an energetic, self-motivated and hard-working Developer and Information Technology Professional with experience in projects, website design and development.

Visit My Technical Blog
Software Developer (Senior)
Poland Poland
Interested in tracing, debugging and performance tuning of the .NET applications.

My twitter: @lowleveldesign
My website: http://www.lowleveldesign.org
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
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)
United States United States
Enterprise developer with over 15 years of experience coding Windows and Web Apps in C#, WCF, SQL, EF, Http, Linq, etc. Enjoy middle-tier development on large BLL/DAL projects, also full SDLC for smaller projects needing single developer.

Currently live near Philadelphia although I've been working for the past 20 months for a large health-care provider in Pittsburgh.
Software Developer
India India
This is Vinoth from Coimbatore. Vinoth have been working as software developer since Jan 2011. Find Vino's other Interesting article in http://dotnettips4all.blogspot.in/
Software Developer Winfried Wille Softwareentwicklung
Germany Germany
I am a .Net programmer working since 25 years as software developer and system engineer. I live in Hamburg, Germany.
My application and blog are here http://w2ww.de .
Currently i work as freelancer.My hourly price is 40€. I gladly accept fixed price projects.
Software Developer (Senior)
India India
I have been involved in web application development for last 8+ years. Currently working as a Senior Software Engineer. Have extensive experience in ASP.Net MVC, C#, MS-SQL Server, JavaScript, AJAX, jQuery and ExtJS. Still learning...
You must sign in to participate in this contest.
This contest has ended.
1 Jul - 31 Jul 2013