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

Best Database article of September 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.
19 Sep 2013G3Coder
Details using an ORM model to provide a common facade to multiple disparate databases.
Please Sign up or sign in to vote.
29 Sep 2013Mubin M. Shaikh
Create Named Query in Data Source View While Designing OLAP Cube in SSAS
Please Sign up or sign in to vote.
25 Sep 2013ModMa
Real and fully functional connection Database Provider and DatabaseTraceListener for SQLite!
Please Sign up or sign in to vote.
19 Sep 2013Saral S Stalin
Explains how to run a script with higher priority to avoid it getting terminated in a deadlock situation.
Please Sign up or sign in to vote.
18 Sep 2013Azim Zahir
This article explains creating a JSF application using NetBeans 7.2.1 and Oracle 11G.
Please Sign up or sign in to vote.
3 Sep 2013mparvez
Session killing from a SQL Server database.
Please Sign up or sign in to vote.
12 Sep 2013Mehdy Moini
How to know which table is updated in the current logfile time.
Please Sign up or sign in to vote.
17 Sep 2013MAW74656
This is a drop-in solution that mimicks the functionality of xp_sendmail (including query results), without installing Outlook on the server.
Please Sign up or sign in to vote.
26 Sep 2013Ashkan.hosseini
Stored procedure that generates insert stored procedure for tables
Please Sign up or sign in to vote.
4 Sep 2013Betclic Tech
How we improved database code quality
Please Sign up or sign in to vote.
15 Sep 2013Dave Kerr
Learn how to deploy SharpShell servers easily with the new Server Registration Manager tool
Please Sign up or sign in to vote.
24 Jul 2014dale.newman
Combining de-normalization, transformation, replication, and awesome-ness.
Please Sign up or sign in to vote.
15 Nov 2013Mike Winiberg
GOTCHAs and tips useful when migrating a complex Access JET application to SQL Server 2012
Please Sign up or sign in to vote.
4 Sep 2013Mubin M. Shaikh
This article shows how to create and populate date dimension for data warehouse.
Please Sign up or sign in to vote.
16 Sep 2013tumbledDown2earth
Browse your Google Drive and integrate your windows explorer with a Google's storage Cloud
Please Sign up or sign in to vote.
17 Sep 2013Venkat Krishna Turlapati
How to use cross apply along with a table valued function as an alternative to cursors
Please Sign up or sign in to vote.
26 Sep 2013Sandeep Kumar Tripathi
Here are the different ways to execute an SSIS Package by using C#.
Please Sign up or sign in to vote.
21 Jul 2014Mubin M. Shaikh
Learn creation of OLAP Cube in SSAS (SQL Server Analysis Services) using Microsoft BIDS (Business Intelligence Development Studio) Environment and Data Warehouse
Please Sign up or sign in to vote.
14 Oct 2013Rion Williams
How to merge smarter with Semantic Merge.
Please Sign up or sign in to vote.
16 Sep 2013Marius Bancila
Provides an overview for creating an consuming classic COM components for desktop applications with the Windows Runtime C++ Template Library
Please Sign up or sign in to vote.
16 Sep 2013Bruno Terkaly
This post will cover the whole spectrum of downloading data from a government site, loading it into an on premise SQL Server database, migrating this on premise SQL Server database to SQL database in Windows Azure.
Please Sign up or sign in to vote.
23 Oct 2013Eduard Keilholz
A quick help for storing images in SQL Server and displaying them on a ASP.NET Website
Please Sign up or sign in to vote.
28 Sep 2013huys03
This article describe how to write a shell extension in plain C++ without ATL
Please Sign up or sign in to vote.
25 Sep 2013Rajan Patekar
N-tier architecture of Project
Please Sign up or sign in to vote.
16 Oct 2013Robert Bettinelli
Check this for a good universal way of running stored procedures..

Current Participants

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

Web Developer
Ukraine Ukraine
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
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.
Chief Technology Officer Betclic
France France
I am Head of Software Development at Betclic France. I manage the Paris Dev Team, consisting of 35+ talented people, in various technical and functional projects in the fields of sports betting, poker, casino or horse betting.

Check out our technical blog at https://techblog.betclicgroup.com
This is a Organisation

3 members
Canada Canada
Starting with Turbo C and 8086 Assembler in the late 80s, Bruno has kept busy teaching and writing code in a multitude of platforms, languages, frameworks, SDKs, libraries, and APIs.

Bruno's depth of knowledge comes from years of experience in the field, where he can bring real-world knowledge and combine it with forward thinking that is required for his current role as a Developer Evangelist at Microsoft. Prior to evangelism, Bruno was a Microsoft Premier Field Engineer, helping customers in remote locations on a moment's notice to help with extreme troubleshooting scenarios, including problem isolation and correction, live and post-mortem debugging, on-the-fly application design and code reviews, performance tuning (IIS, SQL Server, .NET), application stability, porting / migration assistance, configuration management, pre-rollout testing and general development consulting.

As an evangelist, Bruno spends time writing code and giving live presentations on building cloud based applications, specifically using the Windows Azure Platform. He also takes a strong interest in Mobile Computing and is convinced that both mobile and cloud platforms, separately and together, are poised for huge growth over the next 10 years.

