Click here to Skip to main content
15,880,725 members
This competition has ended

Best Database Article of January 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.
11 Jan 2015SarmadAsghar
Building on My SQL Storage Engines and APIs to Conduct Complex Analysis Using SQL Query Language: Part 5
Please Sign up or sign in to vote.
11 Jan 2015Muhammad Hassan Tariq
Glimpse Extension for server side debugging and diagnostic information of ASP.NET applications
Please Sign up or sign in to vote.
28 Jan 2015Sujith Karivelil
In Master - Slave replication, Changes in master will reflect in Slave. but any changes made in the slave Database will not reflect back in Master, this article will help you to implement Bidirectional Replication.
Please Sign up or sign in to vote.
24 Jan 2015shijo joseph
A file backup manager with simple user interface and all the essential functionalities.
Please Sign up or sign in to vote.
29 Jan 2015Suffyan Asad
How to implement Joins in Hadoop Map-Reduce applications during Reduce and Map phases
Please Sign up or sign in to vote.
27 Jan 2015Vaclav Naydenov
Comparing the performance of two similar CRUD server apps, one written in Python and SQLAlchemy, the other in C++ and YB.ORM.
Please Sign up or sign in to vote.
17 Jan 2015Ivan Korhner
Postgresql: PostgreSQL Query Tuning - Indices
Please Sign up or sign in to vote.
19 Jan 2015Thinira
In this tip, we discuss how to pass report parameters from web page to Telerik report programmatically.
Please Sign up or sign in to vote.
10 Jan 2015Afzaal Ahmad Zeeshan
An overview for connecting an ASP.NET website or a web application to a remote SQL Server database
Please Sign up or sign in to vote.
15 Jan 2015Liju Sankar
Find progress of a database restore using sys.dm_exec_requests
Please Sign up or sign in to vote.
7 Jan 2015Masteramuk
JAVA - Connecting to SQL Server database using Windows Authentication or Active Directory
Please Sign up or sign in to vote.
3 Jan 2015Ahmad A.A. Ahmad
How to use chart item in your SSRS Report (% labeling)
Please Sign up or sign in to vote.
19 Jan 2015mrcellux
FluentJdbc is a functional, fluent API to execute most common SQL operations an application needs as a single statement.
Please Sign up or sign in to vote.
19 Jan 2015OriginalGriff
Sometimes, you want to extract the filename (with or without the extension) from the full path of a file. It's easy in C# and so forth - just use the Path.GetFileName method. But what if you want it in SQL?
Please Sign up or sign in to vote.
22 Mar 2018Angel Gabriel Valdés Sarduy
This project is an ASPNET Core MVC site with a generic controller for CRUD and searchs.
Please Sign up or sign in to vote.
27 Jan 2015Sujith Karivelil
This article will help you to create, update and delete events/ appointment in google calendar from your web application.
Please Sign up or sign in to vote.
21 Feb 2015Wendelius
How to log information into a table from inside a transaction, even if the transaction is rolled back.
Please Sign up or sign in to vote.
4 Jan 2015Suffyan Asad
Percolator Analysis Services is a LINQ to MDX ORM that enables writing MDX Queries in LINQ instead of using hard-coded strings of MDX code, resulting in cleaner, easier to read and easier to maintain code.
Please Sign up or sign in to vote.
14 Jan 2015CharlieBrown1433
Resource Governor Enhancements in SQL Server 2014
Please Sign up or sign in to vote.
18 Oct 2017Mauricio David 1 alternative  
Simple, fast and free embedded .NET NoSQL Document Store in single data file
Please Sign up or sign in to vote.
8 Jan 2015Liju Sankar
Find deadlocks in SQL Server using sp_who2 (an undocumented and thus unsupported stored procedure)
Please Sign up or sign in to vote.
27 Jan 2015syed shanu
Project Scheduling using GridView in ASP.NET
Please Sign up or sign in to vote.
7 Jan 2015A. Fry
MonogoDB server side projection using the C# driver
Please Sign up or sign in to vote.
26 Jan 2015TalentTuner
In this article, I’ll describe how to perform basic CRUD operations in an MVC5 application.
Please Sign up or sign in to vote.
1 Jan 2015Mohd Manzoor Ahmed
Linq Queries Examples Using Method And Query Syntax
Please Sign up or sign in to vote.
29 Jan 2015Mina Talaat Ghaly
Add the auditing properties with one SQL query and fill them from one place.
Please Sign up or sign in to vote.
12 Jan 2015Emiliarge
Queries in Microsoft Access (MDB) databases.
Please Sign up or sign in to vote.
3 Jan 2015Mohd Manzoor Ahmed
How to execute a stored procedure from Excel Sheet
Please Sign up or sign in to vote.
7 Jun 2017Gunaprasad Shetty
The tip will help you understand how the Word document can be converted into PDF and merge it as single PDF with digital signature for the secured transport of PDF.
Please Sign up or sign in to vote.
4 Jan 2015Emiliano Musso
How to access, display, modify SQL Server data (tables, etc.) through Windows Forms controls and LINQ instructions, using DataSets and TableAdapters
Please Sign up or sign in to vote.
22 Jan 2015Abu Zafor Khairuzzaman
Comparison Chart for Two Different Time Frames in SSRS
Please Sign up or sign in to vote.
19 Jan 2015JatinKhimani
Develop a web application in 3 layer architecture code style
Please Sign up or sign in to vote.
15 Jan 2015Sandeep Khairha
Query that returns list of all Stored Procedures
Please Sign up or sign in to vote.
3 Jan 2015Peter Piotti
A clean, simple alternative to using the Entity Framework for stored procedures data access in a .NET/SQL Server environment
Please Sign up or sign in to vote.
25 Jan 2015Colm Hoban
A command line utility to script out all jobs from an instance to be used to transfer jobs to another server/environment or to be deposited in source control.

