Click here to Skip to main content
15,501,065 members
This competition has ended

Best Database Article of January 2016

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. The top 50 entries are shown.

Please Sign up or sign in to vote.
27 Jan 2016DataBytzAI
How to refresh intellisense after adding new objects in Microsoft SQL Management Studio
Please Sign up or sign in to vote.
19 Jan 2016essentialSQL
How to Write SQL – Understand Database Table Meanings and Relationships – Step 1
Please Sign up or sign in to vote.
23 Jan 2016Igor_A
An architectural prototype of a business logic server as Windows Service. Sample service implementation and test utility.
Please Sign up or sign in to vote.
3 Jan 2016JoaoSousa23
Using MVC, Entity Framework, ASP.NET5 Scaffolding, and Azure SQLServer you can create a web application that stores your information on an SQL Azure database. This demo shows you how to create a web application with MVC and Entity Framework 7, that communicate with a SQL Azure Database
Please Sign up or sign in to vote.
2 Jan 2016Tore Olav Kristiansen
If you need to change values of db table primary keys during ordinary operations, you probably have a design flaw in your software. In extraordinary situations, it may however be necessary. This tip helps you do so.
Please Sign up or sign in to vote.
22 Jan 2016Kevin Griffin
Why could there not be another tool that allowed a development team to harness their existing source control systems, but make database changes a part of the workflow? Enter SQL Source Control by Redgate.
Please Sign up or sign in to vote.
4 Jan 2016essentialSQL
Introduction to SQL Server's built-in logical functions
Please Sign up or sign in to vote.
22 Jan 2016kaviteshsingh
Simple utility to scan and find duplicate files in a directory.
Please Sign up or sign in to vote.
10 Jan 2016WernfriedD
How to set NLS_LANG value for Oracle to support all special characters you need in your language/application.
Please Sign up or sign in to vote.
4 Jan 2016Han Bo Sun
Detailed description of how many-to-many association works with Hibernate, using MySQL and Spring
Please Sign up or sign in to vote.
4 Jan 2016essentialSQL
How to find duplicate values in SQL Server
Please Sign up or sign in to vote.
24 Jan 2016RickZeeland
This is an alternative for "SMO Tutorial 3 of n - Scripting"
Please Sign up or sign in to vote.
21 Jan 2016smirson
This is an alternative for "String splitting/tokenizing using T-SQL user defined function."
Please Sign up or sign in to vote.
25 Jan 2016Rajat-Indiandotnet
Step by step merge join transformations
Please Sign up or sign in to vote.
2 Jan 2016essentialSQL
Introduction to SQL Server's built-in conversion functions
Please Sign up or sign in to vote.
18 Jan 2016M Faheem Zafar
This tip explains how to install Windows Server 2012 R2 Server on Oracle VirtualBox VM Server.
Please Sign up or sign in to vote.
4 Jan 2016essentialSQL
Introduction to SQL Server’s Mathematical Functions
Please Sign up or sign in to vote.
18 Jan 2016Camilo Reyes
Demystify LocalDB in ASP.NET with sqlcmd
Please Sign up or sign in to vote.
19 Jan 2016essentialSQL
Write SQL – Formulate your Question – Step 2
Please Sign up or sign in to vote.
6 Mar 2016István Smrtnik
A Google fusion tables SQL front end for quick query hacks. Comes with code completion, syntax and error highlighting plus some extra commands like DROP TABLE. Antlr4 grammar included.
26 Jan 2016Dynamsoft
This article illustrates how to implement an online barcode reader using PHP and Windows Component Object Model (COM).
Please Sign up or sign in to vote.
18 Jul 2016wells cheung
Standalone Privilege Control, Single Sign-On Solution
Please Sign up or sign in to vote.
6 Jan 2016essentialSQL
Difference between Cast and Convert
Please Sign up or sign in to vote.
14 Jan 2016Vikas Sharma
In this article we are to going to create Web APIs for manipulating and performing CRUD operations on student resource of our project.
Please Sign up or sign in to vote.
23 Mar 2016Ahmet AYDIN
This post describes step by step how to run a Single Page Application template using ASP.NET Web API 2 and angularJS and how to use Web Application Project whose name is Dalyan.
Please Sign up or sign in to vote.
12 Apr 2016DataBytzAI
How to bring CSV and XML data into MS SQL server
Please Sign up or sign in to vote.
11 Jan 2016essentialSQL
Basic concepts of built-In functions in SQL Server
Please Sign up or sign in to vote.
6 Jan 2016George Swan
An introduction to Graph Databases
Please Sign up or sign in to vote.
28 Jan 2016Pritam Zope
In this Article we will create an Auto Completion/Code Completion Window using C# that automatically shows popup of the list of words or keywords and inserting those into a RichTextBox
Please Sign up or sign in to vote.
8 Feb 2016Dholakiya Ankit
Logging database operations in Entity Framework and handling Exceptions
Please Sign up or sign in to vote.
22 Feb 2016Indresh_Prajapati
This tip will help beginners to implement CRUD operations in ASP.NET MVC 5 using WebAPI 2 with scripting language as AngularJS and Database as MS SQL 2008R2.
Please Sign up or sign in to vote.
26 Jan 2016Rasik Bihari Tiwari
Dependency injection, DI containers, IoC containers and Inversion of control are a world of confusion. Let's take them head-on.
Please Sign up or sign in to vote.
23 Jan 2016Shashangka Shekhar
In this article we will get a short overview on AngularJS, then we will create a ASP.Net MVC-5 CRUD application using AngularJS(v1.4.8).
Please Sign up or sign in to vote.
26 Jan 2016Bert O Neill
Develop your own SSMS ObjectExplorer\CommandBar menus, within SQL Server 12
Please Sign up or sign in to vote.
12 Jan 2016AgarwalPriyanka, ErGauravSharma
Challenges faced in data migration testing
Please Sign up or sign in to vote.
2 Feb 2016syed shanu
In this article, we will see how to create an easy SQL Server Tool.
Please Sign up or sign in to vote.
1 Jan 2016Tore Olav Kristiansen
When you create a new SQL Server database, the default recovery model is Full. This model takes up a lot of disk space. It is ordinarily not necessary for developer images. This tip has a SQL script that helps you change this.
Please Sign up or sign in to vote.
31 Dec 2015essentialSQL
Difference between inner and outer joins
Please Sign up or sign in to vote.
20 Jan 2016Indresh_Prajapati
This tip will help beginners to implement CRUD operations in ASP.NET MVC 4 with scripting language as KnockOut and Database as MS SQL 2008R2.
Please Sign up or sign in to vote.
19 Jan 2016Avron Polakow
This article presents a client-side, JavaScript Relational Database Simulator in the browser, using SQL commands to Create, Read, Insert, Update and Delete in-browser table data, as well as formatting the output as HTML objects in a Webpage.
Please Sign up or sign in to vote.
16 Jan 2016Darek Danielewski
A small script to remove old user accounts
Please Sign up or sign in to vote.
19 Jan 2016essentialSQL
Three simple steps to writing SQL queries
Please Sign up or sign in to vote.
12 Jan 2016shijo joseph
An ADO.NET Layer for SQL Server and Oracle which makes it easier for interfacing with database
Please Sign up or sign in to vote.
26 Jan 2016essentialSQL
Write SQL - write the query
Please Sign up or sign in to vote.
2 Jan 2016essentialSQL
Introduction to SQL Server’s Common String Functions
Please Sign up or sign in to vote.
29 Jan 2016Passion4Code
SQL scheduled jobs
Please Sign up or sign in to vote.
14 Jan 2016Bhishma Anil Kajaria
Browse and Copy data from your CSV file to SQL directly without any Windows application...
Please Sign up or sign in to vote.
5 Jan 2016essentialSQL
Commonly used SQL Server data types

