Click here to Skip to main content
15,028,757 members
This competition has ended

Best Database Article of August 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.

Please Sign up or sign in to vote.
29 Aug 2018
Micah Nikkel
SQL script that dynamically generates the DR scripts for failing over/back all Log Shipped databases. While it makes even a single database failover/failback a more streamlined process, it's most helpful for servers with multiple databases, such as SharePoint, consolidated SQL Servers, etc.
Please Sign up or sign in to vote.
13 Aug 2014
Cindy Potvin
This is the fourth post in my series about saving data in Android applications.
Please Sign up or sign in to vote.
26 Aug 2014
Wendelius
Generate a set of random numbers by using CTE
Please Sign up or sign in to vote.
5 Aug 2014
saurav ray
Article determines how to bind a crystal report with a virtual database
Please Sign up or sign in to vote.
5 Aug 2014
Anis Derbel
The easy way to connect to Mysql using Wamp server on WPF
Please Sign up or sign in to vote.
26 Aug 2014
Roysb
Creating a menu dynamically from a database, with a style type control panel
Please Sign up or sign in to vote.
20 Aug 2014
TheCardProject.co.uk
Quickly set up the ability to serve up several pages and record which was served in SQL Server
1 Aug 2014
Chris_Yates
When managing a large amount of servers and databases, having an efficient way to search for objects in a particular database, SQL Server instance or the object metadata is crucial. DBA Chris Yates tells us why SQL Search from Red Gate helps him achieve this with ease, and at no cost.
Please Sign up or sign in to vote.
18 Aug 2014
DiponRoy
Here, we will see the basic differences or similarities between various joins of MS SQL Server.
Please Sign up or sign in to vote.
8 Jun 2016
David Lee 145
How to make dynamic DTO with ExpandoObject
Please Sign up or sign in to vote.
19 Aug 2014
Mayank Pal Singh
Know you digital presence / cyber presence / internet presence using DFMAP
Please Sign up or sign in to vote.
5 Aug 2014
Igor Ladnik
Technique to obtain in memory code of running .NET application (even wrapped into unmanaged code for binary files anti-reflection) is presented and implemented with workable sample
Please Sign up or sign in to vote.
27 Aug 2014
R M Shahidul Islam Shahed
ASP.NET MVC 5 applications
Please Sign up or sign in to vote.
28 Aug 2014
Wendelius
Generate Fibonacci numbers using CTE
Please Sign up or sign in to vote.
1 Aug 2014
Sreekanth Mohan
Foreach file enumerator in SSIS
Please Sign up or sign in to vote.
29 Aug 2014
Andres Cassagnes
A simple serial communication library, with a serial ports enumerator
Please Sign up or sign in to vote.
22 Jul 2015
Singh Deepika
This article will step by step guide you through the Flow of MVC application clearing your basic concepts of MVC
Please Sign up or sign in to vote.
9 Aug 2014
Afzaal Ahmad Zeeshan
This articles describes how to kick start a shop website using ASP.NET and the software Microsft WebMatrix
Please Sign up or sign in to vote.
18 Aug 2014
Vishal_007
hassle less free fast ajax grid with the use of javascript and asp.net
Please Sign up or sign in to vote.
8 Oct 2014
Peter Leow
The OO way to writing your database operation code in PHP
Please Sign up or sign in to vote.
23 Aug 2014
Muhammad Shoaib Raja
Fully functional web data grids with multi column sorting, filtering and pagination using JQuery based data table plugin and .Net generic handlers
Please Sign up or sign in to vote.
18 Aug 2014
Emiliarge
Read and write data to Access databases without limitations caused by the use of the SQL.
Please Sign up or sign in to vote.
20 Aug 2014
Amol M Vaidya
A simple Data Connection Library to avoid rewriting code when the DB changes
Please Sign up or sign in to vote.
16 Sep 2014
Wendelius
How to generate desired amount of rows in SQL Server using CTE
Please Sign up or sign in to vote.
12 Aug 2014
Gihan Liyanage
Simple Dapper.NET Example with MVC
Please Sign up or sign in to vote.
1 Aug 2014
Ajit Kumar Thakur Microsoft
Reading OLAP Cube using MDX: Part 2
Please Sign up or sign in to vote.
22 Aug 2014
Faustino Dina
In this article we will show one approach to decouple the Entity Framework generated code for stored procedures from the higher layers of code by using the Adapter Pattern
Please Sign up or sign in to vote.
11 Aug 2014
Afzaal Ahmad Zeeshan
This article explains how you can use ASP.NET (C#) and search for related queries in your Database.
Please Sign up or sign in to vote.
5 Aug 2014
Oussama_Kahoul
Introduction to WPF technology and the MVVM design pattern
Please Sign up or sign in to vote.
24 Nov 2014
B. Clay Shannon
In which the author takes the "That is an Exercise Left to the Reader" cop-out to Extremes
Please Sign up or sign in to vote.
17 Aug 2014
Prakash Lekhak
We will create a Table and Stored Procedure in Sql Server 2008R2 and data will be inserted and retrieved by using Asp.net using C#
Please Sign up or sign in to vote.
26 Aug 2014
Chai_Pot
How to use MySQL as database in VB.NET applications.
Please Sign up or sign in to vote.
24 Aug 2014
Mihir.D.Shah
Simple Queries to find row count of all tables in a MS-SQL Database
Please Sign up or sign in to vote.
3 Aug 2014
henry sentio kauta
The Android operating System in action
Please Sign up or sign in to vote.
5 Aug 2014
Uppuluri Aditya
COALESCE and ISNULL in SQL Server - Part 2
Please Sign up or sign in to vote.
29 Aug 2014
pritik889
How to use local database file (.sdf) in Windows application C#

Current Participants

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

DiponRoy
Bangladesh Bangladesh
No Biography provided
Afzaal Ahmad Zeeshan
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.
Ajit Kumar Thakur Microsoft
Database Developer Microsoft
India India
I am Ajit Kumar Thakur. I am Consultant in Microsoft Global Delivery India. I work on Database (SQL Server), BI (SSAS, SSRS,SSIS),and Windows Powershell. I have 8 years of experience in Database and BI project development.
Amol M Vaidya
Architect
Japan Japan
My computer career started as an Avid Gamer Smile | :) . I loved the old times Xatax and Wolf. But, curiosity took over my gaming side and I started to search on ways to create all the mesmerising programs that I used.
I started programming in Qbasic and then moved on to every possible programming language I could lay my hands on. Qbasic, Pascal, C, C++, Win32 SDK, VB 6.0, VB.NET, C#, Struts, Core Java, Javascript, VbScript, Unix Shell Programming, SQL SERVER PROGRAMMING, WMI scripting....are some of the languages I can boast of being proficient in.
My formal introduction to computers was when I took the Bachelor of Computer Sciences (Pune, India) degree.Later on I got Masters from the same university.
My Professional Certifications include
MCP SQL Server 2000 (70-229)
Brainbench Certified MS SQL Server Programmer
Brainbench Certified MS SQL Server Administrator
Brainbench Certified ASP.NET Programmer
Brainbench Certified Javascript Programmer
Brainbench Certified RDBMS Concepts
Andres Cassagnes
Engineer
Argentina Argentina
As an Electronic Engineer I've worked with many languages and for some diferents plattforms including desktop and embedded systems.
My natural envirovment is C/C++, but I've worked with Java, C# and hardware oriented languages (VHDL, Verilog).
I really like programing and always I'm looking for some ideas to development.
I add to the opensource philosophy do I try to share my knowledge with other people.

