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

SQL Server Procedure to Report Duplicates

13 Dec 2014PIEBALDconsult

A stored procedure I use to find duplicate records in tables and views.

SQL-Server-2008R2

Creating Report using Report Builder and Oracle DB - Part 2

28 Dec 2014Snesh Prajapati

In this article series, I am sharing how to create report using Report Builder by fetching data from Oracle DB.

Creating an Outlook 2010 Add-In with a Custom Send Button

22 Dec 2014Turay Melo

This is an alternative for "Creating an Outlook 2010 Add-In"

Calculating Average Processing Time in Hours Excluding Weekends

17 Dec 2014Mohammed A. Mohiuddin

Calculating Average Processing Time in hours excluding weekends

SQL

Oracle

Null Modem Emulator and C# - How They Can Learn To Love One Another

1 Dec 2014ShadowedR

A simple example of a C# Application interfacing with the Null Modem Emulator (com0com) driver to allow run time creation and configuration of Virtual Serial Ports

Smarter Errors & Logs: putting the data to work

10 Dec 2014Jason_Taylor

In this post, we’ll explore the "culture of logging," and share what we’ve done to address it, much of which has become a part of Stackify’s Smart Error & Log Management (SmartELM) product.

SQL

Dev

product-showcase

C#: Avoiding Performance Issues with Inserts in SQLite

17 Dec 2014John Atten

If you are new to SQLite, you may well run across one of the most confounding of its implementation details the moment you attempt to do some sort of bulk or batch processing of inserts or updates. What you will discover is that unless properly implemented, inserting or updating multiple records

WPF Automated Trading Application

14 Dec 2014Martin Arrivets

WPF automated trading application

Internet of Things: Programming IoT Devices, Web Services and IoT Clients

13 Jan 2015Naren Neelamegam

A complete walk through on IoT Device programming, Web Service programming and IoT Client programming.

Installing and Using SQLite on Windows

9 Dec 2014John Atten

How to install and use SQLite on Windows

Implement ORM using C#

4 Dec 2014saddam abu ghaida

Creating Object relation mapping from scratch

SQL Server Health Check Script with Powershell

3 Dec 2014Atul_Kapoor

Perform SQL Server Instance health check simultaneously on more than one server using Powershell

Temporary Table in PostgreSQL

29 Dec 2014Patrycja Dybka

Temporary table is a special table that is bound to a transaction or to a session. It means that the data in the temporary table and the definition lasts till the end of the transaction or session.

SQL

DataSet to T-SQL Script

17 Dec 2014Brad Joss

Export a System.Data.DataTable/DataSet into a T-SQL script that when run creates a #TEMP table of the same definition filled with data.

ROWCOUNT Behavior with Aggregate Functions

3 Dec 2014Abhishek Kumar Goswami

Sometimes, you might find different error handling ways inside a stored procedure like some people use the error code to check the behavior of code or some other techniques. In this tip, I am going to discuss one of the techniques and its special behavior in a situation and why.

SQL

MVVM Silverlight Application with Entity Framework and WCF Service

13 Jun 2016Roger C Moore

MVVM Silverlight Application with Entity Framework and WCF Service

Data Services - Best practices in Business Intelligence Development: SSIS, T-SQL

8 Dec 2014Bertin @nonodata.com

It is often important to have general guidelines when putting together a Data Analysts Team.

SQL Server Connection Dialog (Extensible)

28 Dec 2014Chris Winkelmann

Display a SQL Connection Dialog with extensible functionality to persist the resulting connection string to any location...

Creating Report using Report Builder and Oracle DB - Part 1

28 Dec 2014Snesh Prajapati

In this article series (consist of two parts), I am sharing how to create report using Report Builder by fetching data from Oracle DB. As per requirement, before getting the data we need to run a stored procedure which will get data from table based on given parameter and then we need

Get Ready to Learn SQLServer: 18. How To Use the EXCEPT Operator

21 Dec 2014essentialSQL

How to use the Except Operator in SQLServer

