Click here to Skip to main content
15,033,111 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 2013
Mubin 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 2013
rusanu
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 2013
adriancs
Silverlight access to MySQL using Web Services.
Please Sign up or sign in to vote.
10 Aug 2013
Manas Bhardwaj
How to extract table data from Word document using Aspose Words
Please Sign up or sign in to vote.
5 Sep 2013
Mubin M. Shaikh
Manually Run SSRS Scheduled Reports
Please Sign up or sign in to vote.
8 Aug 2013
h_wiedey
An approach using updatable views with check option and deferred constraint checking.
Please Sign up or sign in to vote.
27 Aug 2013
Må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 2013
Må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 2013
Keyhole Software
An argument against defaulting to auto-increment primary keys
Please Sign up or sign in to vote.
5 Aug 2013
Zhuyun 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 2013
shivaramakrishnaReddy
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 2014
Haydn 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 2013
Atul_Kapoor
Steps for deploying Restart Health Check script in a SQL Server environment.
19 Aug 2013
PowerAdmin
Top 5 reasons you want a server monitoring software solution
Please Sign up or sign in to vote.
5 Sep 2013
Mr. xieguigang 谢桂纲
Easy way to map the table in the mysql database.
Please Sign up or sign in to vote.
9 Aug 2013
groggyjava
SQL 2012 Code Snippet for quick blank transaction
Please Sign up or sign in to vote.
26 Aug 2013
Atul_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 2013
hmdmgd3
SQL code allows you to find objects using multiple keywords in your DB
Please Sign up or sign in to vote.
24 Aug 2013
Hasan Habib Surzo
Basic Server/Client Example using Windows Communication Foundation (WCF) programming
Please Sign up or sign in to vote.
4 Jun 2019
Sacha Barber
An example application using angular/Rx for JavaScript/Web Sockets/jQuery
Please Sign up or sign in to vote.
12 Oct 2013
Dr. 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 2018
Amir 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 2013
Sudhanshu 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 2014
Shuqian 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 2013
Nitin Singh India
Merge data in SQL Server.
Please Sign up or sign in to vote.
22 Aug 2014
Gurdeep 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 2013
Srinivas Kalabarigi
Column values as comma separated string in SQL
Please Sign up or sign in to vote.
31 Aug 2013
TheCodeKing
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 2013
Azim Zahir
This article explains working with SQL Server 2012 Express LocalDB.
Please Sign up or sign in to vote.
30 Sep 2013
Florian 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 2015
DrABELL
Her Most Significant Bit™ NY-2013, All-in-One/Win8 (AIC-2013 FINALIST app)
Please Sign up or sign in to vote.
2 Aug 2013
AlbertoLeon CSharpMan
Insert Ignore with select thousands of rows threw timeout expired exception
Please Sign up or sign in to vote.
31 Oct 2018
Aydin Homay
In this article, we will discover the power of generics in C#.
Please Sign up or sign in to vote.
19 Aug 2013
S.P.Tiwari
Find all the days between two dates using SQL Server
Please Sign up or sign in to vote.
5 Aug 2013
Bikash Prakash Dash
How to highlight search text in a search result using ASP.NET
Please Sign up or sign in to vote.
18 Aug 2013
Maxim 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 2013
adriancs
Settings and Configurations of MySQL Connector/Net ASP.NET Session State Provider
Please Sign up or sign in to vote.
20 Aug 2013
Sivaji1565
This article briefly explains about resizing of custom task panes in Execl/Word/powerpoint
Please Sign up or sign in to vote.
20 Dec 2016
BharatRamV
Finds the Best Table for a given set of columns
Please Sign up or sign in to vote.
23 Aug 2013
Venkat Krishna Turlapati
Powershell script to copy files greater than certain date

Current Participants

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

adriancs
Software Developer
Malaysia Malaysia
Programming is an art.
AlbertoLeon CSharpMan
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
Amir Jalilifard
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.
Atul_Kapoor
United States United States
No Biography provided
Aydin Homay
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.
Azim Zahir
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.
BharatRamV
Software Developer (Senior)
India India
Software Application Developer with 9+ years of experience.
Dr. Song Li
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.
DrABELL
Software Developer (Senior)
United States United States
Dr. Alexander Bell is a seasoned full-stack Software Engineer (Win/Web/Mobile). He holds PhD in Electrical and Computer Engineering, authored 37 inventions and published 300+ technical articles. Currently focused on multiple Android/Mobile development projects and Big Data' Machine Learning, AI, IoT. Alex participated in App Innovation Contests (AIC 2102/2013) with multiple winning submissions. Sample portfolio apps and publications:

  1. Publications by A. Bell
  2. Educational Web Portal
  3. Engineering Calculator VOLTA
  4. Aggregate Product function extends SQL
  5. Use SQL to generate large data sequence
  6. HTML5/CSS3 graphic enhancement: buttons, inputs
  7. Advanced CSS3 Styling of HTML5 SELECT Element
  8. enRoute: Real-time NY City Bus Tracking Web App
  9. YouTube™ API for ASP.NET
  10. HTML5 Tables Formatting: Alternate Rows, Color Gradients, Shadows
Florian Rosmann
Austria Austria
Florian Rosmann, 18 years old, student from austria.
groggyjava
Web Developer
United States United States
This member doesn't quite have enough reputation to be able to display their biography and homepage.
Gurdeep Singh Toor
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).
h_wiedey
Germany Germany
No Biography provided
Hasan Habib Surzo
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,
Haydn Chapman
Software Developer unknown
United Kingdom United Kingdom
No Biography provided
hmdmgd3
United States United States
No Biography provided
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

Manas Bhardwaj
Architect
Netherlands Netherlands

Read my personal blog at www.manasbhardwaj.net.

Måns Tånneryd
Software Developer (Senior) Tånneryd IT AB
Sweden Sweden
No Biography provided
Maxim Rudoi
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 | :)
Mr. xieguigang 谢桂纲
Student 中国南方微生物资源利用中心(SMRUCC)
China China
He is good and loves VisualBasic!



github: https://github.com/xieguigang
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.
Nandha V
Architect Infosys Technologies Ltd.
India India
No Biography provided
Nitin Singh India
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.
PowerAdmin
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
Group type: Organisation (No members)


rusanu
bugcollect.com
United States United States
Remus Rusanu is a developer with the SQL Server team.
S.P.Tiwari
Software Developer (Senior)
India India
Play with programming languages and Technologies....
(C#,C++,JAVA,PYTHON,PL/SQL,T-SQL,Shell Scripting,SQL)
Sacha Barber
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
shahed.sohail
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.
shivaramakrishnaReddy
Software Developer
India India
No Biography provided
Shuqian Ying
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 likes to use distributed code version control system to manage codes. For that reason, a tool to manage git repository forest (related git repositories) was even developed internally.


He was a physist 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 | :) .







Most recent free tools to share:



  • V-NET[^] - connects you devices anywhere on the internet. Voice/video chat, multicase, monitoring and file transfer, private networking, etc..
Sivaji1565
Software Developer
India India
No Biography provided
Srinivas Kalabarigi
Program Manager
India India
No Biography provided
Sudhanshu SP Gupta
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
TheCodeKing
Architect
United Kingdom United Kingdom
Mike Carlisle - Technical Architect with over 20 years experience in a wide range of technologies.

@TheCodeKing
Venkat Krishna Turlapati
Database Developer
United States United States
No Biography provided
Zhuyun Dai
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