Click here to Skip to main content
14,297,458 members

Best Database Article of November 2015

This competition has ended

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.

9 Nov 2015
Sander Rossel
Using Venn diagrams to visualize sets.
12 Nov 2015
Fred 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.
24 Nov 2015
koolprasadd
This article explain you How to protect word document using C# and Word automation
4 Nov 2015
Fred 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.
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.
8 Nov 2015
koolprasadd
This article help you to create word table using OpenXML without interop object
2 Nov 2015
Sibeesh Passion
How to load data from database using Web API
20 Nov 2015
stebo0728
MDI Case Study Purchasing - Part V - ObjectDataSource
2 Nov 2015
Guni Van
Mapping your database with C# object class, then make typed-safe query like SQL syntax
9 Nov 2015
veen_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.
15 Nov 2015
sandeepmittal11
COALESCE in SQL Server
17 Nov 2015
Sibeesh Passion
How to load an XML file and show as li using ng-repeat in Angular JS
5 Nov 2015
Vyacheslav 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
13 Nov 2015
Najmul Hoda
Here is the code snippet to check how many database connections are opened in SQL Server.
19 Nov 2015
Manjuke Fernando
How to capture and analyze deadlocks in SQL Server
12 Nov 2015
Veselin Tenev
Provides simplistic solution to a recursive MySQL table
27 Jan 2016
MarcusCole6833
Make some SQL XML dot style another way
8 Dec 2015
Jovan Popovic(MSFT)
Overview of built-in support for JSON text processing in new SQL Server
7 Nov 2015
Syed Hasan Hyder
Provides plausible and high performing data display, for very large data ( over a million records ).
25 Nov 2015
Manjuke Fernando
Analyzing SQL Server Error Logs / Agent Logs using T-SQL
10 Dec 2015
Daniel Miller
This article describes the C# implementation for a high-performance role-based access control list.
20 Nov 2015
Lộc Nguyễn
With a DEMO WPF application (WinNotif)
15 Nov 2015
Rahul Pawar LogicMonk
Simple Demo Entity Framework - a tutorial explaining Code First!
23 Nov 2015
sandeepmittal11
A sequence is a user defined, schema bound object that generates a sequence of numeric values
7 Jan 2016
Rakhi Shrivastava
This tip explains the step by step approach how we can use Glimpse for easy debugging of the ASP.NET MVC application.
19 Nov 2015
Dennis Baberich
How to get a claimbased cookie authentication between custom frontend and self hosted SignalR server
16 Nov 2015
sandeepmittal11
Apply Operator in SQL Server
6 Dec 2015
Tamer J. Mehyar
A simple way to keep track of DB objects versions (DDL updates) in SQL Server
16 Nov 2015
User 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.
12 Feb 2016
Peter Elzinga
This is a generic solution for converting the output of any SQL server script to an Excel file (using SSIS).
23 Feb 2016
sandeepmittal11
Lead and Lag Functions in SQL Server
18 Aug 2016
syed shanu
In this article you will learn about MVC AngularJS Master/Detail CRUD, Filter and Sorting using WEB API 2 with Stored Procedure.
9 Nov 2015
nomi 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.
29 Nov 2015
Amit 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
22 Nov 2015
Daniel Miller
This code snippet shows how to count all the tables and rows in a SQL Server database
29 Nov 2015
Reeshabh Choudhary
Web platform based query builder to play with your database :)
27 Nov 2015
dibley1973
How to call a basic stored procedure using StoredProcedureFramework
13 Nov 2015
Paulo 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
14 Nov 2015
junnark
This is a tutorial on how to use WinFormsGen's generated code.
17 Nov 2015
DLChambers
Validate MigrationHistory to preempt arcane exceptions when EF accesses DB
20 Mar 2016
Evgeny Pereguda
Simple variadic template for implementation of IUnknown and IDispatch interfaces
3 Nov 2015
Rakibul Islam 33
In this tip, we will try to understand SOLID Architecture principles using simple ASP.NET MVC 5 examples.
3 Nov 2015
Jovan Popovic(MSFT)
SQL Server 2016 introduces the new DROP IF EXISTS syntax
18 Nov 2015
MarcusCole6833
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.
22 Nov 2015
Leya 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.
5 Nov 2015
Steve Naidamast
How to use Black Falcon software's SQL Server source control for developers
17 Nov 2015
sandeepmittal11
Row_Number in SQL Server

Current Participants

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

