Click here to Skip to main content
15,868,016 members
This competition has ended

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

Please Sign up or sign in to vote.
21 Jun 2016Marc Clifton
A deep dive into the $lookup aggregator with examples of one-to-one, one-to-many, many-to-many, and nested relational "queries"
Please Sign up or sign in to vote.
26 Nov 2016JamesFaix
Get a collection of all running Excel interop Application objects (not just the active one)
Please Sign up or sign in to vote.
29 Feb 2016wells cheung
Privilege Control System based on MVC and WCF.
Please Sign up or sign in to vote.
18 Feb 2016Kuv Patel
Debug stored procedures in Visual Studio and SQL Server Management Studio.
Please Sign up or sign in to vote.
10 Feb 2016Jesus Carroll
SQL Server 2016 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time.
Please Sign up or sign in to vote.
13 Feb 2016Paulo Henrique S.S.
Getting started with MongoDB 3.2 and C# driver 2.0
Please Sign up or sign in to vote.
21 Feb 2016Abdullah Al-Muzahid
This is a RAD tool which can be used to generate codes for CRUD operation in ASP.NET and C# automatically based on Database Model Diagram.
Please Sign up or sign in to vote.
7 Dec 2016Kuv Patel
Decrypt Stored Procedures, Views, Functions, and Triggers in SQL Server
Please Sign up or sign in to vote.
12 Feb 2016Marc Clifton
Part 1 of a 3 part series on how to use MongoDB for implementing a semantic database
Please Sign up or sign in to vote.
26 Feb 2016Pavel Sinkevich
How to programmatically change schema name in database project before deployment
Please Sign up or sign in to vote.
18 Feb 2016debashishPaul
How to Get 'serial' value of the Inserted Record and Use with a Variable in PostgreSQL
Please Sign up or sign in to vote.
22 Feb 2016Sifiso W Ndlovu
This tip illustrates a workaround to SQL Server pivoting on variable character data types.
Please Sign up or sign in to vote.
3 Feb 2016Michael B. Erickson
Add rich reporting of exceptions to improve error reporting to users and diagnostics to development.
Please Sign up or sign in to vote.
25 Feb 2016Sibeesh Passion
In this article, we will learn how we can work with jQuery Datatables with server side data.
Please Sign up or sign in to vote.
4 Feb 2016Steve Naidamast
Black Falcon Software Releases MySQL Helper 4.5
Please Sign up or sign in to vote.
15 Feb 2016Craig Pickles
Row-Level Security in Azure SQL with entity framework
Please Sign up or sign in to vote.
1 Feb 2016Deepak A S
An ALL SERVER trigger to know who it is!
Please Sign up or sign in to vote.
19 Feb 2016Wagner NULL
This tip aims to demonstrate in a simple way how to implement MySQL GROUP_CONCAT function in SQL SERVER.
Please Sign up or sign in to vote.
28 Feb 2016syed shanu
In this article, we will see how to create and manage a User Role based menu using ASP.NET MVC, WEB API and AngularJS.
Please Sign up or sign in to vote.
3 Oct 2016Mark W Solomon
In this article, I developed a way to determine all the SQL Servers in our environment at will and filter this information into Microsoft's Sunset report for Microsoft SQL Server and present all this information in an SSRS report.
Please Sign up or sign in to vote.
4 Feb 2016Lộc Nguyễn
Example of Chinook digital media store database
Please Sign up or sign in to vote.
8 Feb 2016Shi Her
Using the Mongo C# Driver in Visual Studio to connect to MongoLab and creating generic CRUDs.
Please Sign up or sign in to vote.
16 Feb 2016Manjuke Fernando
What is the difference between Index REBUILD and REORGANIZE and when exactly should you use it
Please Sign up or sign in to vote.
18 Feb 2016Sreekanth Mothukuru
How to create an interactive interface (help documentation) to represent our RESTful API using popular framework Swagger & Swashbuckle
Please Sign up or sign in to vote.
26 Feb 2016Ranjan.D
Abstract and generic DAO for RavenDB
Please Sign up or sign in to vote.
24 Oct 2016GhostHost
A simple stored procedure to add at your database to keep it reactive
Please Sign up or sign in to vote.
10 Feb 2016Siddharth R Barman
Quick introduction to oData (v4) by understanding how to implement CRUD method using ASP.NET Web API
Please Sign up or sign in to vote.
24 Feb 2016Chris_Yu
To code our own MVC framework from scratch
Please Sign up or sign in to vote.
23 Feb 2016Sreekanth Mothukuru
A look at the free SQL Server Schema Comparison Tool in VS2013
Please Sign up or sign in to vote.
11 Feb 2016kevinfitzpatrick
Migrating a Project from Database First to Code First
Please Sign up or sign in to vote.
5 Feb 2016jgauffin
Griffin DAL Generator – Take 2
Please Sign up or sign in to vote.
21 Feb 2016adityaswami89
NoSQL: MongoDB for beginners
Please Sign up or sign in to vote.
20 Sep 2016GhostHost
Automatic creation of non clustered indexes using system SQL entities
Please Sign up or sign in to vote.
23 Feb 2016otark777
Some thoughts about one page Angular site based on ASP.NET Web API 2 and Cassandra NOSQL database
Please Sign up or sign in to vote.
2 Mar 2016ArindamSarkar
Tips and tricks to quickly find out how to manipulate Excel using .NET Managed Code
Please Sign up or sign in to vote.
28 Feb 2016Bipin Paul
Implementation of Contact Us Page using ASP.NET MVC pattern
Please Sign up or sign in to vote.
9 Feb 2016Kashif-Sohail
This article will guide you to “How to populate and add new nodes to TreeView up-to N Levels from Database”. You will be able to add new node at any level and expand this up-to N Levels and generate automatic code for any child.
Please Sign up or sign in to vote.
17 Feb 2016Aqeeel
Though GridView provides a way to implement paging however when the record count in very big we need to optimize it at the query level.
Please Sign up or sign in to vote.
1 Feb 2016Sibeesh Passion
Introduction to Web SQL
Please Sign up or sign in to vote.
19 Feb 2016mbruchet
MongoDB, everyone talks about it, here article guides you step in its integration with Microsoft.NET.
Please Sign up or sign in to vote.
5 Feb 2016Foothill
A Primer for Writing Parameterized Oracle Queries for the .NET SQL Server Developer
Please Sign up or sign in to vote.
15 Feb 2016Sibeesh Passion
Some information about IndexedDB
Please Sign up or sign in to vote.
21 Sep 2016GhostHost
Use SQL Server to manage completely databases backups, network copy and deletion using only stored procedures

