Best Database article of December 2013

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.

Cross of Fields in a Table of Database Accessible via PDO

22 Sep 2022Member 4206974

CrossData is a PHP object for creating an HTML table or a PHP array, crossing two fields of a table from a PDO accessed database.

HTML

Javascript

MySQL

PHP

Dev

Inno Setup Script to Install SQL Server 2008 R2 with Tools

1 Dec 2013RickZeeland

Inno Setup script to install SQL Server 2008 R2 with Tools, creating an instance with special rights and displaying the log.

SQL Wizardry Part Three - Common Table Expressions (CTEs)

12 Jan 2014Christian Graus

In this third installment, we look at how Common Table Expressions can simplify your SQL and help you perform complex tasks

Accessing SSRS Reports from SharePoint Site using C#

20 Dec 2013Subodh Raikar

Accessing SSRS Reports from SharePoint Site using C#

Camera_Net Library

28 Apr 2022free5lot

Camera_Net is a FLOSS library for using video-cameras and video-inputs in .NET projects easily

Fetching data in order of commit of database transactions in Oracle

17 Dec 2013Davinder 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.

Oracle

Dev

DBA

QuickTip: Oracle SQLPlus – (IF) Check for parameters to script

23 Dec 2013Sam Varadarajan

(IF) Check for parameters to script.

SQL

Oracle

Data protection and privacy law for developers

21 Dec 2013DataBytzAI

An overview of what developers need to know about data protection and privacy

A free "Export to Excel" C# class, using OpenXML

17 Dec 2013Mike Gledhill

How to easily add an "export to Excel" feature to your app

Querying SQL Server 2012: Part I

3 Jan 2014Sander Rossel

The first of two, everything you need to create the most amazing queries!

SQL Wizardry Part 2 - Select, beyond the basics

12 Mar 2014Christian Graus

The second in my series digs in to some of the different things you can do within a select statement.

SQL Wizardry Part One - Joins

23 Jan 2014Christian Graus

The first in a series of articles seeking to explain the intermediate to advanced features of T-SQL

T-SQL

SQL

SQL-Server

Type Preference with UNION in SQL Server

10 Dec 2013Amey A khedekar

A scenario with data type of the resultant select columns with UNION.

Gain Coding Speed with Nido (FREE) Framework .NET/ C#

30 Oct 2014Nirosh

Nido Framework with .Net 4.0 and Entity Framework help you standardize your Business Logic Layer (BLL).

Getting the Current Time from Any Time Zone

18 Dec 2013vikram.mahapatra

How to get the current time from any time zone

SQL-Server-2008

SQL-Server

How to: Get Data from Multiple Workbooks using One OleDbConnection?

3 Jan 2014Maciej Los

This tip shows how to get data from multiple workbooks using one OledbConnection.

SQL

Office

ADO.NET

C# - Optical Marks Recognition (OMR) Engine 1.0

23 Dec 2013LamYongXian

This is an alternative for "C# - Optical Marks Recognition (OMR) Engine 1.0"

Know More about SQL Constrains

21 Aug 2014Mohammed Nazer

SQL Constrains details and its types

jQuery Mobile AutoComplete in ASP.NET with SQL Server Database Connection

12 Dec 2013Mehmet Murat TANDOĞAN

How to use jQuery mobile autocomplete in ASP.NET using generic handler(.ashx) file with database connection.

Gotcha: "BEGIN" in Oracle

23 Dec 2013Sam Varadarajan

"BEGIN" keyword in Oracle.

SQL

Oracle

String Aggregation in the World of SQL Server

4 Dec 2013Sergii Syrovatchenko

This article includes examples of T-SQL capabilities that allow to perform string concatenation flexibly and effectively through the use of different constructs.

Does a Database/Table/Column Exist in SQL Server

12 Dec 2013♥…ЯҠ…♥

Query to check Database, Table, Column exists in Sql Server

SQL-Server

Rowversion datatype in SQL Server: Track Which Rows Have Been Modified

17 Dec 2013SonuKSingh

SQL Server: Track which rows have been modified

SQL-Server

SubStringInstance SQL CLR - Find the nth Instance of a String

14 Dec 2013C Grant Anderson

SQL CLR function to find the nth instance of a string within a string

SQL

Windows

SQL-Server

C# Project on Database for Beginners

6 Jan 2014Hasan Habib Surzo

Class, Database Connection, Login Winform

