Best Database article of October 2013

This competition has ended

Overview
Entries
Participants
Winners
Prizes
Rules

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.

Monitor Database Changes

21 Oct 2013Member 7874525

This how you can monitor your database changes

C#3.5

SQL

.NET

SQL-Server

SysAdmin

DBA

Using Table variable instead of Cursor Variable

3 Nov 2013S. M. Ahasan Habib

I will explain here how to use table variable and over come cursor limitation

T-SQL: Most Practical Split Function

11 Oct 2013Brad Joss

A SQL String Split function for the real world

Remove Slow Startups and Enjoy Less “Suspense” through .NET 4.5.1′s App Suspend Feature

10 Oct 2013Rion Williams

This article covers one of the switches that you might be interested in flipping, the App Suspend feature, which is available in .NET 4.5.1 on Windows Server 2012 R2.

Create CSV File in Microsoft SQL

27 Jan 2017Rajesh_K_Sharma

How to create CSV file in SQL

SQL

SQL-Server-2008

SQL-Server

Debug Java Code in Java COM Windows Application (Remote Java Debugging)

18 Oct 2013Vivek Goyal

Debugging Java JNI and C++ code in COM based application

Books and Help Resources on Entity Framework

11 Oct 2013ASP.NET Community

Programming theMicrosoft® ADO.NET Entity Framework by David SceppaPublisher : MicrosoftProgramming EntityFrameworkBuilding Data Centric

Transfer Users from One SQL Server to Another Including SID’s the Easy Way

5 Oct 2013Raymund Macaalay

How to transfer users from one SQL Server to another including SID's the easy way

SQL-Server

Drop all Triggers belonging to any schema in MS SQL Server

9 Oct 2013Matthew Taylor

How to remove Microsoft SQL Server triggers associated with a custom schema.

T-SQL: Search SQL Code

16 Oct 2013Brad Joss

Search your SQL code with simple T-SQL statements.

Writing a boot loader in Assembly and C - Part 2

16 Oct 2013AshakiranBhatter

Reading the contents of a floppy disk using BIOS interrupts and Services.

Hosting EXE Applications in a WPF Window Application

25 Oct 2013Erxin

Introduce a simple way to embed an EXE into a WPF window application.

How to Handle Appointments and Send Automated Reminder Calls using PHP and your MySQL Database

30 Oct 2013Simon Robert VoIP

This article presents a simple example on how to insert automated reminders about appointments, meetings to MySQL table with the help of PHP

FIPS Encryption Algorithms and Implementation of AES in C# and SQL Server 2008

2 Oct 2013Dnyaneshwar Pawar

Implementation of AES in C# and SQL Server 2008.

AJAX vs. Non-AJAX Calls All-in-One Page

31 Aug 2015Peter Leow

This is a simple web application to illustrate visually the difference between Ajax and non-Ajax calls that take place all in a single web page.

How to use .NET C# COM objects in plain C

9 Jan 2015Qmpel7

Step-by-step walkthrough to communicate C classes with COM objects created in C#.

Fast declarative typesafety with DynamicMethods for SQL

16 Oct 2013tcassisi

Generating typed field accessors and applying them to object mapping and SQL Stored Procedures

Generic Database Frontend– Filtering, Free Text Search, Sorting & Paging

31 Oct 2013Relly Rivlin

This article describes a server and client side code including explanations of a generic database frontend web application.

SQL-Server

MVC4

ASP.NET

Configuring IIS, ASP.NET, and SQL Server

29 Oct 2013Juan Davel

This article is an updated one discussing the configuration of IIS, ASP.NET and SQL Server.

Distributed Transaction between Microsoft SQL Server and MariaDB - A Myth

23 Oct 2013BharatRamV

Distributed transaction between MS SQL Server and MariaDB - A myth.

A propertymapping Extension for DataReaders

26 Jan 2016Jörgen Andersson

A propertymapping extension for DataReaders

ADO.NET Entity Framework Interview Questions

11 Dec 2013Shivprasad koirala

Quick revision of 25 important ADO.NET Entity Framework interview questions with answers.

Anti-Reflector .NET Code Protection

26 Oct 2013Igor Ladnik

Article presents a technique allowing developers to protect their .NET code from reverse engineering by reflection of executable files

Writing a boot loader in Assembly and C - Part 1

20 Apr 2015AshakiranBhatter

How to boot a floppy image with your own hand written code in C and Assembly

SQL Server 2012 Auto Identity Column Value Jump Issue

14 Oct 2013S. M. Ahasan Habib

From SQL Server 2012 version, when SQL Server instance is restarted then its auto Identity column value is jumped based on identity column datatype.

