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

Best Database article of May 2013

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.
16 May 2013dale.newman
Google your SQL.
Please Sign up or sign in to vote.
23 Jun 2013Frederico Regateiro
This project creates a Visual Studio visualizer for entity framework queries, views edit and runs the generated SQL.
Please Sign up or sign in to vote.
26 May 2013Tharaka MTR
This post will show you how to fix orphaned SQL users.
Please Sign up or sign in to vote.
16 Jul 2013RB Starkey
How to create a tree-view control using an Access table and form.
Please Sign up or sign in to vote.
1 May 2013Nasser Malik
Split comma separated IDs to get batch of records through Stored Procedure.
Please Sign up or sign in to vote.
27 May 2013Tharaka MTR
Generate insert statements from a specific table data using SQL Server
Please Sign up or sign in to vote.
3 May 2013Shahriar Iqbal Chowdhury/Galib
Solution to the MSSQL Server “Suspect”
Please Sign up or sign in to vote.
24 Jun 2013Scott Burkow
We build the physical design from the logical design.
Please Sign up or sign in to vote.
15 May 2013Manikandan Sekar
Loading Data from Excel
Please Sign up or sign in to vote.
15 May 2013h_wiedey
Implementation of relative database constraints and permissioning using triggers and shadow tables.
Please Sign up or sign in to vote.
3 May 2013Shahriar Iqbal Chowdhury/Galib
TSQL Recursive Split function
Please Sign up or sign in to vote.
28 May 2013Keyhole Software
Using JSON and File API to view starred Google Reader posts.
Please Sign up or sign in to vote.
9 May 2013Sukant Shekhar
Creation of random and unique code
Please Sign up or sign in to vote.
16 May 2013Sebastian Solnica
In this post, I will show you an interesting problem that we experienced when querying a SQL Server database with Dapper.
Please Sign up or sign in to vote.
10 May 2013Youqi Ma
Using a controller to manage dynamic control form events and creation.
Please Sign up or sign in to vote.
3 May 2013Mohan Mallampalli
A HTML5 note taking app capable of capturing Video notes.
23 May 2013Dynamsoft
The article will show you how to develop a cross-platform document imaging solution that works with all mainstream browsers by using ImageCapture Suite.
Please Sign up or sign in to vote.
2 May 2013DThrasher
Converting a Windows 7 desktop application to Windows 8 and Azure.
Please Sign up or sign in to vote.
16 May 2013Pavan Thakur
I had a requirement to create automatic date entries into Scheduler SQL table. Whenever a Schedule with RecurrenceRange was set with 'No EndDate', the dates will automatically get added from backend for next year through a job.
Please Sign up or sign in to vote.
16 Jan 2018Pragmateek
Using an Access, MySQL, PostgreSQL or SQLite Database from VBA
Please Sign up or sign in to vote.
16 May 2013Joffrey Brouillet
This is an alternative for "A set of ADO classes - version 2.20"
Please Sign up or sign in to vote.
5 Jun 2013Rajat Bittharia
Grid based on JSON data using MVC with Entity Framework and MySQL.
Please Sign up or sign in to vote.
16 Aug 2013Faisal(mfrony)
This Article will help you to manage our CRUD operation more efficient way
Please Sign up or sign in to vote.
19 Jul 2013Oso Oluwafemi Ebenezer
This illustrate how to create shortcut to objects (both file and non-file like printers, folders, files. Drives, etc) in Win32 C++
Please Sign up or sign in to vote.
3 May 2013Tecfield
Beware of What We Ask Them to Do
Please Sign up or sign in to vote.
7 May 2013grandtree
Create a calendar by inputting month
Please Sign up or sign in to vote.
5 May 2013Anuraj Parameswaran
Using existing database in Windows Phone
Please Sign up or sign in to vote.
2 May 2013Koray Dakan, PMP
DBMapper - A new ORM tool for vendor-neutral solutions
Please Sign up or sign in to vote.
22 May 2013cesar_boucas
IDataReader implementation illustrated with SqlBulkCopy class usage
Please Sign up or sign in to vote.
3 Mar 2016Eric Lapouge
An other way to export data from a SQL-Server to use them to call a web service
Please Sign up or sign in to vote.
22 Sep 2016Alexandros Pappas
This project provides utilities for SQL server, such as executing a list of SQL scripts, exporting data to an SQL script, and displaying relationships between records.
Please Sign up or sign in to vote.
8 May 2013PratapReddyP
Merge in SQL Server 2008.
Please Sign up or sign in to vote.
22 May 2013Tadeusz Kaliszewski
A small .NET class library for maintaining SQL CE database schema written in C#.
Please Sign up or sign in to vote.
10 May 2013d.ban
A LINQ tutorial for beginners.
Please Sign up or sign in to vote.
27 May 2013Tharaka MTR
Some online tools for troubleshooting web, SQL, XML and JSON
Please Sign up or sign in to vote.
10 May 2013Bishram
Recruitment and selection process is a very important aspect in acquiring and managing talent in any organization. Typically, the process is owned by Human Resource Department.
Please Sign up or sign in to vote.
6 May 2013Hernán Hegykozi
This tip explains how to calculate the Check Digit Vertical (CDV) and Horizontal (CDH) by SQL Server.
Please Sign up or sign in to vote.
14 May 2013Srinubabu Ravilla
How to get SQL Server database connection string easily from Visual Studio
Please Sign up or sign in to vote.
28 May 2013Bob Crowley
How to use a CASE statement in ORDER BY to avoid dynamic SQL
Please Sign up or sign in to vote.
2 May 2013Amogh Natu
This post shows how to insert a comma-separated string into multiple rows in a table in SQL Server.

