Click here to Skip to main content
15,894,362 members
This competition has ended

Best Database article of June 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.
13 Jun 2013Adam Tibi
Exposing .NET functions to be consumed as Excel functions, otherwise known in Excel as "User Defined Functions" . Those .NET exposed functions can be easily used from Excel's cells. This article presents two ways to achieve this and the pros and cons of each.
Please Sign up or sign in to vote.
20 Jun 2013Levente Kupás
If you have big reports which run slowly, you may use this T-SQL based engine to speed-up them.
Please Sign up or sign in to vote.
20 Jun 2013Bryan O'Connell
Using LINQ to SQL for ETL projects.
Please Sign up or sign in to vote.
26 Jun 2013ThatsAlok
Step by Step creation of SSIS package using C# with Conditional Split
Please Sign up or sign in to vote.
3 Jun 2013Mark Kestenbaum
An entry to the Windows Azure Developer Challenge.
Please Sign up or sign in to vote.
7 Jun 2013Purushotham Agaraharam
Creating a parameterised report using SSRS.
3 Jun 2013Dynamsoft
This article will show you how to decode barcodes from an image captured or scanned in a web application with the help of ImageCapture Suite.
Please Sign up or sign in to vote.
4 Jun 2013Darek Danielewski
The importance of using parameterized SQL queries has been well established, but passing table values or occassional NULL values has always been a problem ... until now ...
Please Sign up or sign in to vote.
21 Mar 2017Dave Clemmer
Mo+ is the first technology that fully supports model oriented development, allowing software developers to powerfully scale the work they already do.
Please Sign up or sign in to vote.
6 Aug 2013Michiel du Toit
Explaining and demonstrating the use of the APPLY keyword for SQL Server
Please Sign up or sign in to vote.
30 Dec 2013Monjurul Habib
Introduction to Agile software development methodologies and how to apply them. It is about how to work together to achieve a common goal. This article focus on how technology team work together well to plan, build and deliver software.
Please Sign up or sign in to vote.
5 Mar 2014Zhuyun Dai
I summarized some best practice rules in writing a COM-visible assembly according to my recent work.
Please Sign up or sign in to vote.
24 Jun 2013KK Kod
How to perform Inline editing in JqGrid
Please Sign up or sign in to vote.
10 Jun 2013Mario Stopfer
Generic database access model which generalizes the interactions with any particular database system.
Please Sign up or sign in to vote.
27 Jun 2013Pål Thingbø
How to get SQL Server XML data to JSON objects in your browser via webservice
Please Sign up or sign in to vote.
10 Jun 2013KK Kod
Developing .Net application with Mongo Db as Back end
Please Sign up or sign in to vote.
14 Jul 2013ThatsAlok
Step by Step creation of SSIS package using C#
Please Sign up or sign in to vote.
1 Jun 2013KK Kod
Document describes about One way web Method creation and consumption in Traditional ASP.net Web Service.
Please Sign up or sign in to vote.
25 Jun 2013Gazmend Jakupi
Tutorial for developing in PHP
Please Sign up or sign in to vote.
23 Jun 2013_Asif_
A Practical approach for implementing Interactive query based systems using MSOLAP
Please Sign up or sign in to vote.
16 Jun 2013Darek Danielewski
The subject of thread safety is often overlooked by even experienced developers. When designing an application or service to be utilized by multiple internal and external threads, one must account for potential issues arising from concurrent access to shared data.
Please Sign up or sign in to vote.
10 Oct 2013savbace
Change Skype status when user locks Windows.
Please Sign up or sign in to vote.
7 Jun 2013Sarvesh Kushwaha
This article descirbes what SQL injection is and how to prevent from SQL injection.
Please Sign up or sign in to vote.
20 May 2014John-ph
WinForms application developed using C#, ADO.NET and MS Access
Please Sign up or sign in to vote.
27 Jun 2013Greg Osborne
Validate existence of Sql Server
Please Sign up or sign in to vote.
11 Jun 2013Tom Glick Philadelphia, US
Using WCF REST Service to call Stored Procedures and run queries on SQL Server.
Please Sign up or sign in to vote.
6 Jun 2013Nelson Kosta Souto
Find text in Stored Procedures, View, Trigger, and Function.
Please Sign up or sign in to vote.
11 Jun 2013blnreddy
SQL Server built-in functions Coalesce()
Please Sign up or sign in to vote.
19 Jun 2013Mayank Dubey
XQuery basics.
Please Sign up or sign in to vote.
10 Jun 2013Aleksei Tuiman
Data extraction from XML fields with different namespaces
Please Sign up or sign in to vote.
17 Jun 2013C Is Sharp
PHP and Accessing MS SQL Server in Unix/Linux.
Please Sign up or sign in to vote.
15 Jun 2013Bhushan W. Juare
How to build you first analysis service cube
Please Sign up or sign in to vote.
4 Jun 2013Michael S Rempel
About SQL and sets
Please Sign up or sign in to vote.
14 Jun 2013Bojjaiah
Single Stored Procedure for delete/retrieve all table of records
Please Sign up or sign in to vote.
11 Jun 2013Dipankar Hazari
How to populate a dynamically created menu bar from the database according to user credentials using C# .NET and ASP.NET.

