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

Best Database Article of July 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.
8 Jul 2015Rodrick Kazembe
This is a step by step SQL Server Stored Procedures tutorial for beginners with insert, update, delete and select examples.
Please Sign up or sign in to vote.
30 Nov 2015Sarkis Matossian
Encoding a .NET assembly as a hex string to install in SQL Server.
Please Sign up or sign in to vote.
29 Jul 2015LalithGallage
This powershell script is you to monitor windows servers’ free hard disk and populate it to sharepoint custom list.
Please Sign up or sign in to vote.
1 Jul 2015Nuredin Abdella
In this tip, I will discuss how to create, alter, enable, disable and remove MySQL event in order to automate database manipulation tasks.
Please Sign up or sign in to vote.
11 Jul 2015ergohack
This SQLite Data Object Window base class automates the data updates and the data bindings between the XAML presentation and the SQLite database allowing the minimum of code needed to present and edit SQLite database records.
Please Sign up or sign in to vote.
6 Jul 2015Mike Trank
Simple Daily SQL Server Database Backup Batch File
Please Sign up or sign in to vote.
28 Jul 2015Bjørn
A Service listening to Windows EventLog, recognizing attacker IPs and block them in the Windows Firewall.
Please Sign up or sign in to vote.
5 Jul 2015Passion4Code
How to do full text search in SQL
Please Sign up or sign in to vote.
15 Jul 2015Sarkis Matossian
The steps to install a CLR Stored Procedure in SQL Server
Please Sign up or sign in to vote.
27 Jul 2015Daniel Miller
This tip describes the code to create a custom SQL Server aggregate function that concatenates multiple string values into a single delimited value.
Please Sign up or sign in to vote.
27 Jul 2015syed shanu
How to create simple web app using MVC 5, Angular JS, WEB API with stored procedure
Please Sign up or sign in to vote.
26 Jul 2015Sumit Tech Brain
Fluent Migrator makes the database migration very easy. It is a database migration framework for .NET and uses fluent interface to manipulate database.
Please Sign up or sign in to vote.
10 Jul 2015Anele 'Mashy' Mbanga
Porting VB functions over to JavaScript and other useful functions
Please Sign up or sign in to vote.
15 Jul 2015Member 10295860
Using stored procedure type for binding data to dataset in SSRS or adding entity to Entity data model
Please Sign up or sign in to vote.
7 Dec 2016Kuv Patel
A quick and simple way of generating POCO classes and EF mappings for database tables.
Please Sign up or sign in to vote.
17 Jul 2015essentialSQL
How to use conditional logic in SQL with CASE expression
Please Sign up or sign in to vote.
5 Jul 2015Ronnie Mukherjee
From SQL to Linq
Please Sign up or sign in to vote.
9 Jan 2016Snorri Kristjansson
Active Directory change auditing solution. A Windows Service that stores selected AD change events from the Security log of all Domain Controllers to an SQL database.
Please Sign up or sign in to vote.
21 Jul 2015Masoud AI
Things you need to know before you start working with MySQL
Please Sign up or sign in to vote.
14 Jul 2015Michael Selector
A code to declare a table variable which will be populated from a query
Please Sign up or sign in to vote.
1 Jul 2015Frank J. Yang
This article provides code for decoding strings that have been encoded for URL transmission in pure T-SQL that works properly for all URL encoded strings.
Please Sign up or sign in to vote.
16 Jul 2015Math08avan
A simple example for CRUD actions using WCF service in ASP.NET
Please Sign up or sign in to vote.
23 Jul 2015Mian Adnan
Using Microsoft Visual Studio Professional 2012, .NET 4.5 and Crystal Report Version regarding .NET 4.5 and VS 2012
Please Sign up or sign in to vote.
28 Jul 2015yuvalsol
A stored procedure that searches for a text in the SQL Server database (DDL)
Please Sign up or sign in to vote.
2 Nov 2019Alaa Ben Fatma
Explore your MMSQL server tables in a professional way
Please Sign up or sign in to vote.
22 Jul 2015Chetan Naithani
Transforming dynamic row-level data into columns
Please Sign up or sign in to vote.
28 Jul 2015Igor Krupitsky
This article shows how to get ADO.NET DataTable out of Excel

Current Participants

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

Student
France France
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer SITHASO HOLDINGS (PTY) LTD
South Africa South Africa
I'm a Bachelor of Commerce graduate, fell inlove with ICT years back with VB5. Used Pick & System Builder to create a windows app. Very curious, developed my first web database app called Project.Show using ExtJS. Published on Google Play Store, learned JQuery Mobile, a project manager at best. My first intranet app eFas with MySQL.

Fear closes people to a lot of things and we hold ourselves back being held by it. Thus the sooner you believe you can't do something, the sooner everything will work towards that belief. Believe in yourself at all times because you can do anything you set your mind to it!

I have a very beautiful woman and four kids, the best joys in the world. East London, South Africa is currently home.

Awards:

Best Mobile Article of February 2015 (First Prize)
http://www.codeproject.com/Articles/880508/Create-a-CRUD-web-app-using-JQuery-Mobile-and-Loca

Best Mobile Article of May 2015 (Second Prize)
http://www.codeproject.com/Articles/991974/Creating-JQuery-Mobile-CRUD-Apps-using-JQM-Show-Ge

Apps
Bible.Show (Android Store App)
https://www.facebook.com/bibleshow
https://play.google.com/store/apps/details?id=com.b4a.BibleShow

JQM.Show (Android Store App)
https://www.facebook.com/jqmshow
https://play.google.com/store/apps/details?id=com.b4a.JQMShow

CodeProject.Show (An offline CodeProject Article writer)
http://www.codeproject.com/Articles/993453/CodeProject-Show-A-CodeProject-offline-article-wri
Software Developer
Germany Germany
I'm working mainly on .NET Compact Framework C# on mobile devices at work. At home it's .NET Full Framework C# and a bit JavaScript.
Software Developer (Senior)
India India
Gained more than 10 years of experience as a software professional while working in different technologies like C#,JQuery,ASP.Net, ASP.Net MVC, SQL Server, Cloud computing, SSRS and Crystal Reports.

Straight talking, focused and still a student. I love perfection and believe in gradual improvement.
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.
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.
Easy Computer Academy, LLC
United States United States
Hello my name is Kris. I’m here because I am passionate about helping non-techie people to overcome their fear of learning SQL.

I know what it is like to not know where to start or whether the time spent learning is worth the effort. That is why I am here to help you to:
- Get started in an easy to follow step-by-step manner.
- Use your time wisely so you focus on what is important to learn to get the most value from your time.
- Answer your questions. Really! Just post a comment and I’ll respond. I’m here to help.

It wasn’t long ago that I was helping a colleague with some reporting. She didn’t know where to start and soon got overwhelmed and lost as she didn’t know SQL.

I felt really bad, as she was under pressure to get some summary information to her boss, the built-in reports were falling short, and to make them better would require her to know SQL. At that time that seemed impossible! It in dawned on me, it doesn’t have to be that way.

Then I discovered a way for anyone with the desire to easily learn SQL. I worked with my co-worker, started to teach her what I learned and soon she was able to write reports and answer her boss’ questions without getting stressed or ploughing hours into manipulating data in Excel.

It hasn’t always been easy. Sometimes the information seems abstract or too conceptual. In this case I’ve found out that a visual explanation is best. I really like to use diagrams or videos to explain hard-to-grasp ideas.

Having video, pictures, and text really help to reinforce the point and enable learning.

And now I want to help you get the same results.

The first step is simple, click here http://www.essentialsql.com/get-started-with-sql-server/
Software Developer (Senior)
Canada Canada
Frank Yang is a senior developer with a working experience in .NET, C# and T-SQL.
Web Developer
United States United States
Igor is a business intelligence consultant working in Tampa, Florida. He has a BS in Finance from University of South Carolina and Masters in Information Management System from University of South Florida. He also has following professional certifications: MCSD, MCDBA, MCAD.
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 (Senior)
Sri Lanka Sri Lanka
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer
Malaysia Malaysia
A part time postgraduate student and full time employee that loves learning, teaching, problem solving, challenges, sports, traveling, movies, animals, beaches...
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 (Senior) self employed
India India
This member doesn't quite have enough reputation to be able to display their biography and homepage.
Pakistan Pakistan
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
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.
UnlimiDev, Inc.
United States United States
This member doesn't quite have enough reputation to be able to display their biography and homepage.
This is a Organisation (No members)

Software Developer
Ethiopia Ethiopia
I am a Software Developer and Database Manager with experience on Microsoft and opensource technologies.
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
Tanzania (United Republic of) Tanzania (United Republic of)
Rodrick is a software developer with over 10 years work experience. In his spare time, he shares what he has learnt via tutorials, articles etc on his blog www.tutorials.kode-blog.com.

Rodrick is passionate about C#, Java, PHP, Android and Databases. He often writes on these topics and other general issues that affect programmers.
Software Developer
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.
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) Kvikna.com
Iceland Iceland
I started programming back in 1980, briefly in Basic, switched to Assembler (Z80 CPU) running CP/M OS. Started to program for MS-DOS in Assembler (8088 CPU) when the IBM PC made it's apperance. Switched to C when I started to write programs for Windows in 1991. In 2002 switched to C++ and MFC. In 2011 started developing in C# .NET for Sharepoint 2010. In 2016 started developing WPF applications.
Software Developer (Senior) 3Pillar Global Pvt. Ltd.
India India
I am Sumit Gupta working in 3Pillar Global Pvt. Ltd as Module Lead. I have 7+ year of experience in .Net technologies. I love to explore new technologies and write technical article.
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
Web Developer
Israel Israel
https://github.com/yuvalsol

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 Jul - 31 Jul 2015