Click here to Skip to main content
14,980,646 members
This competition has ended

Best Database Article of March 2016

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.
29 Mar 2016
wells cheung
Angular Single-Page Application, MEF, Privilege Control, WCF Restful Service, ui-router,
Please Sign up or sign in to vote.
21 Mar 2016
B. Clay Shannon
Creating a simple sample Excel Pie Chart, with labeled slices using C# and Excel Interop
Please Sign up or sign in to vote.
18 Mar 2016
johnniealan
This article describes about adding progress bar in cell.
Please Sign up or sign in to vote.
26 Mar 2016
Amit Kumar Tiwari
.NET to Hadoop connection using Keytab file
Please Sign up or sign in to vote.
3 Mar 2016
witnes
CRUD with filtering for MongoDB version 2 driver
Please Sign up or sign in to vote.
1 Mar 2016
Emiliano Musso
In this short article we will see how to create a SQL database using the services provided by Microsoft Azure cloud platform, and then connect to it via C # code, to perform the normal data insertion and retrieval operations
Please Sign up or sign in to vote.
25 Mar 2016
freedeveloper
Simple Implementation of Google API IDataStore that use MS-SQL server to store your token file
Please Sign up or sign in to vote.
20 Mar 2016
Sumit Samediya
In this article we will learn how to use existing sqlite database in WP 8.1 apps.
Please Sign up or sign in to vote.
3 Mar 2016
Jameson Triplett
Log4j2.xml Tweaks
Please Sign up or sign in to vote.
6 Mar 2016
markkang
This is about how to hash your binary data that exceed the limit (8000bytes) of allowed input values of HASHBYTES in SQL Server.
Please Sign up or sign in to vote.
2 Mar 2016
Mahmoud_Gamal
Connection pool java without ConnectionContext
Please Sign up or sign in to vote.
15 Mar 2016
Sifiso W Ndlovu
Duplicate MySQL table using phpMyAdmin
Please Sign up or sign in to vote.
25 Mar 2016
Member 12149082
Description of useful SVG Filters and Interactivity
Please Sign up or sign in to vote.
29 Mar 2016
Giancarlo Rhodes
ORM objects and basic CRUD operation procedures are first phase tasks that come after establishing a first version of the database. This java-based code generation tool builds those classes and stored procedures.
Please Sign up or sign in to vote.
13 Mar 2016
Zohaib Sibte Hassan
A more detailed look into Iterators and Snapshots in LevelDB UWP
Please Sign up or sign in to vote.
22 Mar 2016
Bhawesh Tiwari
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager failed with error code 0xC0209303.
Please Sign up or sign in to vote.
7 Mar 2016
Akhil Mittal
In this article we’ll learn on how to write unit tests for WebAPI controllers i.e. REST’s actual endpoints.
Please Sign up or sign in to vote.
21 Mar 2016
Sergii Syrovatchenko
Starting from SQL Server 2005, the default trace is enabled by default on every SQL server. Default trace is a lightweight system trace, which stores a lot of useful information about the changes in the system...
Please Sign up or sign in to vote.
18 Mar 2021
VijayRana
A tutorial for MongoDB Tutorial
Please Sign up or sign in to vote.
1 Mar 2016
syed shanu
In this article, we will see in detail how to create a simple Student Master CRUD (Create/Read/Update and Delete) using scaffolding.
Please Sign up or sign in to vote.
30 Mar 2016
koolprasadd
Read write Excel file without interop using OLEDB in C#
Please Sign up or sign in to vote.
1 Mar 2016
Akhil Mittal
In this article we learn how to write unit tests for core business logic and primarily on basic CRUD operations.
Please Sign up or sign in to vote.
15 May 2018
NobsterTheLobster
Publish a WCF DataService with entity model, updatable views, filtering and authentication
Please Sign up or sign in to vote.
3 Mar 2016
Gene R. Browning
Get a quick look at your data characteristics using this tool.
Please Sign up or sign in to vote.
26 Mar 2016
Jovan Popovic(MSFT)
How to easily insert array of JSON objects into SQL Server 2016 tables
Please Sign up or sign in to vote.
23 Mar 2016
rohit7209
Use AccessRemoteMySQLDB-API in your project to access web-server MySQL database
Please Sign up or sign in to vote.
8 Mar 2016
markkang
This tip describes how to generate insert SQL statement from the records in an existing table in SQL server database
Please Sign up or sign in to vote.
18 Mar 2016
M.M.Mohseni
An ASP.NET one page application for getting backup from MS-SQL Server
Please Sign up or sign in to vote.
26 Mar 2016
Mahesh Rajaram Shinde
This project is designed for addressing SQL Server Script deployment on multiple servers and databases.
Please Sign up or sign in to vote.
30 Mar 2016
Bryian Tan
Restore Database is terminating abnormally
Please Sign up or sign in to vote.
28 Mar 2016
Prince Cheruvathur
Step by step development of a Node.js application in Typescript using Express and MongoDB with real-time update using Socket.io
Please Sign up or sign in to vote.
25 Mar 2016
Sibeesh Passion
How to use caching in Web API
Please Sign up or sign in to vote.
20 Mar 2016
Sumit Samediya
In this article we will learn how to share code between Windows store app and Windows phone app using Windows Universal App development.
Please Sign up or sign in to vote.
9 Mar 2016
Arslan Elahi
Get the Comma Separated Value of one or multiple columns from SQL table
Please Sign up or sign in to vote.
28 Mar 2016
Sibeesh Passion
Web API With HttpClient Or Consume Web API From Console Application
Please Sign up or sign in to vote.
17 Mar 2016
Daniel JXHV
No more ORM, EF, A Stored Procedure direct Access framework for JavaScript.
Please Sign up or sign in to vote.
27 Mar 2016
Manish kumar choudhary
In this article, you will learn how to select data from a table and send that data to an email using SQL Server 2008.
Please Sign up or sign in to vote.
21 Mar 2016
Jamescookxj
Repository Pattern with Generic Interface and Dependency Injection
Please Sign up or sign in to vote.
27 Mar 2016
Manish kumar choudhary
In this article, I will explain how to schedule a daily mail from SQL Server 2008.