Current Participants

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

Product Manager Avanza Solutions
Pakistan Pakistan
Asif embarked on his programming journey back in 1991 when he first encountered 80286 8-16 MHz systems. His programming repertoire began with dBase III+, FoxPro, C, and assembly language, where he honed exceptional skills that have been a cornerstone of his development career.

Over the years, Asif's programming saga has seen him delve into a wide array of technologies and languages, ranging from C++, VC++, Java, Delphi, RPG400, SQL Server, and Oracle, to name just a few. His insatiable curiosity continues to lead him towards newer horizons, such as DOT Net Technologies, SOA architectures, BI, DSL, and beyond. These learning experiences are underscored by a robust theoretical foundation, with a penchant for research.

Beyond the realm of technology, Asif's interests include delving into the pages of fiction, exploring biotechnology, and gazing at the wonders of Astronomy. He finds joy in watching movies, and during his free time, he delights in quality moments spent with his children.
Software Developer (Senior)
India India
He used to have biography here Smile | :) , but now he will hire someone (for free offcourse Big Grin | :-D ), Who writes his biography on his behalf Smile | :)

He is Great Fan of Mr. Johan Rosengren (his idol),Lim Bio Liong, Nishant S and DavidCrow and Believes that, he will EXCEL in his life by following there steps!!!

He started with Visual C++ then moved to C# then he become language agnostic, you give him task,tell him the language or platform, he we start immediately, if he knows the language otherwise he quickly learn it and start contributing productively

Last but not the least, For good 8 years he was Visual CPP MSMVP!
Architect
United Kingdom United Kingdom
Passionate about refining software practices, promoting self-motivated teams and orchestrating agile projects.
Lives in London, UK and works as a .NET architect consultant in the City.

Blog AdamTibi.net.
Database Developer
Russian Federation Russian Federation
I've been developing medical information systems for five years. I mainly construct databases, write a database code and also back-end code.

MCITP: Database Developer 2008
MCSE: Data Platform
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 (Senior)
India India
iam software developer on dotnet....
now i am @ hyderabad
This is a Organisation (No members)

Software Developer
India India
Hi Iam software engineer working on asp.net,silverlight,c#.net,SQL Server.
. I am MCTS.
Software Developer (Senior) SPR Consulting
United States United States
Bryan has been solving business problems with software and Agile methodologies for over twelve years. He has experience in all aspects of the software development lifecycle, having directed multiple projects from client initiation through product delivery, deployment, and growth as a team member, manager or independent contributor. Bryan is also a Certified Scrum Master and Manager.
Software Developer
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.
Architect BI Software, Inc.
United States United States
A seasoned IT Professional. Programming and data processing artist. Contributor to StackOverflow.
Software Developer Intelligent Coding Solutions, LLC
United States United States
I enjoy coding like an excellent beer. My particular passion and experience lies in the realm of modeling and code generation. In the late 80s and early 90s, I was involved in early modeling and code generation tools that reached the marketplace, including a tool that modeled FORTRAN programs and generated FORTRAN for parallel supercomputer architectures, and a tool that managed Shlaer-Mellor models and generated C++ code. Over the years, I have applied Shlaer-Mellor, UML, and custom modeling and various code generation techniques to greatly benefit the development of enterprise applications.