Current Participants

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

Chief Technology Officer The DataWorks
United Kingdom United Kingdom
Allen is a consulting architect with a background in enterprise systems. His current obsessions are IoT, Big Data 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 runs his own company specializing in systems architecture and scaling for big data and is involved in a number of technology startups.

Allen is a chartered engineer, a Fellow of the British Computing Society, and a Microsoft MVP. He writes for CodeProject, C-Sharp Corner and DZone. He currently completing a PhD in AI and is also a ball throwing slave for his dogs.
Tester / Quality Assurance
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer
Turkey Turkey
i am Ahmet AYDIN from turkey.
Web Developer
Israel Israel
Drummer (1½/2½/3 simultaneous), PhD Philosophy, AI, Dottiest and possibly oldest Net Developer, Online since 1970
Architect
Ireland Ireland
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Team Leader
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
This is a Organisation

1 members
Engineer
United States United States
Husband, father, and software engineer living in Houston Texas. Passionate about JavaScript, C#, and webbing all the things.
Architect BI Software, Inc.
United States United States
A seasoned IT Professional. Programming and data processing artist. Contributor to StackOverflow.
Web Developer
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Canada Canada
Dynamsoft has more than 15 years of experience in TWAIN SDKs, imaging SDKs and version control solutions.

Our products include:

TWAIN SDK
- Dynamic Web TWAIN: a TWAIN scanning SDK optimized for web document management applications.
- Dynamic .NET TWAIN: a .NET TWAIN and Directshow Image Capture SDK for WinForms/WPF applications.

Imaging SDKs
- Barcode Reader for Windows, Linux, macOS, iOS, Android and Raspberry Pi.
- OCR addon for both web and .NET TWAIN SDKs

Version Control
- SourceAnywhere: a SQL server-based source control solution. Both on-premise and hosting options are provided.

http://www.dynamsoft.com/
This is a Organisation

21 members
Easy Computer Academy, LLC
United States 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/
Student
Wales Wales
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Team Leader The Judge Group
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Technical Lead
Ukraine Ukraine
Igor Alexeev (axaprj2000@yahoo.com)
.NET Development, Architecture, Tech. Consulting
Software Developer
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Austria Austria
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer (Senior) Devscope
Portugal Portugal
I am João Sousa, and since i finish my degree I’m working in software development using Microsoft technologies.

I was awarded

Microsoft Most Valuable Professional (MVP) 2015 – .Net

My profissional profile:

Azure Developer
.NET Developer

My Certifications:

MCTS - .NET Framework - Application Development Foundation
MCTS - .NET Framework 2.0 - Windows-based Client Development
MCTS - .NET Framework 3.5 ADO.NET Applications
MCTS - .NET Framework 3.5 ASP.NET Applications
MCSD - Programming in HTML5 with JavaScript and CSS3
MCSD - Developing ASP.NET MVC 4 Web Applications
MCSD - Developing Windows Azure and Web Services
MCSA Office 365 - Managing Office 365 Identities and Requirements
MCSA Office 365 - Enabling Office 365 Services
MCSD - Implementing Microsoft Azure Infrastructure Solutions
Software Developer (Senior)
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
President Griffin Consulting, Inc
United States United States
Kevin Griffin is an independent software consultant from Chesapeake, VA specializing in helping businesses push their technology stack into the 21st century.

Kevin is writing a book on adding SMS and Voice to your applications with Twilio. Check it out at Twilio Blueprint

Keep in touch with Kevin by heading over to http://kevgriffin.com!
Oakton
Australia Australia
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Technical Lead Air Liquide Industrial Services (Singapore)
Singapore Singapore
My passion lies in building business intelligence and data-based solutions, writing about things I work with and talking about it. New technologies relevant to my line of work interest me and I am often seen playing with early releases of such technologies.