Current Participants

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

Software Developer (Senior) Unisystems
Greece Greece
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.
Technical Lead
India India
Working as Tech. Lead

My blog : dotnetthoughts.net.
You can follow me in twitter : @anuraj
CEO Vision2Value Services Pvt Ltd.
India India
Bishram has 30+ years of experience in corporate sector at Senior management level. Through his company "Vision2Value Services Pvt. Ltd. " , he partners with organizations, to produce measurable business results by improving the performance of employees with emphasis on leadership, sales, team member engagement, customer service, presentations, process improvement and other essential management skills.

Training portfolio includes Time Management, Stress Management, Execution excellence, Self Management, Continuous Improvement through Lean Management, Balanced Scorecard, Engagement Management
Personal blog at http://bishrams.blogspot.com.
Software Developer (Senior) EVO Payments International
United States United States
Full stack developer on .Net and related technologies with heavy emphasis on back-end API development and integrations.
Web Developer
Brazil Brazil
Yesterday C++, today C#.
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)
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 Infovark, 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.
Canada Canada
Dynamsoft has more than 15 years of experience in TWAIN SDKs, imaging SDKs and version control solutions.

Our products include:

TWAIN SDK
- Dynamic Web TWAIN: a TWAIN scanning SDK optimized for web document management applications.
- Dynamic .NET TWAIN: a .NET TWAIN and Directshow Image Capture SDK for WinForms/WPF applications.

Imaging SDKs
- Barcode Reader for Windows, Linux, macOS, iOS, Android and Raspberry Pi.
- OCR addon for both web and .NET TWAIN SDKs

Version Control
- SourceAnywhere: a SQL server-based source control solution. Both on-premise and hosting options are provided.

http://www.dynamsoft.com/
This is a Organisation

21 members
Software Developer (Senior)
France France
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Bangladesh Bangladesh
I am a Sr.Software Engineer at Brain Station -23. I have 5+ years of work experience in .Net technology. I strongly believe that before software can be reusable it first has to be usable.

My contact info :

mfrony2003@yahoo.com
mfrony2003@hotmail.com

LinkedIn
http://www.linkedin.com/profile/view?id=106671466&trk=tab_pro
Software Developer
Portugal Portugal
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Web Developer IBM
China China
I am a software engineer using C# and SQL Server, a certified PMP working in IBM Data Collection team.
Germany Germany
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Team Leader
Argentina Argentina
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Chief Technology Officer Somum Solutions Inc.
Canada Canada
In my 22+ years in the business, I had the privilege to work for big name companies in challenging environments in different countries. I created and helped deploy solutions for small businesses as well as for major corporations spanning many offices worldwide. I also have entrepreneurial qualities having had a few companies of my own making me very autonomous and giving me the understanding of the business side of things.

Currently, I play several major roles alongside consulting. I am privileged to be part of the executive team with my employer, answering directly to the owner and where I can put to good use my skills in management, software architecture, partner and supplier relationships development, major account solution engineering and more.