My current passion and endeavor is to foster the evolution of model oriented development. In particular, I am passionate about evolving the Mo+ model oriented programming language and related model oriented development tools, with as much community input as possible to achieve higher levels in the ability to create and maintain code. The open source site is at https://github.com/moplus/modelorientedplus.
Software Developer Nexval Infotech 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.
This is a Organisation

1 members
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) Net Media - Kosovo
Albania Albania
Software developer since 1988 in many many languages: Basic, Assembler, Clipper, Visual Basic, C, C#, PHP... Plenty of experience in development, design and databases. Currently working on some iPhone applications projects. Net Media - Gjilan-Kosovo.
United States United States
Visual Basic Developer since version 1.0
Java web developer
Currently developing in vb and c#
Software Developer (Senior) n/a
Italy Italy
n/a
Ireland Ireland
Many years of experience in software design, development and architecture. Skilled in Microsoft .Net technology, Cloud computing, Solution Design, Software Architecture, Enterprise integration, Service Oriented and Microservices based Application Development. Currently, focusing on .Net Core, Web API, Microservices, Azure
Software Developer (Senior)
United States United States
Currently working as Application Development Consultant in USA
I love writing what i know about and learning from the mistakes which i make...
Database Developer
Hungary Hungary
2010-2012 - DB. Architect & Senior DB. Developer - www.livejasmin.com
2008-2010 - Senior DB. Developer - www.logmein.com
2006-2008 - DBA & DB. Developer - www.eurotaxglass.co.uk
Software Developer
Croatia Croatia
Programming without Reflection is like driving without a car.
Software Developer (Senior)
Israel Israel
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
It's good to do best whatever you are doing....
Developed Windows and Web based solutions using Microsoft Technologies C#,C++,VC++.Net,MS Sql Server,Biz Talk...
Canada Canada
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer Coderon Technologies
South Africa South Africa
Michiel du Toit is a software developer based in Bloemfontein, South Africa focusing on development using C# and SQL Server (both WinForms and ASP.NET).
Software Developer (Senior)
Singapore Singapore
A life-long-learner, maker and soft music fan. Likes building things to solve problems. Years of successful records serving mid and large scale .NET applications in domestic and international client environment. Expertise in different areas of software development life cycles and Software Architecture.

Always looks for new technology and loves to get hands dirty Smile | :)
Engineer
Portugal Portugal
My name is Nelson Souto, I develop software for fun and profit since 1992.
Architect
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 (Senior) @ CSC
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
This is a Organisation

8 members
Software Developer
India India
I do believe life is to help others ... So here i am .. in my spare time i learn new things of programming and try to help people with my knowledge .
I'm an energetic, self-motivated and hard-working Developer and Information Technology Professional with experience in projects, website design and development.

Visit My Technical Blog
Software Developer
Ukraine Ukraine
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
Enterprise developer with over 15 years of experience coding Windows and Web Apps in C#, WCF, SQL, EF, Http, Linq, etc. Enjoy middle-tier development on large BLL/DAL projects, also full SDLC for smaller projects needing single developer.

Currently live near Philadelphia although I've been working for the past 20 months for a large health-care provider in Pittsburgh.
Architect
China China
Over 10-years experience in using Microsoft technologies.
At present, working as the architect of a clustered real-time data delivery and visualization system, responsible for the design of component architecture, product packaging and deployment, also targeting private cloud solutions for future.
You must sign in to participate in this contest.
This contest has ended.
1 Jun - 30 Jun 2013