Best Database Article of August 2015

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.

Downgrade SQL Server 2008R2 from Enterprise to Standard Edition

13 Aug 2015KASQLDBA

Downgrading from Enterprise to standard edition (SQL server) for those servers which are not using any of enterprise features.

SQL

SQL-Server-2008R2

DBA

Make F5 Execute the Query in the Visual Studio Query Editor Just like in the SSMS Query Editor

16 Aug 2015Brady Kelly

This tip describes how to make the F5 key in Visual Studio execute open SQL queries, instead of starting the project debugging.

Visual-Studio

Dev

DBA

Another Way to Get Identity from SQL Server

26 Aug 2015nithyananthams

Different options to get Identity from SQL Server and how OUTPUT clause helped me to get the accurate Identity value compare with other options.

Putting databases under version control with Redgate's SQL Source Control

10 Aug 2015Alessandro Alpi

MVP and DBA Alessandro Alpi discusses the advantages of source controlling databases, and shows why SQL Source Control is the best tool for SQL Server Management Studio users.

Beginning Hybrid Mobile App Development with Corona SDK

28 Aug 2015Anele 'Mashy' Mbanga

Using Data Classes in ASP.NET - A Beginner's Guide

16 Aug 2015Wombaticus

A beginner's introduction to using data classes in ASP.NET.

XSD 1.1 Support in Liquid XML 2014

25 Aug 2015bconlon

XSD 1.1 support in Liquid XML 2014

How to Load Data Dynamically to Html Dropdownlist

14 Aug 2015Member 11884108

In this tip, we will learn how to load data dynamically to html dropdownlist using Ajax call.

Test and copy files from source to destination in MS-SQL

12 Aug 2015XyedBilal

Copying files from source to destination using master..xp_fileexist and master..xp_cmdshell

SQL-Server-2008R2

Powershell Scripts to Replace "setvar" Variable in SQL-CMD Script File Before Running the SQL Scripts

18 Aug 2015nirman b doshi

Powershell Scripts to replace "setvar" variable in SQL-CMD script file before running the SQL scripts

SQL

PowerShell

Powershell Scripts to Replace Key Value Pair in SQL Script File Before Running the SQL Scripts

18 Aug 2015nirman b doshi

Powershell Scripts to replace Key Value pair in SQL Script file before running the SQL Scripts

SQL

WCF

File Compare And Hash extension for Windows explorer

4 Aug 2015dmihailescu

A windows explorer extension for easy binary/text file comparisons and calculating the MD5, SHA1, SHA256 hashes.

SQL Like Functionality in LINQ?

12 Aug 2015Gaurav Aroraa

SQL Like Functionality in LINQ?

SQL

LINQ

WCF

Build a website with Kaliko CMS using ASP.NET MVC

23 Jan 2016Fredrik Schultz

Introduction to Kaliko CMS - an open source content management system for ASP.NET MVC

Properly executing database operations

10 Jul 2017Wendelius

This article discusses some basic requirements for successful database operations such as error handling, use of parameters and transactions.

Chat / Conversation Balloon Control with datasource

15 Aug 2015IssaharNoam

Simple and customizable Chat Conversation control, with DataTable datasource, inspired by SMS application balloons in OnePlus One Android smartphone.

AngularJS & Web API Active Directory Security

28 Aug 2015Bert O Neill

AngularJS and Web API Active Directory Security (Authorisation)

MVC Web API and AngularJS for Image Puzzle Game

3 Sep 2015syed shanu

How to use MVC, AngularJS and Web API 2 and create a word puzzle game

Dynamic Project Scheduling Using MVC and AngularJS

2 Aug 2015syed shanu

In this article, we will create a simple dynamic project scheduling from a database using a Stored Procedure using MVC and AngularJS.

Did I Say I Wanted to Start Debugging? Huh? Did I?

7 Oct 2017Brady Kelly

Making F5 execute your query

SQL

Audit Trail and Data Versioning with C# and MVC

17 Aug 2015DataBytzAI

Method for implementing an audit-trail

Using MongoDB with C# driver

8 Aug 2015Tanya Jain(Dev)

In this blog post, we will understand how to use MongoDB as backend service for our .NET application using C# drivers.

Let’s SELECT Errors...

