Click here to Skip to main content
15,881,882 members
This competition has ended

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

Please Sign up or sign in to vote.
2 Sep 2015Peter Leow
Get your database to generate unique running IDs for your application
Please Sign up or sign in to vote.
26 Sep 2015AshishShukla6
This tip describes step by step implementation of executing stored procedure having user-defined table type as a parameter in entity framework using EntityFrameworkExtras package.
Please Sign up or sign in to vote.
21 Sep 2015Sarathi Balakrishnan
Reset SQL server SA (System Admin) Password when you have lost all possible ways to connect to SQL server and your server has only Windows authentication disabled. You should have Windows administrator permission to do this.
Please Sign up or sign in to vote.
5 Sep 2015Maxim Kurayan
EF Dynamic Report is a small open source project which allows you to use Entity Framework mapping between types and tables as a dynamic report data source
Please Sign up or sign in to vote.
18 Sep 2015Wendelius
This tip shows how to calculate a difference between two datetime values and to express the difference in years, days, hours, minutes and so on.
Please Sign up or sign in to vote.
24 Sep 2015Dr. Song Li
This is an example to check the SQL server disk and data file usage statistics.
Please Sign up or sign in to vote.
6 Sep 2015Math08avan
Import text file data to SQL database using foreign key relation and validation.
Please Sign up or sign in to vote.
29 Sep 2015DotNetSteve
Variety is the spice of life - rewarding PDF AcroForm reader
Please Sign up or sign in to vote.
7 Sep 2015Sander Rossel
The seventh in a series on MEAN web development.
Please Sign up or sign in to vote.
5 Sep 2015Sadique KT
How to Install Oracle 12c, How to create listener, How to create TablesSpaces and How to restore database
Please Sign up or sign in to vote.
18 Sep 2015Kurt Friedrich
I wanted to use MySQL as the database to hold code first models with ASP MVC.
Please Sign up or sign in to vote.
28 Sep 2015Member 11313437
How to easily anonymize (or pseudonymize, depending on the depth of performing) patients' proper data in clear text in MySQL
Please Sign up or sign in to vote.
19 Sep 2015m_kramar
How to split Oracle CLOB into lines - fast way
Please Sign up or sign in to vote.
5 Sep 2015Member 2007625
It took few days for me to find this solution and I think it worth sharing it.
Please Sign up or sign in to vote.
1 Sep 2015m_kramar
What if you have a collection of objects and want to find matches in database and you want to do it using just one query? The following example demonstrates how it can be done using LINQ.
Please Sign up or sign in to vote.
9 Sep 2015FrankNight
In this tip, I show a set of helper classes useful to prepare and send messages to the SqlXML Joomla component and execute remote SQL calls to your hosted website.
Please Sign up or sign in to vote.
24 Apr 2016Maxim Komlev
Example of WebBrowser customization and http/https server on localhost as engine for cross-platform application based on web technologies.
Please Sign up or sign in to vote.
1 Mar 2016sachin verma, Akhil Mittal
This article of the series will explain how we can handle requests and log them for tracking and for the sake of debugging, how we can handle exceptions and log them. We’ll follow a centralized way of handling exceptions in WebAPI and write our custom classes to be mapped to the type of exception th
Please Sign up or sign in to vote.
14 Sep 2015nam1234567
Build your own database class library with C#
Please Sign up or sign in to vote.
4 Oct 2015syed shanu
In this article, we will learn about DataGridView Gantt Style Chart Using C# WinForm.
Please Sign up or sign in to vote.
11 Sep 2015Ksh_Sr 1 alternative  
This tip shows how to separate a string with delimited characters.
Please Sign up or sign in to vote.
4 Oct 2015syed shanu
This article shows how to create a Are You Genius game using MVC, AngularJS and Web API 2.
Please Sign up or sign in to vote.
11 Sep 2015PIEBALDconsult
This is an alternative for "Split Any Delimited String in SQL"
Please Sign up or sign in to vote.
6 Dec 2015Den367
Short glance at drawing on geographical tiles by using of Microsoft.SqlServer.Types assembly.
Please Sign up or sign in to vote.
14 Sep 2015Vijaykumar Vadnal
We will discuss about how we can combine Dapper.NET and DapperExtensions to configure DAL to execute normal queries as well as Stored Procedures.
Please Sign up or sign in to vote.
19 Sep 2015VijayRana
Signal R Message Logging Application
Please Sign up or sign in to vote.
3 Jul 2017Christian Del Bianco
SqlTableDependency is a component used to receive database notifications containing the record values inserted, deleted or update on a database table.
Please Sign up or sign in to vote.
6 Sep 2015jseijas2
In this tip, we will see how you make quick REST API from database defining the API in a configuration file.
Please Sign up or sign in to vote.
13 Sep 2015Member 10986954
Troubleshooting High-CPU Utilization for SQL Server
Please Sign up or sign in to vote.
19 Sep 2015Ying LEE
This article introduces a general and robust way to persist/serialize any Winforms component to C# code.
Please Sign up or sign in to vote.
5 Sep 2015Pragmateek
Introduction If you've already developed COM APIs with .Net, typically in C# with VBA as the consuming language, you've probably leveraged two powerful features: by-reference parameter passing that allows the API to change the input object itself, not only its ... Continue reading ...
Please Sign up or sign in to vote.
8 Sep 2015Passion4Code
How to send email using stored procedure in SQL Server
Please Sign up or sign in to vote.
1 Sep 2015idreeskhan
String interpolation or String handling in C# 6.0 with new feature
Please Sign up or sign in to vote.
23 Sep 2015dibley1973
Call stored procedures in a type safe way using my StoredProcedureFramework for .NET
Please Sign up or sign in to vote.
9 Sep 2015syed shanu
MVC using ReactJS and WCF Rest
Please Sign up or sign in to vote.
28 Sep 2015Antonio Soares
This tip shows three alternatives (an intuitive and less efficient, a more efficient one and a third more efficient one) to count all rows of all tables in a database.
Please Sign up or sign in to vote.
17 Sep 2015IssamK
How to automatically generate classes for your database tables
Please Sign up or sign in to vote.
7 Sep 2015Atul Kharecha
If you are using Lotus Notes as an email client and it is running very slowly, this tip will help you to overcome the performance issues.
Please Sign up or sign in to vote.
22 Sep 2015hlonihloksDJ
Building DynamicTVP
Please Sign up or sign in to vote.
8 Sep 2015Muhamm Irfan
This tip will describe each step involved in the implementation of Reg-Free approach of .NET Component.