Bruno is very optimistic about the potential for new interactions with software using Kinect. The software industry has been languishing in aging approaches to human interactions and software. Kinect opens up an brave new world of possibilities to next generation software engineering.
Software Developer (Senior)
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
United Kingdom United Kingdom
Follow my blog at www.dwmkerr.com and find out about my charity at www.childrenshomesnepal.org.
Architect http://4dotnet.nl
Netherlands Netherlands
I'm developing software for over two decades. I'm working as a cloud solution architect and a team lead at 4DotNet in The Netherlands.

In my current position, I love to help customers with their journey to the cloud. I like to create highly performant software and to help team members to a higher level of software development.

My focus is on the Microsoft development stack, mainly C# and the Microsoft Azure Cloud. I also have a strong affinity with Angular. As a result of my contributions to the community, I received the Microsoft MVP Award for Microsoft Azure.
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.
China China
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Architect Visma Software
Romania Romania
Marius Bancila is the author of Modern C++ Programming Cookbook and The Modern C++ Challenge. He has been a Microsoft MVP since 2006, initially for VC++ and nowadays for Development technologies. He works as a system architect for Visma, a Norwegian-based company. He works with various technologies, both managed and unmanaged, for desktop, cloud, and mobile, mainly developing with VC++ and VC#. He keeps a blog at http://www.mariusbancila.ro/blog, focused on Windows programming. You can follow Marius on Twitter at @mariusbancila.
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.
Software Developer Idea Tolue Software
Iran (Islamic Republic of) Iran (Islamic Republic of)
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
CEO Charter Software Ltd
United Kingdom United Kingdom
I have been a software developer for nearly 40 years now - I find that incredibly hard to believe myself! Starting with Fortran, Algol 68R, Algol 60, through to C++/Java via Occam, Z80/8086/68000 assembler - so many languages, so little time!

Currently developing an application for MS SQL SERVER 2012, I specialize in bespoke solutions for Linux and/or Windows, mainly in Java, Python, C++ or Visual Basic. I also have a keen interest in all forms of digital media, audio, imaging, video and document production.

Games are good too!

Mike
Architect Sermicro
Spain Spain
My life in programming has been long, begins from the 6 years of age with Basic, I have knowledge of C++, Javascript, ASP .NET, Cisco CCNA, among others.

One of my pastimes in the programming, is cryptology and systems security

One of my recognized works is P2PFire, other smaller projects like utilities for Chats
Software Developer (Senior) icddr,b
Bangladesh Bangladesh
More than 8 years experience on Programming and Project implementation, I was primarily involved with projects for private organization,Govt.(Bangladesh Army,DG Health,RJSC), NGO (SEDF,WFP). Presently I am working at ICDDR,B and enhancing Hospital Management System developed by Microsoft Dynamic NAV and Windows Mobile Application 5.0

An active supporter of Open Source technology, my interested areas are ERP, IT Audit, Data warehouse, BI etc.

Playing Guitar for 15 years, my interested music style is Blues Rock,Neo Classical.

Certification

70-540:Microsoft® Windows Mobile® 5.0 - Application Development
MB7-514:Microsoft Dynamics™ NAV 5.0 C/SIDE Introduction
MB7-516:Microsoft Dynamics™ NAV 5.0 Solution Development
MB7-517:Microsoft Dynamics™ NAV 5.0 Installation and Configuration
MB7-515:Microsoft Dynamics™ NAV 5.0 Financials
70-432:Microsoft SQL Server 2008 - Implementation and Maintenance
70-450:PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008
70-448:Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
312-50:Certified Ethical Hacker

Web :http://masudparvezshabuz.appspot.com
Blog :http://masudparvezshabuz.wordpress.com
linkedin :http://www.linkedin.com/in/masudparvez
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.
Technical Lead
India India
Rajan is a radiant and rationalist person.
Other than coding he is having his interest in playing chess, pool and reading novels. Google+
Software Developer (Senior)
United States United States
An experienced Software Developer and Graphic Designer with an extensive knowledge of object-oriented programming, software architecture, design methodologies and database design principles. Specializing in Microsoft Technologies and focused on leveraging a strong technical background and a creative skill-set to create meaningful and successful applications.

Well versed in all aspects of the software development life-cycle and passionate about embracing emerging development technologies and standards, building intuitive interfaces and providing clean, maintainable solutions for even the most complex of problems.
Web Developer Nottawasaga Valley Conservation Authority
Canada Canada
I have background in programming(many languages), web design, hardware and software. Currently I hold a lead database programming position for the Nottawasaga Valley Conservation Authority... Programming in vb.net and java comes 2nd nature to me and of course I do this for fun. I also used to design in cobol and pascal and run a BBS(anyone remember what this was?). Anyways, drop me a line maybe I can help you.
Software Developer (Senior) R1 RCM 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.
Technical Lead
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
is a poor software developer and thinker. Presently working on a theory of "complementary perception". It's a work in progress.
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.
You must sign in to participate in this contest.
This contest has ended.
1 Sep - 30 Sep 2013