Now I am developing embedded systems for nuclear industries in the Argentina most important technology Company.
Anis Derbel
Software Developer (Junior) Microsoft Student Partners
Tunisia Tunisia
I study Software Engineering , 23 years old , I'm motivated with all Technologies of Microsoft.
Since I have been in the Community of Microsoft as Microsoft Student Partners, I developped many apps on the platform Windows and Phone. Now , it's time to share what I learn here and I'am ready to help Everyone.
You can contact me at any time (anisderbel@outlook.com)
Group type: Organisation

9 members

B. Clay Shannon
Founder Across Time & Space
United States United States
I am in the process of morphing from a software developer into a portrayer of Mark Twain. My monologue (or one-man play, entitled "The Adventures of Mark Twain: As Told By Himself" and set in 1896) features Twain giving an overview of his life up till then. The performance includes the relating of interesting experiences and humorous anecdotes from Twain's boyhood and youth, his time as a riverboat pilot, his wild and woolly adventures in the Territory of Nevada and California, and experiences as a writer and world traveler, including recollections of meetings with many of the famous and powerful of the 19th century - royalty, business magnates, fellow authors, as well as intimate glimpses into his home life (his parents, siblings, wife, and children).

Peripatetic and picaresque, I have lived in eight states; specifically, besides my native California (where I was born and where I now again reside) in chronological order: New York, Montana, Alaska, Oklahoma, Wisconsin, Idaho, and Missouri.

I am also a writer of both fiction (for which I use a nom de plume, "Blackbird Crow Raven", as a nod to my Native American heritage - I am "½ Cowboy, ½ Indian") and nonfiction, including a two-volume social and cultural history of the U.S. which covers important events from 1620-2006: http://www.lulu.com/spotlight/blackbirdcraven
Chai_Pot
Software Developer
India India
No Biography provided
Chris_Yates
United States United States
This member doesn't quite have enough reputation to be able to display their biography and homepage.
Cindy Potvin
Canada Canada
Cindy Potvin is a software developer based in the Montreal area. At her day job, she creates web applications using the ASP.NET MVC framework and mobile applications using the Android SDK.
David Lee 145
Web Developer Nexon Korea
Korea (Republic of) Korea (Republic of)
I am a web developer in South Korea. I work at Nexon Korea now.

My interest:
- ASP.NET (MVC, Web API)
- C#
- Etc.