25 Aug 2015Wendelius

This post discusses about how to add checks into a SQL statement in order to prevent wrong results in case of possible future changes.

SQL

All-Topics

Oracle Home Selector

10 Aug 2015hevesir

Oracle Home Selector

Introduction to SQL Unit Testing using TSQLT

3 Aug 2015Rooney (Deepak Bisht)

How to use tSQLt for writing unit test cases in SQL (for stored procedures & functions)? This article can be treated as a tutorial as well.

SQL Server export to CSV

25 Aug 2015Muhammad Magdi

This tip contains how to Export SQL Data to CSV files using normal ways and mainly using SQLCM.

SQL

export

CSV

Plug-in Architecture To Work for Multiple Platforms/Techs

2 Aug 2015Reader Man San

Plug-in Architecture To Work in WinForms MVC + WPF MVVM + ASP.NET MVC + Mobile (Xamarin MVC/PhoneGap MVC) + Win 10 Universal App MVC

Simple Client Side Consume ASP.NET Web API Server

12 May 2017Chinh Vo Wili

Send HTTP GET requests, consume ASP.NET Web API server

Self Hosted WCF Service as Windows Service with custom Authentication

30 Aug 2015Murugan Sivananantha Perumal

Self Hosted WCF Service as Windows Service with custom User Authentication over Http.

Auto Backup Of Database in SQL Server 2008 & Above

8 Aug 2015Harsh Aggarwal - India

It's about making back up of database in SQL server 2008 and above you can get rid of making bak file manually.

Current Participants

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

DataBytzAI

Chief Technology Officer SocialVoice.AI

Ireland

