Click here to Skip to main content
15,041,025 members
This competition has ended

Best Database article of November 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.
6 Nov 2013
Sichen D
How to build system availability timeline in SSRS
Please Sign up or sign in to vote.
6 Nov 2013
Sam Varadarajan
Oracle - commit on exit
Please Sign up or sign in to vote.
29 Nov 2013
lalitsrana
Demonstrate a simple yet efficient way to upload the data (SqlBulkCopy)
Please Sign up or sign in to vote.
22 Nov 2013
Vagif Abilov
The article describes limitations of WCF Data Services client and shows how Simple.OData.Client can become a better alternative
Please Sign up or sign in to vote.
15 Nov 2013
Johan Ohlin
How to use recursive CTE calls in T-SQL.
Please Sign up or sign in to vote.
11 Nov 2013
Rajat-Indiandotnet
Find column or Text in entire stored procedure
Please Sign up or sign in to vote.
7 Nov 2013
Alexander Chernosvitov
ActiveX component for 3D visualization, embedded in different client applications.
Please Sign up or sign in to vote.
12 Nov 2013
Jobless Creature
CTE To find all the related nodes in a hierarcy
Please Sign up or sign in to vote.
27 Nov 2013
Tharaka MTR
Emoji; is the Japanese term for the ideograms or smileys used mostly in Japanese electronic messages and webpages.
Please Sign up or sign in to vote.
12 Nov 2013
Alejandro Xalabarder
Yet another XML to database aproach
Please Sign up or sign in to vote.
3 Nov 2013
Marc Clifton
Creating a website in Ruby on Rails for dynamically displaying and navigating a SQL Server database
Please Sign up or sign in to vote.
28 Apr 2014
Marc Leger
Microsoft ASP.NET Identity MerlinFramework
Please Sign up or sign in to vote.
4 Dec 2013
Alexander Iskhakov
A comparison Entity Framework 5 and NHibernate 3.3 on a real-world .NET application with Oracle 11g.
Please Sign up or sign in to vote.
9 Nov 2013
Damijan Vodopivec
Sample Code First project with SQL CE 4.0 database
Please Sign up or sign in to vote.
4 Nov 2013
Lyubomir Rumenov Velchev
A simple console application, which executes all SQL files added by developers working with decentralised development environment.
Please Sign up or sign in to vote.
4 Nov 2013
Raymund Macaalay
This post will show you how to archive SharePoint List Items to SQL Server
Please Sign up or sign in to vote.
5 May 2014
Shuqian Ying
Client side data provider for data importing to a relational data service build for StackExchange data dump.
Please Sign up or sign in to vote.
10 Nov 2013
Rajat-Indiandotnet
A unique feature of SQL SERVER Loop with Go statement
Please Sign up or sign in to vote.
11 Feb 2015
Aydin Homay
In the software implementing business synchronizing structures/templates of the database entities with Data Access Layer SQL (commands/Transactions) is the most expensive thinks because you need to re-implement when you have change/s in your entities structure's such as Data-type, Name, and etc.
Please Sign up or sign in to vote.
21 Nov 2013
Vijay-Srivastava
Fetching complex data from multiple table using nested MySQL queries, JOIN operations, LIKE operator and aggregate functions(eg. GROUP BY, GROUP_CONCAT, etc.)
Please Sign up or sign in to vote.
16 Nov 2013
Debopam Pal
Using Microsoft.Office.Interop.Excel library, you can bring your data from your database against LINQ query and store them into an Excel Sheet.
Please Sign up or sign in to vote.
7 Nov 2013
Raymund Macaalay
The easiest way to cancel all SharePoint workflows in progress
Please Sign up or sign in to vote.
4 Nov 2013
Mr.Thursday
SQL script for creating ASP.Net Identity Database
Please Sign up or sign in to vote.
22 Nov 2013
h_wiedey
Asynchronous processing of triggers using cursors
Please Sign up or sign in to vote.
1 Nov 2013
Gabi Barcan
Call methods of an existing class in MFC asynchronously, while still preserving the thread affinity required by MFC and COM.
Please Sign up or sign in to vote.
15 Nov 2013
Johan Ohlin
Group concatenation in T-SQL using CTE.
Please Sign up or sign in to vote.
29 Nov 2013
Mehdy Moini
Implementing a map as a tree, and finding the shortest path, between the streets, is what you will see.
Please Sign up or sign in to vote.
4 Nov 2013
Sam Varadarajan
Oracle SQL*Plus - Forward slash contd... (PL/SQL)
Please Sign up or sign in to vote.
18 Nov 2013
skydger
Checking MS SQL Server database files default paths.

Current Participants

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

