Click here to Skip to main content
15,885,782 members
This competition has ended

Best Database article of August 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.
5 Sep 2013Mubin M. Shaikh
Create time dimension with 24 hour plus values and time buckets in your data warehouse
Please Sign up or sign in to vote.
2 Aug 2013rusanu
This article will help you write better database code and will help you get started when you have to investigate performance problems.
Please Sign up or sign in to vote.
8 Aug 2013adriancs
Silverlight access to MySQL using Web Services.
Please Sign up or sign in to vote.
10 Aug 2013Manas Bhardwaj
How to extract table data from Word document using Aspose Words
Please Sign up or sign in to vote.
5 Sep 2013Mubin M. Shaikh
Manually Run SSRS Scheduled Reports
Please Sign up or sign in to vote.
8 Aug 2013h_wiedey
An approach using updatable views with check option and deferred constraint checking.
Please Sign up or sign in to vote.
27 Aug 2013Måns Tånneryd
This tip shows how to significantly speed up inserts of large amounts of data using the entity framework.
Please Sign up or sign in to vote.
26 Aug 2013Måns Tånneryd
This tip shows how to speed up inserts using POCO objects and the entity framework version 5.
Please Sign up or sign in to vote.
6 Aug 2013Keyhole Software
An argument against defaulting to auto-increment primary keys
Please Sign up or sign in to vote.
5 Aug 2013Zhuyun Dai
Fix multiple SQL Server DTC errors when we use distributed transactions between VMs duplicated from the same template on Hyper-V
Please Sign up or sign in to vote.
27 Aug 2013shivaramakrishnaReddy
Get time difference in the format "HH:MM:SS" for two different DateTime values in SQL Server.
Please Sign up or sign in to vote.
4 Mar 2014Haydn Chapman
A method to update a table column with a random set of specified values
Please Sign up or sign in to vote.
25 Aug 2013Atul_Kapoor
Steps for deploying Restart Health Check script in a SQL Server environment.
19 Aug 2013PowerAdmin
Top 5 reasons you want a server monitoring software solution
Please Sign up or sign in to vote.
5 Sep 2013Mr. xieguigang 谢桂纲
Easy way to map the table in the mysql database.
Please Sign up or sign in to vote.
9 Aug 2013groggyjava
SQL 2012 Code Snippet for quick blank transaction
Please Sign up or sign in to vote.
26 Aug 2013Atul_Kapoor
SQL Server Reporting database migration from SQL Server 2005 to SQL Server 2008 R2
Please Sign up or sign in to vote.
27 Aug 2013hmdmgd3
SQL code allows you to find objects using multiple keywords in your DB
Please Sign up or sign in to vote.
24 Aug 2013Hasan Habib Surzo
Basic Server/Client Example using Windows Communication Foundation (WCF) programming
Please Sign up or sign in to vote.
4 Jun 2019Sacha Barber
An example application using angular/Rx for JavaScript/Web Sockets/jQuery
Please Sign up or sign in to vote.
12 Oct 2013Dr. Song Li
This is part 2 of a comparison on Data Access methods in the .NET environment.
Please Sign up or sign in to vote.
10 Jan 2018Amir Jalilifard
In this article, you are going to learn about P2P Network and Windows Communication Foundation to share your files between peers through a P2P network.
Please Sign up or sign in to vote.
1 Sep 2013Sudhanshu SP Gupta
A multilevel puzzle game to apply some arrangement through touch and click to destroy every target under given tap chances !!
Please Sign up or sign in to vote.
4 May 2014Shuqian Ying
Service based, multi-application ASP.NET custom membership, role and profile providers with a hierarchical role system.
Please Sign up or sign in to vote.
20 Aug 2013Nitin Singh India
Merge data in SQL Server.
Please Sign up or sign in to vote.
22 Aug 2014Gurdeep Singh Toor
A Complete Guide to develop aplication using MyGeneration code genration framework. We will develop a Meeting Room Booking web application in this Article.
Please Sign up or sign in to vote.
10 Aug 2013Srinivas Kalabarigi
Column values as comma separated string in SQL
Please Sign up or sign in to vote.
31 Aug 2013TheCodeKing
Everything you ever wanted to know about why SimpleMembershipProvider does not work as a MembershipProvider.
Please Sign up or sign in to vote.
9 Aug 2013Azim Zahir
This article explains working with SQL Server 2012 Express LocalDB.
Please Sign up or sign in to vote.
30 Sep 2013Florian Rosmann
COM Interop using a little post compiler. As a result, it is possible to use multithreading in combination with COM interfaces.
Please Sign up or sign in to vote.
16 Feb 2015DrABELL
Her Most Significant Bit™ NY-2013, All-in-One/Win8 (AIC-2013 FINALIST app)
Please Sign up or sign in to vote.
2 Aug 2013AlbertoLeon CSharpMan
Insert Ignore with select thousands of rows threw timeout expired exception
Please Sign up or sign in to vote.
31 Oct 2018Aydin Homay
In this article, we will discover the power of generics in C#.
Please Sign up or sign in to vote.
19 Aug 2013S.P.Tiwari
Find all the days between two dates using SQL Server
Please Sign up or sign in to vote.
5 Aug 2013Bikash Prakash Dash
How to highlight search text in a search result using ASP.NET
Please Sign up or sign in to vote.
18 Aug 2013Maxim Rudoi
A simple way to create an XML file from SQL Server tables using SSIS
Please Sign up or sign in to vote.
6 Aug 2013adriancs
Settings and Configurations of MySQL Connector/Net ASP.NET Session State Provider
Please Sign up or sign in to vote.
20 Aug 2013Sivaji1565
This article briefly explains about resizing of custom task panes in Execl/Word/powerpoint
Please Sign up or sign in to vote.
20 Dec 2016BharatRamV
Finds the Best Table for a given set of columns
Please Sign up or sign in to vote.
23 Aug 2013Venkat Krishna Turlapati
Powershell script to copy files greater than certain date