Query Database From MFC (Database Viewer)

4 Dec 2013Mahdi Nejadsahebi

How to query a database file from an MFC application.

Oracle: Commit and Forward Slash

26 Dec 2013Sam Varadarajan

Commit and forward slash in Oracle

SQL

Dev

DBA

Oracle: Forward Slash in SQL*Plus – Take 2

8 Jan 2014Sam Varadarajan

Oracle - Forward slash in SQL&Plus - Take 2

SQL

Dev

DBA

Oracle: DDL and Forward Slash

26 Dec 2013Sam Varadarajan

Oracle: DDL and forward slash

Oracle

Gotcha: Oracle11g Password Case Sensitivity

29 Dec 2013Sam Varadarajan

Apparently, passwords are case sensitive in Oracle 11g by default. This can be overridden.

SQL

Oracle

Working with SQL Server using the MVP Pattern

10 Dec 2013Ravindra T C

Working with SQL Server in an ASP.NET application using the MVP Pattern.

SQL-Server

ASP.NET

Connecting to SQL Server using MVVM Pattern

13 Dec 2013Ravindra 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.

WPF

SQL-Server

Dev

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.

♥…ЯҠ…♥

Software Developer

India

There are only 10 type of people in this programming world....
one who knows the binary and other who doesn't.

Amey A khedekar

India

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

C Grant Anderson

Architect AT&T

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

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

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

free5lot

Software Developer

Russian Federation

codeproject@free5lot.com

Hasan Habib Surzo

Software Developer (Senior)

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

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

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
Python
JCL

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

Mahdi Nejadsahebi

Software Developer

Iran (Islamic Republic of)

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

Mehmet Murat TANDOĞAN

Software Developer (Senior)

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

Member 4206974

Software Developer Condor Informatique

Italy

Computer literacy (software) : Languages: PHP, Javascript, SQL Autoit,Basic4Android; Frameworks: JOOMLA!
Teaching/Training skills on Office, WEB site development and programming languages.
Others : WEB site development.
UNDP Missions
feb – may 2003 Congo DR Bukavu: ground IT computer course
nov 2003 Burundi Bujumbura: Oracle Data Base course
feb 2005 Burundi Bujumbura: JAVA course
mar 2005 Mali Kati: MS Office course
oct 2006 Mali Kati: MS Office course
jun 2006 Burkina Faso Bobo Dioulasso: MS Office course
jun 2007 Burkina Faso Bobo Dioulasso: MS Office course
may 2007 Argentina Olavarria hospital: Internet application for access to medical records
apr 2008 Burkina Faso Ouagadougou: MS ACCESS and dynamic Internet applications
jun 2008 Niger Niamey: analysis of the computing needs of the Niamey hospital
may 2009 Burkina Faso Ouagadougou: MS ACCESS and dynamic Internet applications
oct 2010 Niger Niamey: analysis of the computing needs of the Niamey hospital (following)
Region Piedmont project Evaluation
mar 2006 Burkina Faso, Niger
mar 2007 Benin, Burkina Faso, Niger
sep 2008 Benin, Burkina Faso, Niger
Others
feb 2010 Burundi Kiremba hospital: MS Office course
feb 2011 Congo DR Kampene hospital: MS Office course

Mike Gledhill

Software Developer

Switzerland

Full-stack Software Developer, working for an insurance company in Zurich, Switzerland.

More developer tips'n'trip at my website:
http://www.MikesKnowledgeBase.com

Mohammed Nazer

Software Developer

India

Dot Net Developer

Nirosh

Architect Virtusa Pvt. Ltd.

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

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

Software developer in the Netherlands, currently working on Video Surveillance applications.
Experience: C#, C++, VB, ASP, SQL Server, PostgreSQL, Gitea, TeamCity.
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

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

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 DraftKings Inc.

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

Programming is my passion. It is always fun to learn new things.

Follow my blog
Follow on FB

Subodh Raikar

Software Developer

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

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

	Sander Rossel - Querying SQL Server 2012: Part I
Prize pool	CodeProject Mug - CodeProject CodeProject Mousepad - CodeProject SQL Prompt from Red Gate Software - Redgate Software

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.
Must be an article, or blog entry
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).
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.
Articles entries must follow the CodeProject submission guidelines.
No cheating, lying, plagiarizing articles, chicanery, or kicking.
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.
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 article 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.
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, 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.