Create SSRS Report in SQL Server

12 Dec 2014pritik889

In this article, we will learn how to create a SSRS report, how to configure the reporting server and how to deploy the report.

SQL

SQL-Server-2014

Quick-and-Dirty Deployment of Apps

9 Dec 2014B. Clay Shannon

Simply, quickly, and freely make your apps available to the public

MVP.PHP Data Synchronize

13 Dec 2014Ali Torabi 2

MVP is a class library for managing database tables and gives an easy migrations solution.

SQL

Javascript

PHP

Developing Applications With Express Framework And Node.js - Quick Start

25 Dec 2014Tushar_Gupta

Walk through to quickly develop applications using Node.js and Express framework.

How to Find Character Repeated in a String Few Times using CTE?

9 Dec 2014Maciej Los

This tip shows how to use CTE to find character repeated in a string few times.

SQL

Get Ready to Learn SQL Server: 15. Learn to use Union, Intersect, and Except Clauses

21 Dec 2014essentialSQL

Learn to use Union, Intersect, and Except clauses

SQL Zip Compression, RegEx and Random Functions

17 Dec 2014Brad Joss

SQL CLR Functions for Zip Compression and Regular Expression evaluations

Current Participants

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

Abhishek Kumar Goswami

Software Developer

India

I like to code and I really enjoy to share my knowledge with all, Its my passion.

http://abhishekgoswami.com/

Ali Torabi 2

United States

I think it's better to design rather than sleeping and waking up!

Atul_Kapoor

United States

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

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

Bertin @nonodata.com

Founder nonodata.com

United States

I see myself as a Data Artist.With about 6 years experience working with a myriad sources of data including healthcare, financial, agricultural, and customers related data. I like finding ways to extract some wonderful information from data.
Regards,
Bertin Nono
www.nonodata.com

Brad Joss

Software Developer (Senior)

United States

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

Chris Winkelmann

Software Developer (Senior)

United States

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

essentialSQL

Easy Computer Academy, LLC

United States

Hello my name is Kris. I’m here because I am passionate about helping non-techie people to overcome their fear of learning SQL.

I know what it is like to not know where to start or whether the time spent learning is worth the effort. That is why I am here to help you to:
- Get started in an easy to follow step-by-step manner.
- Use your time wisely so you focus on what is important to learn to get the most value from your time.
- Answer your questions. Really! Just post a comment and I’ll respond. I’m here to help.

It wasn’t long ago that I was helping a colleague with some reporting. She didn’t know where to start and soon got overwhelmed and lost as she didn’t know SQL.

I felt really bad, as she was under pressure to get some summary information to her boss, the built-in reports were falling short, and to make them better would require her to know SQL. At that time that seemed impossible! It in dawned on me, it doesn’t have to be that way.

Then I discovered a way for anyone with the desire to easily learn SQL. I worked with my co-worker, started to teach her what I learned and soon she was able to write reports and answer her boss’ questions without getting stressed or ploughing hours into manipulating data in Excel.

It hasn’t always been easy. Sometimes the information seems abstract or too conceptual. In this case I’ve found out that a visual explanation is best. I really like to use diagrams or videos to explain hard-to-grasp ideas.

Having video, pictures, and text really help to reinforce the point and enable learning.

And now I want to help you get the same results.

The first step is simple, click here http://www.essentialsql.com/get-started-with-sql-server/

Jason_Taylor

Chief Technology Officer

United States

Jason has worked in a number of high-growth business units centered around delivering Software as a Service. The experiences gained in those shops directly led him to Stackify, and those experiences help shape the product. Jason has led small and medium sized development teams through his career and is intently focused on delivering a great product while helping developers grow, learn, and realize their full potential. He is responsible for all software development activities at Stackify, and product delivery.

In his free time, Jason enjoys homebrewing, golfing, and traveling the world.

John Atten

Software Developer XIV Solutions

United States