Current Participants

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

Software Developer
Other Other
Programming is an art.
Technical Lead Get Me An Apartment
Spain Spain
I'm developer fall in love with C#, .NET and Mono.
Designing and programming websites since 2001.
I like literature (to read and to write), playing football (soccer)... and of course I'm great fan of La Roja (Spain football team)

At now I work in GetMeAnApartment, I do Research and Development features to upgrade our website (asp.net, MVC, MySQL) and business model (rental short stay apartments)


My Knowledge:
LANGUAGES: C#, XML, HTML, JavaScript, ActionScript, php, VisualBasic Script

TECHNOLOGIES: asp.net, asp.net mvc, php, flash, GTK#

APPLICATIONS: wordpress, wikimedia, I programmed modules for Macromedia Flash MX for myself

FRAMEWORKS: .Net Framework, Mono

SERVERS: IIS, apache2

SO: Windows, Debian

SOFTWARE: Visual Studio 2010, 2008. Monodevelop. Glade. Illustrator. Indesign. Photoshop. Dreamweaver.


Employment:

GetMeAnApartment
IT Director and website developer, 2010 - present

Círculo Rojo Publicidad y Comunicación
IT Director and websites developer, 2007 - 2010

Dédalo Creative
Co-founder,Programmer and Developer, Graphical designer 2006 - 2007

Costa Mediterránea Comunicación
Chief writer, 2004 - 2006

Stalker Creacion
Web designer and developer, 2001 - 2003

Education
Myself
Designer and Programmer, 2001 - present

Jaime I, University
Advertising, 2000 - 2005
Student UFMG
Brazil Brazil
I am a PhD candidate in computer science. I started software development since 2006 and it seems like now it consumes most every part of my life. My life is my computer and solving problems, more specifically computational-mathematical problems, is my passion.I mostly enjoy areas like Machine Learning, Big Data and Brain-Computer Interface (BCI). My major goal in my life is becoming a person who utilizes everything he knows to improve human life quality. I also like hiking and reading self-development books.
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) BHGE
Germany Germany
I worked as a software engineer and researcher in different countries with a wide range of related projects and engineers from all around the world. I was involved in Oil&Gas, Telecommunication, Transportation, and Semiconductor projects and played various roles such as junior, senior, and lead engineer both in embedded and non-embedded devices and technologies.

