Best Database Article of May 2017

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.

LINQ to Entities, Cross Apply, and Left Outer Join

12 May 2017DaveDavidson

In this article, I show LINQ to Entities syntax that will produce queries with CROSS APPLY and LEFT OUTER JOIN clauses.

SQL

T-SQL

.NET4.5

FOR XML Basics (AUTO Mode): 2 of 4

2 Jun 2017AhsanAhmed

A brief introduction on how to use FOR XML clause in AUTO mode in Microsoft SQL Server to return data in XML format

Build Modern App with MEAN Stack 2.0 – Part 1

3 May 2017Pankaj Kumar Choudhary

Basics of MEAN stack development and concepts that are required for MEAN stack development

R-script Migration to SQL Server 2016

13 May 2017Evgeniy Sukhikh

Issues and solutions taken while moving R from cmd to sp_execute_external_script

T-SQL

SQL

Windows toast notifications without a COM server

14 May 2017Martin Chrzan

An easy way to react on windows toasts activation without using a COM server

EntityFrameworkCore Seeding Component

9 May 2017Adriaan Booysen

Adding Seeding Framework towards EntityFrameworkCore that can be wired up in either a dotnet core Web Application or WebAPI

Reducing KnpPaginatorBundle Database Queries

25 May 2017Alvin Bunk

Introduction If you are not familiar with the KnpLabs KnpPaginatorBundle and how to use it with Symfony applications, you might want to read up on it. The GitHub page does say it is a Symfony 2 bundle, however, it does work perfectly with Symfony 3. Why would you use it?

database

Calculate Geo Distance Using SQL Server

8 May 2017Nirav Prabtani

How to calculate distance between two geolocations or find out distance within a specific radius by SQL Server

FOR XML Basics (RAW Mode): 1 of 4

2 Jun 2017AhsanAhmed

A brief introduction on how to use FOR XML clause in RAW mode in MS SQL Server to return data in XML format

How to create Dynamic draggable and droppable TreeView with checkbox in MVC(for beginner)

6 Jun 2017VINEET MISHRA 086

This article explains how to use data source for representation of data in TreeView structure using ASP.NET MVC and Gijgo treeview JQuery plug-in, The TreeView control can display a hierarchical (or nested, or recursive) collection of data in a tree of expandable nodes.

LINQ Basic to Advanced - MVC Demo Application

14 May 2017Sibeesh Passion

Here, in this post, we are going to see some LINQ queries, which covers both basics and advanced.

HTTP Sweet HTTP (with Gastona)

9 Jul 2017Alejandro Xalabarder

HTTP for everybody

SqlDependency .NET library can work to detect updates automatically

24 May 2017Zahid Nawaz Ch.

SqlDependency ,can be used to pick changes without executing query to see there is any update from database , WHERE CLAUSE can also be applied for narrowing scope, Its way to push changes from SQL Server to SQLDependency , .NET library , SQL Server Broker service sends updates to SQLDependency.

Capture of a Typical SQL Server Database Workload

29 May 2017Tomáš Bauer

Capture of a Typical SQL Server Database Workload

Copy Data Between Excel Sheets using VBA

17 May 2017Maciej Los

This is an alternative for "Copy Rows Within Excel Sheets via VBA"

MS-Excel

VBA

ADO

Govern and control your server ressources Using SQL Server

19 May 2017Christian Luketa Kanyinda

This article will allow you to govern your resources and to control them to optimize your server

SQL

SQL-Server-2008R2

SQL-Server

Calendar - calendar with notes using the Qt framework

12 May 2017alexey_t

A simple calendar with notes support

Using AES Symmetric Key to Secure Table Content

17 May 2017girlprogrammer

Securing table data at column level using AES-128 encryption

Use COM Interop to Create an Excel in MVC

3 May 2017V5709

This tip will provide one of the ways of generating Excel files using Microsoft COM interop in MVC project.

MVC

MS-Excel

COM

Current Participants

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

Nirav Prabtani

Team Leader eInfochips

India

Nirav Prabtani

I am a team lead, Database Architect and Designer /Technical Architect/Analyst,
Programmer in Microsoft .NET Technologies & Microsoft SQL Server with more than
4.5 years of hands on experience.

I love to code....!!!

My recent past includes my work with the education domain as a technical business
requirement analyst, database architect & designer and analyst programmer; just
love my involvement with the world of knowledge, learning and education and I think
I know quite well what I want to do in life & in my career. What do I like? Well,
ideation, brainstorming, coming up with newer and more creative ways of doing things;
each time with an enhanced efficiency. An item in my day's agenda always has a task
to look at what I did yesterday & focus on how I can do it better today