Current Participants

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

Akhil Mittal
Architect https://codeteddy.com/
India India
Akhil Mittal is an Ex-Microsoft MVP(Most Valuable Professional), C# Corner MVP, Codeproject MVP, a blogger, author and likes to write/read technical articles. Akhil has an experience of around 12 years in developing, designing, architecting enterprises level applications primarily in Microsoft Technologies. Akhil enjoys working on technologies like MVC, Web API, Entity Framework, Angular, C# and BlockChain. Akhil is an MCP( Microsoft Certified Professional) in Web Applications (MCTS-70-528, MCTS-70-515) and .Net Framework 2.0 (MCTS-70-536). Visit Akhil Mittal’s personal blog CodeTeddy for some good and informative articles.
LinkedIn: https://www.linkedin.com/in/akhilmittal/
Group type: Collaborative Group

772 members

Amit Kumar Tiwari
Technical Lead
United States United States
I am a developer in Microsoft Technologies like .NET, SharePoint etc.
Arslan Elahi
Software Developer (Senior) TECNEX System LLC
Pakistan Pakistan
No Biography provided
B. Clay Shannon
Founder Across Time & Space
United States United States
I am in the process of morphing from a software developer into a portrayer of Mark Twain. My monologue (or one-man play, entitled "The Adventures of Mark Twain: As Told By Himself" and set in 1896) features Twain giving an overview of his life up till then. The performance includes the relating of interesting experiences and humorous anecdotes from Twain's boyhood and youth, his time as a riverboat pilot, his wild and woolly adventures in the Territory of Nevada and California, and experiences as a writer and world traveler, including recollections of meetings with many of the famous and powerful of the 19th century - royalty, business magnates, fellow authors, as well as intimate glimpses into his home life (his parents, siblings, wife, and children).

Peripatetic and picaresque, I have lived in eight states; specifically, besides my native California (where I was born and where I now again reside) in chronological order: New York, Montana, Alaska, Oklahoma, Wisconsin, Idaho, and Missouri.

I am also a writer of both fiction (for which I use a nom de plume, "Blackbird Crow Raven", as a nod to my Native American heritage - I am "½ Cowboy, ½ Indian") and nonfiction, including a two-volume social and cultural history of the U.S. which covers important events from 1620-2006: http://www.lulu.com/spotlight/blackbirdcraven
Bhawesh Tiwari
Software Developer (Senior)
New Zealand New Zealand
No Biography provided
Bryian Tan
Software Developer (Senior)
United States United States
I have over 10 years of experience working with Microsoft technologies. I have earned my Microsoft Certified Technology Specialist (MCTS) certification. I'm a highly motivated self-starter with an aptitude for learning new skills quickly.
Daniel JXHV
United States United States
No Biography provided
Emiliano Musso
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.
freedeveloper
Software Developer (Senior) Avalon Development
United States United States
Jose A. Garcia Guirado, Electronic Engineer, graduated in Havana/Cuba 1982, MCTS, MCSD.NET, MCAD.NET, MCSE. Worked in the Institute for Cybernetics and Mathematics of Academy of Science of Cuba for 8 years; since 1995 working as free software architect, developer and adviser, first in Argentina and from 2003 to 2010, in Germany as External consultant in DWS Luxembourg, AIXTRON AG and Shell Deutschland GmbH and from 2010 to 2012 in Mexico working for Twenty Century Fox, and Mexico Stock Exchange (BMV). From 2010 to now in USA, Florida, First in FAME Inc. and now as Senior Software Engineer in Spirit Airlines.
Gene R. Browning
Technical Lead
United States United States
I have extensive experience in the Information Technology field utilizing a broad range of technologies in a variety of industries with significant knowledge of Information Technology Management, Database Development, Database Administration, Database Architecture/Design, Transactional/ETL Application Development and Data Warehousing.
Giancarlo Rhodes
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.
Jamescookxj
Unknown
No Biography provided
Jameson Triplett
Product Manager Workday
United States United States
No Biography provided
johnniealan
Team Leader
United States United States
My passion is working on solutions architecture and software development, using an extensive range of technical knowledge and expertise in protocol and driver development, programming, communication peripherals and software applications. Leading projects with major global clients I have developed strong skills in all stages of the software development lifecycle and project management, and possess strong communication skills for working with stakeholders from different backgrounds to understand requirements, lead development and testing, deliver reporting, training and post-implementation support.