GitHub : https://github.com/thinkit-software
Emiliarge
Software Developer
Russian Federation Russian Federation
Want to contribute my CodeProject articles and tips? Write my e-mail: emiliarge@mail.ru
Faustino Dina
Software Developer
Mexico Mexico
No Biography provided
Gihan Liyanage
Software Developer (Senior)
Sri Lanka Sri Lanka
No Biography provided
No Biography provided
Igor Ladnik
Software Developer (Senior)
Israel Israel


  • Nov 2010: Code Project Contests - Windows Azure Apps - Winner
  • Feb 2011: Code Project Contests - Windows Azure Apps - Grand Prize Winner


Mark J. Caplin
Software Developer Joey Software Solutions
United States United States
Mark Caplin has specialized in Information Technology solutions for the past 30 years. Specializing in full life-cycle development projects for both enterprise-wide systems and Internet/Intranet based solutions.

For the past fifteen years, Mark has specialized in the Microsoft .NET framework using C# as his tool of choice. For the past four years Mark has been implementing Single Page Applications using the Angular platform.

When not coding, Mark enjoys playing tennis, listening to U2 music, watching Miami Dolphins football and watching movies in Blu-Ray technology.

In between all this, his wife of over 25 years, feeds him well with some great home cooked meals.

You can contact Mark at mark.caplin@gmail.com

...
Mayank is a security professional with 6+ years of experience in developing networking security products like IDS, IPS, vulnerability scanners. Mayank has also performed vulnerability assessments, penteration testing configuration reviews.
Member 10872251
Software Developer (Junior)
India India
I have been working in software area from last 1 year. I have worked on .net technology. I always interested to learn new technology.
Micah Nikkel
United States United States
No Biography provided
Mihir.D.Shah
Software Developer
India India
A Qualified Electronics Engineer, a professional web application developer, an accidental SQL DBA and an amateur Photoshop artist!
Muhammad Shoaib Raja
Software Developer Pakistan Revenu Automation Ltd. (PRAL)
Pakistan Pakistan
I am passionate web developer and mostly works in ASP.NET and Adobe Flex applications. Now my keen of learning is driving me toward Node.js and believe me, i truly love it.

I have just started my blog and you can find it Here
Oussama_Kahoul
Software Developer
France France
No Biography provided
Peter Leow
Instructor / Trainer
Singapore Singapore
Stop by my website at https://peterleowblog.com/

Check out my publications at https://www.amazon.com/author/peterleow

Follow me on twitter at https://twitter.com/peterleowblog

“Live as if you were to die tomorrow. Learn as if you were to live forever.”
― Mahatma Gandhi

子曰:"三人行,必有我师焉;择其善者而从之,其不善者而改之."
Prakash Lekhak
Software Developer
United States United States
No Biography provided
pritik889
Software Developer MNC
India India
I am C# corner MVP and Blogger and currently working as a .Net Developer in an MNC Company India and have one and eight month experience in C#,ASP.NET,SQL server.I am a B.Tech in computer science.This is My Blog where i blog https://aspdotnetmyblog.com/
Group type: Collaborative Group (No members)


R M Shahidul Islam Shahed
Software Developer UChicago Research Bangladesh
Bangladesh Bangladesh
• 4 year’s professional experience in Software Development with CMMI process.
• Experience in VB.NET, C#, ADO.NET, LINQ, EF, Web Programming, Crystal Report, Microsoft Reporting, Telerik Reporting, SSRS & MS SQL server 2003, 2008.
• Experience in complex SQL query, Store Procedure, Views, RDMS & Micro Finance business.
• Experience in Writing RSD, DSD & Diagramming of Use case, Activity, RTM, Class, Object etc.
• Knowledge of software engineering practices: Planning, Designing, Coding, Code Review, Unit Testing, Test Plan & Implementation.
• Possess a strong analytical ability and can adapt quickly.
• Can work within a team as well as independently with comfort.
• Strong bug fixing and problem-solving skills.
• Have solid understanding about business process, technology and system development with object oriented concepts.
• I keep myself updated about the latest trends and developments of technology.
• Excellent interpersonal, written and verbal communication skills.
Roysb
Costa Rica Costa Rica
No Biography provided
saurav ray
Software Developer
India India
Hi Guys,

I am Saurav Ray have done M.C.A from Inder prastha Enginnering College and currently working as a Software Developer on .Net Technologies from the last 2 year.
Singh Deepika
Software Developer (Junior)
India India
No Biography provided
Sreekanth Mohan
Software Developer (Senior)
India India
I am a software Engineer specialized in Microsoft technologies(Asp.Net, SQL Server, MSBI etc).
TheCardProject.co.uk
Software Developer (Senior) RichardGreenSoftware Ltd
United Kingdom United Kingdom
I am technical Director of TheCardProject.co.uk in Nottingham, a website giving information, software, services and expertise in the area of ID cards, smart cards.
Uppuluri Aditya
Software Developer (Junior)
India India
I have started my IT career in April 2013. Currently working as C#, SSIS and SQL Server developer in a multinational company. I am a Microsoft Certified Professional in SQL Server 2012.
Vishal_007
Web Developer QX Ltd
India India
I am an ambitious Software Professional who is always wanted to move forward….. Smile | :)
Wendelius
Architect
Europe Europe
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. 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 Aug - 31 Aug 2014