Generate script from Microsoft SQL Server Management Studio

25 Oct 2013Sadeque Sharif

Generate script from Microsoft SQL Server Management Studio.

SQL-Server

Send Email Alert on Database Schema Change in SQL Server

4 Oct 2013Mubin M. Shaikh

Auto Monitoring On Schema Change within Database in SQL Server and Email Alert

Use Excel in PowerShell without a full version of Excel

18 Oct 2013Douglas M. Weems

Easily import Excel Sheets into PowerShell as PS Objects

Dynamic SQL From DB Table with Parameters

21 Oct 2013Johnny L Washington

How to execute store SQL with parameters via Procedure

SQL

SQL-Server

DBA

Duplicate Rows/XML-Nodes Identification and Clean-up from Database

27 Nov 2013S. M. Ahasan Habib

In this article I explain how can we identify duplicate rows from database table and clean them up. I also cover duplicate XML nodes inside XML type fields having the same problem and a solution.

A Comparison on Data Access Methods - Part 3

12 Oct 2013Dr. Song Li

This is the part 3 of a comparison on Data Access methods in the .NET environment.

Calculate exponential function with Taylor series in SQL Server

24 Oct 2013Mehdy Moini

Iteration without curser is one of database programmig arts, in this article i have tried to calculate exponential function with taylor series

SQL-Server

SQL Synonyms :.: Avoiding Dynamic SQL

29 Oct 2013Claudio cespon

A first approach to avoid Dynamic SQL in stored procedures

SQL

SQL-Server

Direct access to C++ native code from C++/CLI MSSQL Stored Procedure

19 Sep 2014Konstantin Tchoumak

Reading hardware information in Stored Procedure

Rowversion: Version Stamping A Row

19 Oct 2013SonuKSingh

rowversion datatype in SQL Server: Track which row has been modified

Database Driven Dynamic Menu Control

6 Oct 2013Muhammad Ahmed Azam

"Database Driven Dynamic Menu Control"

View for SQL Agent Job Histories

12 Mar 2014Brad Joss

Views to make analyzing SQL Agent Job statistics easier

SQL

SQL-Server

How to Take Backup from SQL Azure using Database Deployment Technique

1 Oct 2013P_Dash

Taking a SQL Azure database backup to Local instance from an SQL Azure instance using Deployment Technique

Measurement Unit Conversion Library

2 Oct 2013George Ziady

This is an alternative for "Measurement Unit Conversion Library"

Display Last Activity Date and Time in Microsoft SQL

12 Oct 2013Yugal Pandya

Display last activity Date and Time smartly like Google and Facebook in Microsoft SQL

SQL-Server

ASP.NET

How to Generate T-SQL Code by Using Dynamic SQL?

15 Oct 2013Sergii Syrovatchenko

T-SQL code generation by using Dynamic SQL for routine tasks automation.

Simplified ORM with NW.ORM

29 Oct 2013Ogwara Rowland

NW.ORM, a helper framework for working Hibernate.

How to Cascade Delete an Adjacency List Model in SQL in C#

14 Oct 2013marks-mike

Demonstrates how to cascade delete on a single table that maintains hierarchy by a ParentId that points to the primary key of the same table

SQL bulk insert with strongly typed data including validation

7 Oct 2013Vikash Kumar

SQL bulk copy with strongly typed data including validation.

Using Pipeline from Parallel Extension Extras

2 Oct 2013Darek Danielewski

The combined use of Pipeline and NullObject patterns greatly simplifies data processing

Merlin Framework 2013

30 Oct 2013Marc Leger

ORM, databinding, asynchronous data access, and transactions

Forgot Password With Check Email From Database

22 Oct 2013Muhammad Aqib Shehzad

Forgot Password and Email Check from Database

Create SQL Job for SSIS Package by using C#

1 Oct 2013Sandeep Kumar Tripathi

How to create SQL Server Agent Job to schedule SSIS Package

SQL

SQL-Server

ASP.NET

ADO.NET

11 Oct 2013ASP.NET Community

ADO.NET stands for ActiveX Data Objects for .NET. It refers to the suite of data access technologies used to manipulate databases. ADO.NET is part

Current Participants

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

Shivprasad koirala

Architect https://www.questpond.com

India

AshakiranBhatter

Software Developer

United States

Ashakiran is from Hyderabad, India and currently working as a Software Engineer in USA. He is a hobbyist programmer and enjoys writing code.

ASP.NET Community

United States

