Click here to Skip to main content
15,074,668 members
This competition has ended

Best Database Article of July 2014

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.
24 Jul 2014
David Rogers Dev
Learn how to load related entities using the Entity Framework with simple examples
Please Sign up or sign in to vote.
15 Jul 2014
Jesús López Méndez
This article introduces you to client side multi-column dynamic pivot, a cleaner, simpler and elegant alternative to the complex and convoluted dynamic server side pivot.
Please Sign up or sign in to vote.
18 Jul 2014
Matthew Givens
How to change databases at run-time in a user-friendly manner.
Please Sign up or sign in to vote.
2 Jul 2014
Chakravarthi Elchuri
Display data in Multi nested gridview using C# in ASP.NET
Please Sign up or sign in to vote.
28 Jul 2014
DiponRoy
How to manage Entity Framework Code First in Real Time Projects
Please Sign up or sign in to vote.
19 Jul 2014
Tim Golisch
The Master database often seems to be the "Lost & Found" bin of the SQL Server world. There are two popular ways for preventing this kind of problem. Read on...
Please Sign up or sign in to vote.
30 Jul 2014
DiponRoy
How to handle database scheme changes with normal SQL scripts, without migration in Entity Framework code first
Please Sign up or sign in to vote.
21 Jul 2014
Phil Jeffrey
How to run a ClickOnce app as Administrator on Windows 8 when the app includes a SQL Compact database
Please Sign up or sign in to vote.
9 Jul 2014
Jason Parms
Lightweight Directory Access Protocol (LDAP) Injection
Please Sign up or sign in to vote.
2 Jul 2014
Mattintosh
How to create a formatted column with nothing more than a knowledge of which columns you want and the format you want them in
Please Sign up or sign in to vote.
22 Jul 2014
Rocky R. Fernandes
Install Rails 4 and MySQL Server on Windows 7/8
Please Sign up or sign in to vote.
1 Jul 2014
Ryszard Dżegan
How to get around restrictions for parameters in OLE DB connection type while working with SSIS and BIDS.
Please Sign up or sign in to vote.
29 Jul 2014
Ajit Kumar Thakur Microsoft
This article explains the step by step process to learn MDX query. It will help user to read data from OLAP cube.
Please Sign up or sign in to vote.
26 May 2016
peterswinkels
Query Assistant - connect to databases with ADO and execute queries
Please Sign up or sign in to vote.
18 Jul 2014
Ajit Kumar Thakur Microsoft
This tip contains simple step by step solution to read SSAS cube data using MDX query and display in SSRS report.
Please Sign up or sign in to vote.
3 Jul 2014
Dave Elliott
Find the column information of a SQL query
Please Sign up or sign in to vote.
13 Jul 2014
Anton Kaminsky
Easy way to call a native COM method which has a parameter of type: HWND from C# code
14 Jul 2014
Redgate Software
If you’re thinking about adopting database source control, or have a system but aren’t using it consistently yet, here are seven tips to avoid deployment disasters.
Please Sign up or sign in to vote.
30 Jul 2014
Debopam Pal
How to run SQL script containing DDL, DML, Select statements and PL/SQL block through reader in Java
Please Sign up or sign in to vote.
11 Jul 2014
Arindam Jha
Understanding of complex jQuery Datatable tricks and Save it's state in SQL Server with a basic concepts of jQyuery template. Sample Application used .NET 4.5, Entityt Framework.
Please Sign up or sign in to vote.
25 Jul 2014
Ajit Kumar Thakur Microsoft
This article explain step by step approach to implement SSAS Cube.
Please Sign up or sign in to vote.
20 Mar 2015
Sreekanth Mothukuru
SQL CLR functions
Please Sign up or sign in to vote.
20 Jul 2014
Mubin M. Shaikh
This Article will give you a good start for Creating SSRS Report First time with SQL Server Analysis Services OLAP Cube
Please Sign up or sign in to vote.
23 Jul 2014
Matthew Katakam
ASP.NET MVC Edit Primary Key Values for Composite Keys
Please Sign up or sign in to vote.
27 Jul 2014
Emiliarge
How to send data to device and receive data from device through COM-port
Please Sign up or sign in to vote.
11 Jul 2014
CatchExAs
Using evolutionary techniques to deduce an optimal poker strategy
Please Sign up or sign in to vote.
5 Aug 2014
a.alghabban
using ADO.net
Please Sign up or sign in to vote.
14 Jul 2014
Sandeep Singh Shekhawat
How to get the last inserted identity value of an auto increment column of database tables using SQL Server variable (@@IDENITY) and functions (SCOPE_IDENTITY() and IDENT_CURRENT())
Please Sign up or sign in to vote.
16 Oct 2014
Omar Al Zabir
SQL Server Performance Dashboard (SSPD) is a small open source web app that shows you performance & problems of one or more SQL Server instances and their databases in near real time.
Please Sign up or sign in to vote.
9 Jul 2014
Arun Ramachandran India
How to write stored procedures with output parameters in SQL Server
Please Sign up or sign in to vote.
11 Jul 2014
LM Heah
MongoDB Hadoop Hortonworks in Windows Server 2008
Please Sign up or sign in to vote.
29 Jul 2014
Kundan Singh Chouhan
This article is all about of my developed entity framework pattern named “K-Pattern”
Please Sign up or sign in to vote.
21 Jul 2014
_Asif_
Article will demonstrate how to develop generalize framework for creating Outlook style Auto Refresh Count of Menu Items
Please Sign up or sign in to vote.
4 Jul 2014
mengwangk
Android phone as webcam or remote surveillance camera through Skype
Please Sign up or sign in to vote.
11 Dec 2016
Ștefan-Mihai MOGA
Did you spot any bugs today? Than this tool might save some of your time
Please Sign up or sign in to vote.
22 Jul 2014
DiponRoy
How to post rowversion or timestamp of MsSQL using jquery
Please Sign up or sign in to vote.
23 Jul 2014
Ajit Kumar Thakur Microsoft
This article describes concepts and terminologies used in Datawarehouse. This will help beginners to understand datawarehouse concepts. This will also help developers who wish to design and develop SSAS cube, design data model of datawarehouse system.
Please Sign up or sign in to vote.
21 Jul 2014
congiuluc
In this article I explain step by step how to migrate users from ASP.NET Membership to ASP.NET Identity
Please Sign up or sign in to vote.
22 Jul 2014
kasbaba
This tip is to help anyone trying to split strings in SQL into Rows and Columns based on Row/Column Delimiters
Please Sign up or sign in to vote.
25 Jul 2014
henry sentio kauta
Android at figure tips
Please Sign up or sign in to vote.
15 Jul 2014
anki.mathur
Restart hanged SQL Server scheduled job
Please Sign up or sign in to vote.
20 Jul 2014
SREENATH GANGA
How to change the DBservername ,DBName ,password,Userid etc of a crystal report at runtime
Please Sign up or sign in to vote.
25 Jul 2014
Kumarbs
In this article we are going to see how we can consume a web api which is hosted on Cloud Azure service

