Click here to Skip to main content
15,867,453 members
This competition has ended

Best Database Article of November 2015

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.
9 Nov 2015Sander Rossel
Using Venn diagrams to visualize sets.
Please Sign up or sign in to vote.
12 Nov 2015Fred Song (Melbourne)
In this article, we started from Generate Inserts procedure, then go through how generates inserts SQL files with this procedure and runs these inserts SQL files to import data.
Please Sign up or sign in to vote.
24 Nov 2015koolprasad2003
This article explain you How to protect word document using C# and Word automation
Please Sign up or sign in to vote.
4 Nov 2015Fred Song (Melbourne)
Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.
Please Sign up or sign in to vote.
6 Dec 2016_Asif_
This article helps in identifying database design issues like certain fields missing, nullable fields, Primary key not found issues in production environment using SQL Server schema views.
Please Sign up or sign in to vote.
8 Nov 2015koolprasad2003
This article help you to create word table using OpenXML without interop object
Please Sign up or sign in to vote.
2 Nov 2015Sibeesh Passion
How to load data from database using Web API
Please Sign up or sign in to vote.
20 Nov 2015stebo0728
MDI Case Study Purchasing - Part V - ObjectDataSource
Please Sign up or sign in to vote.
2 Nov 2015Guni Van
Mapping your database with C# object class, then make typed-safe query like SQL syntax
Please Sign up or sign in to vote.
9 Nov 2015veen_rp
A simple, step by step tutorial to set up an MS-Office Excel Ribbon, launch your own .NET applications from Excel and interact with the spreadsheet values.
Please Sign up or sign in to vote.
15 Nov 2015sandeepmittal11
COALESCE in SQL Server
Please Sign up or sign in to vote.
17 Nov 2015Sibeesh Passion
How to load an XML file and show as li using ng-repeat in Angular JS
Please Sign up or sign in to vote.
13 Nov 2015Najmul Hoda
Here is the code snippet to check how many database connections are opened in SQL Server.
Please Sign up or sign in to vote.
5 Nov 2015Vyacheslav Voronenko
As a contractor software developer I am asked from time to time to perform audit of LAMP projects. As project configuration is different, I use so-called "umbrella repository environment" which allows me to wrap such projects into reusable vagrant environment without need to amend audited projects c
Please Sign up or sign in to vote.
19 Nov 2015Manjuke Fernando
How to capture and analyze deadlocks in SQL Server
Please Sign up or sign in to vote.
27 Jan 2016MarcusCole6833
Make some SQL XML dot style another way
Please Sign up or sign in to vote.
12 Nov 2015Veselin Tenev
Provides simplistic solution to a recursive MySQL table
Please Sign up or sign in to vote.
11 Nov 2015Masteramuk
Basic rules for using MySQL Cluster (NDB) from MyISAM or InnoDB
Please Sign up or sign in to vote.
12 Nov 2015Eduardo Yost
Creating a Web User Control containing an AutoCompleteExtender for data through WCF (JSON) allowing to store the entity selected through EntityFramework. Entity object serialization from the server to the client and the client to the server.
Please Sign up or sign in to vote.
14 Nov 2015BI Road Warrior
Improving Pentaho Data Integration with MySQL: improving performance.
Please Sign up or sign in to vote.
8 Dec 2015Jovan Popovic(MSFT)
Overview of built-in support for JSON text processing in new SQL Server
Please Sign up or sign in to vote.
7 Nov 2015Syed Hasan Hyder
Provides plausible and high performing data display, for very large data (over a million records)
Please Sign up or sign in to vote.
25 Nov 2015Manjuke Fernando
Analyzing SQL Server Error Logs / Agent Logs using T-SQL
Please Sign up or sign in to vote.
10 Dec 2015Daniel Miller
This article describes the C# implementation for a high-performance role-based access control list.
Please Sign up or sign in to vote.
20 Nov 2015Lộc Nguyễn
With a DEMO WPF application (WinNotif)
Please Sign up or sign in to vote.
23 Nov 2015sandeepmittal11
A sequence is a user defined, schema bound object that generates a sequence of numeric values
Please Sign up or sign in to vote.
7 Jan 2016Rakhi Shrivastava
This tip explains the step by step approach how we can use Glimpse for easy debugging of the ASP.NET MVC application.
Please Sign up or sign in to vote.
19 Nov 2015Dennis Baberich
How to get a claimbased cookie authentication between custom frontend and self hosted SignalR server
Please Sign up or sign in to vote.
16 Nov 2015sandeepmittal11
Apply Operator in SQL Server
Please Sign up or sign in to vote.
6 Dec 2015Tamer J. Mehyar
A simple way to keep track of DB objects versions (DDL updates) in SQL Server
Please Sign up or sign in to vote.
16 Nov 2015User 10668410
How to get SQLite 1.0.98.1 working with Entity Framework 6.1.3 without a massive headache using the Database First Model and Code First Model.
Please Sign up or sign in to vote.
12 Feb 2016Peter Elzinga
This is a generic solution for converting the output of any SQL server script to an Excel file (using SSIS).
Please Sign up or sign in to vote.
23 Feb 2016sandeepmittal11
Lead and Lag Functions in SQL Server
Please Sign up or sign in to vote.
18 Aug 2016syed shanu
In this article, you will learn about MVC AngularJS Master/Detail CRUD, Filter and Sorting using WEB API 2 with Stored Procedure.
Please Sign up or sign in to vote.
9 Nov 2015nomi ali
In this article we learn MEAN Stack a combination of open source JavaScript framework. How they work and How can create a single page application using these technologies. We use these JavaScript technologies not only on front end but also on the back end.
Please Sign up or sign in to vote.
29 Nov 2015Amit Singh Baghel
Saving Details Table Data (An HTML Table) in Database by converting it into a jagged array and passing it to a table type parameter
Please Sign up or sign in to vote.
22 Nov 2015Daniel Miller
This code snippet shows how to count all the tables and rows in a SQL Server database
Please Sign up or sign in to vote.
29 Nov 2015Reeshabh Choudhary
Web platform based query builder to play with your database :)
Please Sign up or sign in to vote.
27 Nov 2015dibley1973
How to call a basic stored procedure using StoredProcedureFramework
Please Sign up or sign in to vote.
13 Nov 2015Paulo Zemek
Lately I am dealing a lot with security issues and, as I am thinking about security all the time, I decided to write this post. Yet, don't expect me to talk about the newest cases.So, first, what is considered a security issue?I don't have a perfect answer but maybe we can say that if anything in an
Please Sign up or sign in to vote.
14 Nov 2015junnark
This is a tutorial on how to use WinFormsGen's generated code.
Please Sign up or sign in to vote.
17 Nov 2015DLChambers
Validate MigrationHistory to preempt arcane exceptions when EF accesses DB
Please Sign up or sign in to vote.
20 Mar 2016Evgeny Pereguda
Simple variadic template for implementation of IUnknown and IDispatch interfaces
Please Sign up or sign in to vote.
3 Nov 2015Rakibul Islam 33
In this tip, we will try to understand SOLID Architecture principles using simple ASP.NET MVC 5 examples.
Please Sign up or sign in to vote.
3 Nov 2015Jovan Popovic(MSFT)
SQL Server 2016 introduces the new DROP IF EXISTS syntax
Please Sign up or sign in to vote.
18 Nov 2015MarcusCole6833
I recently posted an article on how to place the data in an XML into an SQL table with a bulk Insert; this is an alternative way to do it by breaking up the XML before placing it into the Table.
Please Sign up or sign in to vote.
22 Nov 2015Leya Samuel
This article mainly explains about how you can write custom webhook using persistent storage, how they can be created and also a sample source code on custom webhook. The purpose of this article is just to give an idea on writing your own custom web hook.