My current role involves architecting and building a variety of data solutions, providing database maintenance and administration support, building the organization’s data practice, and training and mentoring peers.

My aspiration over the next several years is to achieve higher competency and recognition in the field of Data Analytics and move into a career of data science.


Specialities: SQL Server, T-SQL Development, SQL Server Administration, SSRS, SSIS, C#, ASP.Net, Crystal Reports
Software Developer (Senior)
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer
India India
Software Engineer
Team Leader
India India
I am Rajat Jaiswal from India. I am working as a Technology specialist in one of the reputed company in India with 12+ years of experience. I am a Microsoft Data Platform MVP & Alibaba Cloud MVP.
I have always had an affinity to learn something new in technology. Database, Web development, Cloud computing are the areas of my interests always.
I have been a regular contributor to technologies with more than 300+ tips. Learning & Sharing is one of my aims always. Writing blogs, delivering sessions, helping on forums is my hobby.
Software Developer 1E
India India
My professional details will hardly make a difference to you if you have come to know about me after reading my lengthy article but my intent will make a difference for sure. Why I write articles is for the sole motto which I got to know pretty late in my career. My motto is that there is ONLY one way of enhancing knowledge and that way is sharing. Blogs, articles and white papers are nothing but a form of knowledge sharing. It also helps you creating a backup copy of the knowledge you have in your brain and nerves. This backup copy will surely outlive your life as this knowledge gets transferred to uncountable people through sharing. So start contributing now! Always remember my favorite quote - "Knowledge is the ONLY antidote to all fears. Start reading a new book today". Don't seek Nirvana. Seek knowledge. Nirvana and knowledge are synonymous.
Software Developer
Netherlands 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 ...
Software Developer
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer (Senior) s3 Innovate Pte Ltd
Bangladesh Bangladesh
Hi, I am Shashangka Shekhar,

Working with Microsoft Technologies. Since March 2011, it was my first step to working with Microsoft Technologies, achieved bachelor’s degree on Computer Science from State University of Bangladesh(Dhaka). Have 10+ years of professional experience, currently working as Senior Software Engineer at s3 Innovate Pte Ltd.

I believe in desire of learning & also love to be a part of .Net Community by sharing knowledge’s.
Technical Lead
United States United States
Started Programming career with VB 6 and VC++ and now Into .Net Development. Working with .Net since its first release (Version 1.0 Beta). Lucky enough to continue always with most updated versions of .Net and as of now; May 2007, fighting with .Net 3.0 (WPF,WCF...etc) and it's next most anticipated version LINQ.

Got familiarity up on the .Net Technologies and Guidelines like CAB, and Patterns and Practices, Enterprise Library and now with it's WPF version etc.

Specialized in Windows and Distributed and Service oriented applications.
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Team Leader
India 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
Technical Lead IdentityStream
Norway Norway
My name is Tore Olav Kristiansen and I am a developer. I am passionate about making coherent people-friendly solutions.

I have worked as a software engineer for 18 years. I am the founder of IdentityStream.

I have a masters in computer science from the University of Stavanger, Norway.
Software Developer (Senior)
India India
I am currently working as a Senior Software Engineer in Quovantis Technologies and have an experience of more than 4 years in C#.Net. I have my graduation in Bachelor of Computer Applications and hold a diploma in Software Engineering GNIIT from NIIT.
I am very passionate about programming, love to learn new technology and believe in sharing knowledge.
My work experience includes Development of Enterprise Applications using C#,.Net,Sql Server,AngularJS and Javascript.
Software Developer (Senior)
United States United States
ASP.NET Developer 3.5(Microsoft® Certified Professional Developer)
.NET Framework 3.5, ASP.NET Applications(Microsoft® Certified Technology Specialist)
Software Developer (Senior)
Switzerland Switzerland
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

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 Jan - 31 Jan 2016