Current Participants

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

_Asif_
Architect Avanza Solutions
Pakistan Pakistan
Asif has started programming back in 1991 on 80286 8-16 MHZ systems. Started from dBase III+, FoxPro, C, assembly (exceptional skills in Assembly language have added a significant confidence in his development career). The programming saga continues exploring new technologies and languages ranging from C++, VC++, Java, Delphi, RPG400, SQL Server, Oracle to name a few and the exploration still continues to DOT Net Technologies, SOA architectures, BI, DSL, etc. These learning experiences are backed by strong theoretical background with a flavor of research.

Asif show significant interest in reading fiction, bio technology, Astronomy. He Loves watching movies and in free time love to play with his kids.
DiponRoy
Bangladesh Bangladesh
No Biography provided
a.alghabban
Software Developer
Saudi Arabia Saudi Arabia
No Biography provided
Ajit Kumar Thakur Microsoft
Database Developer Microsoft
India India
I am Ajit Kumar Thakur. I am Consultant in Microsoft Global Delivery India. I work on Database (SQL Server), BI (SSAS, SSRS,SSIS),and Windows Powershell. I have 8 years of experience in Database and BI project development.
anki.mathur
Software Developer (Senior)
India India
No Biography provided
No Biography provided
Arindam Jha
Software Developer (Senior)
India India
No Biography provided
Arun Ramachandran India
Software Developer
India India
Arun Ramachandran is a Software Engineer having hands on experience in different Microsoft Technologies who is presently working in Experion Technologies, India. He has written over 95 articles on the subject on his blog at http://BestTEchnologyBlog.com. Along with 3 years of hands on experience he holds a Master of Computer Applications degree from Cochin University of Science & Technology (CUSAT).
CatchExAs
Technical Lead Alpha Integralis Limited
United Kingdom United Kingdom
CatchExAs aka Nick Wilton runs Alpha Integralis, a software development consultancy to companies in the City of London.

Main interests include exploring Algo-Trading, Quant Development and Physics using C# and Java.

