Best Database Article of February 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.

Model-driven REST or GraphQL API for CRUD and More

11 May 2022Evoluteur

Generic REST or GraphQL endpoints for CRUD and more, written in JavaScript, using Node.js, Express, and PostgreSQL

Javascript

Node.js

PostgreSQL

JSON

REST

CRUD

database

SPA^2 using ASP.NET Core 1.1 + Angular 2.4 - Part 3

9 Mar 2017Robert_Dyball

Build a Calendar Without Pre-Existing Tables

31 Jan 2017#realJSOP

Using common table expressions to build data from thin air.

Sending Events from Azure Event Hub to Azure SQL Database using Azure Functions

7 Feb 2017Jovan Popovic(MSFT)

Collaborative Todo List with Emitter, SQLite, and Vue.js

6 Feb 2017Florimond

Explains how to use Emitter with a database to store the content of collaborative todo list

Javascript

SQLite

vue.js

Create Query Shortcuts in SQL Server Management Studio

31 Jan 2017saddam_msp

Shortcuts to execute your query faster while working or debugging T-SQL statement

T-SQL

SQL

SSMS

THVDataSet - A Complete Delphi DataSet Based on Stream

7 Feb 2017hamdenvogel

Learn how to implement a real stream file based dataset descendant with blob support and much more

Delphi

desktop

database

Introduction to the Merge Statement

12 Feb 2017essentialSQL

In this article, well explore how to use the MERGE statement. We discuss some best practices, limitations, and wrap-up with several examples.

SQL

Paste Table Data into an Editor Then Quickly Format for Good Appearance

8 Feb 2017RedDk

Use ALT+SHIFT to "block" select text (thinking of justifying columnar relations of words/data/etc. so the visual appearance is perfectly tabular) ... and TAB (TAB+SHIFT to undo) to MOVE SELECTION right (and left) ...

What is the Difference Between Merge and Update?

12 Feb 2017essentialSQL

This post discusses the difference between merge and update

SQL

Angular2 + CData API Server: Data-Driven Dynamic Web Apps

10 Feb 2017Jerod Johnson

Use the CData Software API Server to create an OData service for your databases and build a dynamic Web app based on the database data.

Republic Bank Streamlining database deployments with SQL Compare

9 Feb 2017Redgate Software

A case study where Republic Bank introduced Redgate SQL Compare; the industry standard for comparing SQL Server schemas and creating deployment scripts in minutes.

SQL-Server

DBA

product-showcase

Creating Contact Manager App with MEAN Stack

2 Oct 2017HHerzl

Creating Contact Manager App with MEAN Stack

Learning SQLite databases in Xamarin for Android

19 Feb 2017Afzaal Ahmad Zeeshan

In this article I will give you a complete overview of SQLite databases in Android and how to consume them using Xamarin APIs.

What is Multi-tenancy

6 Feb 2017Anuja Pawar Indore

Multi-Tenancy means same instance shared amongst all customers.

SQL Puzzle: How to Rank Student Scores

23 Feb 2017essentialSQL

How to identify the top and bottom 25 percent to rank student scores

SQL

WCF

SQL Puzzle: How to Calculate Moving Averages

23 Feb 2017essentialSQL

How to calculate moving averages by working through a hypothetical stock market example

SQL

WCF

Common Problems in Xamarin.Android and their Solutions

20 Feb 2017Afzaal Ahmad Zeeshan

In this article, I cover the most widely faced problems in Xamarin installation and setup for Android application development.

SQLite interaction on Android with Visual Studio and Xamarin

17 Feb 2017Emiliano Musso

In the present article we'll see how to develop a simple Android solution, through the use of Visual Studio e Xamarin, the developer framework which allows the creation of cross-platform solutions.

US Federal Holidays (SQL)

31 Jan 2017#realJSOP

A scalar function to determine if a given DateTime is one of the ten US federal holidays, using SQL Server.

ASP.NET Core, Angular2 Shopping Cart Using Web API And EF 1.0.1