My name is John Atten, and my username on many of my online accounts is xivSolutions. I am Fascinated by all things technology and software development. I work mostly with C#, Javascript/Node.js, Various flavors of databases, and anything else I find interesting. I am always looking for new information, and value your feedback (especially where I got something wrong!)

Maciej Los

Team Leader

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!

C#
SQL
Linq
VB/VBA/VB.NET
XML & XSL

If you want to contact me... find me on LinkedIn.

Martin Arrivets

Software Developer

United Kingdom

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

Mohammed A. Mohiuddin

Business Analyst

Saudi Arabia

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

Naren Neelamegam

Software Developer

India

Naren started coding during 1999 with FORTRAN, then COBOL, PASCAL, C, C++, VC++ ..... C#, Java, ASP so on, till today. He claims himself as techie who loves coding, but he is not even sure which technology or platform he loves, most of the time Windows, some time WinCE, some time Linux, nowadays Android and embedded platforms. He can do some query stuffs with Oracle, SQL Server, MySQL. He strongly believes that C/C++ is a must for all programmers, "if you know C/C++, you can do programming on any language". He is an electronic gadget guy who likes to buy small gadgets all the time, at least he will do window shopping on a gadget shop. His interest always have been with Automation in any form, call it a little automated program sitting in his Laptop or a home automation program runs on his mobile. Apart from coding, he likes to do...???

Patrycja Dybka

Technical Writer Vertabelo

Poland

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

PIEBALDconsult

Software Developer (Senior)

United States

BSCS 1992 Wentworth Institute of Technology

Originally from the Boston (MA) area. Lived in SoCal for a while. Now in the Phoenix (AZ) area.

OpenVMS enthusiast, ISO 8601 evangelist, photographer, opinionated SOB, acknowledged pedant and contrarian

---------------

"I would be looking for better tekkies, too. Yours are broken." -- Paul Pedant

"Using fewer technologies is better than using more." -- Rico Mariani

"Good code is its own best documentation. As you’re about to add a comment, ask yourself, ‘How can I improve the code so that this comment isn’t needed?’" -- Steve McConnell

"Every time you write a comment, you should grimace and feel the failure of your ability of expression." -- Unknown

"If you need help knowing what to think, let me know and I'll tell you." -- Jeffrey Snover [MSFT]

"Typing is no substitute for thinking." -- R.W. Hamming

"I find it appalling that you can become a programmer with less training than it takes to become a plumber." -- Bjarne Stroustrup

ZagNut’s Law: Arrogance is inversely proportional to ability.

"Well blow me sideways with a plastic marionette. I've just learned something new - and if I could award you a 100 for that post I would. Way to go you keyboard lovegod you." -- Pete O'Hanlon

"linq'ish" sounds like "inept" in German -- Andreas Gieriet

"Things would be different if I ran the zoo." -- Dr. Seuss

"Wrong is evil, and it must be defeated." –- Jeff Ello

"A good designer must rely on experience, on precise, logical thinking, and on pedantic exactness." -- Nigel Shaw

“It’s always easier to do it the hard way.” -- Blackhart

“If Unix wasn’t so bad that you can’t give it away, Bill Gates would never have succeeded in selling Windows.” -- Blackhart

"Use vertical and horizontal whitespace generously. Generally, all binary operators except '.' and '->' should be separated from their operands by blanks."

"Omit needless local variables." -- Strunk... had he taught 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)

Roger C Moore

Software Developer (Senior)

Canada

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

saddam abu ghaida

Team Leader CCC

Greece

Nothing Much i love reading and developing new things and thats about it

ShadowedR

CEO

South Africa

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

Snesh Prajapati

Software Developer

India

I am a Software Developer working on Microsoft technologies. My interest is exploring and sharing the awesomeness of emerging technologies.

Turay Melo

Software Developer Banco de Moçambique

Mozambique

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

Tushar_Gupta

India

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

First Prize	Martin Arrivets - WPF Automated Trading Application
Prize pool	CodeProject T-Shirt - CodeProject


Second Prize	John Atten - Installing and Using SQLite on Windows
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.