The ASP.NET Wiki was started by Scott Hanselman in February of 2008. The idea is that folks spend a lot of time trolling the blogs, ~~googling~~live-searching for answers to common "How To" questions. There's piles of fantastic community-created and MSFT-created content out there, but if it's not found by a search engine and the right combination of keywords, it's often lost.

The ASP.NET Wiki articles moved to CodeProject in October 2013 and will live on, loved, protected and updated by the community.

This is a Collaborative Group

754 members

BharatRamV

Software Developer (Senior)

India

Software Application Developer with 9+ years of experience.

Brad Joss

Software Developer (Senior)

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Claudio cespon

Web Developer

Argentina

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Darek Danielewski

Architect BI Software, Inc.

United States

A seasoned IT Professional. Programming and data processing artist. Contributor to StackOverflow.

Dnyaneshwar Pawar

Software Developer

India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Douglas M. Weems

Web Developer

United States

My experience with programming began with Turbo Pascal while working on my Physics degree back in 1989.

After getting out of school, I used pre-VBA Excel macros to write some really fancy applications to help with the job I was doing. This inspired me to try to write "Windows" programs and to search out Visual Basic 3.0.

I wrote a bunch of small applications and ran them against Access and FoxPro. However, this still wasn't my primary job.

In 1994, I went on my first contract, a 3-month deal that turned into 3-years. I learned a lot more about development. Development was in VB3, VB4 and ASP. I got a chance to admin NT4 and SQL Server 6 and 6.5.

After moving on to another company, I spent another 2 years with VB and then 5 years with Java and JSP.

In March of 2004, I installed Visual Studio 2003. I tasted C#, and became hopelessly addicted.

My other interests are my 3 sons, my wife Smile | :)

, metal detecting, yard work, travel and learning new things.

update: Now love SharePoint, PowerShell, JQuery, C#, PHP

location: Atlanta, Georgia

Dr. Song Li

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.

Erxin

Architect MicroFocus

China

Love programming and have fun!

George Ziady

Springfisher

Singapore

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Igor Ladnik

Software Developer (Senior)

Israel

Nov 2010: Code Project Contests - Windows Azure Apps - Winner
Feb 2011: Code Project Contests - Windows Azure Apps - Grand Prize Winner

Johnny L Washington

Architect

United States

I love development.

Jörgen Andersson

Database Developer

Sweden

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Juan Davel

Software Developer (Senior)

South Africa

I was a software and web application developer for several local companies and started my own company on the side providing similar services. I used to develop using Microsoft-technologies such as Microsoft C#, Microsoft .NET, Microsoft ASP.NET and MVC, and Microsoft SQL Server.

In 2015 I have started pursuing a career in aviation and am currently studying for my Student Pilot License after which I will obtain my PPL and CPL.

Marc Leger

Web Developer Epsilon

United States

20+ years experience developing web solutions.

marks-mike

United States

Mike is a web developer for a leading oil and gas company in Oklahoma. He's been writing .NET apps for 4 years and has expertise in ASP.NET with MVC.

Matthew Taylor

Software Developer Cox Telecommunication

United States

15+ years Information System and Software Development experience.
Currently Senior Software Engineer @ Cox Telecommunication Hamptons Roads.

Qualification:
1.Master of Science Electronic Commerce Development.
2.Microsoft Certified Application Developer (MCAD)
3.Brain Bench Certified .Net Developer

Currently persuiting my PMP from PMI.org. Should be taking the exam in 2 months.

This is a Collaborative Group (No members)

Mehdy Moini

Software Developer Idea Tolue Software

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.

Member 7874525

Software Developer Cygnet Infotech pvt ltd

India

Harshal Sanghavi
Currently Software Engineer.
Worked in .net.
Good experience in SQL Server Business Intelligence.

Mubin M. Shaikh

Architect Cybage Software Pvt. Ltd.

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.

Muhammad Ahmed Azam

Software Developer (Junior)

Pakistan

Currently doing BS in Computer Science (6th semseter). Working On Microsoft technologies c# asp.net sql server.
Also Working on Crystal Reports.

Junior Software Engineer At Rasg Consulting Services Karachi Pakistan.

Muhammad Aqib Shehzad

Software Developer (Senior)

Pakistan

I am a passionate c# developer and love ASP.Net technologies and of course love too to learn new technologies and tools, currently my role is to find the performance leaks and to resolve application level bugs, analysis the best performance tools and latest technologies.

Ogwara Rowland

Software Developer (Senior) Neemworks Ltd

Nigeria

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 (No members)

P_Dash

Software Developer (Senior) Autodesk

Singapore

A person who is in search of opportunities to show his capabilities & knowledge.

Peter Kovalchuk