www.nickwilton.info/Blog
Chakravarthi Elchuri
Software Developer
India India
Having good experience of developing code for CTI, Scanner, Cammera, Interactive maps for IRP(International Registration Plan)integration and 311 service request maps using different Geocoding API providers.
congiuluc
Web Developer
Italy Italy
I am an Italian developer specialized on ASP.NET web applications.
I consider myself a lucky person because my work coincides with my passion: Develop code!
I began to develop code from the age of about ten years with the infamous Commodore 64.
My turning point was the advent of the internet since 1995 and I started to develop websites first static and then dynamic (ASP) before moving to. NET platform since then ... I do not have more 'stopped!
Dave Elliott
Software Developer (Senior) Webbert Solutions
United States United States
Dave is an independent consultant working in a variety of industries utilizing Microsoft .NET technologies.
David Rogers Dev
Software Developer
Australia Australia
A mid-level developer writing .NET code to provide business solutions to a wide range of customer requirements.
Debopam Pal
Software Developer National Informatics Centre (NIC)
India India
Hello! Myself Debopam Pal. I've completed my MCA degree from West Bengal University of Technology at 2013. I'm from India. I’ve started to work with MS Technologies in 2013 specially in C# 4.0, ASP.NET 4.0. I've also worked in PHP 5. Now I work in JAVA/J2EE, Struts2. Currently I'm involved in a e-Governance Project since Jan, 2014. In my leisure time I write Blog, Articles as I think that every developer should contribute something otherwise resource will be finished one day. Thank you for your time.

Visit: Linkedin Profile | Facebook Profile | Google+ Profile | CodeProject Profile
Emiliarge
Software Developer
Russian Federation Russian Federation
Want to contribute my CodeProject articles and tips? Write my e-mail: emiliarge@mail.ru
No Biography provided
Jason Parms
Technical Lead SSL2BUY Inc.
United States United States
Jason Parms is customer service manager at SSL2BUY Inc. His key responsibility is maintaining customer happiness by providing help desk resources and technical guidance, resolution for customer troubles, detecting and diagnosing network problems and managing staff. As a part of online security industry, He is always update knowledge by contributing in cyber security events, reading information security publications, maintaining personal networks, examine information and applications, participate in security surveys.

Official Website:- https://www.ssl2buy.com
Jesús López Méndez
Architect i-nercya intelligent software
Spain Spain
Working on i-nercya intelligent software as a Database Administrator, IT Manager and Software Architect.

I developed my first programs 30 years ago in BASIC on a CASIO PB 100 programmable calculator which had 1.5 Kb of RAM (with extended memory, factory version had 512 bytes of RAM). Later I programmed on a Commodore 64 micro computer, data was stored on a music-like magnetic tape. Oh My!

I worked for the Spanish Air Force, I have a master degree on aeronautical engineering after all. But making software is my passion.

My other passions are dancing tango and ballroom, cooking good food and watching cinema. And of course and mainly, to love my girlfriend and my daughter.

I also worked on Solid Quality Mentors where my job was SQL Server consulting. I optimized lot of queries on that job. I also worked teaching SQL Server.

I was a Visual Basic MVP during three years several years ago. But I think I don't remember VB sintax anymore, c# is my development language now.
kasbaba
United States United States
No Biography provided
Kumarbs
Software Developer (Senior)
India India
I am passion about the technology and coding. I would like to expose myself with the contemporary technology.
Kundan Singh Chouhan
Software Developer (Senior)
India India
Eager to contribute highly applicable application development skills and ability to personalize service delivery to analyzing business needs and translating them into executable strategies.
LM Heah
Malaysia Malaysia
No Biography provided
No Biography provided
Matthew Givens
Software Developer (Senior)
United States United States
Matthew Givens has been a software developer since 1988, and has worked for numerous companies over the years. He currently works in the healthcare industry, developing with C# .NET and Sql-Server.
Matthew Katakam
Software Developer (Senior) Archdiocese of Melbourne
Australia Australia
As a software developer working for a Catholic Organisation I look at programming as a knowledge to help people and resolve social issues. I am very firm believer in simple solutions to complex issues. I had been in IT industry for more than 13 years worked as an Operations Analyst, Business Analyst and now as a web programmer. I always like to learn new technologies and passionate about helping others.
Mattintosh
United States United States
No Biography provided
mengwangk
Software Developer (Senior)
Malaysia Malaysia
A programmer for a long time, and still learning everyday.

A supporter for open source solutions, and have written quite a few open source software both in .NET and Java.