Contact Me

Nirav Prabtani

Mobile : +91 738 308 2188

Email : niravjprabtani@gmail.com

My Blog:
Nirav Prabtani

Adriaan Booysen

Software Developer (Senior) Self Employed

South Africa

I am a well seasoned developer with 18 years experience in the industry and have been working on C# since .Net 1 made its debut, which is since 2002 and remember all the hardcore work that needed to be done and has seen how it evolved. I have written multitudes of solutions in .Net for many customers and always learn something new.

Needles to say, my repertoire does not start and end with .Net and includes tech knowledge from database, servers, applications across various streams, not just Microsoft technologies.

In the future I will attempt to hand some of my knowledge down to the community, since it has helped me so many times over the years.

AhsanAhmed

Software Developer

Pakistan

Software Engineer and a clean code proponent, working on various .NET, Oracle and front end technologies including Web Forms, MVC, Web API, LINQ, EF, T-SQL, PL/SQL, SSIS, JavaScript, jQuery.

Alejandro Xalabarder

Germany

I have a Telecomunications Engineering degree but since I learnt the first language (Pascal), almost I haven't stopped developing software. Mainly with C and C++ but I have touched many other languages and scripts. I use also to develop for fun (reinventing the wheel, of course!), currently almost all of such programs and tools are written in java (visit www.elxala.de).

alexey_t

Russian Federation

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

Alvin Bunk

Software Developer Taft College

United States

I’m a software developer. Currently I’m working at Taft College as a Programmer.

Christian Luketa Kanyinda

Database Administrator Hologram Identification Services

Congo (the Democratic Republic of the)

I am
- DataBase Administrator & DataBase Developper Using SQL Server , MySQL and PostGresql
- Software Developper ( C#,Vb.net , Java and Php )
- Business Intelligence Developper
- WebMaster

I work in this area about 3 years ago. I participate in upgrades in different computer training centers and as a database consultant in several companies

DaveDavidson

Software Developer (Senior)

United States

Software developer and jazz pianist, not necessarily in that order.

Evgeniy Sukhikh

Technical Lead

Ukraine

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

girlprogrammer

Web Developer

United States

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

Maciej Los

Team Leader

Poland

I'm a lawyer, teacher/trainer and author of VBA programming book (only polish version). Programming is my hobby and the source of extra earnings!

C#
SQL
Linq
VB/VBA/VB.NET
XML & XSL
Python
JCL

If you want to contact me... find me on LinkedIn.

Martin Chrzan

Software Developer

Denmark

C# software developer.

Pankaj Kumar Choudhary

Student

India

Pankaj Kumar Choudhary loves Microsoft and Database technologies. He has experience on several database technology like SQL Server, MySQL, Oracle, MongoDB, PostgreSQL . He has knowledge of several technology like Asp.Net MVC, Entity Framework , Android, Php, AngularJS, Node.js, Angular2, React, Ionic and Android.

Sibeesh Passion

Software Developer

Germany

I am Sibeesh Venu, an engineer by profession and writer by passion. I’m neither an expert nor a guru. I have been awarded Microsoft MVP 3 times, C# Corner MVP 5 times, DZone MVB. I always love to learn new technologies, and I strongly believe that the one who stops learning is old.

My Blog: Sibeesh Passion
My Website: Sibeesh Venu

Tomáš Bauer

United States

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

V5709

Software Developer

India

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

VINEET MISHRA 086

Software Developer (Senior) Ideavate Indore

India

Vineet Mishra is a Software Engineer. He have been working more than 3 years of professional experience in Software Development industry. Currently he is working with IT
Technical expertise: ASP.NET, C#, Sql Server, MVC , WCF, Windows Service, Jquery

Zahid Nawaz Ch.

Technical Lead Advanced Programs Trd. Co. Ltd

Saudi Arabia

Motivated software Engineer in web/mobile application and windows development, architecture design, and multi-layer implementation. Well-versed in multiple programming languages and platforms. Demonstrated success in UI, integration, Service {REST, SOAP}. Highly skilled at assessing legacy code, identifying defects, promptly designing resolution strategies and performing corrective measures.

First Prize	DaveDavidson - LINQ to Entities, Cross Apply, and Left Outer Join
Prize pool	CodeProject Mug - CodeProject


Second Prize	Zahid Nawaz Ch. - SqlDependency .NET library can work to detect updates automatically
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.