Current Participants

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

Software Developer (Senior) BRAC IT Services
Bangladesh Bangladesh
Application Developer, Database Designer, and Project Manager in a wide variety applications. Currently working at BRAC IT Services, Bangladesh as a Senior Software Engineer. Particularly interested in financial application development.
Software Developer (Senior)
India India
Passionate about Microsoft Technologies like WPF, Windows Azure, ASP.NET, Win Phone and also on Cross platform Mobile Apps, Mongo DB's, IOT & WOT. I love learning and working with (or) Creating Design Patterns . Writer | Technology Evangelist | Technology Lover | Microsoft Developer Guidance Advisory Council Member | Cisco Champion | Speaker |

Blog : http://adityaswami89.wordpress.com/
Software Developer
Pakistan Pakistan
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Technical Lead Wipro
India India
I am working as .NET developer for around 9 Years now. I have 4 years+ experience in WPF desktop application and WCF service. Recently I have started exploring AngularJS, HTML5 and Kendo controls.
Student
Nepal Nepal
Student, Freelancer , Developer, Web Guy, ASP.NET Core and More
Web Developer
Australia Australia
Chris Yu is a full stack web developer, a Zend Certified PHP Engineer. His current interest focuses on front-end web component, as well as front-end & back-end separation development.
United Kingdom United Kingdom
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer (Senior)
Australia Australia
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Engineer
India India
This member doesn't quite have enough reputation to be able to display their biography and homepage.
Software Developer (Senior)
United States United States
Professional Experience
Languages: C++, C#, VB, .Net, SQL
Systems: MSSQL Database Architecture, Server Admin, MS System Center Admin(Service Manager)
Web: Asp.Net, Ajax, Web design and deployment
Other: MS Access guru
Software Developer
Italy Italy
I'm a software engineer, specializing in backend development and distributed systems. I have extensive experience in designing and implementing resilient, responsive, scalable, and maintainable systems using C#, .NET on top of cutting-edge technologies.
Software Developer
United States United States
I am a professional developer, but I really create software because it's fun. I've always been interested in deconstructing complex systems, and software engineering has proven to be an inexhaustable supersystem of such systems. In the past I've also spent time focusing on music composition, audio engineering, electronics, game design, history, and philosophy.

