Best Database Article of September 2016

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.

The Software Development Process - Science, Engineering, Art, or Craft?

21 Sep 2016Marc Clifton

An opinionated look at our trade

DBA

Dev

Design

Architect

Agile

Master Chef (Part 1) ASP.NET Core MVC with Fluent NHibernate and AngularJS

6 Feb 2020Fred Song (Melbourne)

In this article, I want to show how to build a Single Page Application – MasterChef with ASP.NET Core MVC, Fluent Hibernate, and Angular JS.

How to correlate IIS, Application and SQL Server Audit logs to achieve full stack audit.

5 Sep 2016Z Kavtaskin

TrimChar to Remove Desired Character

30 Sep 2016Wendelius

TrimChar function which removes occurences of the desired character from both ends of a string.

T-SQL

SQL-Server

Dev

Nested Transactions for System.Data.SQLite with Savepoints

10 Sep 2016Midi_Mick

A set of extension methods giving System.Data.SQLite access to Savepoints

Backup your SQLite database with zero downtime when running Ghost in Azure Web Apps

16 Sep 2016Tom Chantler

If you're hosting your Ghost blog in Azure then you're probably not backing up your database, even if you think you are. I wasn't, but I am now. Here's how.

MEC: How to Set Message Counter for EDI Message

5 Sep 2016Kelum W. Ganegoda

How to set message counter for EDI message

DBA

Bringing Control Back to Database Deployment with ReadyRoll and Entity Framework Code First Migrations

12 Sep 2016Redgate Software, Dan Nolan

In this article, I’m going to show you how you can continue using EF Code First to model your database, while also using ReadyRoll to do the actual deployment of T-SQL change scripts and overcome the challenges of the Code First approach.

Microsoft Data Science Virtual Machine for Windows and Linux now available

23 Sep 2016Lee Stott

The Microsoft Data Science Virtual Machine jump starts your analytics project. It enables you to work on tasks in a variety of languages including R, Python, SQL, and C#.

Creating Web Based Music Player System Using MVC and AngularJs

18 Sep 2016syed shanu

In this article, we will learn how to create a simple web based music player system using MVC, AngularJS and Web API.

Easy application to detect and recognize faces with EmugCV

7 Sep 2016Emanuel Santos

In this article i will show how to create a basic application to detect and recognize faces using EmugCV.

Active Directory Query using CLR Stored Procedure

17 Sep 2016Snorri Kristjansson

A SQL server CLR Stored Procedure that can query the Active Directory directly in T-SQL code

Automatically Define the State of All Entities in the Graph in EntityFramework

9 Oct 2016Farhad Jabiyev

One of the most popular questions is whether there exists a method which will automatically decide whether to insert, update or delete entity in the Entity-Framework. Now it is possible with EntityGraphOperations library.

Using Async/Await Task Methods With SQL Queries .NET 4.5

2 Sep 2016JamesAmos

Microsoft .NET 4.5 introduced new "async and await" methods to provide an easy way of implementing asynchronisity using .NET tasks objects.

Detects Differences Between Databases

15 Sep 2016GhostHost

Compare two databases to detect which object has been modified from an old version of the same database.

Save and Retrieve PDF from SQL DB using SSRS and ASP.NET

18 Sep 2016inishant12

Using SSRS report, generate the PDF, save it into DB and send it through mail using C#

.NET-Compiler-Platform

Dynamic Restore SQL Server

31 Aug 2017Member 10262330

Dynamic restore SQL Server

SQL

SQL-Server-2008R2

backup

Coping with DBNull

17 Sep 2016Midi_Mick

A set of helper functions to cope with DBNull results from database queries

SQL

.NET

database

List Primary Key and Foreign Key Relationship in Database - SQL Server

6 Oct 2016Hussain Patel

Display the list of all Tables, the Referenced columns, the Referencing Table, the Referencing columns and the Constraint name in a database

SQL-Server

MongoDB/NoSQL For Beginners

25 Sep 2016sanathjs

MongoDB/NoSQL For Beginners

Using Case to convert Date format in SQL Select

28 Sep 2016Thomas Cooper

Using Case to convert Date format in SQL Select

SQL

WCF

Current Participants

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

Emanuel Santos

Engineer

Portugal

I'm a freelancer software enthusiastic that like to learn everyday a little bit more and if its a new tech the better Smile | :)

Farhad Jabiyev

Software Developer (Senior) AistGroup LLC

Azerbaijan

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

Fred Song (Melbourne)

Software Developer (Senior)

Australia

Fred is a senior software developer who lives in Melbourne, Australia. In 1993, he started Programming using Visual C++, Visual Basic, Java, and Oracle Developer Tools. From 2003, He started with .Net using C#, and then expertise .Net development.