23 Feb 2017syed shanu

In this article let’s see how to create a shopping cart using ASP.NET Core, Angular 2, Entity Framework 1.0.1 and Web API with Template pack .

Contextual Filtered List in a DataGridComboBoxCell

26 Feb 2017AXI_IeD

How to Filter contextually the list shown by a DataGridComboBoxCell?

Firebase Realtime Database By Example with Android

13 Feb 2017Val Okafor

A complete, step by step tutorial on working with Firebase Realtime Database in Android

Java

Android

database

Download file(s) from FTP Server using Command through SQL Server

14 Feb 2017saddam_msp

Download files using T-SQL server which is very much faster then any other option.

T-SQL

SQL

SQL-Server

Current Participants

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

#realJSOP

Software Developer (Senior) Paddedwall Software

United States

I've been paid as a programmer since 1982 with experience in Pascal, and C++ (both self-taught), and began writing Windows programs in 1991 using Visual C++ and MFC. In the 2nd half of 2007, I started writing C# Windows Forms and ASP.Net applications, and have since done WPF, Silverlight, WCF, web services, and Windows services.

My weakest point is that my moments of clarity are too brief to hold a meaningful conversation that requires more than 30 seconds to complete. Thankfully, grunts of agreement are all that is required to conduct most discussions without committing to any particular belief system.

Afzaal Ahmad Zeeshan

Software Developer

Pakistan

Afzaal Ahmad Zeeshan is a computer programmer from Rabwah, Pakistan, currently living in The Netherlands, likes .NET Core and Node.js for regular everyday development. Afzaal Ahmad works at Adyen as a Developer Advocate.

He is an expert with Cloud, Mobile, and API development. Afzaal has experience with the Azure platform and likes to build cross-platform libraries/software with .NET Core. Afzaal is an Alibaba Cloud MVP, twice he has been awarded Microsoft MVP status for his community leadership in software development, four times CodeProject MVP status for technical writing and mentoring, and 4 times C# Corner MVP status in the same field.

Anuja Pawar Indore

Program Manager Infobeans

India

I have keen interest in learning new things, exploring more on a topic and being more versatile

AXI_IeD

France

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

Emiliano Musso

Software Developer

Italy

Working in IT since 2003 as Software Developer for Essetre Srl, a company in Northern Italy.
I was awarded in 2014, 2015 and 2016 with Microsoft MVP, for Visual Studio and Development Technologies expertise. My technology interests and main skills are in .NET Framework, Visual Basic, Visual C# and SQL Server, but i'm proficient in PHP and MySQL also.

essentialSQL

Easy Computer Academy, LLC

United States

Hello my name is Kris. I’m here because I am passionate about helping non-techie people to overcome their fear of learning SQL.

I know what it is like to not know where to start or whether the time spent learning is worth the effort. That is why I am here to help you to:
- Get started in an easy to follow step-by-step manner.
- Use your time wisely so you focus on what is important to learn to get the most value from your time.
- Answer your questions. Really! Just post a comment and I’ll respond. I’m here to help.

It wasn’t long ago that I was helping a colleague with some reporting. She didn’t know where to start and soon got overwhelmed and lost as she didn’t know SQL.

I felt really bad, as she was under pressure to get some summary information to her boss, the built-in reports were falling short, and to make them better would require her to know SQL. At that time that seemed impossible! It in dawned on me, it doesn’t have to be that way.

Then I discovered a way for anyone with the desire to easily learn SQL. I worked with my co-worker, started to teach her what I learned and soon she was able to write reports and answer her boss’ questions without getting stressed or ploughing hours into manipulating data in Excel.

It hasn’t always been easy. Sometimes the information seems abstract or too conceptual. In this case I’ve found out that a visual explanation is best. I really like to use diagrams or videos to explain hard-to-grasp ideas.

Having video, pictures, and text really help to reinforce the point and enable learning.

And now I want to help you get the same results.