My strongest languages are English and C#, in fact I'm a Microsoft Certified Professional for "Programming in C#". I do not have any certifications for English, so please trust me there. I've spent a lot of time working on Windows desktop applications, particularly for interacting with SQL Server or automating Microsoft Office programs, using technologies such as C#, VB.NET, VBA, T-SQL, WinForms, WPF, ADO.NET, the MS Office PIA's, ExcelDNA, EPPlus, and Crystal Reports. I've also done some web development using JavaScript, HTML, CSS, TypeScript, ASP.NET, WCF, jQuery, and requirejs. I am very interested in functional programming (F#, Haskell, Clojure), and try to use C# and JavaScript in a "functional" way at times, but I haven't had the opportunity to use a functional language for a serious project yet.
Systems Engineer
Colombia Colombia
Systems Engineer. Computer Scientist. Data Development Consultant currently supporting on mission critical systems. Current academic researcher for application of Numerical Analysis and Genetic Algorithms on Data Mining techniques for Cloud Computing's Database As A Service (DaaS) in Computational Physics area.
Founder 1TCompany AB
Sweden Sweden
Software Developer
Pakistan Pakistan
I am passionate about programming, playing with data is all time my favorite hobby. Making things, processes intelligent and convenient is my ultimate goal. Love to work with real-time systems. Cloud is my life.
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)
United Kingdom United Kingdom
Kuv Patel is a Senior Software Developer and Solutions Architect, specializing in .NET and Javascript frameworks development using MVC, ASP.NET, C#, WCF, Web API, Entity Framework, React, Angular.
Software Developer
United States United States
while (live) {
try {
learn();
code();
food();
...
} catch (Exception ex) {
recover();
}
}
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
Architect Interacx
United States United States
Blog: https://marcclifton.wordpress.com/
Home Page: http://www.marcclifton.com
Research: http://www.higherorderprogramming.com/
GitHub: https://github.com/cliftonm

All my life I have been passionate about architecture / software design, as this is the cornerstone to a maintainable and extensible application. As such, I have enjoyed exploring some crazy ideas and discovering that they are not so crazy after all. I also love writing about my ideas and seeing the community response. As a consultant, I've enjoyed working in a wide range of industries such as aerospace, boatyard management, remote sensing, emergency services / data management, and casino operations. I've done a variety of pro-bono work non-profit organizations related to nature conservancy, drug recovery and women's health.
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.
Architect
France France
Hy, I'm comming success on Microsoft Certification profesionnal 70-480 on HTML 5 / CSS 3 / JavaScript and I preparing the next certificate 70-486. This certificat is required to MCSD Web And Azure.

I'm a Asp.NET Expert, I can help you to develop your web site and i can host it on Microsoft Azure Data center.

My budget is depend on your functions.

I can talk you tomorrow if you want to exchange about it.