Software Developer (Senior)

Canada

He has an experience with Visual C++/Borland C++, C#, TSQL, in image processing, desktop and critical mission server applications, distributed systems design.
Former developer of Blackberry Enterprise Server.

Peter Leow

Instructor / Trainer

Singapore

“Live as if you were to die tomorrow. Learn as if you were to live forever.”
― Mahatma Gandhi

子曰："三人行，必有我师焉；择其善者而从之，其不善者而改之."

Qmpel7

Software Developer

Poland

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Rajesh_K_Sharma

Web Developer

India

Rajesh is a MCSD, MCAD, MCA and trying to become .Net expert who has more than 9 years experience in Dot net.

Raymund Macaalay

Technical Lead

New Zealand

http://nz.linkedin.com/in/macaalay
http://macaalay.com/

Relly Rivlin

Software Developer (Senior) backand.com

United States

I have 20 years experience in software development. Currently I'm the head of R&D in backand.com. The core technology of backand.com emerged by my M.Sc studies in database visualization and ORM. Prior to joining backand.com I was the R&D Manager for 7 years in another startup and before that as development manager in enterprise companies.

Rion Williams

Software Developer (Senior)

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.

S. M. Ahasan Habib

Architect

Bangladesh

How do I describe myself to you? How can I explain that this is true?
I am who I am because of you! My work I love you !!

Sadeque Sharif

Founder Codexplorer Technologies

Bangladesh

I am:
Founder & Technical Head at Codexplorer Technologies.
IT Consultant at Meridian Group.

I was:
Manager (IT) at Meridian Group.
Assistant Manager (Software Division) at KDS Garment Industries Limited.
Assistant Manager (Software Division) at E-Vision Software Limited.

My blog:
crea8ivecode

My preferred work area:
ASP.NET & SQL SERVER.

My email:
sadeque.sharif@yahoo.com

Follow me:
twitter | facebook | linkedin

Sandeep Kumar Tripathi

Software Developer (Senior) R1 RCM Pvt. Ltd.

India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Sergii Syrovatchenko

Database Administrator DraftKings Inc.

Ukraine

SQL Server DBA/DB Developer with 10+ years of experience in SQL Server 2005-2019, Azure/GCP. Worked on high-load OLTP/DW projects and develops system tools for SQL Server. In depth understanding of SQL Server Engine and experience in working with big databases. Domain knowledge of ERP/CRM, crawlers, gambling and retail sales. Blogger, mentor and speaker at local SQL Server events.

Simon Robert VoIP

Chief Technology Officer

United Kingdom

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

SonuKSingh

Software Developer

India

Programming is my passion. It is always fun to learn new things.

Follow my blog
Follow on FB

tcassisi

Tovica Technology Pty Ltd

Australia

Toni Cassisi

Vikash Kumar

Software Developer (Senior) Mindfire Solutions

India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Vivek Goyal

Software Developer (Senior)

India

Software Engineer having hands-on experience with C, C++, C#, .NET, ASP.NET, SQL, Website designing technologies, Joomla CMS, Application development, COM, MFC, Installshield, Installscript project, Basic MSI

http://newapputil.blogspot.in/
http://nvivekgoyal.blogspot.in/

Yugal Pandya

Technical Lead

India

Software Professional experience since 2006 in ASP.NET, VB.NET, C# .NET, SQL SERVER, ORACLE, MS ACCESS, Web Services, HTML, JQUERY and CRYSTAL REPORTS.

Expertise in developing web and Desktop applications.

Visit http://yugalpandya.wordpress.com for more information.

	Relly Rivlin - Generic Database Frontend– Filtering, Free Text Search, Sorting & Paging
Prize pool	CodeProject Mug - CodeProject CodeProject Mousepad - CodeProject SQL Prompt from Red Gate Software - Redgate Software

Contest Entries and Requirements

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.
Must be an article, or blog entry
With the exception of the overall 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).
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.
Articles entries must follow the CodeProject submission guidelines.
No cheating, lying, plagiarizing articles, chicanery, or kicking.
Authors may only have their article considered for multiple categories if that second category is the Overall monthly category. Under no circumstance will an article be nominated in a second category that is not the Overall monthly category.
No author can be nominated twice in the same category.
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 article could be nominated in the C# and VB.NET competitions, respectively.
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.
Multiple votes from the same IP will be automatically disqualified.
The judges’ decision is final and no correspondence will be entered into.
Only those who live in jurisdictions in which this contest is legal may enter.
Any breach of the rules and the prize will be awarded to the runner up.
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.
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. Please read the submission requirements before submitting your entry.

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.