I have a Telecomunications Engineering degree but since I learnt the first language (Pascal), almost I haven't stopped developing software. Mainly with C and C++ but I have touched many other languages and scripts. I use also to develop for fun (reinventing the wheel, of course!), currently almost all of such programs and tools are written in java (visit www.elxala.de).
Alexander Chernosvitov
Instructor / Trainer Peter the Great St.Petersburg Polytechnic Universi
Russian Federation Russian Federation
Peter the Great St. Petersburg Polytechnic University professor,
Microsoft Authorized Educational Center trainer,
Microsoft Certified Professional (C# Desktop Apps and MFC)
Lectures on OOP, C# and C++, Windows programming with C# and C++.
Have long practice and experience in finding the right way to formulate and numerically solve differential equations.
Alexander Iskhakov
Team Leader
Ukraine Ukraine
No Biography provided
Aydin Homay
Software Developer (Senior) BHGE
Germany Germany
I worked as a software engineer and researcher in different countries with a wide range of related projects and engineers from all around the world. I was involved in Oil&Gas, Telecommunication, Transportation, and Semiconductor projects and played various roles such as junior, senior, and lead engineer both in embedded and non-embedded devices and technologies.

During my professional carrier, I was directly involved in designing and maintaining editor, compiler, and interpreter for IEC 611131-3 (PLC programming standard) and fault-tolerant communication layer for distributed automation standard IEC 61499, and many other projects such as DCS (Distributed Control Systems), (SCADA) Supervisory Control and Data Acquisition System, Oilfield (CMS) Computerised Maintenance Systems, Oil&Gas Laboratory Automaton Systems, and Semiconductor Equipment Connectivity Solutions.

Currently, I pursue a Ph.D. degree in Computer Science in the Technical University of Dresden and works as a software engineer in Germany. Beside, I am a certified specialist in Microsoft technologies since 2011.

My main research and work areas are Industrial Communication and Automation Systems, Real-Time Systems, Service-Oriented Systems, IEC 61131-3, IEC 61499, and Distributed Embedded Systems.
Damijan Vodopivec
Software Developer
Slovenia Slovenia
Senior C# .NET developer in gaming industry

Specialties
C#, XML, WebServices, WCF
Debopam Pal
Software Developer National Informatics Centre (NIC)
India India
Hello! Myself Debopam Pal. I've completed my MCA degree from West Bengal University of Technology at 2013. I'm from India. I’ve started to work with MS Technologies in 2013 specially in C# 4.0, ASP.NET 4.0. I've also worked in PHP 5. Now I work in JAVA/J2EE, Struts2. Currently I'm involved in a e-Governance Project since Jan, 2014. In my leisure time I write Blog, Articles as I think that every developer should contribute something otherwise resource will be finished one day. Thank you for your time.

Visit: Linkedin Profile | Facebook Profile | Google+ Profile | CodeProject Profile
Ehsan A Samani
CEO NanoToolkit, Inc
United States United States
I have been doing some sort of Software Development since 1998. I started with C Programming but quickly upgraded to C++. I am proficient in Windows UI, Windows Server/Service, COM, C# and WinForms, C# and Asp.net. I can also claim some know-how in VB.NET and java. Every once in a while I hone in my scripting skills by doing more JQuery and Powershell but I quickly forget it all. I also have a working knowledge of CSS and HTML as well.
check out my Blog
Gabi Barcan
Software Developer
United States United States
No Biography provided
h_wiedey
Germany Germany
No Biography provided
Jobless Creature
Software Developer (Senior) TATA Communications
India India
I have a total experience of around 5 years out of which 4 years in MS technologies. I have a passion towards coding.
Johan Ohlin
CEO BJ Focus Ltd
United Kingdom United Kingdom
Johan is the CEO of BJ Focus Ltd, a UK company specialised in the development of business structure platforms helping companies to structure flows of organisable data.

He writes articles on the BJ Lab's blog, especially when his customers keep asking the same thing. You might find a few of these articles here on CodeProject.

Currently his focus is on building MVC web apps on the Azure platform, but PHP and MySQL get their share of attention as well.

Johan has double masters, in business and in software development, and an MCTS in .Net Framework 4, web applications.
lalitsrana
Software Developer (Senior)
India India
More about me on my website
http://lalit.50webs.com
Lyubomir Rumenov Velchev
Software Developer (Senior) Softopia
United Kingdom United Kingdom
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.
Marc Leger
Web Developer Epsilon
United States United States
20+ years experience developing web solutions.
Mehdy Moini
Software Developer Idea Tolue Software
Iran (Islamic Republic of) Iran (Islamic Republic of)
No Biography provided
Mr.Thursday
Software Developer (Senior)
South Africa South Africa
No Biography provided
Rajat-Indiandotnet
Team Leader
India India
I am Rajat Jaiswal from India. I am working as a Technology specialist in one of the reputed company in India with 12+ years of experience. I am a Microsoft Data Platform MVP & Alibaba Cloud MVP.
I have always had an affinity to learn something new in technology. Database, Web development, Cloud computing are the areas of my interests always.
I have been a regular contributor to technologies with more than 300+ tips. Learning & Sharing is one of my aims always. Writing blogs, delivering sessions, helping on forums is my hobby.
Raymund Macaalay
Technical Lead
New Zealand New Zealand
http://nz.linkedin.com/in/macaalay
http://macaalay.com/
Sam Varadarajan
Software Developer (Senior) City of Los Angeles
United States United States
Originally a Physics major, fell in love with Microprocessors and switched to Computer Science 20+ years ago. Since then, dabbled in various languages including, PowerBuilder, Oracle, Java, C, C++, Perl, Python etc. Constantly striving for quality and performance too.

I try to help fellow developers with technology as a way of "giving back to the community". Blogging became a natural extension of that effort. Still learning to perfect that art. If one new programmer out there benefits from this blog, my time and effort are fully worth it.

The underlying theme in my blogs is power and beauty of programming (and technology in general). A well written program gives me the sense of awe you get when you look at a man made wonder like Angkor Wat. You experience poetry, art, mystique, power all at once. A program and the troubleshooting that ensues also gives you a feeling you get while reading a mystery novel!
Shuqian Ying
Founder CryptoGateway Software Inc.
Canada Canada


His interests in software research and development include security, domain specific meta-language development technologies and tools, meta-language driven code generation, generation of non-invasive and virtual SQL database for "un-structured" data (sqlization), automated relational data service production technologies, file system sqlization technologies and products, structured multi-lingual documentation tools and technologies, sqlization of user's personal data, like emails, etc.. He likes to use distributed code version control system to manage codes. For that reason, a tool to manage git repository forest (related git repositories) was even developed internally.


He was a physist before year 2000. He studied theoretical physics (the hidden symmetry between the past and future, quantum field theories, mirror universe, cosmological dark energies etc.) in which he think to had made fundamental breakthroughs[^] but the community is either not ready for it or is actively rejecting/ignoring it Smile | :) .