Fred is often working with software projects in different business domains based on different Microsoft Technologies like SQL-Server, C#, VC++, ASP.NET, ASP.Net MVC, WCF,WPF, Silverlight, .Net Core and Angular, although he also did some development works on IBM AS400.

GhostHost

Software Developer

Italy

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

Hussain Patel

Technical Lead

United States

Husband, Father, TheWorkingProgrammer

inishant12

Software Developer (Senior)

India

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

JamesAmos

Software Developer TriSys Business Software

United Kingdom

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

Kelum W. Ganegoda

Software Developer (Senior) Brandix Lanka Pvt Ltd.

Sri Lanka

I’ve started my career in 2001 with Microsoft .net ver 1.0. I’m a MCSD for .net.

Currently, I’m working for Sri Lanka’s largest apparel exporter as a Software Engineer. All projects in .net, MS Sql Server, Biztalk Server, WCF and WPF. And also, I’m developing components to the ERP. In addition to that, I’ve involved to create architecture of ERP integration.

Lee Stott

United Kingdom

Lee Stott is a Senior Technical Evangelist at Microsoft UK, responsible for Gaming and Students within the UK. Stott has a simple goal of making Science, Technology, Engineering, Math and Design Academic curriculum interesting, exciting and modern.

Marc Clifton

Architect Interacx

United States

Blog: https://marcclifton.wordpress.com/
Home Page: http://www.marcclifton.com
Research: http://www.higherorderprogramming.com/
GitHub: https://github.com/cliftonm

All my life I have been passionate about architecture / software design, as this is the cornerstone to a maintainable and extensible application. As such, I have enjoyed exploring some crazy ideas and discovering that they are not so crazy after all. I also love writing about my ideas and seeing the community response. As a consultant, I've enjoyed working in a wide range of industries such as aerospace, boatyard management, remote sensing, emergency services / data management, and casino operations. I've done a variety of pro-bono work non-profit organizations related to nature conservancy, drug recovery and women's health.

Member 10262330

Italy

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

Midi_Mick

Software Developer

Australia

Been programming for 40 years now, starting when I was 13 on DEC PDP 11 (back in the day of paper tape storage, and hex switch boot procedures). Got right into micro-computers from an early age, with machines like the Dick Smith Sorcerer and the CompuColor II. Started CP/M and MS-DOS programming in the mid 1980's. By the end of the '80's, I was just starting to get a good grip on OOP (Had Zortech C++ V1.0).

Got into ATL and COM programming early 2002. As a result, my gutter vocabulary has expanded, but it certainly keeps me off the streets.

Recently, I have had to stop working full time as a programmer due to permanent brain damage as a result of a tumour (I just can't keep up the pace required to meet KPI's). I still like to keep my hand in it, though, and will probably post more articles here as I discover various tricky things.

Redgate Software

Red Gate Software Ltd.

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.

This is a Organisation

1 members

sanathjs

Software Developer (Senior)

India

Software Engineer in Euromonitor Research & Consulting|Bengaluru
I Work on microsoft technologies(C#,Asp.net,MVC,Azure),Angular.js,Angular 2,Node.js,Mongodb etc..

I believe every person is capable of learning a new technology but just he/she needs a kick-start to start with the learning of any technology so most of my articles will be targeting to help begineers.

Snorri Kristjansson

Software Developer (Senior) Kvikna.com

Iceland

I started programming back in 1980, briefly in Basic, switched to Assembler (Z80 CPU) running CP/M OS. Started to program for MS-DOS in Assembler (8088 CPU) when the IBM PC made it's apperance. Switched to C when I started to write programs for Windows in 1991. In 2002 switched to C++ and MFC. In 2011 started developing in C# .NET for Sharepoint 2010. In 2016 started developing WPF applications.

syed shanu

Team Leader

India

Microsoft MVP | Code Project MVP | CSharp Corner MVP | Author | Blogger and always happy to Share what he knows to others. MyBlog

My Interview on Microsoft TechNet Wiki Ninja Link

Thomas Cooper

United Kingdom

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

Tom Chantler

Architect

United Kingdom

I write about various things (e.g. security, privacy, cloud architecture) at TomSSL.

Wendelius

Architect

Europe

Biography provided

Z Kavtaskin

United Kingdom

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




Second Prize	sanathjs - MongoDB/NoSQL For Beginners
Prize pool	Bob Sticker - CodeProject

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.
Entries must be an article, or blog entry.
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).
Articles entries must follow the CodeProject submission guidelines.
No cheating, lying, plagiarizing articles, chicanery, or kicking.
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.
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 articles 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.
In the event an article has multiple authors and/or contributors, the number of prizes issued is solely at the discretion of the prize issuer.
In the event of a tie, 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 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.