Click here to Skip to main content
14,977,979 members
This competition has ended

Best Database article of December 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.
1 Dec 2013
RickZeeland
Inno Setup script to install SQL Server 2008 R2 with Tools, creating an instance with special rights and displaying the log.
Please Sign up or sign in to vote.
12 Jan 2014
Christian Graus
In this third installment, we look at how Common Table Expressions can simplify your SQL and help you perform complex tasks
Please Sign up or sign in to vote.
20 Dec 2013
Subodh Raikar
Accessing SSRS Reports from SharePoint Site using C#
Please Sign up or sign in to vote.
17 Dec 2013
Davinder Singla
This tip provides soution details for fetching data from an Oracle database in the order in which data was commited when multiple concurrent transactions are executing.
Please Sign up or sign in to vote.
23 Dec 2013
Sam Varadarajan
(IF) Check for parameters to script.
Please Sign up or sign in to vote.
21 Dec 2013
DataBytzAI
An overview of what developers need to know about data protection and privacy
Please Sign up or sign in to vote.
14 Jan 2015
free5lot
Camera in .NET application using .NET library (DirectShow).
Please Sign up or sign in to vote.
17 Dec 2013
Mike Gledhill
How to easily add an "export to Excel" feature to your app
Please Sign up or sign in to vote.
3 Jan 2014
Sander Rossel
The first of two, everything you need to create the most amazing queries!
Please Sign up or sign in to vote.
12 Mar 2014
Christian Graus
The second in my series digs in to some of the different things you can do within a select statement.
Please Sign up or sign in to vote.
23 Jan 2014
Christian Graus
The first in a series of articles seeking to explain the intermediate to advanced features of T-SQL
Please Sign up or sign in to vote.
10 Dec 2013
Amey A khedekar
A scenario with data type of the resultant select columns with UNION.
Please Sign up or sign in to vote.
30 Oct 2014
Nirosh
Nido Framework with .Net 4.0 and Entity Framework help you standardize your Business Logic Layer (BLL).
Please Sign up or sign in to vote.
18 Dec 2013
vikram.mahapatra
How to get the current time from any time zone
Please Sign up or sign in to vote.
3 Jan 2014
Maciej Los
This tip shows how to get data from multiple workbooks using one OledbConnection.
Please Sign up or sign in to vote.
23 Dec 2013
LamYongXian
This is an alternative for "C# - Optical Marks Recognition (OMR) Engine 1.0"
Please Sign up or sign in to vote.
21 Aug 2014
Mohammed Nazer
SQL Constrains details and its types
Please Sign up or sign in to vote.
12 Dec 2013
Mehmet Murat TANDOĞAN
How to use jQuery mobile autocomplete in ASP.NET using generic handler(.ashx) file with database connection.
Please Sign up or sign in to vote.
23 Dec 2013
Sam Varadarajan
"BEGIN" keyword in Oracle.
Please Sign up or sign in to vote.
4 Dec 2013
Sergii Syrovatchenko
This article includes examples of T-SQL capabilities that allow to perform string concatenation flexibly and effectively through the use of different constructs.
Please Sign up or sign in to vote.
12 Dec 2013
♥…ЯҠ…♥
Query to check Database, Table, Column exists in Sql Server
Please Sign up or sign in to vote.
17 Dec 2013
SonuKSingh
SQL Server: Track which rows have been modified
Please Sign up or sign in to vote.
14 Dec 2013
C Grant Anderson
SQL CLR function to find the nth instance of a string within a string
Please Sign up or sign in to vote.
6 Jan 2014
Hasan Habib Surzo
Class, Database Connection, Login Winform
Please Sign up or sign in to vote.
4 Dec 2013
Mahdi Nejadsahebi
How to query a database file from an MFC application.
Please Sign up or sign in to vote.
8 Jan 2014
Sam Varadarajan
Oracle - Forward slash in SQL&Plus - Take 2
Please Sign up or sign in to vote.
26 Dec 2013
Sam Varadarajan
Commit and forward slash in Oracle
Please Sign up or sign in to vote.
26 Dec 2013
Sam Varadarajan
Oracle: DDL and forward slash
Please Sign up or sign in to vote.
29 Dec 2013
Sam Varadarajan
Apparently, passwords are case sensitive in Oracle 11g by default. This can be overridden.
Please Sign up or sign in to vote.
10 Dec 2013
Ravindra T C
Working with SQL Server in an ASP.NET application using the MVP Pattern.
Please Sign up or sign in to vote.
13 Dec 2013
Ravindra T C
The Model-View-ViewModel (MVVM) design pattern, why MVVM has to be used, and how to work with SQL Server using the MVVM design pattern.