During my professional carrier, I was directly involved in designing and maintaining editor, compiler, and interpreter for IEC 611131-3 (PLC programming standard) and fault-tolerant communication layer for distributed automation standard IEC 61499, and many other projects such as DCS (Distributed Control Systems), (SCADA) Supervisory Control and Data Acquisition System, Oilfield (CMS) Computerised Maintenance Systems, Oil&Gas Laboratory Automaton Systems, and Semiconductor Equipment Connectivity Solutions.

Currently, I pursue a Ph.D. degree in Computer Science in the Technical University of Dresden and works as a software engineer in Germany. Beside, I am a certified specialist in Microsoft technologies since 2011.

My main research and work areas are Industrial Communication and Automation Systems, Real-Time Systems, Service-Oriented Systems, IEC 61131-3, IEC 61499, and Distributed Embedded Systems.
Instructor / Trainer NIIT, India
India India
I am a trainer by profession. Currently I am working with iFuture Technologies(India) as a Senior Faculty. I enjoy programming as a hobby. During my career I have seen the growth and decline of many technologies, many of them being my favorites like Flash, WPF, Windows Mobile Development. Few of my current favorites are Android, Xamarin and Python, though I also like traditional and evergreen languages like PHP, C#, Visual Basic and Java.

Apart from computers, my favorite pastime is bicycling.
Software Developer (Senior)
India India
Software Application Developer with 9+ years of experience.
Software Developer (Senior)
India India
United States United States
I have been working in the IT industry for some time. It is still exciting and I am still learning. I am a happy and honest person, and I want to be your friend.
Engineer
United States United States
Dr. Alexander Bell (aka DrABell), a seasoned full-stack Software (Win/Web/Mobile) and Data Engineer holds PhD in Electrical and Computer Engineering, authored 37 inventions and published 100+ technical articles and developed multiple award-winning apps (App Innovation Contests AIC 2012/2013 submissions) Alexander is currently focused on Microsoft Azure Cloud and .NET 6/8 development projects.

  1. HTML5/CSS3 graphic enhancement: buttons, inputs
  2. HTML5 Tables Formatting: Alternate Rows, Color Gradients, Shadows
  3. Azure web app: Engineering Calculator VOLTMATTER
  4. Azure: NYC real-time bus tracking app
  5. Quiz Engine powered by Azure cloud
  6. 'enRoute': Real-time NY City Bus Tracking Web App
  7. Advanced CSS3 Styling of HTML5 SELECT Element
  8. Aggregate Product function extends SQL
  9. YouTube™ API for ASP.NET
Austria Austria
Florian Rosmann, 18 years old, student from austria.
Web Developer
United States United States
This member doesn't quite have enough reputation to be able to display their biography and homepage.
Software Developer (Senior)
Ireland Ireland
Gurdeep is graduated from National College of Ireland. He has been involved in application development since 2006 & has experience in software solutions across multiple business sectors such as Transportation, Company Registry & Telecoms. He is always keen to learn and keep up to date with the Software development world. Gurdeep is currently working as a Software Developer in Dublin (Ireland) in a Telecoms Company.

Apart from I.T. he is a big fan of Music & love to play Cricket. He is an active member of a local Cricket Club (Adamstown Cricket Club - www.adamstowncricketclub.ie).
Germany Germany
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer (Senior)
Bangladesh Bangladesh
I am very positive about life and a born explorer. I set my personal goal to be a good human being,
Software Developer unknown
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.
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.
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
Architect
Netherlands Netherlands

Read my personal blog at www.manasbhardwaj.net.