Allen is CTO of SocialVoice (https://www.socialvoice.ai), where his company analyses video data at scale and gives Global Brands Knowledge, Insights and Actions never seen before! Allen is a chartered engineer, a Fellow of the British Computing Society, a Microsoft mvp and Regional Director, and C-Sharp Corner Community Adviser and MVP. His core technology interests are BigData, IoT 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 currently completing a PhD in AI and is also a ball throwing slave for his dogs.

Brady Kelly

Founder Erisia Web Development

South Africa

I am a software developer in Johannesburg, South Africa. I specialise in C# and ASP.NET MVC, with SQL Server, with special fondness for MVC and jQuery. I have been in this business for about eighteen years, and am currently trying to master Angular 4 and .NET Core, and somehow find a way to strengthen my creative faculties.
- Follow me on Twitter at @bradykelly

Alessandro Alpi

Team Leader Engage IT Services S.r.l.

Italy

Alessandro Alpi is the CTO and Co-Founder of Engage IT Services s.r.l. A SQL Server MVP, he has many years' experience as a .NET and SQL Server developer and Database Administrator. He now works as a DBA and Solutions Architect on the Microsoft Azure platform and also trains companies in object-orientated programming based on the .NET Framework and Microsoft SQL Server. A keen adherent of Agile methodologies, he is one of the organisers of the Italian PASS SQL Saturday, and is the local manager of SQL Saturday events in Parma. He has two blogs on wordpress and .nethell, and can also be found on the SQL Server MSDN italian forums and StackOverflow.

Anele 'Mashy' Mbanga

Software Developer SITHASO HOLDINGS (PTY) LTD

South Africa

I'm a Bachelor of Commerce graduate, fell inlove with ICT years back with VB5. Used Pick & System Builder to create a windows app. Very curious, developed my first web database app called Project.Show using ExtJS. Published on Google Play Store, learned JQuery Mobile, a project manager at best. My first intranet app eFas with MySQL.

Fear closes people to a lot of things and we hold ourselves back being held by it. Thus the sooner you believe you can't do something, the sooner everything will work towards that belief. Believe in yourself at all times because you can do anything you set your mind to it!

I have a very beautiful woman and four kids, the best joys in the world. East London, South Africa is currently home.

Awards:

Best Mobile Article of February 2015 (First Prize)
http://www.codeproject.com/Articles/880508/Create-a-CRUD-web-app-using-JQuery-Mobile-and-Loca

Best Mobile Article of May 2015 (Second Prize)
http://www.codeproject.com/Articles/991974/Creating-JQuery-Mobile-CRUD-Apps-using-JQM-Show-Ge

Apps
Bible.Show (Android Store App)
https://www.facebook.com/bibleshow
https://play.google.com/store/apps/details?id=com.b4a.BibleShow

JQM.Show (Android Store App)
https://www.facebook.com/jqmshow
https://play.google.com/store/apps/details?id=com.b4a.JQMShow

CodeProject.Show (An offline CodeProject Article writer)
http://www.codeproject.com/Articles/993453/CodeProject-Show-A-CodeProject-offline-article-wri

bconlon

Software Developer

United Kingdom

Software developer and geek with 20 years coding experience mainly C++, C#, XML.
Please visit my developer blog: http://geekswithblogs.net/bconlon/Default.aspx

Bert O Neill

Architect

Ireland

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

Chinh Vo Wili

Architect OSM Solution Vietnam Ltd. Co.

Vietnam

We are working in Web Application with SPA, MVC domain. Beside we are master in Management Information Systems, how to use IS to improve decision making and knowledge sharing in open learning organization.

dmihailescu

Software Developer (Senior)

United States

Decebal Mihailescu is a software engineer with interest in .Net, C# and C++.

Fredrik Schultz

Software Developer (Senior)

Sweden

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

Gaurav Aroraa

Chief Technology Officer

India

Learning never ends.

Harsh Aggarwal - India

Software Developer (Senior) TATA SKY PVT LTD.

India

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

hevesir

Software Developer

Hungary

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

IssaharNoam

Software Developer (Senior)

Israel

Software Development freelancer.

KASQLDBA

Systems Engineer

India

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

Member 11884108

Software Developer (Junior) focussoftnet

India

I am currently working as a .Net Developer.
My Interest areas are Web Technology,Windows Phone apps and Standalone application.

I am always very Much excited to know about new technology and always welcome to new challenges.

Muhammad Magdi

Software Developer (Senior)

Egypt

Senior software engineer with experience in Microsoft .net development stack. Having a good knowledge of team- management, solution architecture, and agile environment. I have a great passion for learning new frameworks, tools, and technologies And I do blogging sharing technical articles.

Murugan Sivananantha Perumal

Software Developer (Senior) Wellcare Infotech LLC

United Arab Emirates

Murugan Shivananantha Perumal is from Chennai, India, He is Currently Working with Wellcare Infotech LLC,Dubai, UAE., as a Senior Software Architect.

Murugan Shivananantha Perumal has 12+ yrs of experience in the IT industry working on Microsoft Technologies. He is involved in various project activities like designing the system and technical architecture, leading technical front and doing core development. He also has strong knowledge of ERP Domain.

Technical experience : Microsoft Dynamics AX Technical Professional, AIF, X++, Visual Basic 6, Classic ASP, Visual Basic .Net, C#, ASP.NET MVC 5 @Razor, Bootstrap, JQuery, WCF and RESTFul Webservices, SSRS, SSIS Automation, Crystal Reports.

nirman b doshi

Unknown

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

nithyananthams

Software Developer

India

I love to face new challenges in my professional life

Reader Man San

Software Developer (Senior) Dev

United Arab Emirates

Hussain Naji Al-Safafeer

Work: Software Developer (Assistant manager)
Like: Programming, reading.
Technical site: https://readerman1.wordpress.com

Rooney (Deepak Bisht)

Software Developer (Senior) Pri-Med

United States

My name is Deepak Bisht and I have 8+ years of experience in the field of software/website development. I am basically from India and currently working as a CMS(Sitecore) & Microsoft Technologies consultant in Boston, USA.

syed shanu

Team Leader

India

Microsoft MVP | Code Project MVP | CSharp Corner MVP | Author | Blogger and always happy to Share what he knows to others. MyBlog

My Interview on Microsoft TechNet Wiki Ninja Link

Tanya Jain(Dev)

Software Developer (Senior) 3Pillar Global Pvt. Ltd.

India

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

Wendelius

Architect

Europe

Biography provided

Wombaticus

United Kingdom

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

XyedBilal

India

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

First Prize	Wendelius - Properly executing database operations
Prize pool	CodeProject T-Shirt - CodeProject


Second Prize	Rooney (Deepak Bisht) - Introduction to SQL Unit Testing using TSQLT
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.