https://mengwangk.github.io/
mkalos
Software Developer (Senior)
Slovakia Slovakia
No Biography provided
Mubin M. Shaikh
Architect Cybage Software Pvt. Ltd.
India India
Microsoft® Certified Professional (Microsoft Certification ID: 8918672).

Microsoft Certified Technology Specialist with more than 14+ years of experience to architect effective solutions for various Analytical, Reporting & Visualization requirement using MS. BI toolkit, Data warehouse & Various heterogeneous source systems On-Premise or Cloud

Technology :
(MS.BI, SSIS, SSAS, SSRS, SQL-Server, MySQL, Pentaho, Talend, Data Warehouse, Tableau, Power BI, Qlikview, Azure Synapse, Google BigQuery, Snowflake DW, Redshift, C#.Net, ASP.Net)
Domain : Sales, Retail, CRM, Public Transport, Media & Entertainment

Linked In Profile:

Click Here to View Linked In Profile

Change Will Not Come If We Wait for Some Other Person,or Wait for Some Other Time, We are the One We are Waiting For,We are the Change That we Seek.
peterswinkels
Netherlands Netherlands
No Biography provided
Phil Jeffrey
Software Developer Jeffrey Technology
Australia Australia
This member doesn't quite have enough reputation to be able to display their biography and homepage.
Redgate Software
Red Gate Software Ltd.
United Kingdom United Kingdom
Redgate makes ingeniously simple software used by 804,745 IT professionals and counting, and is the leading Microsoft SQL Server tools vendor. Our philosophy is to design highly usable, reliable tools which elegantly solve the problems developers and DBAs face every day, and help them adopt database DevOps. As a result, more than 100,000 companies use products in the Redgate SQL Toolbelt, including 91% of those in the Fortune 100.
Group type: Organisation

1 members

Rocky R. Fernandes
Software Developer (Senior) 3MD Tech
United States United States
Rocky Fernandes has over 11 years of experience in Software Industry mostly developing Web Applications. Other than having vast experience in various Microsoft Technologies like SharePoint, ASP.Net, C#, VB.Net, Silverlight, WCF, MVC, Web API, SQL Server, ADO.Net, ADOMD.Net, LINQ, Entity Framework, Exchange Web Service(EWS) API, he also has vast experience in Client Side Scripting like JavaScript, jQuery, JSON, JSONP, CSS and HTML5. He is very much passionate in programming and enjoys doing it. In the academic side he holds a BE Degree in Computer Science & Engineering. In the certification side he holds certifications in Sharepoint 2010, SharePoint 2013, ASP.Net & SQL Server.

In most of the free time, he will be spending in technical activities like researching solutions, reading technical articles and learning new stuff. He believes that following Best Practices and Coding standard is a way to go for producing an efficient, quality & satisfactory application.

Homepage: http://www.smartsolutionshub.com/
Ryszard Dżegan
Software Developer GFT
Poland Poland
No Biography provided
Sandeep Singh Shekhawat
Software Developer
India India
He is awarded for Microsoft TechNet Guru, CodeProject MVP and C# Corner MVP. http://l-knowtech.com/
SarmadAsghar
Team Leader VF
Pakistan Pakistan
No Biography provided
Sreekanth Mothukuru
Technical Lead
India India
No Biography provided
SREENATH GANGA
Software Developer
United Arab Emirates United Arab Emirates
No Biography provided
Ștefan-Mihai MOGA
Software Developer NXP Semiconductors
Romania Romania
My professional background includes knowledge of analyst programmer for Microsoft Visual C++, Microsoft Visual C#, Microsoft Visual Basic, Sun Java, assembly for Intel 80x86 microprocessors, assembly for PIC microcontrollers (produced by Microchip Inc.), relational databases (MySQL, Oracle, SQL Server), concurrent version systems, bug tracking systems, web design (HTML5, CSS3, XML, PHP/MySQL, JavaScript).
Tim Golisch
Architect
United States United States
I have been programming for 30 years(22 professionally). I mostly work with the Microsoft product stack (.NET, SQL Server, IIS, ASP.NET, Dynamics, TFS, etc) however, I have worked with a wide variety of others too (IBM DB2, Oracle, Java, PHP, ColdFusion, Perl, etc). I have taught classes at community colleges, and other speaking engagements. During the day, I am a consultant, programming and fixing programs.

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. Multiple votes from the same IP will be automatically disqualified.
  11. The judges’ decision is final and no correspondence will be entered into.
  12. Only those who live in jurisdictions in which this contest is legal may enter.
  13. Any breach of the rules and the prize will be awarded to the runner up.
  14. 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.
  15. 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 Jul - 31 Jul 2014