Current Participants

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

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 The Jaxara It ltd.
Bangladesh Bangladesh
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
Afzaal Ahmad Zeeshan is a computer programmer from Rabwah, Pakistan, currently living in The Netherlands, likes .NET Core and Node.js for regular everyday development. Afzaal Ahmad works at Adyen as a Developer Advocate.

He is an expert with Cloud, Mobile, and API development. Afzaal has experience with the Azure platform and likes to build cross-platform libraries/software with .NET Core. Afzaal is an Alibaba Cloud MVP, twice he has been awarded Microsoft MVP status for his community leadership in software development, four times CodeProject MVP status for technical writing and mentoring, and 4 times C# Corner MVP status in the same field.
Database Developer
Canada Canada
My name is Ahmad Ahmad, I’m a SQL Server developer and a Microsoft Certified Professional, I have 5+ years hands-on experience in SQL Server Reporting Services, SQL Server Integration Services and SQL Database Development.

Until recently I built my own blog SQLDeft.com and published articles on SSIS, SSRS, T-SQL and DW, it's still growing, since I have had some free time I decided to dedicate my time for writing and sharing knowledge with others.

I would welcome any connect invitation on LinkedIn.
Engineer AEI Aguas Varadero
Cuba Cuba
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Canada Canada
Charlie is a Remote DBA experts – RemoteDBA.com, and is a veteran in database management systems. Due to an experience of over 8 years in the industry, his opinions, reviews and tips are highly valued.
Architect
United States United States
Originally started out as an Oracle developer, I moved on to become an Oracle DBA, then became certified on Oracle. Later on I had the opportunity to work on some T-SQL projects in parallel with PL/SQL. After working with SQL Server for some time, I now primary find myself dealing almost exclusively with SQL Server and the Microsoft toolkits/SDKs. I am gainfully employed in the financial services industry as a Senior Data/Database Architect specializing in performance tuning, T-SQL code optimization and evangelizing the use of CLR stored procedures, functions, triggers and UDTs, where appropriate.
Software Developer
Italy Italy
Working in IT since 2003 as Software Developer for Essetre Srl, a company in Northern Italy.
I was awarded in 2014, 2015 and 2016 with Microsoft MVP, for Visual Studio and Development Technologies expertise. My technology interests and main skills are in .NET Framework, Visual Basic, Visual C# and SQL Server, but i'm proficient in PHP and MySQL also.
Software Developer
Russian Federation Russian Federation
Want to contribute my CodeProject articles and tips? Write my e-mail: emiliarge@mail.ru
Software Developer (Senior)
United States United States
Started engineering as a 5 year old by completely dissembled my father's .38 special replica pistol. I was trying to figure out GOTOs and GOSUBs on the Commodore Vic-20 at 10. Graduated from the University of Missouri-Columbia with a degree in Computer Science in 1998 and have been programming since. My area of focus has been web programming for the last 10 years.
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
Yugoslavia Yugoslavia
I am a software developer from Serbia with a passion in backend programming and technologies.
Software Developer (Junior) THOMSON REUTERS
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Architect
United States United States
@
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.
Web Developer
Brazil Brazil
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer LinkDev
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.
Founder ManzoorTheTrainer.com
India India
Manzoor is a Microsoft Certified Trainer who has been working on MS .Net technologies for more than a decade. Apart from development he is also passionate about delivering training on various MS .Net technologies and he has 10+ years of experience as a software development teacher. He writes articles for code-project as well. His YouTube channel has 1 million hits. He is the founder of ManzoorTheTrainer portal.