Current Participants

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

DataBytzAI
Chief Technology Officer The DataWorks
United Kingdom United Kingdom
Allen is a consulting architect with a background in enterprise systems. His current obsessions are IoT, Big Data and Machine Learning. When not chained to his desk he can be found fixing broken things, playing music very badly or trying to shape things out of wood. He runs his own company specializing in systems architecture and scaling for big data and is involved in a number of technology startups.

Allen is a chartered engineer, a Fellow of the British Computing Society, and a Microsoft MVP. He writes for CodeProject, C-Sharp Corner and DZone. He currently completing a PhD in AI and is also a ball throwing slave for his dogs.
♥…ЯҠ…♥
Software Developer
India India
There are only 10 type of people in this programming world....
one who knows the binary and other who doesn't.
No Biography provided
C Grant Anderson
Architect AT&T
United States United States
Grant is a multi-dimensional individual that counts amongst his talents architecture, design, development, and training for software, databases, data warehouses, and OLAP cubes using Microsoft .NET and C# and the Microsoft BI stack. Grant has a Master's degree in Transpersonal Psychology and is currently writing a book on Software Psychology which explains that how we think determines software success (or failure) more than tools, technology, or developer skills.
Christian Graus
Software Developer (Senior)
Australia Australia
Programming computers ( self taught ) since about 1984 when I bought my first Apple ][. Was working on a GUI library to interface Win32 to Python, and writing graphics filters in my spare time, and then building n-tiered apps using asp, atl and asp.net in my job at Dytech. After 4 years there, I've started working from home, at first for Code Project and now for a vet telemedicine company. I owned part of a company that sells client education software in the vet market, but we sold that and I worked for the owners for five years before leaving to get away from the travel, and spend more time with my family. I now work for a company here in Hobart, doing all sorts of Microsoft based stuff in C++ and C#, with a lot of T-SQL in the mix.
Davinder Singla
Architect
India India
No Biography provided
free5lot
Software Developer
Russian Federation Russian Federation
codeproject@free5lot.com
Hasan Habib Surzo
Software Developer (Senior)
Bangladesh Bangladesh
I am very positive about life and a born explorer. I set my personal goal to be a good human being,
LamYongXian
Software Developer
Singapore Singapore
No Biography provided
Maciej Los
Team Leader
Poland Poland
I'm a lawyer, teacher/trainer and author of VBA programming book (only polish version). Programming is my hobby and the source of extra earnings!
  1. C#
  2. SQL
  3. Linq
  4. VB/VBA/VB.NET
  5. XML & XSL


If you want to contact me... find me on LinkedIn.
Mahdi Nejadsahebi
Software Developer
Iran (Islamic Republic of) Iran (Islamic Republic of)
No Biography provided
Mehmet Murat TANDOĞAN
Software Developer (Senior)
Turkey Turkey
Computer Engineer, MSc. (Turkey), and works as a senior software engineer who's interested in WindowsForms, Asp, Asp.Net, WPF, Silverlight, C#, DexExpress, jQuery, jQuery Mobile, MS SQL platforms. He likes traveling, playing guitar, reading and meeting new people and cultures.


http://www.linkedin.com/profile/view?id=111762036
http://www.linkedin.com/in/tandogan
Mike Gledhill
Software Developer
Switzerland Switzerland
Programming since the age of 15, with experience in C# and iPad software development.
Working as a software developer for a financial company in Zurich, Switzerland.

More developer tips'n'trip at my website:
http://www.MikesKnowledgeBase.com
Mohammed Nazer
Software Developer
India India
Dot Net Developer
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


Other Links
Ravindra T C
Software Developer L&T Technology Services Mysore Campus
India India
I'm a software developer. I spent most of the time in learning new technologies. I've a keen interest in client-side technologies especially JavaScript and Jquery it is the most beautiful language ever seen.

I like sharing my knowledge and written some non-popular articles. I believe in quality and standards but blames myself for lagging them.

I believe in small things and they makes me happy!
RickZeeland
Software Developer
Netherlands Netherlands
Software developer in the Netherlands, currently working on Video Surveillance applications.
Experience: C#, C++, VB, ASP, SQL Server, PostgreSQL.
It all started with Black&White, no not the whiskey but the Sinclair ZX81 followed by several Atari's and PC's. The journey continues ...
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!
Sander Rossel
CEO JUUN Software
Netherlands Netherlands
Sander Rossel is a Microsoft certified professional developer with experience and expertise in .NET and .NET Core (C#, ASP.NET, and Entity Framework), SQL Server, Azure, Azure DevOps, JavaScript, MongoDB, and other technologies.

He is the owner of JUUN Software, a company specializing in custom software. JUUN Software uses modern, but proven technologies, such as .NET Core, Azure and Azure DevOps.

You can't miss his books on Amazon and his free e-books on Syncfusion!

He wrote a JavaScript LINQ library, arrgh.js (works in IE8+, Edge, Firefox, Chrome, and probably everything else).

Check out his prize-winning articles on CodeProject as well!
Sergii Syrovatchenko
Database Administrator Teamwork Commerce
Ukraine Ukraine
SQL Server DBA/DB Developer with 10+ years of experience in SQL Server 2005-2019, Azure/GCP. Worked on high-load OLTP/DW projects and develops system tools for SQL Server. In depth understanding of SQL Server Engine and experience in working with big databases. Domain knowledge of ERP/CRM, crawlers, gambling and retail sales. Blogger, mentor and speaker at local SQL Server events.
SonuKSingh
Software Developer
India India
Programming is my passion. It is always fun to learn new things.

Follow my blog
Follow on FB
Subodh Raikar
Software Developer
United States United States
My name is Subodh Raikar and I am currently working as a Software Developer. I enjoy writing code and solving problems using technology. This not only provides me livelihood, but also gives a satisfaction of being creative and assisting people with the day to day business operations.

I have been involved in the entire software development life cycle, from requirement gathering to design, coding, testing, documentation and maintenance. These softwares are used among a wide array of departments within the company. I also developed several ERP customizations and designed reports on top of the ERP system as well as custom applications.

My technical expertise includes Microsoft's .NET platform, C#, ADO.NET, SQL Server 2008, VB.NET, SSRS, Crystal Reports, Entity Framework and LINQ. I also developed a project using Amazon Web Services like Elastic Compute Cloud (EC2), Relational Database Service (RDS), SimpleDB and Simple Storage Service (S3) during my graduate coursework.
vikram.mahapatra
Software Developer (Senior)
India India
He has more than 3.10 years of experience in the software development. He has spent most of the times in web/desktop application development. He has sound knowledge in the ASP.Net, C#, VB,SQL Server, AJAX. You can reach him at

http://vkm-mahapatra.blogspot.in/
viki_keshari@yahoo.co.in
viki.keshari@gmail.com
http://www.facebook.com/viki.keshari

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, Sudan, Syria, Armenia, Azerbaijan, Belarus, Burma, Democratic Republic of Congo, Democratic People’s Republic of Korea, Eritrea, Ivory Coast, Lebanon, Liberia, Republic of Guinea, Sierra Leone, Somalia, and Zimbabwe. 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 Dec - 31 Dec 2013