Current Participants

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

Product Manager Avanza Solutions
Pakistan Pakistan
Asif embarked on his programming journey back in 1991 when he first encountered 80286 8-16 MHz systems. His programming repertoire began with dBase III+, FoxPro, C, and assembly language, where he honed exceptional skills that have been a cornerstone of his development career.

Over the years, Asif's programming saga has seen him delve into a wide array of technologies and languages, ranging from C++, VC++, Java, Delphi, RPG400, SQL Server, and Oracle, to name just a few. His insatiable curiosity continues to lead him towards newer horizons, such as DOT Net Technologies, SOA architectures, BI, DSL, and beyond. These learning experiences are underscored by a robust theoretical foundation, with a penchant for research.

Beyond the realm of technology, Asif's interests include delving into the pages of fiction, exploring biotechnology, and gazing at the wonders of Astronomy. He finds joy in watching movies, and during his free time, he delights in quality moments spent with his children.
Software Developer
United States United States
Passionate for Coding,kind of geek ,creative way of thinking, R&D freak,New Web technologies's admirer,Cappuccino lover that's what simply define me.

Great lines by Steve Jobs that I follow
"Stay Hungry Stay Foolish"
United States United States
This member doesn't quite have enough reputation to be able to display their biography and homepage.
Chief Technology Officer Shift iQ
Canada Canada
I have been building software systems for more than 20 years, working for organizations that range from small non-profit associations in my local community to global Fortune 500 enterprises.