Software Developer (Senior) Tånneryd IT AB
Sweden Sweden
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer Taldor
Israel Israel
I work at Taldor as a computer programmer. I write code mostly in C# and also in VB.NET
I deal a lot with SQL Server databases and T-SQL.
When I studied programming in 1993-1995 it was C++ and Visual Basic 6. Good old memories Smile | :)
Technical Lead PANOMIX
China China
He is good and loves VisualBasic! Senior data scientist at PANOMIX


github: https://github.com/xieguigang
Architect Cybage Software Pvt. Ltd.
India India
Microsoft® Certified Professional (Microsoft Certification ID: 8918672).

Microsoft Certified Technology Specialist with more than 16+ years of expertise to architect and implement effective solutions for Data Analytics, Reporting and Data Visualization solutioning need on Azure Cloud or On-Premise

Technology :
Azure (Data Lake, Data Factory, Synapse Analytics, Databricks, SQL),
Microsoft BI (SSIS, SSAS, SSRS, SQL-Server), C#.Net, Pentaho,
Data Warehousing, Dimension modelling, Snowflake DW, SQL DW, MySQL
Data Visualization using (Tableau, Power BI, QlikView, Pentaho),
Domain : Sales, Retail, CRM, Public Transport, Media & Entertainment, Insurance
Data Integration and Analytics Experience with MS. Dynamic CRM, Salesforce CRM, Dataverse, SAP- FI, Dynamics AX etc.

Linked In Profile:
Click Here to View Linked In Profile

Change will not come if we keep waiting for some other person !!, or keep waiting for some other time !!, We are the one we are waiting for, We are the change that we are looking for.
Architect Infosys Technologies Ltd.
India India
Nandha Venkateswaran, Principal Technology Architect at Infosys, whose profession has rubbed onto her passion for technology which helped her in being innovative, collaborative, enthusiastic, agile to achieve great results
Technical Lead 3PillarGlobal
India India
I am a solutions lead working on .NET for about 10 years, focusing on core framework implementations in project. My development interests are in middle tier and backend components and sometimes, identifying design elements for technical solutions. Apart, I collect coins and stamps and do photography whenever I get a chance.
Technical Writer Power Admin LLC
United States United States
Power Admin LLC has been building professional grade system monitoring products for many years. Our products are used by Fortune 500 companies, SMBs, government entities and educational institutions all around the world.

Why?

Some of us have worked in IT. It can be stressful. Life is hard enough -- we are striving to remove as much stress for our customers as we can by creating products that really help and simplify. It might sound sappy, but we hope to get more people home in the evening for dinner with their families. And we are on a quest to build the very best monitoring software in the world. We're not there yet, but we're always getting closer.

What?

Our flagship product PA Server Monitor has an enthusiastic following because of its simplicity and power. One of our favorite unsolicited customer quotes is: "You don't know how much money and time you guys have saved us." That's what it's all about!

Power Admin LLC is a privately held, debt-free company. We are profitable, cash-flow positive, and don't have outside investors -- that means we can take the long view on all decisions. We don't sacrifice long term potential for short term gain. We are going to be around for a very long time. Smile | :)

We are a U.S. company based in the beautiful Kansas City area.

Our Promise

Our products will go through extensive beta testing involving many external testers. We will not release our software until these testers tell us it's ready. We'll also make every effort to find problems.

If serious bugs are reported in the current version of our software, a fix will be made as soon as possible (higher in priority than any other new features), and free of charge.

We will build our software based on the needs of our customers. We welcome feature suggestions and critical input and take it seriously. Drop us a line! Contact Us
Visit our blog at Network Wrangler
This is a Organisation (No members)

