Best Database Article of August 2014

This competition has ended

Overview
Entries
Participants
Winners
Prizes
Rules

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.

Streamline Log Shipping Failovers

29 Aug 2018Micah 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.

SQL

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

SQL-Server-2016

SQL-Server

Saving to a SQLite Database in Your Android Application

13 Aug 2014Cindy Potvin

This is the fourth post in my series about saving data in Android applications.

Android

SQLite

Generating a set of random numbers in SQL Server

26 Aug 2014Wendelius

Generate a set of random numbers by using CTE

Bind Crystal Reports with Dataset or Datatable

5 Aug 2014saurav ray

Article determines how to bind a crystal report with a virtual database

Connect WPF with Wamp Server MySql

5 Aug 2014Anis Derbel

The easy way to connect to Mysql using Wamp server on WPF

Dynamic Menu type Control Panel from DataBase

26 Aug 2014Roysb

Creating a menu dynamically from a database, with a style type control panel

SQL

HTML

ASP.NET

Implement Split A/B pages in your ASP NET project

20 Aug 2014TheCardProject.co.uk

Quickly set up the ability to serve up several pages and record which was served in SQL Server

Searching SQL Server Databases with Red Gate’s SQL Search

1 Aug 2014Chris_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.

Differences Between Various Joins in MS SQL Server

18 Aug 2014DiponRoy

Here, we will see the basic differences or similarities between various joins of MS SQL Server.

SQL

SQL-Server-2008R2

Dynamic ASP.NET Web API Controller - Part 1. Dynamic DTO

8 Jun 2016David Lee 145

How to make dynamic DTO with ExpandoObject

Digital Footprint Mapper - DFMAP

19 Aug 2014Mayank Pal Singh

Know you digital presence / cyber presence / internet presence using DFMAP

How to Read in Memory Code of .NET Application Protected with Anti-Reflector

5 Aug 2014Igor 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

Developing a Large Scale Application with a Single Page Application (SPA) using AngularJS

31 Aug 2014Mark J. Caplin

AngularJS and the MVC/MVVM design patterns

Dynamic DropDownList Binding in ASP.NET MVC With Database

14 Aug 2014Member 10872251

Cascading DropDownList in ASP.NET MVC

ASP.NET MVC-5 CRUD Application with drop down list

27 Aug 2014R M Shahidul Islam Shahed

ASP.NET MVC 5 applications

Fibonacci sequence using SQL Server CTE

28 Aug 2014Wendelius

Generate Fibonacci numbers using CTE

C# / VB.NET / C++ CLI: Create, read and write MS Access (mdb, accdb), MySQL, SQL Server, SQL Server Compact and SQLite databases

13 Nov 2014Emiliarge

Both MS Access formats (mdb and new - accdb), MSSQL 2008 R2, MSSQL CE, SQLite, MySQL

Foreach File Enumerator in SSIS

1 Aug 2014Sreekanth Mohan

Foreach file enumerator in SSIS

SQL

DBA

SSIS

Simple Serial Communication Utilities

29 Aug 2014Andres Cassagnes

A simple serial communication library, with a serial ports enumerator

First MVC Application for Beginners

22 Jul 2015Singh Deepika

This article will step by step guide you through the Flow of MVC application clearing your basic concepts of MVC

Creating a shop website in ASP.NET

9 Aug 2014Afzaal Ahmad Zeeshan

This articles describes how to kick start a shop website using ASP.NET and the software Microsft WebMatrix

jquery javascript ajax grid for asp.net and asp.net mvc

18 Aug 2014Vishal_007

hassle less free fast ajax grid with the use of javascript and asp.net

PHP's Database Operation- Go OO

8 Oct 2014Peter Leow

The OO way to writing your database operation code in PHP

SQL

PHP

database

Developing Fully Functional Data Grids with Jquery DataTable and ASP.Net Generic Handler

23 Aug 2014Muhammad Shoaib Raja

Fully functional web data grids with multi column sorting, filtering and pagination using JQuery based data table plugin and .Net generic handlers

C# / VB.NET / C++ CLI: Read and write MS Access (mdb) database without ADO and SQL via Microsoft DAO

18 Aug 2014Emiliarge

Read and write data to Access databases without limitations caused by the use of the SQL.

DB Independent Code using Wrappers

20 Aug 2014Amol M Vaidya

A simple Data Connection Library to avoid rewriting code when the DB changes