I specialize in the design and implementation of online database solutions. My work-related research interests include software design patterns and information architecture.
CEO baberich.de
Germany Germany
<insert stereotypes="" here="">

Just me, just saying.
Message me if you like.
Software Developer
United Kingdom United Kingdom
Duane has worked in a commercial software development environment for 9 years, with all but three for a global fashion retailer.

He is proficient in ASP.Net, MVC, C#, HTML, CSS, JavaScript, SQL Server TSQL.
Software Developer
United States United States
I can type "while" and "for" very quickly
Software Developer (Senior)
Argentina Argentina
This member doesn't quite have enough reputation to be able to display their biography and homepage.
Software Developer
Australia Australia
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
Fred is a senior software developer who lives in Melbourne, Australia. In 1993, he started Programming using Visual C++, Visual Basic, Java, and Oracle Developer Tools. From 2003, He started with .Net using C#, and then expertise .Net development.

Fred is often working with software projects in different business domains based on different Microsoft Technologies like SQL-Server, C#, VC++, ASP.NET, ASP.Net MVC, WCF,WPF, Silverlight, .Net Core and Angular, although he also did some development works on IBM AS400.
Software Developer (Senior) QAS
Vietnam Vietnam
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Program Manager Microsoft
Serbia Serbia
Graduated from Faculty of Electrical Engineering, Department of Computer Techniques and Informatics, University of Belgrade, Serbia.
Currently working in Microsoft as Program Manager on SQL Server product.
Member of JQuery community - created few popular plugins (four popular JQuery DataTables add-ins and loadJSON template engine).
Interests: Web and databases, Software engineering process(estimation and standardization), mobile and business intelligence platforms.
Web Developer
United States United States
None.
Technical Lead
India India
Hi there, I am Prasad. Author, Blogger, contributor and passionate about Microsoft .NET technologies. I like to write an articles/blogs on different .NET aspects and like to help Developers, to resolve their issues and boost them on Microsoft Technologies.


Certifications: Microsoft Certified professional (MCP), Microsoft Certified technology specialist (MCTS), Agile-Scrum Master.


Awards: Microsoft Re-connect MVP (GSC Member), Most valuable member at dotnetspider, Most popular curator, Most active curator, featured curator at Microsoft Curah, Editor at dotnetspider.


Microsoft MVP 2014 [ASP.NET/IIS]
Click here for more .NET Tips
-After all Knowledge is an endless entity
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.
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
Software Developer (Junior) ABB
United States United States
On career 2.0 mainly work in the dot net environment predominantly SQL and SSMS.
Architect
Malaysia Malaysia
I’m a UiTM graduated with major in multimedia (B.Sc (hons) IT) in 1999. Prior to that, I received my Diploma in Computer Sciences (major in software engineering) from the same university in 1994. Currently, I’m pursuing Master degree in Software Security and waiting for my viva session.

In terms of experience, I’ve more than 14 years of challenging experience. I started as lecturer in IT and software engineering at Stamford College. 6 months later, to improve my skill and knowledge, I joined PKDP as MIS executives responsible on support and maintenance of logistics application running on Informix 4GL. Since then, I've joined few others company such as IB Technologies Sdn Bhd, Mesiniaga Berhad, MIMOS Berhad and Matrix Power Network Sdn Bhd.