I am ambitious and committed to always providing a professional service, and am proud to have consistently received promotions and awards in reward and recognition programs.
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.
koolprasadd
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
M.M.Mohseni
Software Developer (Senior)
Sweden Sweden
Mehdi Mohseni is a Software senior developer (Consultant) in Sigma ITC (www.sigmait.se), Mehdi has a deep experience in N-Tier software applications as well as MVC design pattern. Mehdi has led more than 100 Asp.Net C# or VB.Net Automation applications. Mehdi is working in Toyota Material Handling Logistic Solution as Senior .Net Developer now.
Mahesh Rajaram Shinde
Technical Lead Thomson Reuters
India India
Mahesh Shinde is Leader in SQL Server with 14+ years of experience. I’m Microsoft Certified professional in SQL Server, ITIL 3.0 v foundation and Six Sigma Green Belt. As a lead Database Engineer I’ve proven experience in Database Technologies and able to Architect / Design / implement a DB solution which meet client requirement of High Availability, Performance and Reliability with complex SQL server/Oracle database infrastructure. Expert in managing complex production SQL servers across different data centres with wide range of MS SQL servers versions (7.0 To 2012). I’ve proven expertises in SQL server consolidation with virtualization and data cloud offerings helped clients deploy SQL servers in cost effective manner. I’m looking to take up a bigger opportunity where I would be working as solution architect for DB infrastructure as a whole.
Mahmoud_Gamal
Software Developer (Senior)
Egypt Egypt
No Biography provided
Manish kumar choudhary
Software Developer
India India
Manish Kumar Choudhary is a passionate and pragmatic software engineer specializing in web application development with ASP.NET MVC, Web API, Entity Framework, NHibernet, Angular, Backbone, HTML5, and CSS. He started programming at the age of twelve on VB.Net and fell in love with it. His dream at the time was to become a software engineer so he pursues programming both academically and professionally. He has a Bachelor of Science in Computer Application and a Master of Science in Computer Application. He has over 3.5 years’ professional experience developing web applications. Outside the software world, he enjoys photography, swimming, cricket and football. Manish is based in Hyderabad, India.
markkang
CEO intelcells
China China
No Biography provided
Member 12149082
Ukraine Ukraine
No Biography provided
No Biography provided
Prince Cheruvathur
Software Developer (Senior)
United States United States
I work as a consultant in the Seattle/Redmond area. Most of the projects in the past were for Microsoft Corporation.
rohit7209
Student
India India
I am a java lover, with some experience of working in web development and mobile development. I have a keen interest in developing java libraries and utility classes. Am not so experienced in software development but still i love to share whatever i know and use techniques. I enjoy learning new things, new stuffs to be a better developer.
Sergii Syrovatchenko
Database Administrator Teamwork Commerce
Ukraine Ukraine
SQL Server DBA/DB Developer with 10+ years of experience in SQL Server 2005-2019, Azure/GCP. Worked on high-load OLTP/DW projects and develops system tools for SQL Server. In depth understanding of SQL Server Engine and experience in working with big databases. Domain knowledge of ERP/CRM, crawlers, gambling and retail sales. Blogger, mentor and speaker at local SQL Server events.
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
Sifiso W Ndlovu
Technical Lead select SIFISO
South Africa South Africa
Sifiso W. Ndlovu is a certified Microsoft professional who holds a Master’s degree in IT Management from the University of Johannesburg. He specializes on a range of enterprise and consumer technologies using open source and proprietary software. He is the member of the Johannesburg SQL User Group wherein he has made several presentations on User Group Meetings and SQL Saturday sessions. He has written for a number of publications including SQLShack.com and SQLServerCentral.com.
stebo0728
United States United States
No Biography provided
Sumit Samediya
Software Developer (Senior)
India India
No Biography provided
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
VijayRana
Technical Lead
India India
Hi Myself Vijay having around 7 years of experience on Microsoft Technologies.
wells cheung
Software Developer (Senior)
United States United States
ASP.NET Developer 3.5(Microsoft® Certified Professional Developer)
.NET Framework 3.5, ASP.NET Applications(Microsoft® Certified Technology Specialist)
witnes
Software Developer (Senior) Kensium
Ukraine Ukraine
Hi,
I'm Acumatica ERP Solutions architect at Kensium. Besides ERP programming my area of interests includes Neural Networks, Machine Learning, Statistics and of course performance optimization.
Here is my blog: http://blog.zaletskyy.com
No 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 Mar - 31 Mar 2016