Dapper.NET Sample with MVC 4- Add,Edit,Update,Delete

12 Aug 2014Gihan Liyanage

Simple Dapper.NET Example with MVC

Generating Desired Amount of Rows in SQL using CTE

16 Sep 2014Wendelius

How to generate desired amount of rows in SQL Server using CTE

Reading OLAP Cube using MDX: Part 2

1 Aug 2014Ajit Kumar Thakur Microsoft

Reading OLAP Cube using MDX: Part 2

SQL

Using Adapter Pattern on Entity Framework Database First stored procedures results

22 Aug 2014Faustino 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

How to search for related query inside the Database using ASP.NET

11 Aug 2014Afzaal Ahmad Zeeshan

This article explains how you can use ASP.NET (C#) and search for related queries in your Database.

WPF and MVVM pattern

5 Aug 2014Oussama_Kahoul

Introduction to WPF technology and the MVVM design pattern

Two Way Binding using JavaScript in ASP.NET MVC With Database

8 Aug 2014Member 10872251

Two way binding using JavaScript

A Very High-Level Outline for a Way Cool Utility

24 Nov 2014B. Clay Shannon

In which the author takes the "That is an Exercise Left to the Reader" cop-out to Extremes

Create Table and Stored Procedure in SQL Server and connect it from ASP.NET using C#

17 Aug 2014Prakash 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#

MySQL Connection In Windows Application Using VB.NET

26 Aug 2014Chai_Pot

How to use MySQL as database in VB.NET applications.

.NET

DBA

Fastest way to find row count of all tables in SQL

24 Aug 2014Mihir.D.Shah

Simple Queries to find row count of all tables in a MS-SQL Database

SQL

SQL-Server-2008R2

Anatomy of the Android operating System

3 Aug 2014henry sentio kauta

The Android operating System in action

COALESCE and ISNULL in SQL Server - Part 2

5 Aug 2014Uppuluri Aditya

COALESCE and ISNULL in SQL Server - Part 2

SQL-Server

DBA

Use Local DataBase file (.sdf) in Windows Application C#

29 Aug 2014pritik889

How to use local database file (.sdf) in Windows application C#

Windows

DBA

Current Participants

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

DiponRoy

Bangladesh

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Afzaal Ahmad Zeeshan

Software Developer

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

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

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

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

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)

This is a Organisation

9 members

B. Clay Shannon

Founder Across Time & Space

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

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Chris_Yates

United States

This member doesn't quite have enough reputation to be able to display their biography and homepage.

Cindy Potvin

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)

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

Want to contribute my CodeProject articles and tips? Write my e-mail: emiliarge@mail.ru

Faustino Dina

Software Developer

Mexico

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Gihan Liyanage

Software Developer (Senior)

Sri Lanka

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

henry sentio kauta

Uganda

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Igor Ladnik

Software Developer (Senior)

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

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 Pal Singh

India

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

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

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Mihir.D.Shah

Software Developer

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

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

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Peter Leow

Instructor / Trainer

Singapore

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

子曰："三人行，必有我师焉；择其善者而从之，其不善者而改之."

Prakash Lekhak

Software Developer

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

pritik889

Software Developer MNC

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/

This is a Collaborative Group (No members)

R M Shahidul Islam Shahed

Software Developer UChicago Research 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

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

saurav ray

Software Developer

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

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Sreekanth Mohan

Software Developer (Senior)

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

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

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

I am an ambitious Software Professional who is always wanted to move forward….. Smile | :)

Wendelius

Architect

Europe

Biography provided

First Prize	Shemeer NS - REST enabled WCF service
Prize pool	CodeProject T-Shirt - CodeProject


Second Prize	Afzaal Ahmad Zeeshan - How to search for related query inside the Database using ASP.NET
Prize pool	Bob Sticker - CodeProject

Contest Entries and Requirements

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.
Entries must be an article, or blog entry.
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).
Articles entries must follow the CodeProject submission guidelines.
No cheating, lying, plagiarizing articles, chicanery, or kicking.
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.
No author can be nominated twice in the same category.
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.
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.
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.
In the event of a tie, the number of prizes issued is solely at the discretion of the prize issuer.
Multiple votes from the same IP will be automatically disqualified.
The judges’ decision is final and no correspondence will be entered into.
Only those who live in jurisdictions in which this contest is legal may enter.
Any breach of the rules and the prize will be awarded to the runner up.
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.
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.