Current Participants

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

Software Developer (Senior)
Portugal Portugal
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Architect
India India
I love exploring latest technologies especially but not limited to Microsoft technologies including ASP.NET MVC, WCF, Workflow Foundation, Entity Framework, Web API, Signal R, C# and hook around them.

I am trainer/consultant for latest technologies including ASP.NET MVC, WebAPI, WCF, Entity Framework, SQL SERVER, JQuery, Creating responsive web design using Bootstrap, Search Engine optimization etc.

My e-learning portal Modern Pathshala provides tutorials on different technologies, video tutorials, Books, Quizzes for self-assessment and articles on different technologies.
Architect
India India
My Linkedin Profile

https://in.linkedin.com/in/atulkharecha
Software Developer
Italy Italy
Email: christian.delbianco@gmail.com
Skype: christian.delbianco
Software Developer
Russian Federation Russian Federation
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
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 (Senior)
United States United States
Steven Contos

Working in varied settings from small entrepreneurial companies to Fortune 500 companies. Skilled in analyzing client needs and developing solutions that are sound and effective.

Strong analytic capabilities with proven accomplishments in developing programs that exceed or meet stated goals, consistently work well, are easily maintained and fully documented. Versed in a number of SDLC technologies including Agile and Scrum, dedicated to deliver high quality software on time and on budget.

Experienced in helping companies and teams change their culture. Providing clear vision, asking tough questions of both developers and business, leading by example and building trust among all concerned.
United States United States
I have been working in the IT industry for some time. It is still exciting and I am still learning. I am a happy and honest person, and I want to be your friend.
CEO Gekoproject.com
Italy Italy
I'm a senior software developer.
I wrote my first program in basic with commodore 64, that is... a long time ago Wink | ;-)
From that moment, I've learned many programming language and developed many projects.

I've started working as IT consultant in a software factory company that had produced software mostly for banking and financial business.
In this environment I could work on many different hardware platforms, using many different technologies and programming languages.Then, in the era of distributed application, I learnt to make all these different techologies working together.

