Click here to Skip to main content
15,072,422 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 2013
dale.newman
Google your SQL.
Please Sign up or sign in to vote.
23 Jun 2013
Frederico 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 2013
Tharaka MTR
This post will show you how to fix orphaned SQL users.
Please Sign up or sign in to vote.
16 Jul 2013
RB Starkey
How to create a tree-view control using an Access table and form.
Please Sign up or sign in to vote.
1 May 2013
Nasser Malik
Split comma separated IDs to get batch of records through Stored Procedure.
Please Sign up or sign in to vote.
27 May 2013
Tharaka MTR
Generate insert statements from a specific table data using SQL Server
Please Sign up or sign in to vote.
3 May 2013
Shahriar Iqbal Chowdhury/Galib
Solution to the MSSQL Server “Suspect”
Please Sign up or sign in to vote.
24 Jun 2013
Scott Burkow
We build the physical design from the logical design.
Please Sign up or sign in to vote.
15 May 2013
Manikandan Sekar
Loading Data from Excel
Please Sign up or sign in to vote.
15 May 2013
h_wiedey
Implementation of relative database constraints and permissioning using triggers and shadow tables.
Please Sign up or sign in to vote.
3 May 2013
Shahriar Iqbal Chowdhury/Galib
TSQL Recursive Split function
Please Sign up or sign in to vote.
28 May 2013
Keyhole Software
Using JSON and File API to view starred Google Reader posts.
Please Sign up or sign in to vote.
9 May 2013
Sukant Shekhar
Creation of random and unique code
Please Sign up or sign in to vote.
16 May 2013
Sebastian 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 2013
Youqi Ma
Using a controller to manage dynamic control form events and creation.
Please Sign up or sign in to vote.
13 May 2013
Randall Smith II
A simple solution trying out the Azure platform for development and deployment.
Please Sign up or sign in to vote.
3 May 2013
Mohan Mallampalli
A HTML5 note taking app capable of capturing Video notes.
23 May 2013
Dynamsoft
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 2013
DThrasher
Converting a Windows 7 desktop application to Windows 8 and Azure.
Please Sign up or sign in to vote.
16 May 2013
Pavan 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 2018
Pragmateek
Using an Access, MySQL, PostgreSQL or SQLite Database from VBA
Please Sign up or sign in to vote.
16 May 2013
Joffrey Brouillet
This is an alternative for "A set of ADO classes - version 2.20"
Please Sign up or sign in to vote.
5 Jun 2013
Rajat Bittharia
Grid based on JSON data using MVC with Entity Framework and MySQL.
Please Sign up or sign in to vote.
16 Aug 2013
Faisal(mfrony)
This Article will help you to manage our CRUD operation more efficient way
Please Sign up or sign in to vote.
19 Jul 2013
Oso 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 2013
Tecfield
Beware of What We Ask Them to Do
Please Sign up or sign in to vote.
7 May 2013
grandtree
Create a calendar by inputting month
Please Sign up or sign in to vote.
5 May 2013
Anuraj Parameswaran
Using existing database in Windows Phone
Please Sign up or sign in to vote.
2 May 2013
Koray Dakan, PMP
DBMapper - A new ORM tool for vendor-neutral solutions
Please Sign up or sign in to vote.
22 May 2013
cesar_boucas
IDataReader implementation illustrated with SqlBulkCopy class usage
Please Sign up or sign in to vote.
3 Mar 2016
Eric 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 2016
Alexandros 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 2013
PratapReddyP
Merge in SQL Server 2008.
Please Sign up or sign in to vote.
22 May 2013
Tadeusz Kaliszewski
A small .NET class library for maintaining SQL CE database schema written in C#.
Please Sign up or sign in to vote.
27 May 2013
Tharaka MTR
Some online tools for troubleshooting web, SQL, XML and JSON
Please Sign up or sign in to vote.
10 May 2013
d.ban
A LINQ tutorial for beginners.
Please Sign up or sign in to vote.
10 May 2013
Bishram
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 2013
Herná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 2013
Srinubabu Ravilla
How to get SQL Server database connection string easily from Visual Studio
Please Sign up or sign in to vote.
28 May 2013
Bob Crowley
How to use a CASE statement in ORDER BY to avoid dynamic SQL
Please Sign up or sign in to vote.
2 May 2013
Amogh 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.

Alexandros Pappas
Software Developer (Senior) Unisystems
Greece Greece
No Biography provided
Amogh Natu
Software Developer
India India
No Biography provided
Anuraj Parameswaran
Technical Lead
India India
Working as Tech. Lead

My blog : dotnetthoughts.net.
You can follow me in twitter : @anuraj
Bishram
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.
Bob Crowley
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.
cesar_boucas
Web Developer
Brazil Brazil
Yesterday C++, today C#.
d.ban
United States United States
No Biography provided
dale.newman
Software Developer (Senior)
United States United States
No Biography provided
DThrasher
Founder Infovark, Inc.
United States United States
No Biography provided
Dynamsoft
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/
Group type: Organisation

21 members

Eric Lapouge
Software Developer (Senior)
France France
No Biography provided
Faisal(mfrony)
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
Frederico Regateiro
Software Developer
Portugal Portugal
No Biography provided
grandtree
Web Developer IBM
China China
I am a software engineer using C# and SQL Server, a certified PMP working in IBM Data Collection team.
h_wiedey
Germany Germany
No Biography provided
Hernán Hegykozi
Team Leader
Argentina Argentina
No Biography provided
Joffrey Brouillet
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
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.
Group type: Organisation

3 members

No Biography provided
Manikandan Sekar
Software Developer (Junior)
India India
No Biography provided
Mohan Mallampalli
Software Developer Ushodaya Enterprises Pvt. Ltd[EENADU]
India India
No Biography provided
Nasser Malik
United States United States
No Biography provided
Oso Oluwafemi Ebenezer
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.
Pavan Thakur
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 | :)
Pragmateek
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.
PratapReddyP
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.
Rajat Bittharia
Software Developer (Senior)
India India
No Biography provided
Randall Smith II
Software Developer Rio National Insurance
United States United States
I am an avid technology enthusiast and coder for 15+ years. Started developing applications using QBasic on Windows 3.1 machines and have not stopped since. Currently I manage several large databases as well as the front end web pages/applications that access them. I also develop standalone tools used in managing various aspects of the services. I have several side projects that I have been part of over the years some of them small, and some of the more current ones larger in scope. Feel free to ask questions or drop suggestions to me as I am always learning new ways to do things.
RB Starkey
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.
Scott Burkow
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.
Sebastian Solnica
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
Shahriar Iqbal Chowdhury/Galib
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
Srinubabu Ravilla
Software Developer (Senior) KANTAR
India India
No Biography provided
Sukant Shekhar
Unknown
No Biography provided
Tadeusz Kaliszewski
United Kingdom United Kingdom
No Biography provided
Tecfield
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.
Tharaka MTR
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
Youqi Ma
Software Developer (Senior)
United States United States
No Biography provided
 
You must sign in to participate in this contest.
This contest has ended.
1 May - 31 May 2013