Thanks
Software Developer (Senior) Erickson and Associates
United States United States
Principle Software Engineer for the consulting firm of Erickson and Associates in Seattle WA. BA in Architecture from Virginia Tech and BS in Computer Science, University of WA.
Web Developer
Israel Israel
C# developer

e-mail: otark777@yahoo.com
Software Developer (Senior)
Australia Australia
Software developer. I've been working with the design and coding of several .NET solutions over the past 12 years.

Brazilian, living in Australia currently working with non-relational searching engine and BI.
Belarus Belarus
T-SQL developer, SSIS developer, C# developer. Have experience in .Net development, minor experience in web development (ASP.NET, Sharepoint).
Microsoft certification in MS SQL Server 2008 development.
Most recent experience with MS SQL Server 2012, SSIS 2012.
Web Developer
United States United States
Profile

Around 10 years of professional software development experience in analysis, design, development, testing and implementation of enterprise web applications for healthcare domain with good exposure to object-oriented design, software architectures, design patterns, test-driven development and agile practices.

In Brief

Analyse and create High Level , Detailed Design documents.
Use UML Modelling and create Use Cases , Class Diagram , Component Model , Deployment Diagram, Sequence Diagram in HLD.

Area of Working : Dedicated to Microsoft .NET Technologies
Experience with : C# , J2EE , J2ME, Windows Phone 8, Windows Store App
Proficient in: C# , XML , XHTML, XML, HTML5, Javascript, Jquery, CSS, SQL, LINQ, EF

Software Development

Database: Microsoft SQL Server, FoxPro
Development Frameworks: Microsoft .NET 1.1, 2.0, 3.5, 4.5
UI: Windows Forms, Windows Presentation Foundation, ASP.NET Web Forms and ASP.NET MVC3, MVC4
Coding: WinForm , Web Development, Windows Phone, WinRT Programming, WCF, WebAPI

Healthcare Domain Experience

CCD, CCR, QRDA, HIE, HL7 V3, Healthcare Interoperability

Education

B.E (Computer Science)

CodeProject Contest So Far:

1. Windows Azure Developer Contest - HealthReunion - A Windows Azure based healthcare product , link - http://www.codeproject.com/Articles/582535/HealthReunion-A-Windows-Azure-based-healthcare-pro

2. DnB Developer Contest - DNB Business Lookup and Analytics , link - http://www.codeproject.com/Articles/618344/DNB-Business-Lookup-and-Analytics

3. Intel Ultrabook Contest - Journey from development, code signing to publishing my App to Intel AppUp , link - http://www.codeproject.com/Articles/517482/Journey-from-development-code-signing-to-publishin

4. Intel App Innovation Contest 2013 - eHealthCare

5. Grand Prize Winner of CodeProject HTML5 &CSS3 Article Contest 2014

6. Grand Prize Winner of CodeProject Android Article Contest 2014

7. Grand Prize Winner of IOT on Azure Contest 2015
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
Germany Germany
I am Sibeesh Venu, an engineer by profession and writer by passion. I’m neither an expert nor a guru. I have been awarded Microsoft MVP 3 times, C# Corner MVP 5 times, DZone MVB. I always love to learn new technologies, and I strongly believe that the one who stops learning is old.

My Blog: Sibeesh Passion
My Website: Sibeesh Venu
Software Developer (Senior)
United States United States
My personal website is at http://sbytestream.pythonanywhere.com
Technical Lead select SIFISO
South Africa South Africa
Sifiso W. Ndlovu is a certified Microsoft professional who holds a Master’s degree in IT Management from the University of Johannesburg. He specializes on a range of enterprise and consumer technologies using open source and proprietary software. He is the member of the Johannesburg SQL User Group wherein he has made several presentations on User Group Meetings and SQL Saturday sessions. He has written for a number of publications including SQLShack.com and SQLServerCentral.com.
Technical Lead
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 (Senior) Black Falcon Software, Inc.
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
Brazil Brazil
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
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)

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 Feb - 29 Feb 2016