"I focus on simplifying, complex concepts..." - ManzoorTheTrainer

Founder of www.ManzoorTheTrainer.com [Free .net video tutorials on MS SQL Server, Asp.Net, C#.Net, Ado.Net, Entity Framework, MVC, Web Services, Android]
Norway Norway
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
Five+ years of demonstrated work experience in developing and implementing business technology applications, systems integration and testing solutions with in-depth domain knowledge of industries like Healthcare, Telecom, Call Center, Financial Instruments, Payroll, HR, and skills including, but not limited to, software analysis, design and development.

Comprehensive understanding of NET Framework 4.5, 4.0, 2.0 and C#, ASP.Net, ADO.Net, Entity Framework, LINQ, Web Service, WCF, AJAX Control Toolkit, Advanced JavaScript, HTML 5.0, CSS3.0, jQuery, SSIS, SSRS, XML, XSLT, JSON.

Expertise in end to end development of enterprise web application and Single Page Application (SPA) using ASP.NET MVC, ASP.NET Web Forms, ASP.NET Web API, AngularJS, TypeScript, NodeJS, SQL Server and Design Pattern fanatic.
CEO
Wales Wales
Born at an early age, he grew older. At the same time, his hair grew longer, and was tied up behind his head.
Has problems spelling the word "the".
Invented the portable cat-flap.
Currently, has not died yet. Or has he?
PiottiTech Corp
United States United States
Roles: Developer / Architect / Development Manager / CTO
Technologies: .NET / SQL Server / Salesforce
Software Developer
India India
string currentJob = new ComputerScientist("ND-1550", "02/04", "CDN Solutions");

while (live)
{
try
{
learn();
code();
}
catch (Exception ex)
{
recover();
}
}
Team Leader VF
Pakistan Pakistan
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Technical Lead
United States United States
Started Programming career with VB 6 and VC++ and now Into .Net Development. Working with .Net since its first release (Version 1.0 Beta). Lucky enough to continue always with most updated versions of .Net and as of now; May 2007, fighting with .Net 3.0 (WPF,WCF...etc) and it's next most anticipated version LINQ.

Got familiarity up on the .Net Technologies and Guidelines like CAB, and Patterns and Practices, Enterprise Library and now with it's WPF version etc.

Specialized in Windows and Distributed and Service oriented applications.
Software Developer
Pakistan Pakistan
Software Engineer and Data Scientist
Software Developer (Senior) Vanilla Networks Pvt.Ltd
India India
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
Architect TalentTuner.com
India India
We are set of professionals who love technical things – Architecting, Coding, Fixing issues & Talk & Write on technologies. We do consultancy especially for Analysis & Architecture applications, we keep developing our own products and we also give trainings on our expertise areas.
This is a Organisation (No members)

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 ISM APAC (Pvt) Ltd
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 (Senior) Yandex
Russian Federation Russian Federation
Senior developer at Yandex:
Billing System application logic and WEB-interface development,
Communication protocols for various Payment Systems.
Teacher of Computer Science at Moscow State University of Mechanical Engineering.
Architect
Europe Europe
Biography provided

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