The first step is simple, click here http://www.essentialsql.com/get-started-with-sql-server/

Florimond

Belgium

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

hamdenvogel

Software Developer (Senior)

Brazil

Developer with large experience since 2000, and also an article writer with experience since 2008; I program with Delphi since version 3 and I´ve implemented many softwares through Brazil and some for Cabo Verde (Africa) and USA.

HHerzl

Software Developer

El Salvador

CatFactory Creator.

Full Stack Developer with Experience in C#, Entity Framework Core, ASP.NET Core and Angular.

Jerod Johnson

Technical Writer CData Software

United States

I'm an educator-turned-technology evangelist, with a short stint as a software developer. In all of the work I've done, data has been critical, and as businesses, industries, and services grow, I can't help but notice the growth in the breadth and depth of data usage. A common interface to data frees enterprises from the burden of connecting to their data and frees them to focus on their own business. By leveraging CData drivers to access common SQL interfaces to more than 100 SaaS, Big Data, and NoSQL sources, developers can build solid, data-driven products and analysts and data scientists can quickly and easily build insights that drive business.

While giving presentations, writing articles, engaging in webinars, and producing tutorial videos I get the opportunity to see first-hand the difference that standard connectivity makes, with regards to both the underlying data sources and the tools and apps consuming the data. Talk to me about partnering with CData to connect to your own organization's data, embedding connectivity into your data-driven solutions or building custom connectors for a new data source.

Jovan Popovic(MSFT)

Program Manager Microsoft

Serbia

Graduated from Faculty of Electrical Engineering, Department of Computer Techniques and Informatics, University of Belgrade, Serbia.
Currently working in Microsoft as Program Manager on SQL Server product.
Member of JQuery community - created few popular plugins (four popular JQuery DataTables add-ins and loadJSON template engine).
Interests: Web and databases, Software engineering process(estimation and standardization), mobile and business intelligence platforms.

Olivier_Giulieri

United States

I'm a UI engineer with an eye for UX and a passion for model-driven UIs.

I usually build UIs for startups in the San Francisco Bay Area.

My hobby open source project is Evolutility, a minimalist low-code platform with a model-driven UI, a model-driven backend, and a set of models to play with.

More about me on my GitHub page.

RedDk

United States

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

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

Robert_Dyball

Software Developer (Senior)

Australia

Robert works as a full stack developer in the financial services industry. He's passionate about sustainable software development, building solid software and helping to grow teams. He's had 20+ years of development experience across many areas that include scheduling, logistics, telecommunications, manufacturing, health, insurance and government regulatory and licensing sectors. Outside work he also enjoys electronics, IOT and helping a number of non-profit groups.

saddam_msp

Software Developer (Senior) MSP

India

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

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

Val Okafor

Software Developer (Senior) ValOkafor.com

United States

My name is Val Okafor, I am a Senior Software Engineer with specialization in Android Development. Learning and problem solving is my passion and I share my Android development knowledge through my blog ValOkafor.com.

My Android courses are the courses I wish I had when I started. I teach Android development in the context of a fully developed Android app. I believe that new Android concepts are better understood if they are presented in the context of creating an app from scratch to finish.

I focus on creating Productivity Android apps and besides Android development I have 7 years’ experience as System Administrator supporting Enterprise applications and 2 years’ experience as a Web Developer building websites using PHP and ASP.Net.

I have worked for corporations such as The Home Depot, American Council on Exercise, Legend3D and HD Supply, Inc. I have a bachelor's degree in Information Technology from National University San Diego, California and a master's degree in Software Engineering from Regis University Denver, Colorado.

I enjoy sharing my extensive work experience through my blog, social media.

First Prize	essentialSQL - SQL Puzzle: How to Calculate Moving Averages
Prize pool	CodeProject Mug - CodeProject


Second Prize	Jovan Popovic(MSFT) - Sending Events from Azure Event Hub to Azure SQL Database using Azure Functions
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.