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

Call a Web Service using SSIS then Store and Query the Results

7 May 2017Michael Lockwood

How to call a web service using SSIS, store XML results and then query XML using XQuery

Windows

ADO.NET

VS2015

SQL-Server

SPA^2 using ASP.Net Core 1.1 + Angular 4.0 - part 8

10 Apr 2017Robert_Dyball

Covering conversion from Angular 2.40 to Angular 4.0 + Publishing the ASP.Net Core / Angular 4 SPA to IIS using VS2017

SPA^2 using ASP.Net Core 1.1 + Angular 4.0 - part 9

19 Apr 2017Robert_Dyball

Publishing the ASP.Net Core 1.1 / Angular 4 SPA to Azure and external IIS hosts. Also covering code cleanup, optimization, bundling and minification. Gulp, Grunt, Webpack and some architecture and development philosophy.

Artisan Way of Data Reply

10 Jun 2021Vadim Loboda

A way to deliver more details about an error or exception from an SQL Server database through an ASP.NET web application to a web client.

.NET

ADO.NET

SQL-Server

BigDL: Distributed Deep Learning on Apache Spark

19 Apr 2017Intel

This article introduces BigDL, shows you how to build the library on a variety of platforms, and provides examples of BigDL in action.

Master Chef (Part 4) - ASP.NET Core and Angular 2 CRUD SPA

10 May 2017Fred Song (Melbourne)

Inthis article, I talk about how to use ASP.NET Core MVC, Entity Framework Coreand Angular 2 to implement a CRUD SPA (Single Page Application).

SPA^2 using ASP.Net Core 1.1 + Angular 4.0 - Part 7

4 Apr 2017Robert_Dyball

Covering conversion from Angular 2.40 to Angular 4.0 + Publishing the ASP.Net Core / Angular 4 SPA to IIS using VS2015.

What You See Is What You Update

2 Apr 2017Wendelius

This is an alternative for "What You See Is What You Update"

Securing ASP.NET Web API using Custom Token Based Authentication

20 Apr 2017 Saineshwar Bageri

In this article, we are going to learn how to secure asp.net web API using custom token based authentication.

SQL

ASP.NET

WebAPI

Get Target Screen Size of the Hosting Window in WPF

27 Apr 2017Ramachandraiah Pandula

Retrieves height and width of the screen/monitor which is hosting the WPF window or windows control.

How to Search Good Places to Travel (MongoDb LINQ & .NET Core)

22 Sep 2017Petru Faurescu

Walkthrough article to run LINQ queries with MongoDB, import data and define indexes

Backup Tables (not databases) in PostgreSQL

27 Apr 2017Darren G441

An effective solution for backing up a schema worth of tables on a Window installation of PostgreSQL database

Windows

PostgreSQL

DBA

SQL to ADO.NET API (Automated ADO.NET or DB API)

10 Apr 2017dmytro.sen

SQL to ADO.NET API (Automated ADO.NET)

ASP.NET Page to Process SSAS Cubes

27 Apr 2017Igor Krupitsky

ASP.NET page that lets you process an SSAS (SQL Server Analysis Services) cube database.

Javascript

ADO.NET

ASP.NET

Current Participants

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

Saineshwar Bageri

Technical Lead

India

Microsoft Most Valuable Professional
Code Project Most Valuable Author
C# Corner Most Valuable Professional

I am Senior Technical lead Working on.Net Web Technology
ASP.NET MVC,.Net Core,ASP.NET CORE, C#, SQL Server, MYSQL, MongoDB, Windows

Darren G441

Database Developer self interested

United Kingdom

I have been a software developer for about 20 years, mostly in small IT department that means you do all the roles all the time from 1st line support to 3rd line diagnostics and help authoring. To be fair, I don't do enough of the later which in turn causes way too much of the former with new staff always ready to show you how unintuitive your interfaces are!

I generally consider myself a "data plumber" with the majority of my work in back end SQL. If I could rule the world by writing a SPROC I would....

New definition of Stoicism: Someone who start a career in I.T. and still has a career in I.T. after 20 years!

dmytro.sen

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.

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.

Igor Krupitsky

Web Developer

United States

Igor is a business intelligence consultant working in Tampa, Florida. He has a BS in Finance from University of South Carolina and Masters in Information Management System from University of South Florida. He also has following professional certifications: MCSD, MCDBA, MCAD.

Intel

United States

You may know us for our processors. But we do so much more. Intel invents at the boundaries of technology to make amazing experiences possible for business and society, and for every person on Earth.

Harnessing the capability of the cloud, the ubiquity of the Internet of Things, the latest advances in memory and programmable solutions, and the promise of always-on 5G connectivity, Intel is disrupting industries and solving global challenges. Leading on policy, diversity, inclusion, education and sustainability, we create value for our stockholders, customers and society.

This is a Organisation

42 members

Michael Lockwood

Database Administrator

United States

I was first introduced to Microsoft data technologies while earning my bachelor's degree at DeVry University. I discovered that I could use Microsoft Access to manage my own data and develop reports and interfaces all within a single application and file, not knowing then that this marked the beginning of what would become my career in IT focused on tackling real-world challenges involving data. Soon after working as a Microsoft Access Developer, I ran into Access' 1 GB file size limitation. Times have changed. It was then that I performed my first series of data migrations from Microsoft Access 2000 to Microsoft SQL Server 7.0 using Microsoft's first release of Data Transformation Services (DTS).

I enjoy writing SQL code, creating, and continuing to learn all there is to know about Microsoft SQL Server and its features. I also explore a short list of other NoSQL platforms, including MongoDB, Hadoop, and DocumentDB. I am fascinated with database management systems and data visualization technologies, and I continue striving to master the disciplines. I'm also a lifelong reader of and subscriber to SQL Server Magazine, which is now sqlmag.com. I remain inspired by the technology experts that I've learned from over the years.

I enjoy being challenged to think critically about matters of database architecture, performance, availability, scalability, and reliability – key tenets of sound database management. I've extended these challenges to application development with a renewed interest beginning with the introduction of .NET Core. My career objective is full stack software development. So, thanks to many that create courses on Pluralsight and authors of the many books I read, I've learned to build REST and OData web services, ASP.NET Core web applications, and ASP.NET MVC 5 web applications. I've also learned Entity Framework, ASP.NET Identity, and D3js. Add all of this to my proficiency with SQL Server, Azure SQL, Integration Services and Reporting Services.

Petru Faurescu

Architect

Denmark

My name is Petru Faurescu and I am a solution architect and technical leader. Technical blog: QAppDesign.com

Ramachandraiah Pandula

United States

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

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.

Vadim Loboda

Russian Federation

"It is best to erase all personal history, because that would make us free from the encumbering thoughts of other people."

Journey to Ixtlan by Carlos Castaneda

Wendelius

Architect

Europe

Biography provided

First Prize	Petru Faurescu - How to Search Good Places to Travel (MongoDb LINQ & .NET Core)
Prize pool	CodeProject Mug - CodeProject


Second Prize	Wendelius - What You See Is What You Update
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.