My interest has always been in software development specially oriented to internet application, but during all this time I've acquired also other skill in system and network administration.
South Africa South Africa
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
I'm from Pakistan and have two years of experience in C# and Asp.net in visual stdio 2005 ,2008, 2010 and SQL Server 2000/2005/2008
Systems Engineer Card Systems
Lebanon Lebanon
Issam is member of the board at NGC and acts as Technology and Innovation Advisor.

Alongside, he founded several startups, including Card Systems (2008) and Izzy Homes (2013). He is also actively involved in mentoring and assisting other young entrepreneurs startup, their business infrastructure and technology platforms.

Previously, Issam worked as an executive engineer at OpenWay Group in Belgium and across Europe. He holds a BS in Business Administration with MIS specialty from the American University of Beirut
Architect
Spain Spain
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
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Instructor / Trainer Bellevue College
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.
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) iPower Lanka
Sri Lanka Sri Lanka
I am Mathavan. I have been programming since 2008. My programming experience includes C/C++, C#, ASP.NET.
Software Developer Netgear 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.
Russian Federation Russian Federation
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Technical Lead
India India
Hi,

This is Balajee Ganji. I am working as Database Administrator in 3i-infotech
Germany Germany
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Vietnam Vietnam
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer Sequel System
Pakistan Pakistan
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer Catapult Sports
Australia Australia
Software developer in Melbourne, Australia.
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 (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.
Instructor / Trainer
Singapore Singapore
“Live as if you were to die tomorrow. Learn as if you were to live forever.”
― Mahatma Gandhi

子曰:"三人行,必有我师焉;择其善者而从之,其不善者而改之."
Software Developer (Senior)
United States United States
BSCS 1992 Wentworth Institute of Technology

Originally from the Boston (MA) area. Lived in SoCal for a while. Now in the Phoenix (AZ) area.

OpenVMS enthusiast, ISO 8601 evangelist, photographer, opinionated SOB, acknowledged pedant and contrarian

---------------

"I would be looking for better tekkies, too. Yours are broken." -- Paul Pedant

"Using fewer technologies is better than using more." -- Rico Mariani

"Good code is its own best documentation. As you’re about to add a comment, ask yourself, ‘How can I improve the code so that this comment isn’t needed?’" -- Steve McConnell

"Every time you write a comment, you should grimace and feel the failure of your ability of expression." -- Unknown

"If you need help knowing what to think, let me know and I'll tell you." -- Jeffrey Snover [MSFT]

"Typing is no substitute for thinking." -- R.W. Hamming

"I find it appalling that you can become a programmer with less training than it takes to become a plumber." -- Bjarne Stroustrup

ZagNut’s Law: Arrogance is inversely proportional to ability.

"Well blow me sideways with a plastic marionette. I've just learned something new - and if I could award you a 100 for that post I would. Way to go you keyboard lovegod you." -- Pete O'Hanlon

"linq'ish" sounds like "inept" in German -- Andreas Gieriet

"Things would be different if I ran the zoo." -- Dr. Seuss

"Wrong is evil, and it must be defeated." –- Jeff Ello

"A good designer must rely on experience, on precise, logical thinking, and on pedantic exactness." -- Nigel Shaw

“It’s always easier to do it the hard way.” -- Blackhart

“If Unix wasn’t so bad that you can’t give it away, Bill Gates would never have succeeded in selling Windows.” -- Blackhart

"Use vertical and horizontal whitespace generously. Generally, all binary operators except '.' and '->' should be separated from their operands by blanks."

"Omit needless local variables." -- Strunk... had he taught programming
Instructor / Trainer Pragmateek
France (Metropolitan) France (Metropolitan)
To make it short I'm an IT trainer specialized in the .Net ecosystem (framework, C#, WPF, Excel addins...).
(I'm available in France and bordering countries, and I only teach in french.)

I like to learn new things, particularly to understand what happens under the hood, and I do my best to share my humble knowledge with others by direct teaching, by posting articles on my blog (pragmateek.com), or by answering questions on forums.
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
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!
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
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.
Technical Lead
India India
Hi Myself Vijay having around 7 years of experience on Microsoft Technologies.
Architect
Europe Europe
Biography provided
Architect SmartData: Excel for Enterprise Data
Hong Kong Hong Kong
I have more than 10 years experience in software developing. And my primary language is C# (5 years). I also used Delphi, PowerBuilder, Matlab and R before.
Generally I focus on information management. I am working on a personal project, SmartData: Excel for Enterprise Data (http://smartdatahk.blogspot.hk/) recently for I am looking for venture capital and a new job, whichever is good for me.

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