_Asif_
Architect Avanza Solutions
Pakistan Pakistan
Asif has started programming back in 1991 on 80286 8-16 MHZ systems. Started from dBase III+, FoxPro, C, assembly (exceptional skills in Assembly language have added a significant confidence in his development career). The programming saga continues exploring new technologies and languages ranging from C++, VC++, Java, Delphi, RPG400, SQL Server, Oracle to name a few and the exploration still continues to DOT Net Technologies, SOA architectures, BI, DSL, etc. These learning experiences are backed by strong theoretical background with a flavor of research.

Asif show significant interest in reading fiction, bio technology, Astronomy. He Loves watching movies and in free time love to play with his kids.
Amit Singh Baghel
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"
Daniel Miller
Software Developer
Canada Canada
I have been doing software system development and operations for many more years than I care to count, working as an independent consultant for organizations that range from small non-profit associations in my local community to global Fortune 500 enterprises.

Most of my work is focused on the design, implementation, and operation of web-based business software. My research interests include application architecture, data modeling, and custom solutions for large-scale data management, conversion, and integration.
Dennis Baberich
CEO baberich.de
Germany Germany
<insert stereotypes="" here="">

Just me, just saying.
Message me if you like.
dibley1973
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.
DLChambers
Software Developer
United States United States
I can type "while" and "for" very quickly
Evgeny Pereguda
Software Developer
Australia Australia
No Biography provided
Fred Song (Melbourne)
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.
Guni Van
Software Developer (Senior) QAS
Vietnam Vietnam
No Biography provided
Jovan Popovic(MSFT)
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.
junnark
Web Developer
United States United States
None.
koolprasadd
Software Developer (Senior)
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
Leya Samuel
Team Leader
India India
No Biography provided
Lộc Nguyễn
Software Developer
United States United States
while (live) {
try {
learn();
code();
food();
...
} catch (Exception ex) {
recover();
}
}
Manjuke Fernando
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
MarcusCole6833
Software Developer (Junior) ABB
United States United States
On career 2.0 mainly work in the dot net environment predominantly SQL and SSMS.
Najmul Hoda
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 & platforms from C# to VB.NET with Access & MS SQLServer from Javascript,AJAX to ASP.NET, MVC.

Besides programming he loves playing mouth organ, guitar, listening to music,singing, bike riding & cricket.


Free website chat software
www.magixchat.com

nomi ali
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
Paulo Zemek
Software Developer (Senior) Niantic
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).
Peter Elzinga
Software Developer Elzyntax B.V.
Netherlands Netherlands
No Biography provided
Rahul Pawar LogicMonk
Software Developer
Australia Australia
I am .Net developer.
Earn my bread primarily by working with WPF and WCF Services.

Love working with new technologies!

My latest interest is in AngularJS and how to incorporate it with WEB API2Smile | :)
Rakhi Shrivastava
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.
Rakibul Islam 33
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.
Reeshabh Choudhary
Systems Engineer Infosys Ltd.
India India
Sports Addict who codes for Brain exercise. Smile | :)
No Biography provided
Sander Rossel
Software Developer (Senior)
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, and other technologies.
He has an interest in various technologies including, but not limited to, Cloud, NoSQL, Continuous Integration and Deployment, Functional Programming, and software quality in general.
In his spare time he writes articles for MSDN, CodeProject, and his own blog, as well as books about Object Oriented Programming, Databases, and Azure.

You can't miss his must read book Continuous Integration, Delivery, and Deployment!

Also make sure to check his FREE +/- 100 page eBooks Object-Oriented Programming in C# Succinctly and SQL Server for C# Developers Succinctly.

He wrote a JavaScript LINQ library, arrgh.js (works in IE8+, Edge, Firefox, Chrome, and probably everything else).

Check out his prize-winning articles here on CodeProject and his blogs over at sanderrossel.com as well!
Sibeesh Passion
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
stebo0728
United States United States
No Biography provided
Steve Naidamast
Software Developer (Senior) Black Falcon Software, Inc.
United States United States
No Biography provided
Syed Hasan Hyder
Software Developer
Pakistan Pakistan
No Biography provided
Group type: Organisation

33 members

syed shanu
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
No Biography provided
User 10668410
New Zealand New Zealand
No Biography provided
veen_rp
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.
Veselin Tenev
Software Developer (Senior)
United Kingdom United Kingdom
No Biography provided
Vyacheslav Voronenko
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