I have strong interrelation skills which facilitate team management and commitment. I promote brainstorms and initiatives from my teams with very positive results. I put forward the human side of a relationship.
Keyhole Software
United States United States
Keyhole is a software development and consulting firm with a tight-knit technical team. We work primarily with Java, .NET, and Mobile technologies, specializing in application development. We love the challenge that comes in consulting and blog often regarding some of the technical situations and technologies we face. Kansas City, St. Louis and Chicago.
This is a Organisation

3 members
Turkey Turkey
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer (Junior)
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 Ushodaya Enterprises Pvt. Ltd[EENADU]
India India
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
Nigeria Nigeria
A graduate of Agricultural Engineering from Ladoke Akintola University of Technology, Ogbomoso but computer and web programming is his first love. You can meet him on Facebook Osofem Inc.
Software Developer (Senior)
India India
MCP, MCAD.NET, MCSD.NET in .NET technology. MCTS in .NET Framework 3.5, ASP.NET Applications, MS (Microsoft Specialist).
PGDIT in IT (Symbiosis).

Doing programming into .Net Technology from year 2004.
Worked extensively on both windows and web platform.
In my projects I have worked on Asp.Net(1.1, 2.0, 3.5, 4.7), C#, VB.Net, MVC, Angularjs 1.6, Angular 2+, Typescript, SignalR, Linq, Dependency Injection, Design Pattern, Bootstrap and Sql Server(2000,2005, 2008, 2012).
HTML5, JScript, CSS, XML, AJAX, Webapi, WCF & Web Services, WPF, MVC.

Since you have gone through my profile and would like to share any job opportunities for me, please contact me at pavan.thakur@gmail.com

I love programming and like to share my knowledge.
Cheers Smile | :)
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.
Web Developer
India India
I am an Aspiring Architect, having expertise in Design and Development. Good knowledge on TDD and DDD Approaches. Well versed with Agile methodology. Strong at Sharepoint, C# , Asp.Net, MVC, MVC Razor, WCF, Entity Framework, SQL, BI Tools.
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.
Web Developer ACCESSible IT Limited
United Kingdom United Kingdom
I hold a BSc(Hons) degree in Computer Science and Business Administration, an MSc in database design and an MPhil in neural networks.

Since 1994 I have been running my own Access and SQL Server development company. Four years ago I re-skilled into Silverlight but now, I am learning MVC .Net 2, HTML 5, JavaScript and TypeScript.
United States United States
Scott is a data architect/database developer specializing in SQL Server. He holds an Ms. C.S. from UCSB engineering, and is MCITP Database Developer in 2005 and 2008.

Based in San Francisco under the incorporated name Ziron Systems, he works with clients to analyze, design, and develop database systems as well as mentor team members and troubleshoot issues.

His passion is working on complex problems, and at the moment, writing articles for advanced practitioners that pose problems and explore solutions.

Reach him at scott.burkow@zironsystems.com or (310)403-1137.
Software Developer (Senior)
Poland Poland
Interested in tracing, debugging and performance tuning of the .NET applications.

My twitter: @lowleveldesign
My website: http://www.lowleveldesign.org
Chief Technology Officer
Bangladesh Bangladesh
I am a Software Engineer and Microsoft .NET technology enthusiast. Professionally I worked on several business domains and on diverse platforms. I love to learn and share new .net technology and my experience I gather in my engineering career. You can find me from here

Personal Site
Personal Blog
FB MS enthusiasts group
About Me
Software Developer (Senior) KANTAR
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Unknown
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
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.
Architect
United States United States
I got my BS in Software Engineering from Iran, worked there for 4.5 years mainly in industrial automation field. Then I moved to Australia. In Australia, I had a great chance to work at some big companies. Since 2009 I have been living in the States. I received my MS in Information Systems from Illinois State University. Currently, I am a Senior Software Development Engineer.
Technical Lead Eyepax IT Consulting (Pvt) Ltd.
Sri Lanka Sri Lanka
Having more than 9 year hands-on industry experience in software development
Responsible for designing, implementing and managing complex software systems with stringent up-time requirement.

Visit my blog
Software Developer (Senior)
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.
 
You must sign in to participate in this contest.
This contest has ended.
1 May - 31 May 2013