bugcollect.com
United States United States
Remus Rusanu is a developer with the SQL Server team.
Software Developer (Senior)
India India
Play with programming languages and Technologies....
(C#,C++,JAVA,PYTHON,PL/SQL,T-SQL,Shell Scripting,SQL)
Software Developer (Senior)
United Kingdom United Kingdom
I currently hold the following qualifications (amongst others, I also studied Music Technology and Electronics, for my sins)

- MSc (Passed with distinctions), in Information Technology for E-Commerce
- BSc Hons (1st class) in Computer Science & Artificial Intelligence

Both of these at Sussex University UK.

Award(s)

I am lucky enough to have won a few awards for Zany Crazy code articles over the years

  • Microsoft C# MVP 2016
  • Codeproject MVP 2016
  • Microsoft C# MVP 2015
  • Codeproject MVP 2015
  • Microsoft C# MVP 2014
  • Codeproject MVP 2014
  • Microsoft C# MVP 2013
  • Codeproject MVP 2013
  • Microsoft C# MVP 2012
  • Codeproject MVP 2012
  • Microsoft C# MVP 2011
  • Codeproject MVP 2011
  • Microsoft C# MVP 2010
  • Codeproject MVP 2010
  • Microsoft C# MVP 2009
  • Codeproject MVP 2009
  • Microsoft C# MVP 2008
  • Codeproject MVP 2008
  • And numerous codeproject awards which you can see over at my blog
Technical Lead Softedge Systems LTD
Ireland Ireland
 Experienced software professional with 7 years+ on Microsoft Technology.
 Knowledge of SDLC (System Development Life Cycle).
 Technical Team Member experience leading application development on both short and long term projects.
 Good team player with excellent work history as regards with work ethics, dependability and willingness to go an extra mile.
 Good knowledge of IIS Hosting and Domain management.
 Extensive knowledge of ASP.Net, C#.Net, VB.Net, SQL Server, SharePoint development using SharePoint Web Services and SharePoint administration, Business Intelligence & KPIs (Configuration and Creation) Web Parts, Data View Webparts, Integration of External Sources content types, Site Definition, Site templates, Workflow development, customizing and branding a SharePoint portal sites and branding.
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.
Founder CryptoGateway Software Inc.
Canada Canada


His interests in software research and development include security, domain specific meta-language development technologies and tools, meta-language driven code generation, generation of non-invasive and virtual SQL database for "un-structured" data (sqlization), automated relational data service production technologies, file system sqlization technologies and products, structured multi-lingual documentation tools and technologies, sqlization of user's personal data, like emails, etc..


He was a physicist before year 2000. He studied theoretical physics (the hidden symmetry between the past and future, quantum field theories, mirror universe, cosmological dark energies etc.) in which he think to had made fundamental breakthroughs[^] but the community is either not ready for it or is actively rejecting/ignoring it Smile | :) .



It struck me on Apr. 11, 2023 that the said theory above can even generate General Relativity naturally after a recent discussion in the Insider News group that triggers a rethinking of the subject on my side. The first stage of the work is completed in Sept. 2023, it is and will be continue to be published online

  • On Vacuum
  • Quantum and Gravity







    Most recent software system to share:



    • V-NET[^] - Full stack virtualization management system including networking, storage, virtual machines and containers, with an emphasis on networking ... to be released.
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.
Program Manager
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
India India
Hello
I am a student currently studying Computer Science & Engineering in BIET Jhansi, and a Microsoft Student Partner.
I have worked on ASP.NET, windows phone and windows 8 and part time on Blackberry.I have been developing apps for windows phone from past 2years and windows 8 from 1 year and i like to develop games and some of my games are here which I have developed for windows phone and windows 8.
My windows phone Apps- http://www.windowsphone.com/en-in/search?q=sudhanshu%20gupta

My Windows 8 Apps-

1. Learn Alphabets and Numbers-http://apps.microsoft.com/windows/app/learn-alphabets-numbers/88a28cf3-9aad-405a-8379-54bb7b028003

2. Hitball-http://apps.microsoft.com/windows/app/hit-ball/deec5ced-172d-4f16-95e3-1331d9897a01

3.Quick Ball-http://apps.microsoft.com/windows/app/quick-ball/76c9a2c5-63d9-4705-8d7f-cbd8089c3fc4
Architect
United Kingdom United Kingdom
Mike Carlisle - Technical Architect with over 20 years experience in a wide range of technologies.

@TheCodeKing
Database 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
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 Aug - 31 Aug 2013