Most recent free tools to share:



  • V-NET[^] - connects you devices anywhere on the internet. Voice/video chat, multicase, monitoring and file transfer, private networking, etc..
Sichen D
Software Developer Acxiom Corpopration
United States United States
No Biography provided
skydger
Architect
Russian Federation Russian Federation
Since the middle of 90-s when I was able to deal only with ZX Spectrum, I became addicted to programming. It was a strange path from Sinclair Basic through old-school Fortran, C and C++ to C# and SQL.

I fond of Microsoft technologies but also interested in Linux development. I like to learn new technologies, patterns and techniques and gladly share with my experience to others.

If you wish to contact with me feel free to write down a message through any of social network.
Tharaka MTR
Technical Lead Eyepax IT Consulting (Pvt) Ltd.
Sri Lanka Sri Lanka
Having more than 9 year hands-on industry experience in software development
Responsible for designing, implementing and managing complex software systems with stringent up-time requirement.

Visit my blog
Vagif Abilov
Architect Miles AS
Norway Norway
Vagif Abilov is a Russian/Norwegian software developer and architect working for Miles. He has more than twenty years of programming experience that includes various programming languages, currently using mostly C# and F#.

Vagif writes articles and speaks at user group sessions and conferences. He is a contributor and maintainer of several open source projects, including Simple.Data OData adapter, Simple.OData.Client and MongOData.
No Biography provided

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. Must be an article, or blog entry
  3. With the exception of the overall 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. 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.
  5. Articles entries must follow the CodeProject submission guidelines.
  6. No cheating, lying, plagiarizing articles, chicanery, or kicking.
  7. Authors may only have their article considered for multiple categories if that second category is the Overall monthly category. Under no circumstance will an article be nominated in a second category that is not the Overall monthly category.
  8. No author can be nominated twice in the same category.
  9. 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 article could be nominated in the C# and VB.NET competitions, respectively.
  10. 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.
  11. Multiple votes from the same IP will be automatically disqualified.
  12. The judges’ decision is final and no correspondence will be entered into.
  13. Only those who live in jurisdictions in which this contest is legal may enter.
  14. Any breach of the rules and the prize will be awarded to the runner up.
  15. 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.
  16. 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. Please read the submission requirements before submitting your entry.

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 Nov - 30 Nov 2013