I gain lots of experience developing various types of applications using various tools and programming language. Beside application development, I had the opportunity to become project manager and also lead a team for a few months due to departure of my department head to another cluster. In addition, I’ve serve as member of IP mining and panel in IP Disclosure part of the task is to improve an IP or evaluate the feasibility of an IP. On top of that, I’ve been presented in few security and software development conferences and published papers locally and international.
Software Developer (Senior) Birla Soft
India India
Najmul Hoda is a Master of Computer Application.
He has worked with .Net technologies in web development and has been programming since 2007.
He is very comfortable in various languages,RDBMS,C# to VB.NET with Access & MS SQLServer from Javascript,AJAX to ASP.NET, MVC.


Khata Wata (Free Online Udhar Khata, Bahi Khata)
Download from play store

Software Developer (Senior)
Pakistan Pakistan
MCP, MCSD, MCTS
I am a Software Developer with almost 4 years of professional experience in web applications.
I have hands-on experience in full Software Development Life Cycle where best practices, design patterns and n-tier architecture are used in development. I love to work in C#, ASP.NET, ASP.NET MVC, MEAN Stack, Mongodb, Expressjs, Nodejs, Angularjs, Javascript, Jquery, WCF, and Web API.
I love to play (Physically + E-Games) and watch football in free time, I can die for Barcelona Football Club.
linkedin: https://ae.linkedin.com/in/nomiali
Software Developer (Senior) Microsoft
United States United States
I started to program computers when I was 11 years old, as a hobbyist, programming in AMOS Basic and Blitz Basic for Amiga.
At 12 I had my first try with assembler, but it was too difficult at the time. Then, in the same year, I learned C and, after learning C, I was finally able to learn assembler (for Motorola 680x0).
Not sure, but probably between 12 and 13, I started to learn C++. I always programmed "in an object oriented way", but using function pointers instead of virtual methods.

At 15 I started to learn Pascal at school and to use Delphi. At 16 I started my first internship (using Delphi). At 18 I started to work professionally using C++ and since then I've developed my programming skills as a professional developer in C++ and C#, generally creating libraries that help other developers do their work easier, faster and with less errors.

Want more info or simply want to contact me?
Take a look at: http://paulozemek.azurewebsites.net/
Or e-mail me at: paulozemek@outlook.com

Codeproject MVP 2012, 2015 & 2016
Microsoft MVP 2013-2014 (in October 2014 I started working at Microsoft, so I can't be a Microsoft MVP anymore).
Software Developer Elzyntax B.V.
Netherlands Netherlands
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Technical Lead 3 Pillar Global
India India
Working as Technical Lead.
Having experience in C#,ASP.net MVC, ASP.NET, TDD, Entity Framework,Design Patterns, SQL Server,AngularJs.
Software Developer
Bangladesh Bangladesh
Rakibul Islam is a software Engineer and developer with extensive experience and managing skill. He has completed his B.Sc. in Computer Science and Engineering from Mawlana Bhashani Science and Technology University(2012) .Rakibul prefers coding in C# ,ASP.NET MVC, Entity Framework, AngularJs ,Web API ,Bootstrap ,PHP, Oracle ,MS SQL Server, MySql ,PhpMyAdmin and many more.
Systems Engineer Infosys Ltd.
India India
Sports Addict who codes for Brain exercise. Smile | :)
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
CEO JUUN Software
Netherlands 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!
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
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
Pakistan Pakistan
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

33 members
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
Jordan Jordan
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
New Zealand New Zealand
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Engineer VeeTools
Netherlands Netherlands
A (usually exploring) geologist who sometimes develops software for fun and colleagues... Check out my new website at www.veetools.xyz for online mapping and coordinate conversion.
Software Developer (Senior)
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.
Web Developer
Ukraine Ukraine
Web Developer, interested in bleeding age web technologies and projects.

Experienced and interested in:
- High load web projects, bespoke software development
- DevOps: Chef, Ansible, Vagrant
- NoSQL (mongodb)
- Client stack (javascript core, jquery, AngularJS, HTML5 apis)
- *AAS (Amazon beanstalk, Redhat openshift)
- MEAN & Pure JS stack (Javascript, AngularJS, Node.JS, MongoDB)


-> DevOps inquiries
-> Other inquiries
-> Follow me on Github

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 Nov - 30 Nov 2015